HCDL_ADMIN_XREF

(SQL Table)
Index Back

Delegation Approval

Delegation Approval Reference Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAFTHREAD_ID Number(10,0) DECIMAL(10) NOT NULL Thread ID
2 PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 PTAFREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 PTAFTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Suspended
T=Terminated
X=Suspended/Pending Denial

Default Value: N

8 PTAFPARENT_THREAD Number(10,0) DECIMAL(10) NOT NULL Parent Thread ID
9 PTAFDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 COMMENTS Long Character CLOB Comment
11 DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
12 DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
13 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
14 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
15 FROM_DATE Date(10) DATE From Date