HCDL_RQST_HIS (SQL View)	Index Back
Delegation log table This record stores the delegated authority log information for Manager Desktop applications.

HCDL_RQST_HIS

(SQL View)

Delegation log table

This record stores the delegated authority log information for Manager Desktop applications.

SELECT A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , A.DLGT_REQ_STATUS , A.FROM_DATE , A.TO_DATE , A.PROXY_ID ,A.DLGT_STATUS , B.NAME_DISPLAY ,A.ACTION_DT , C.GROUP_SEQ_NUM ,A.DATETIME_STAMP FROM PS_HCDL_DLGT_LOG A , PS_PERSON_NAME B , PS_HCDL_DELEGATION C WHERE A.DELEGATOR_ID = B.EMPLID AND A.DELEGATOR_ID = C.DELEGATOR_ID AND A.DELEGATOR_RCD = C.DELEGATOR_RCD AND A.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.TRANS_ALLOWED = C.TRANS_ALLOWED AND A.FROM_DATE = C.FROM_DATE

# 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 DLGT_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Request Status
A=Accepted
E=Ended
J=Rejected
R=Revoked
S=Submitted

6 FROM_DATE Date(10) DATE From Date

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

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

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

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

11 ACTION_DT Date(10) DATE Action Date

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

13 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

#	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	DLGT_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted E=Ended J=Rejected R=Revoked S=Submitted
6	FROM_DATE	Date(10)	DATE	From Date
7	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
8	PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
9	DLGT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delegation Status A=Active I=Inactive
10	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
11	ACTION_DT	Date(10)	DATE	Action Date
12	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.
13	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp