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

    • # 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
    N=Name

    Default Value: G

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

    Prompt Table: %EDITTABLE

    8 TBH_SEC_PRODUCT Character(2) VARCHAR2(2) NOT NULL Section product.
    BA=Benefits Administration
    EG=Education and Government
    GA=Absence Management
    GP=Global Payroll
    TL=Time and Labor
    9 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    10 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    11 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    12 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N