EODL_DLGTRPT_VW(SQL View) |
Index Back |
|---|
| SELECT A.EOAWPRCS_ID , A.EOAWDEFN_ID , A.EFFDT , A.EOAWSTAGE_NBR , A.EOAWPATH_ID , A.EOAWSTEP_NBR , A.EOAWTHREAD_ID , A.EOAWSTEP_INSTANCE , A.EOAWUSTEP_INST_ID , DLGT.EODL_DELEGATOR_OID , DLGT.TRANSACTION_NAME , DLGT.EODL_TRAN_ALLOWED , DLGT.FROM_DATE , DLGT.EODL_PROXY_OID , DLGT.EODL_DELEGATOR_ID , DLGT.EODL_DELEGATOR_RCD , DLGT.EODL_PROXY_ID , DLGT.TO_DATE , DLGT.EODL_END_DAY_IND , DLGT.EODL_DLGT_REQ_STAT , DLGT.EODL_DLGT_STATUS , DLGT.EODL_NOTIFY_DLGTOR , DLGT.EODL_GROUP_SEQ_NUM , DLGT.TRANSACTION_NBR FROM %Table(EOAW_STEP_VW) A , %Table(EO_TRANSACTIONS) TRANS , %Table(EODL_DELEGATION) DLGT WHERE A.EOAWPRCS_ID = TRANS.EOAWPRCS_ID AND TRANS.TRANSACTION_NAME = DLGT.TRANSACTION_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | EOAWDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EOAWSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Approval Framework Stage Number |
| 5 | EOAWPATH_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
| 6 | EOAWSTEP_NBR |
Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path |
| 7 | EOAWTHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 8 | EOAWSTEP_INSTANCE |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 9 | EOAWUSTEP_INST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 10 | EODL_DELEGATOR_OID | Character(30) | VARCHAR2(30) NOT NULL | Delegator User Id |
| 11 | TRANSACTION_NAME | Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 12 | 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 |
| 13 | FROM_DATE | Date(10) | DATE | Start Date |
| 14 | EODL_PROXY_OID | Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id |
| 15 | EODL_DELEGATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |
| 16 | EODL_DELEGATOR_RCD | Number(3,0) | SMALLINT NOT NULL | Delegator Record Number |
| 17 | EODL_PROXY_ID | Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |
| 18 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 19 | EODL_END_DAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
End Absence Day
Y/N Table Edit |
| 20 | EODL_DLGT_REQ_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Request Status
A=Accepted E=Ended J=Rejected R=Revoked S=Submitted |
| 21 | EODL_DLGT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Delegation Status
A=Active I=Inactive |
| 22 | EODL_NOTIFY_DLGTOR | Character(1) | VARCHAR2(1) NOT NULL |
Notify flag
N=Not Notify Delegator Y=Notify Delegator |
| 23 | EODL_GROUP_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated. |
| 24 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |