EODL_DLGT_TXN_V (SQL View)	Index Back
Delegation Request This view is used to retrieve delegation request info for HTML approval email.

EODL_DLGT_TXN_V

(SQL View)

Delegation Request

This 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 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 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

#	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	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