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 Name Field Type Column Type Description
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

Prompt Table: PTAFAW_TXN

EFFDT Date(10) DATE Effective Date

Default: %date

DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19