PTAFAW_ESCAL_VW

Platform

View Text

Default

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.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'

PeopleSoft Field Name	Description
PTAFPRCS_ID	Approval Process ID
PTAFDEFN_ID	Definition ID
EFFDT	Effective Date Default: %date
PTAFSTAGE_NBR	Stage Number
PTAFPATH_ID	Approval Path ID
PTAFSTEP_NBR	Sequence number of step in its path
PTAFTHREAD_ID	Thread ID
PTAFSTEP_INSTANCE	Object id of a step instance. Generated off the main thread id for the approval process.
PTAFUSTEP_INST_ID	Object id of a step instance. Generated off the main thread id for the approval process.
OPRID	A user's ID
PTAFDTTM_MODIFIED	Datetime modified

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010