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 Name Field Type Column Type Description
SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
PTAFTHREAD_ID Number(10,0) DECIMAL(10) NOT NULL Thread ID
PTAFPARENT_THREAD Number(10,0) DECIMAL(10) NOT NULL Parent Thread ID
PTAFAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oprid
PTAFACTION Character(3) VARCHAR2(3) NOT NULL Action
PTAFCOMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
PTAFDONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag
PTAFMA_STATUS Long Character CLOB Used to store the detailed status of the action performed on that particular thread.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19