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