CMB_GRP_SLCT_VW

(SQL View)
Index Back

Combo Group Selector Tbl View

View of Combo Group Tbl data with Combo Edit Option set to 'Master SelectorTables'. Used as Process Group field prompt table in 'Review Combo Selector Tbl Data' component.

SELECT SETID , PROCESS_GROUP , DESCR FROM PS_COMBO_GROUP_TBL WHERE COMBO_EDIT_OPTION = 'R'

  • Related Language Record: CMB_GRP_SLC_LVW
  • # 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