GP_ABS_EA_TK_VW

(SQL View)
 Index Back

All Extended Absence Takes

View for all the Extended Absence Takes.

SELECT DISTINCT PIN.PIN_NUM , PIN.DESCR FROM PS_GP_PIN PIN , PS_GP_ABS_SS SS WHERE PIN.PIN_NUM < 50000000 AND SS.PIN_TAKE_NUM=PIN.PIN_NUM AND SS.ALLOW_EA_ENTRY = 'Y'

  • Related Language Record: GP_ABS_EA_TK_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description