EODL_DELEGATOR_OIDEODL_DELEGATOR_RCDTRANSACTION_NAMEEODL_TRAN_ALLOWEDA=Approve
I=Initiate
FROM_DATEEODL_PROXY_OIDLANGUAGE_CDEODL_MYPROXY_LN(SQL View) |
Index Back |
|---|---|
My Proxy ViewKey in by Delegator Id to get all the proxies for the delegator. |
| SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED, A.FROM_DATE, A.EODL_PROXY_OID , B.LANGUAGE_CD , B.DESCR FROM PS_EODL_DELEGATION A , PS_EODL_TXN_LANG B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = B.EODL_TRAN_ALLOWED |
| # | 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 | FROM_DATE |
Date(10) | DATE | From Date |
| 6 | EODL_PROXY_OID |
Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |