PTAFAW_AUTH_SR

index back

Approval Transaction Search


SELECT DISTINCT B.PTAFPRCS_ID , B.EFFDT , A.DESCR FROM PS_PTAFAW_TXN A , PS_PTAFAW_AUTH B WHERE A.PTAFPRCS_ID = B.PTAFPRCS_ID

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID

Prompt Table: PTAFAW_TXN

EFFDTDate(10)DATEEffective Date

Default: %date

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19