EOAW_ESCAL_MSG(SQL Table) |
Index Back |
---|---|
Escalations IB messagerecord 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 |