PTAFPRCSROOT_VW

(SQL View)
Index Back

SELECT PTAFPRCS_ID , PTAFDEFN_ID , EFFDT , DESCR FROM PS_PTAFAW_PRCS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
2 PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description