GP_ABS_TMPLSCHL

(SQL View)
 Index Back

Template Configuration table

Configurable Sections: Related language record for the Template Configuration table, which is a single child of the Template Header Table, and will store template configuration fields.

SELECT A.COUNTRY , A.GP_ABS_CS_TMPL_ID , A.LANGUAGE_CD , A.DESCR50 , C.XLATLONGNAME , D.DESCR FROM PS_GP_ABS_THDR_LNG A , PS_GP_ABS_TMPL_HDR B , PSXLATITEMLANG C , PS_COUNTRYTBL_LANG D WHERE %EffdtCheck(GP_ABS_THDR_LNG A1, A, %CurrentDateIn) AND B.GP_ABS_CS_TMPL_ID = A.GP_ABS_CS_TMPL_ID AND B.EFFDT = A.EFFDT AND C.FIELDNAME = 'GP_ABS_CS_PER_ORG' AND C.FIELDVALUE = 'EMP' AND %EffdtCheck(PSXLATITEMLANG C1, C, A.EFFDT) AND D.COUNTRY = A.COUNTRY

  • Parent record: GP_ABS_TMPL_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY

    2 GP_ABS_CS_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 PER_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Description for the PER_ORG field.
    6 COUNTRY_DESCR1 Character(30) VARCHAR2(30) NOT NULL Country Description