EOAW_ESCAL_ARC(SQL Table) |
Index Back |
|---|---|
User escalation Archive |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
| 2 | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number | |
| 3 | Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. | |
| 4 | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 0 |
|
| 5 | 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 |
| 6 | EOAWREASSIGNOPRID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Framework Reassign Oprid
Prompt Table: EOAW_OPRDESC_VW |
| 7 | 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 |
| 8 | EOAWACTUAL_APPR | Character(1) | VARCHAR2(1) NOT NULL | Use Proxy Participant |
| 9 | EOAW_ESCAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Escalated Flag to markup whether this timeout option has been escalated. |
| 10 | EOAWDTTM_ESCALATE | DateTime(26) | TIMESTAMP | Datetime to be escalated |