HR_TBH_TXN_CMP

(SQL Table)
 Index Back

Template Transaction Component

The Template Transaction Component table will store the transaction components, component interfaces and services for a template transaction type.

  • Parent record: HR_TBH_TXN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TBH_TMPL_TXN_TYP Character(10) VARCHAR2(10) NOT NULL Template Transaction Type

    Prompt Table: HR_TBH_TXN_TBL

    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PANELGRP_NAMES

    4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Prompt Table: COMP_MARKET_VW

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

    Prompt Table: HR_TBH_TXTID_VW

    6 TBH_TEXT_ID2 Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_TBH_TXTID_VW

    7 TBH_TEXT_ID3 Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_TBH_TXTID_VW

    8 TBH_TEXT_ID4 Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_TBH_TXTID_VW

    9 TBH_TEXT_ID5 Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_TBH_TXTID_VW

    10 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N