EOAW_CESCAL_VW(SQL View) |
Index Back |
---|---|
Escalation based on cal viewThis view identifies approval step instances that need to be escalated based on the path settings. |
SELECT DISTINCT B.EOAWPRCS_ID , B.EOAWDEFN_ID , B.EFFDT , B.EOAWSTAGE_NBR , B.EOAWPATH_ID , B.EOAWSTEP_NBR , B.EOAWTHREAD_ID , B.EOAWSTEP_INSTANCE , C.EOAWUSTEP_INST_ID , A.SEQ_NBR , C.OPRID , C.EOAWDTTM_MODIFIED FROM PS_EOAW_USER_ESCAL A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWUSTEP_INST_ID = C.EOAWUSTEP_INST_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND %CurrentDateTimeIn >= A.EOAWDTTM_ESCALATE AND C.EOAWSTEP_STATUS = 'P' AND A.EOAW_ESCAL_FLAG = 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID | |
3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
4 | Number(3,0) | SMALLINT NOT NULL | Approval Framework Stage Number | |
5 | Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID | |
6 | Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path | |
7 | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID | |
8 | Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. | |
9 | Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. | |
10 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
12 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |