GPIN_ABS_ENT_VW

(SQL View)
 Index Back

India Absence Entitlement 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 IN ('AE','AT','AC', 'AA') AND b.COUNTRY = 'IND'

# 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