EODL_DLGT_TXN_V(SQL View) |
Index Back |
---|---|
Delegation RequestThis view is used to retrieve delegation request info for HTML approval email. |
SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , A.FROM_DATE , A.EODL_PROXY_OID , B.TO_DATE , B.EODL_GROUP_SEQ_NUM , B.TRANSACTION_NBR , B.EODL_DLGT_REQ_STAT , B.TRANSACTION_NAME , C.DESCR FROM PS_EODL_APPR_XREF A , PS_EODL_DELEGATION B , PS_EODL_CURR_TXNS C WHERE A.EODL_DELEGATOR_OID = B.EODL_DELEGATOR_OID AND A.EODL_DELEGATOR_RCD = B.EODL_DELEGATOR_RCD AND A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = B.EODL_TRAN_ALLOWED AND A.FROM_DATE = B.FROM_DATE AND A.EODL_PROXY_OID = B.EODL_PROXY_OID AND B.TRANSACTION_NAME = C.TRANSACTION_NAME AND B.EODL_TRAN_ALLOWED = C.EODL_TRAN_ALLOWED |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Delegator User Id | |
2 | Number(3,0) | SMALLINT NOT NULL | Delegator Record Number | |
3 | Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name | |
4 | 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 | Date(10) | DATE | From Date | |
6 | Character(30) | VARCHAR2(30) NOT NULL | Proxy Operator Id | |
7 | TO_DATE | Date(10) | DATE | To Date |
8 | 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. |
9 | 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. |
10 | EODL_DLGT_REQ_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Request Status
A=Accepted E=Ended J=Rejected R=Revoked S=Submitted |
11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
12 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |