COMBO_GROUP_TBL

(SQL Table)
 Index Back

ChartField Combination Groups

In GL 9 release, GL_EXPLODE column is added to support the new features for master selctor table.

  • Related Language Record: COMBO_GRP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 VALID_CODE Character(1) VARCHAR2(1) NOT NULL Indicator
    N=Not Valid
    V=Valid

    Default Value: V

    5 USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined Combination Data

    Y/N Table Edit

    Default Value: N

    6 COMBO_EDIT_OPTION Character(1) VARCHAR2(1) NOT NULL Combo Editing Option
    D=Combo Data Table
    R=Master Selector Tables

    Default Value: D

    7 COMBO_DIRECTION Character(1) VARCHAR2(1) NOT NULL Combination Group Defines
    I=Invalid Combinations
    V=Valid Combinations

    Default Value: V

    8 ANCHOR_ONLY Character(1) VARCHAR2(1) NOT NULL Anchor Values Not In Rules
    N=Mark Invalid
    Y=Mark Valid

    Default Value: Y

    9 COMBO_DEFN_NAME Character(10) VARCHAR2(10) NOT NULL Combo CF Definition

    Prompt Table: COMBO_DEFN_VW

    10 INCREMENT_FLG Character(1) VARCHAR2(1) NOT NULL Perform Incremental Load

    Y/N Table Edit

    Default Value: N

    11 DESCRLONG Long Character CLOB Long Description
    12 GL_EXPLODE Character(1) VARCHAR2(1) NOT NULL Added in 9 to support explode detail values for tree node range in combination build

    Y/N Table Edit

    Default Value: N