HR_TBH_SECDTL

(SQL Table)
 Index Back

Template Section Field Setup

The Template Section Field Setup Table, a child of the Template Section Setup Table, is where the meta-data for each field included in the section is stored.

  • Parent record: HR_TBH_SECDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TBH_SECTION_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: HR_TBH_RECSCHVW

    3 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

    Default Value: 1

    Prompt Table: HR_TBH_RECDEFN

    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HR_TBH_RECDTLVW

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

    Default Value: 1

    6 TBH_DISPLAY_TYPE Character(2) VARCHAR2(2) NOT NULL Template Display type
    C=CheckBox
    D=Date
    LD=DropDown
    LE=Edit Box
    LG=Long Edit Box
    LP=Prompt
    SD=Short DropDown
    SE=Short Edit Box
    SP=Short Prompt

    Default Value: LE

    7 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: HR_TBH_RECLKPVW

    8 PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL This defines what field should be used when forming a prompt for a Configurable Matrix item.

    Prompt Table: HR_TBH_PRMFLDVW

    9 TBH_DD_LIST_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether code, description or both are shown in a dropdown list.
    B=Code and Description
    C=Code Only
    D=Description Only

    Default Value: D

    10 UPDATE_BLANK_FLG Character(1) VARCHAR2(1) NOT NULL Include Blanks flag

    Y/N Table Edit

    Default Value: N

    11 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    12 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    13 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    14 APPCLASSID2 Character(30) VARCHAR2(30) NOT NULL Application Class ID
    15 APPCLASS_PATH2 Character(254) VARCHAR2(254) NOT NULL Application Class Path
    16 METHODNAME2 Character(32) VARCHAR2(32) NOT NULL Method Name
    17 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N