HCSC_TAB_DTL

(SQL Table)
Index Back

Tab Definition

This record defines the tabs within a tabset structure to be displayed on a page

  • Related Language Record: HCSC_TABDTL_LNG
  • Parent record: HCSC_TAB_SET
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Default Value: HCSC_TAB_SET.PNLNAME

    Prompt Table: PSPNLDEFN_VW

    2 TABSET_ID Character(12) VARCHAR2(12) NOT NULL Tab Identifier ID

    Default Value: HCSC_TAB_SET.TABSET_ID

    Prompt Table: HCSC_TAB_SET_VW

    3 TAB_ID Character(12) VARCHAR2(12) NOT NULL Folder Tab Identifier
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 TAB_LABEL_TEXT Character(20) VARCHAR2(20) NOT NULL Tab Label Text
    6 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PTAFPACKAGE_VW

    7 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: PTAFAPCLSPTH_VW

    8 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    9 TAB_LBLTYPE Character(1) VARCHAR2(1) NOT NULL Tab Label Type
    M=Message Catalog
    S=Static Text
    T=Text Catalog

    Default Value: M

    10 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

    Prompt Table: HR_SSTEXT_OO_VW

    11 HR_SSTEXT_SUB_ID Character(4) VARCHAR2(4) NOT NULL The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.

    Prompt Table: HR_SSTEXT_OS_VW

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

    Prompt Table: HR_SSTEXT_MSGID

    13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: MSG_SET_VW

    14 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: MSG_CAT_VW