PTAFAW_PRCSSRCH

index back

Approval Process Search

Approval Process Search
SELECT PTAFPRCS_ID , PTAFDEFN_ID , EFFDT , PTAFDEFN_PRIORITY , EFF_STATUS , PTAFACT_LINE_LEVEL , DESCR , PTAFADMIN_ROLENAME FROM PS_PTAFAW_PRCS

PeopleSoft Field Name Field Type Column Type Description
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

Prompt Table: PTAFAW_TXN

PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

PTAFDEFN_PRIORITY Number(3,0) SMALLINT NOT NULL Priority
EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: A

PTAFACT_LINE_LEVEL Character(1) VARCHAR2(1) NOT NULL Take Final Action at Line Level
N=No
Y=Yes
DESCR Character(30) VARCHAR2(30) NOT NULL Description
PTAFADMIN_ROLENAME Character(30) VARCHAR2(30) NOT NULL Rolename of Approval Workflow Administrator
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19