GPMX_ABSTK_VW

(SQL View)
 Index Back

Mexico View - Abs Take

Mexico's View of Absences Take

SELECT B.PIN_NUM , B.PIN_NM , B.DESCR FROM PS_GP_PIN B WHERE B.PIN_TYPE = 'AT' AND (B.USED_BY = 'A' OR B.USED_BY = 'C') AND B.COUNTRY='MEX'

# 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
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description