EODL_MYDLGTOR (SQL View)	Index Back
My Delegator View Key by Proxy ID. Use Proxy ID to get all delegators of the proxy.

EODL_MYDLGTOR

(SQL View)

My Delegator View

Key by Proxy ID. Use Proxy ID to get all delegators of the proxy.

SELECT A.EODL_PROXY_OID , A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , B.DESCR , B.PNLGRPNAME , A.FROM_DATE , A.TO_DATE , A.EODL_END_DAY_IND , A.EODL_DELEGATOR_ID , A.EODL_PROXY_ID , A.EODL_DLGT_REQ_STAT , A.EODL_DLGT_STATUS , A.EODL_NOTIFY_DLGTOR , A.EODL_GROUP_SEQ_NUM , A.COMMENTS FROM PS_EODL_DELEGATION A , PS_EODL_CURR_TXNS B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = B.EODL_TRAN_ALLOWED

Related Language Record: EODL_DLGT_LANG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

8 FROM_DATE Date(10) DATE From Date

9 TO_DATE Date(10) DATE To Date

10 EODL_END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day
Y/N Table Edit

11 EODL_DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.

12 EODL_PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.

13 EODL_DLGT_REQ_STAT Character(1) VARCHAR2(1) NOT NULL Request Status
A=Accepted
E=Ended
J=Rejected
R=Revoked
S=Submitted

14 EODL_DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
A=Active
I=Inactive

15 EODL_NOTIFY_DLGTOR Character(1) VARCHAR2(1) NOT NULL Notify flag
N=Not Notify Delegator
Y=Notify Delegator

16 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.

17 COMMENTS Long Character CLOB Comment

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
8	FROM_DATE	Date(10)	DATE	From Date
9	TO_DATE	Date(10)	DATE	To Date
10	EODL_END_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	End Absence Day Y/N Table Edit
11	EODL_DELEGATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
12	EODL_PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
13	EODL_DLGT_REQ_STAT	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted E=Ended J=Rejected R=Revoked S=Submitted
14	EODL_DLGT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delegation Status A=Active I=Inactive
15	EODL_NOTIFY_DLGTOR	Character(1)	VARCHAR2(1) NOT NULL	Notify flag N=Not Notify Delegator Y=Notify Delegator
16	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.
17	COMMENTS	Long Character	CLOB	Comment