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 Name Field Type Column Type Description
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
PTAFSTAGE_NBR Number(3,0) SMALLINT NOT NULL Stage Number
PTAFPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
PTAFSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path
PTAFTHREAD_ID Number(10,0) DECIMAL(10) NOT NULL Thread ID
PTAFSTEP_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.
PTAFUSTEP_INST_ID Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
DTTM_STAMP DateTime(26) TIMESTAMP Specifies 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.
TIMEOUTMINUTES Number(5,0) INTEGER NOT NULL Time out minutes

Default: 0

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