GP_ABS_REASN_LV

(SQL View)
Index Back

Langview for ABS REASN VW

Prompt view against Absence Reason keyed by PIN NUM without requiring USED BY or COUNTRY present on page. Used on Absence Self Service where separate COUNTRY field interfers with lookup to Absence Reasons used by ALL countries

SELECT A.USED_BY , A.COUNTRY , A.ABS_TYPE_OPTN , A.EFFDT , A.ABSENCE_REASON , A.LANGUAGE_CD , A.DESCR FROM PS_GP_ABS_RSN_LANG A

  • Related Language Record for GP_ABS_REASN_VW
  • # 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
    3 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    10=Vacations
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description