PTAFAW_ESCAL_VW

index back

Escalation view for Approvals

This view identifies approval step instances that need to be escalated based on the path settings.
SELECT DISTINCT B.PTAFPRCS_ID , B.PTAFDEFN_ID , B.EFFDT , B.PTAFSTAGE_NBR , B.PTAFPATH_ID , B.PTAFSTEP_NBR , B.PTAFTHREAD_ID , B.PTAFSTEP_INSTANCE , C.PTAFUSTEP_INST_ID , C.OPRID , C.PTAFDTTM_MODIFIED FROM PS_PTAFAW_TIMEOUT A , PS_PTAFAW_STEPINST B , PS_PTAFAW_USERINST C WHERE A.PTAFDEFN_ID = B.PTAFDEFN_ID AND A.PTAFPRCS_ID = B.PTAFPRCS_ID AND A.EFFDT = B.EFFDT AND A.PTAFSTAGE_NBR = B.PTAFSTAGE_NBR AND A.PTAFPATH_ID = B.PTAFPATH_ID AND B.PTAFSTEP_INSTANCE = C.PTAFSTEP_INSTANCE AND (%DateTimeDiff(C.PTAFDTTM_MODIFIED,%CurrentDateTimeIn) - (A.PTAFNUMBER_HOURS + (A.PTAFNUMBER_DAYS *24))* 60) > 0 AND C.PTAFSTEP_STATUS = 'P' AND (A.PTAFNUMBER_HOURS > 0 OR A.PTAFNUMBER_DAYS > 0)

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
EFFDTDate(10)DATEEffective Date

Default: %date

PTAFSTAGE_NBRNumber(3,0)SMALLINT NOT NULLStage Number
PTAFPATH_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Path ID
PTAFSTEP_NBRNumber(6,2)DECIMAL(5,2) NOT NULLSequence number of step in its path
PTAFTHREAD_IDNumber(10,0)DECIMAL(10) NOT NULLThread ID
PTAFSTEP_INSTANCENumber(15,0)DECIMAL(15) NOT NULLObject id of a step instance. Generated off the main thread id for the approval process.
PTAFUSTEP_INST_IDNumber(15,0)DECIMAL(15) NOT NULLObject id of a step instance. Generated off the main thread id for the approval process.
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PTAFDTTM_MODIFIEDDateTime(26)TIMESTAMPDatetime modified
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19