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

HCDL_MYPROXY

(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.DESCR ,B.ROLENAME ,B.PACKAGEROOT ,B.APPCLASS_PATH ,B.MESSAGE_SET_NBR ,B.MESSAGE_NBR ,A.DELEGATOR_OPRID , A.PROXY_ID , A.FROM_DATE , A.TO_DATE , A.END_DAY_IND , A.DLGT_REQ_STATUS , A.DLGT_STATUS , A.NOTIFY_DELEGATOR , C.NAME_DISPLAY , A.GROUP_SEQ_NUM , A.COMMENTS FROM PS_HCDL_DELEGATION A , PS_HCDL_CURR_TXNS B , PS_PERSON_NAME C WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED AND A.PROXY_ID = C.EMPLID

Related Language Record: HCDL_MYPROXY_LN

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

6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

7 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

8 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

11 DELEGATOR_OPRID Character(30) VARCHAR2(30) NOT NULL Delegator Oprid

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

13 FROM_DATE Date(10) DATE From Date

14 TO_DATE Date(10) DATE Latest Date to be sent to PYR

15 END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day
0=End Day No
1=End Day Yes

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

17 DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
A=Active
I=Inactive

18 NOTIFY_DELEGATOR Character(1) VARCHAR2(1) NOT NULL Notify flag
N=Not Notify Delegator
Y=Notify Delegator

19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

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

21 COMMENTS Long Character CLOB Comment

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
7	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID
8	APPCLASS_PATH	Character(254)	VARCHAR2(254) NOT NULL	Application Class Full Path
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	DELEGATOR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Delegator Oprid
12	PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. Prompt Table: HCDL_PROXY_SRCH
13	FROM_DATE	Date(10)	DATE	From Date
14	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
15	END_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	End Absence Day 0=End Day No 1=End Day Yes
16	DLGT_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted E=Ended J=Rejected R=Revoked S=Submitted
17	DLGT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delegation Status A=Active I=Inactive
18	NOTIFY_DELEGATOR	Character(1)	VARCHAR2(1) NOT NULL	Notify flag N=Not Notify Delegator Y=Notify Delegator
19	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
20	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.
21	COMMENTS	Long Character	CLOB	Comment