HR_TBH_TMPLS_VW

(SQL View)
Index Back

Template Section View

Joins the Template Section table with the Section Definition table.

SELECT A.TBH_TMPL_ID , A.EFFDT , A.TBH_SECTION_ID , A.SEQ_NBR , A.TEXT_ID , A.ENABLED , A.HIDDEN_FLAG , A.PAGE_NUM , A.TBH_SEC_STYLE , B.DESCRSHORT , B.DESCR50 , B.DESCRLONG , B.TBH_SECTION_TYPE , B.TBH_SEC_TYPE_VAL , B.APPCLASSID , B.APPCLASS_PATH , B.METHODNAME FROM PS_HR_TBH_TMPL_SEC A , PS_HR_TBH_SECDEFN B WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID

  • Related Language Record: HR_TBH_TMPLSVWL
  • 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 TBH_SECTION_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID

    Prompt Table: HR_TBH_SEC_VW0

    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    5 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_TBH_TXTID_VW

    6 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

    Y/N Table Edit

    Default Value: Y

    7 HIDDEN_FLAG Character(1) VARCHAR2(1) NOT NULL Hidden Flag

    Y/N Table Edit

    Default Value: N

    8 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    9 TBH_SEC_STYLE Character(1) VARCHAR2(1) NOT NULL This field is to indicate the type of the section - Tabular or Grid
    G=Grid
    T=Tabular

    Default Value: T

    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    11 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    12 DESCRLONG Long Character CLOB Long Description
    13 TBH_SECTION_TYPE Character(1) VARCHAR2(1) NOT NULL Template Section Type
    A=Address
    C=Country Specific
    F=Federal
    G=General
    J=Profile Item
    N=Name

    Default Value: G

    14 TBH_SEC_TYPE_VAL Character(12) VARCHAR2(12) NOT NULL Section Type Value

    Prompt Table: %EDITTABLE

    15 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    16 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    17 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name