HGA_CAN_AWPR_V2

(SQL View)
Index Back

Approval Transaction Registry

Global Absence Approval Transaction Registry

SELECT A.EOAWPRCS_ID , A.EOAWDEFN_ID , A.EFFDT FROM PS_EOAW_PRCS A WHERE A.EFF_STATUS = 'A'

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

Default Value: %date