PTAFAW_STEP_VW

Platform	View Text
Default	SELECT S.PTAFPRCS_ID , S.PTAFDEFN_ID , S.EFFDT , S.PTAFSTAGE_NBR , S.PTAFPATH_ID , S.PTAFSTEP_NBR , S.PTAFTHREAD_ID , S.PTAFSTEP_INSTANCE , S.PTAFSTEP_TYPE , U.PTAFUSTEP_INST_ID , U.PTAFUSER_TYPE , U.OPRID , U.PTAFORIG_OPRID , U.PTAFSTEP_STATUS , S.PTAFADHOC_BY FROM PS_PTAFAW_STEPINST S , PS_PTAFAW_USERINST U WHERE S.PTAFSTEP_INSTANCE = U.PTAFSTEP_INSTANCE

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.
PTAFSTEP_TYPE	Type of step instance--Defined, Adhoc, Error
PTAFUSER_TYPE	Approval Workflow Events for Notification A=Approver R=Reviewer
OPRID	A user's ID Prompt Table: PSOPRDEFN
PTAFORIG_OPRID	User ID
PTAFSTEP_STATUS	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role S=Skipped T=Terminated U=Auto approved X=Deleted Y=Bypassed
PTAFADHOC_BY	User ID

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