EOAW_CESCAL_VW

(SQL View)
 Index Back

Escalation based on cal view

This 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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number
5 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
6 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path
7 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
8 EOAWSTEP_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.
9 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.
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