GPAU_ABS_ENT_VW

(SQL View)
 Index Back

GPAU - Australia Abs Entl View

This view retrieves pin numbers specific to Absence Entitlement.

SELECT b.pin_num , b.pin_nm FROM PS_GP_PIN b WHERE b.pin_type = 'AE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field