HR_TBH_TMPL_SCH

(SQL View)
Index Back

Template Configuration table

The Template Configuration table is a single child of the Template Header Table, and will store template configuration fields.

SELECT A.TBH_TMPL_ID , A.DESCR50 , A.TBH_TMPL_STATUS , B.TBH_PER_ORG , C.XLATLONGNAME , B.COUNTRY , D.DESCR , B.CATEGORY_CD , E.DESCR50 FROM PS_HR_TBH_TMPL_HDR A , PS_HR_TBH_TMPL_CFG B , PSXLATITEM C , PS_COUNTRY_TBL D , PS_HR_TBH_CTG_TBL E WHERE A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_HR_TBH_TMPL_HDR A1 WHERE A1.TBH_TMPL_ID = A.TBH_TMPL_ID) AND B.TBH_TMPL_ID = A.TBH_TMPL_ID AND B.EFFDT = A.EFFDT AND C.FIELDNAME = 'TBH_PER_ORG' AND C.FIELDVALUE = B.TBH_PER_ORG AND %EffdtCheck(PSXLATITEM C1, C, A.EFFDT) AND D.COUNTRY = B.COUNTRY AND E.CATEGORY_CD = B.CATEGORY_CD

  • Related Language Record: HR_TBH_TMPLSCHL
  • Parent record: HR_TBH_TMPL_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TBH_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 TBH_TMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
    A=Active
    I=Inactive
    T=Test
    4 TBH_PER_ORG Character(3) VARCHAR2(3) NOT NULL Organizational Relationship
    CWR=Contingent Worker
    EMP=Employee

    Default Value: EMP

    5 PER_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Description for the PER_ORG field.
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    7 COUNTRY_DESCR1 Character(30) VARCHAR2(30) NOT NULL Country Description
    8 CATEGORY_CD Character(10) VARCHAR2(10) NOT NULL Category Code

    Prompt Table: HR_TBH_CTG_TBL

    9 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50