PROXY_IDDELEGATOR_IDDELEGATOR_RCDTRANSACTION_NAMETRANS_ALLOWEDA=Approve
I=Initiate
LANGUAGE_CDHCDL_DLGT_LANG(SQL View) |
Index Back |
|---|---|
My Delegator Language ViewMy Delegator Language View. |
| SELECT A.PROXY_ID , A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , E.LANGUAGE_CD , D.SETID_DEPT , E.DESCR FROM PS_HCDL_DELEGATION A , PS_HCDL_CURR_TXNS B , PS_HCDL_ALL_JOB_VW D , PS_DEPT_TBL_LANG E WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED AND A.DELEGATOR_ID = D.EMPLID AND A.DELEGATOR_RCD = D.EMPL_RCD AND D.SETID_DEPT = E.SETID AND D.DEPTID = E.DEPTID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROXY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |
| 2 | DELEGATOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |
| 3 | DELEGATOR_RCD |
Number(3,0) | SMALLINT NOT NULL | Delegator Record Number |
| 4 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 5 | 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 |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 8 | DEPTNAME | Character(30) | VARCHAR2(30) NOT NULL | Department |