PTAFAW_TIMEOUT(SQL Table) |
Index Back |
|---|---|
Stores escalation optionsIn order to make timeouts as configurable as possible, they are now removed from the sac_aw_path table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTAFPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | PTAFDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Definition ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | PTAFSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Stage Number |
| 5 | PTAFPATH_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 0 |
| 7 | 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 Value: N |
| 8 | PTAFNUMBER_HOURS | Number(2,0) | SMALLINT NOT NULL |
Number of Hours
Default Value: 0 |
| 9 | PTAFNUMBER_DAYS | Number(3,0) | SMALLINT NOT NULL |
Number of Days
Default Value: 0 |
| 10 | PTAFREASSIGNOPRID | Character(30) | VARCHAR2(30) NOT NULL |
Reassign To
Prompt Table: OPRIDDESC_VW |
| 11 | 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 |
| 12 | TIMEOUTMINUTES | Number(5,0) | INTEGER NOT NULL |
Time out minutes
Default Value: 0 |