EOAW_ESCAL_ARC(SQL Table) |
Index Back |
---|---|
User escalation Archive |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PSARCH_ID | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
2 | PSARCH_BATCHNUM | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
3 | EOAWUSTEP_INST_ID | Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
4 | SEQ_NBR | 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 |