PTAFAW_XREF_WRK

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFTHREAD_IDNumber(10,0)DECIMAL(10) NOT NULLThread ID
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
ORIGINATORIDCharacter(30)VARCHAR2(30) NOT NULLOriginator Identifier
PTAFREQUESTOR_IDCharacter(30)VARCHAR2(30) NOT NULLRequestor id
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTAFTHREAD_STATUSCharacter(1)VARCHAR2(1) NOT NULLThread 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: N

PTAFPARENT_THREADNumber(10,0)DECIMAL(10) NOT NULLParent Thread ID
PTAFDTTM_MODIFIEDDateTime(26)TIMESTAMPDatetime modified
COMMENTSLong CharacterCLOBComment
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19