GPMX_ABSTK2_VW

(SQL View)
 Index Back

Absences Take View

Mexico's View of Absences Take

SELECT B.PIN_NUM , B.PIN_NM , B.DESCR FROM PS_GP_PIN B , PS_GP_ABS_TAKE C WHERE B.PIN_NUM = C.PIN_NUM AND B.PIN_TYPE = 'AT' AND (B.USED_BY = 'A' OR B.USED_BY = 'C') AND B.COUNTRY='MEX' AND C.ABS_TYPE_OPTN IN ('VAC', 'ABS', 'RET', 'OPA')

# 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