EOAW_USER_ESCAL(SQL Table) |
Index Back |
---|---|
User escalation options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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. |
2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 0 |
3 | 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 |
4 | EOAWREASSIGNOPRID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Framework Reassign Oprid
Prompt Table: EOAW_OPRDESC_VW |
5 | 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 |
6 | EOAWACTUAL_APPR | Character(1) | VARCHAR2(1) NOT NULL | Use Proxy Participant |
7 | EOAW_ESCAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Escalated Flag to markup whether this timeout option has been escalated. |
8 | EOAWDTTM_ESCALATE | DateTime(26) | TIMESTAMP | Datetime to be escalated |