SETIDPrompt Table: SP_SETID_NONVW
PROCESS_GROUPPrompt Table: COMBO_GROUP_TBL
COMBINATIONEFFDT_FROMEFFDT_OPENEFFDT_TOCOMBO_DEFN_NAMEFIELD_SEQUENCECOMBO_FLDS_VW2(SQL View) |
Index Back |
|---|---|
Combo ChartField VW2 |
| SELECT DISTINCT a.setid , a.process_group , a.combination , a.effdt_from , a.effdt_open , a.effdt_to , a.combo_defn_name , b.field_sequence , b.chartfield , c.length FROM ps_combo_data_vw a , ps_combo_flds_tbl b , PSDBFIELD c WHERE a.setid = b.setid AND a.combo_defn_name = b.combo_defn_name AND b.chartfield = c.fieldname |
| # | 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 | FIELD_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 9 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 10 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |