DELEGATOR_IDDELEGATOR_RCDTRANSACTION_NAMETRANS_ALLOWEDA=Approve
I=Initiate
FROM_DATEHCDL_PROXYIMG_V(SQL View) |
Index Back |
|---|---|
Proxy's PhotoThis view is used to retrieve the employee photo of the delegatee |
| SELECT A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , A.FROM_DATE , B.EMPLID , B.EMPLOYEE_PHOTO , N.NAME_DISPLAY1 FROM %Table(HCDL_DELEGATION) A , %Table(USER_PH_LIST_FL) B , %Table(HCDL_APPR_XREF) XREF , %Table(HCDL_DLGT_HDR_V) N WHERE A.PROXY_ID = B.EMPLID AND A.DELEGATOR_ID = XREF.DELEGATOR_ID AND A.DELEGATOR_RCD = XREF.DELEGATOR_RCD AND A.TRANSACTION_NAME = XREF.TRANSACTION_NAME AND A.TRANS_ALLOWED = XREF.TRANS_ALLOWED AND A.FROM_DATE = XREF.FROM_DATE AND A.DELEGATOR_ID = N.DELEGATOR_ID AND A.DELEGATOR_RCD = N.DELEGATOR_RCD AND A.TRANSACTION_NAME = N.TRANSACTION_NAME AND A.TRANS_ALLOWED = N.TRANS_ALLOWED AND A.FROM_DATE = N.FROM_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DELEGATOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |
| 2 | DELEGATOR_RCD |
Number(3,0) | SMALLINT NOT NULL | Delegator Record Number |
| 3 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 4 | TRANS_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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPLOYEE_PHOTO | Image / Attachment(256) | VARCHAR2(256) | Employee Photograph |
| 8 | DELEGATEE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Delegatee Name |