EODL_DELEGATOR_OIDEODL_DELEGATOR_RCDDefault Value: 0
TRANSACTION_NAMEEODL_TRAN_ALLOWEDA=Approve
I=Initiate
FROM_DATEEODL_PROXY_OIDEODL_DLTRIMG_VW(SQL View) |
Index Back |
|---|---|
Delegator Image View |
| SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , A.FROM_DATE , A.EODL_PROXY_OID , PHOTO.EMPLID , PHOTO.EMPLOYEE_PHOTO , ' ' FROM PS_EODL_DELEGATION A , PS_EODL_APPR_XREF XREF , PS_EOAW_FLPHOTO_VW PHOTO WHERE A.EODL_DELEGATOR_OID = XREF.EODL_DELEGATOR_OID AND A.EODL_DELEGATOR_RCD = XREF.EODL_DELEGATOR_RCD AND A.TRANSACTION_NAME = XREF.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = XREF.EODL_TRAN_ALLOWED AND A.FROM_DATE = XREF.FROM_DATE AND A.EODL_PROXY_OID = XREF.EODL_PROXY_OID AND A.EODL_DELEGATOR_ID = PHOTO.EMPLID |
| # | 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
Default Value: 0 |
| 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 | FROM_DATE |
Date(10) | DATE | From Date |
| 6 | EODL_PROXY_OID |
Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPLOYEE_PHOTO | Image / Attachment | CLOB | Employee Photograph |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |