| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUQS_NONVW
|
| 2 |
QS_APP_CONTEXT |
Character(18) |
VARCHAR2(18) NOT NULL |
QC application context identifier
Prompt Table:
QS_APP_DEF
|
| 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
Default Value: NDAY
|
| 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
Default Value: MFDS
|
| 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 |
DATE_FROM |
Date(10) |
DATE |
Date From
Default Value: %Date
|
| 10 |
TIME_FROM |
Time(15) |
TIMESTAMP |
From Time
Default Value: %time
|
| 11 |
DATE_TO |
Date(10) |
DATE |
Date To
Default Value: %Date
|
| 12 |
TIME_TO |
Time(15) |
TIMESTAMP |
To Time
Default Value: %time
|
| 13 |
QS_HIERFLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select hierarchy fields - switch
Y/N Table Edit
Default Value: N
|
| 14 |
QS_TRACEFLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select trace fields - switch
Y/N Table Edit
Default Value: N
|
| 15 |
QS_CSEACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select causes and actions and comments - switch
Y/N Table Edit
Default Value: Y
|
| 16 |
QS_QAL_LOCK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock Selections
Y/N Table Edit
Default Value: N
|
| 17 |
GREF_ID |
Number(4,0) |
SMALLINT NOT NULL |
Graph Preference ID
Prompt Table:
QS_GRSET_VW
|
| 18 |
QS_MOD_DATE |
DateTime(26) |
TIMESTAMP |
General modification date for record change tracking
|
| 19 |
QS_MOD_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified by "operator"
|