HR_TBH_SECDEFN

(SQL Table)
 Index Back

Template Section Setup Table

The Template Section Setup Table is where the meta-data for each template section is stored.

  • Related Language Record: HR_TBH_SECDF_LN

  • Parent Record Of HR_TBH_HDRH_LN HR_TBH_HDR_LN HR_TBH_SECDF_LN HR_TBH_SECDTL HR_TBH_SECRECVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TBH_SECTION_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRLONG Long Character CLOB Long Description
    6 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

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

    Prompt Table: %EDITTABLE

    8 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    9 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    10 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    11 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N