PTAFAW_APPR_ARC

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFUSTEP_INST_IDNumber(15,0)DECIMAL(15) NOT NULLObject id of a step instance. Generated off the main thread id for the approval process.
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
OPRID_APPROVED_BYCharacter(30)VARCHAR2(30) NOT NULLApproved By
PTAFSTAGE_NBRNumber(3,0)SMALLINT NOT NULLStage Number
PTAFPATH_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Path ID
PTAFSTEP_NBRNumber(6,2)DECIMAL(5,2) NOT NULLSequence number of step in its path
PTAFAW_STEP_DESCRCharacter(30)VARCHAR2(30) NOT NULLStep Description
PTAFSTEP_STATUSCharacter(1)VARCHAR2(1) NOT NULLStep Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
S=Skipped
T=Terminated
U=Auto approved
X=Deleted
Y=Bypassed
PTAFUSTEP_STATUSCharacter(1)VARCHAR2(1) NOT NULLApprover Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
S=Skipped
T=Terminated
U=Auto approved
X=Deleted
Y=Bypassed
PTAFDTTM_PROCESSEDDateTime(26)TIMESTAMPDatetime processed
PTAF_APPKEY254_1Character(254)VARCHAR2(254) NOT NULLApplication Key 1
PTAF_APPKEY254_10Character(254)VARCHAR2(254) NOT NULLApplication key 10
PTAF_APPKEY254_2Character(254)VARCHAR2(254) NOT NULLApplication Key 2
PTAF_APPKEY254_3Character(254)VARCHAR2(254) NOT NULLApplication Key 3
PTAF_APPKEY254_4Character(254)VARCHAR2(254) NOT NULLApplication Key 4
PTAF_APPKEY254_5Character(254)VARCHAR2(254) NOT NULLApplication Key 5
PTAF_APPKEY254_6Character(254)VARCHAR2(254) NOT NULLApplication Key 6
PTAF_APPKEY254_7Character(254)VARCHAR2(254) NOT NULLApplication Key 7
PTAF_APPKEY254_8Character(254)VARCHAR2(254) NOT NULLApplication Key 8
PTAF_APPKEY254_9Character(254)VARCHAR2(254) NOT NULLApplication Key 9
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19