PTAFAW_TO_LOG

index back

Tracking mechanism for timeout

Records all escalations when they are sent. Allows us to send the most dire timeout notification on subsequent "doEscalate" calls.

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
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
PTAFTHREAD_IDNumber(10,0)DECIMAL(10) NOT NULLThread ID
PTAFSTEP_INSTANCENumber(15,0)DECIMAL(15) NOT NULLObject id of a step instance. Generated off the main thread id for the approval process.
PTAFUSTEP_INST_IDNumber(15,0)DECIMAL(15) NOT NULLObject id of a step instance. Generated off the main thread id for the approval process.
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number
DTTM_STAMPDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
TIMEOUTMINUTESNumber(5,0)INTEGER NOT NULLTime out minutes

Default: 0

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19