HCDL_MYPROXY_LN (SQL View)	Index Back
My Proxy View Key in by Delegator Id to get all the proxies for the delegator.

HCDL_MYPROXY_LN

(SQL View)

My Proxy View

Key in by Delegator Id to get all the proxies for the delegator.

SELECT A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , B.LANGUAGE_CD , B.DESCR FROM PS_HCDL_DELEGATION A , PS_HCDL_TXN_LANG B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED

Related Language Record for HCDL_MYPROXY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number

3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

4 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

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DELEGATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
2	DELEGATOR_RCD	Number(3,0)	SMALLINT NOT NULL	Delegator Record Number
3	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
4	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
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description