PTAFAW_TIMEOUT

index back

Stores escalation options

In order to make timeouts as configurable as possible, they are now removed from the sac_aw_path table

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
EFFDT Date(10) DATE Effective Date

Default: %date

PTAFSTAGE_NBR Number(3,0) SMALLINT NOT NULL Stage Number
PTAFPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default: 0

PTAFESCALATN_OPTN Character(1) VARCHAR2(1) NOT NULL 1-Notify Approver 2-Notify Supervisor 3-Notify Approver & Supervisor 4-Skip to Next Step 5-Skip to Next Step & Notify Appover 6-Skip to Next Step & Notify Appover 7-Skip to Next Step & Notify Appover & Supervisor
A=Advance Approval
N=Notify Participant
R=Reassign Approval

Default: N

PTAFNUMBER_HOURS Number(2,0) SMALLINT NOT NULL Number of Hours

Default: 0

PTAFNUMBER_DAYS Number(3,0) SMALLINT NOT NULL Number of Days

Default: 0

PTAFREASSIGNOPRID Character(30) VARCHAR2(30) NOT NULL Reassign To

Prompt Table: OPRIDDESC_VW

PTAFUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.

Prompt Table: PTAFUSER_LIST

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