SETIDPrompt Table: SP_SETID_NONVW
PROCESS_GROUPPrompt Table: COMBO_GROUP_TBL
COMBINATIONEFFDT_FROMEFFDT_OPENEFFDT_TOCOMBO_DEFN_NAMEI=Invalid Combinations
V=Valid Combinations
COMBO_DATAB_VW(SQL View) |
Index Back |
|---|---|
ChartField Combo Data View |
| SELECT DISTINCT a.setid , a.process_group , a.combination , a.effdt_from , a.effdt_open , a.effdt_to , b.combo_defn_name , b.combo_direction FROM ps_combo_data_BUDG a , PS_COMBO_GROUP_TBL b WHERE a.setid = b.setid AND a.process_group = b.process_group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Process Group
Prompt Table: COMBO_GROUP_TBL |
| 3 | COMBINATION |
Character(10) | VARCHAR2(10) NOT NULL | Combination Rule |
| 4 | EFFDT_FROM |
Date(10) | DATE NOT NULL | Effective Date From |
| 5 | EFFDT_OPEN |
Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 6 | EFFDT_TO |
Date(10) | DATE NOT NULL | Effective Date To |
| 7 | COMBO_DEFN_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Combo CF Definition |
| 8 | COMBO_DIRECTION | Character(1) | VARCHAR2(1) NOT NULL |
Combination Group Defines
I=Invalid Combinations V=Valid Combinations |