EOAW_ESCAL_MSG

(SQL Table)
Index Back

Escalations IB message

record definition for escalations IB message

# 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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 EOAW_CALENDAR Character(10) VARCHAR2(10) NOT NULL Calendar ID
6 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

7 EOAWNUMBER_DAYS Number(3,0) SMALLINT NOT NULL Number of Days
8 EOAWNUMBER_HOURS Number(2,0) SMALLINT NOT NULL Number of Hours
9 EOAWREASSIGNOPRID Character(30) VARCHAR2(30) NOT NULL Approval Framework Reassign Oprid

Prompt Table: EOAW_OPRDESC_VW

10 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

11 EOAWACTUAL_APPR Character(1) VARCHAR2(1) NOT NULL Use Proxy Participant
12 EOAW_ESCAL_FLAG Character(1) VARCHAR2(1) NOT NULL Escalated Flag to markup whether this timeout option has been escalated.
13 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified