EOAW_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 |  EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | EOAWDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EOAWSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Approval Framework Stage Number |
| 5 | EOAWPATH_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 | EOAWESCALATN_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 C=Cancel Approval N=Notify Participant R=Reassign Approval Default Value: N |
| 8 | EOAWNUMBER_HOURS | Number(2,0) | SMALLINT NOT NULL |
Number of Hours
Default Value: 0 |
| 9 | EOAWNUMBER_DAYS | Number(3,0) | SMALLINT NOT NULL |
Number of Days
Default Value: 0 |
| 10 | EOAWREASSIGNOPRID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Framework Reassign Oprid
Prompt Table: EOAW_OPRDESC_VW |
| 11 | EOAWUSER_LIST_ID | Character(30) | VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
Prompt Table: EOAWUSER_LIST |
| 12 | TIMEOUTMINUTES | Number(5,0) | INTEGER NOT NULL |
Time out minutes
Default Value: 0 |
| 13 | EOAW_TIMEOUTMINUTE | Number(9,0) | DECIMAL(9) NOT NULL |
Time out minutes
Default Value: 0 |
| 14 | EOAWACTUAL_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Use Proxy Participant
Y/N Table Edit Default Value: N |