GPCN_ABS_ENT_VW

(SQL View)
 Index Back

GPCN - China 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