EODL_DLGT_LOG(SQL Table) | 
Index Back | 
|---|---|
Delegation log tableThis record stores the delegated authority log information for Manager Desktop applications. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Delegator User Id | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Delegator Record Number | |
| 3 | Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name | |
| 4 | 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 | Character(1) | VARCHAR2(1) NOT NULL | 
Request Status
 A=Accepted E=Ended J=Rejected R=Revoked S=Submitted  | 
|
| 6 | Date(10) | DATE | From Date | |
| 7 | 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  |