EODL_DLGT_LOG

(SQL Table)
Index Back

Delegation log table

This record stores the delegated authority log information for Manager Desktop applications.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EODL_DELEGATOR_OID Character(30) VARCHAR2(30) NOT NULL Delegator User Id
2 EODL_DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
4 EODL_TRAN_ALLOWED Character(1) VARCHAR2(1) NOT NULL Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate.
A=Approve
I=Initiate
5 EODL_DLGT_REQ_STAT Character(1) VARCHAR2(1) NOT NULL Request Status
A=Accepted
E=Ended
J=Rejected
R=Revoked
S=Submitted
6 FROM_DATE Date(10) DATE From Date
7 EODL_PROXY_OID Character(30) VARCHAR2(30) NOT NULL Proxy Operator Id
8 EODL_DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
9 EODL_PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
10 TO_DATE Date(10) DATE To Date
11 EODL_END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day

Y/N Table Edit

12 EODL_DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
A=Active
I=Inactive
13 EODL_NOTIFY_DLGTOR Character(1) VARCHAR2(1) NOT NULL Notify flag
N=Not Notify Delegator
Y=Notify Delegator
14 EODL_ACTION_DT Date(10) DATE Action Date
15 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

Default Value: %datetime