BUSINESS_UNITQS_APP_CONTEXTQSX_NAMEALL=All Subgroups
DATE=Specific Date Range
NDAY=Daily Window
SGRP=Subgroup Window
ALL=All (Single Subset)
MFDS=Characteristic
STRM=Stream
QS_QSX_DEF_VW(SQL View) |
Index Back |
|---|---|
Data extraction view |
| SELECT business_unit , qs_app_context , qsx_name , descr , qs_selectby_cd , qs_subsetby_cd , qs_num_days , qs_num_sgrps , qs_hierfld_sw , qs_tracefld_sw , qs_cseact_sw , qs_qal_lock_sw , gref_id , qs_mod_date , qs_mod_by FROM PS_QS_QSX_DEF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 3 | QSX_NAME |
Character(24) | VARCHAR2(24) NOT NULL | Extraction Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | QS_SELECTBY_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data selection option
ALL=All Subgroups DATE=Specific Date Range NDAY=Daily Window SGRP=Subgroup Window |
| 6 | QS_SUBSETBY_CD | Character(4) | VARCHAR2(4) NOT NULL |
Options for creating QServer subsets from extracted data.
ALL=All (Single Subset) MFDS=Characteristic STRM=Stream |
| 7 | QS_NUM_DAYS | Number(4,0) | SMALLINT NOT NULL | # of days (delta days from current) |
| 8 | QS_NUM_SGRPS | Number(4,0) | SMALLINT NOT NULL | # of subgroups (delta sgrps from current) |
| 9 | QS_HIERFLD_SW | Character(1) | VARCHAR2(1) NOT NULL | Select hierarchy fields - switch |
| 10 | QS_TRACEFLD_SW | Character(1) | VARCHAR2(1) NOT NULL | Select trace fields - switch |
| 11 | QS_CSEACT_SW | Character(1) | VARCHAR2(1) NOT NULL | Select causes and actions and comments - switch |
| 12 | QS_QAL_LOCK_SW | Character(1) | VARCHAR2(1) NOT NULL | Lock Selections |
| 13 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 14 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 15 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |