TRANSACTION_NAMEA=Approve
I=Initiate
FROM_DATEHCSC_DLTORIMG_V(SQL View) |
Index Back |
|---|---|
Delegator's PhotoThis view is used to retrieve the employee photo of the delegator |
| SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_PROXY_OID , A.EODL_TRAN_ALLOWED , A.FROM_DATE , B.EMPLID , B.EMPLOYEE_PHOTO , N.NAME_DISPLAY FROM PS_EODL_DELEGATION A , PS_USER_PH_LIST_FL B , PS_EODL_APPR_XREF XREF , PS_PERSON_NAME N WHERE A.EODL_DELEGATOR_ID = B.EMPLID AND 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_DELEGATOR_ID = N.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 |
| 3 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 4 | EODL_PROXY_OID | Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id |
| 5 | 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 |
| 6 | FROM_DATE |
Date(10) | DATE | From Date |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPLOYEE_PHOTO | Image / Attachment(256) | VARCHAR2(256) | Employee Photograph |
| 9 | DELEGATOR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Delegator Name |