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 NameField TypeColumn TypeDescription
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
EFFDTDate(10)DATEEffective Date

Default: %date

PTAFSTAGE_NBRNumber(3,0)SMALLINT NOT NULLStage Number
PTAFPATH_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Path ID
SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number

Default: 0

PTAFESCALATN_OPTNCharacter(1)VARCHAR2(1) NOT NULL1-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_HOURSNumber(2,0)SMALLINT NOT NULLNumber of Hours

Default: 0

PTAFNUMBER_DAYSNumber(3,0)SMALLINT NOT NULLNumber of Days

Default: 0

PTAFREASSIGNOPRIDCharacter(30)VARCHAR2(30) NOT NULLReassign To

Prompt Table: OPRIDDESC_VW

PTAFUSER_LIST_IDCharacter(30)VARCHAR2(30) NOT NULLIdentifies the user list to be used when creating the approval process.

Prompt Table: PTAFUSER_LIST

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