EODL_PROXY_OIDEODL_DELEGATOR_OIDEODL_DELEGATOR_RCDTRANSACTION_NAMEEODL_TRAN_ALLOWEDA=Approve
I=Initiate
LANGUAGE_CDEODL_DLGT_LANG(SQL View) |
Index Back |
|---|---|
My Delegator Language ViewMy Delegator Language View. |
| SELECT A.EODL_PROXY_OID , A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , B.LANGUAGE_CD , %Coalesce(BL.DESCR, B.DESCR) FROM PS_EODL_DELEGATION A , PS_EODL_TXN_AL_VW B LEFT OUTER JOIN PS_EODL_TXN_LANG BL ON B.TRANSACTION_NAME = BL.TRANSACTION_NAME AND B.EODL_TRAN_ALLOWED = BL.EODL_TRAN_ALLOWED AND B.LANGUAGE_CD = BL.LANGUAGE_CD 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_PROXY_OID |
Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id |
| 2 | EODL_DELEGATOR_OID |
Character(30) | VARCHAR2(30) NOT NULL | Delegator User Id |
| 3 | EODL_DELEGATOR_RCD |
Number(3,0) | SMALLINT NOT NULL | Delegator Record Number |
| 4 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |