PTAFPRCS_IDPTAFDEFN_IDEFFDTDefault: %date
PTAFSTAGE_NBRPTAFPATH_IDSEQ_NBRDefault: 0
A=Advance Approval
N=Notify Participant
R=Reassign Approval
Default: N
Default: 0
Default: 0
Prompt Table: OPRIDDESC_VW
Prompt Table: PTAFUSER_LIST
Default: 0
PTAFAW_TIMEOUT |
index back |
|---|---|
Stores escalation options |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |