GP_ABS_TYP_VW

(SQL View)
 Index Back

Absence Take Types in SS

Prompt view used to list absence take types available for Self Service

SELECT DISTINCT TY.COUNTRY , TY.ABS_TYPE_OPTN , TY.EFFDT , TY.DESCR FROM PS_GP_ABS_TYPE TY

  • Related Language Record: GP_ABS_TYP_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description