GP_ABS_REASON

(SQL Table)
Index Back

Absence Reasons

Used to identify the valid Absence Reasons associated with a specific Absence Type

  • Related Language Record: GP_ABS_RSN_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY

    3 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    10=Vacations
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description