PTAFAW_DECISION

index back

Mass Approvals Action Table

Contains an action that is to be taken in the Mass Approvals Framework. The record is update upon completion of the action taken.

PeopleSoft Field NameField TypeColumn TypeDescription
SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number
PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFTHREAD_IDNumber(10,0)DECIMAL(10) NOT NULLThread ID
PTAFPARENT_THREADNumber(10,0)DECIMAL(10) NOT NULLParent Thread ID
PTAFAPPROVER_OPRIDCharacter(30)VARCHAR2(30) NOT NULLApprover Oprid
PTAFACTIONCharacter(3)VARCHAR2(3) NOT NULLAction
PTAFCOMMENT1Character(254)VARCHAR2(254) NOT NULLComments
STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus Indicator
A=Active
I=Inactive
PTAFDONE_FLAGCharacter(1)VARCHAR2(1) NOT NULLDone Flag
PTAFMA_STATUSLong CharacterCLOBUsed to store the detailed status of the action performed on that particular thread.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19