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 NameField TypeColumn TypeDescription
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID

Prompt Table: PTAFAW_TXN

PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

PTAFDEFN_PRIORITYNumber(3,0)SMALLINT NOT NULLPriority
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: A

PTAFACT_LINE_LEVELCharacter(1)VARCHAR2(1) NOT NULLTake Final Action at Line Level
N=No
Y=Yes
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PTAFADMIN_ROLENAMECharacter(30)VARCHAR2(30) NOT NULLRolename of Approval Workflow Administrator
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19