GP_ABS_RSN_SRCH

(SQL View)
 Index Back

Absence Reasons for SES

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

SELECT A.USED_BY ,A.COUNTRY ,A.ABS_TYPE_OPTN , A.EFFDT ,A.ABSENCE_REASON ,A.DESCR ,A.DESCRSHORT FROM PS_GP_ABS_REASON A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GP_ABS_REASON A_ED WHERE A.USED_BY = A_ED.USED_BY AND A.COUNTRY = A_ED.COUNTRY AND A.ABSENCE_REASON=A_ED.ABSENCE_REASON AND A.ABS_TYPE_OPTN = A_ED.ABS_TYPE_OPTN AND A_ED.EFFDT <= %CurrentDateIn)

  • 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
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description