| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GREF_ID |
Number(4,0) |
SMALLINT NOT NULL |
Graph Preference ID
Default Value: 1
|
| 2 |
GREF_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Graph Preference Name
|
| 3 |
QS_MOD_DATE |
DateTime(26) |
TIMESTAMP |
General modification date for record change tracking
|
| 4 |
QS_MOD_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified by "operator"
|
| 5 |
GREF_NOTE |
Character(24) |
VARCHAR2(24) NOT NULL |
Default Graph Layout
|
| 6 |
GREF_GEN_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Transformation
0=None
1=X = Sqrt(X)
2=X = X ^ 2
3=X = Ln(X)
4=X = Log10(X)
5=X = 1/X
Default Value: 0
|
| 7 |
GREF_GEN_DIST_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Data Distribution
BFIT=Pearson Best Fit
NRMA=Normality Assumed
NRMT=Test For Normality
Default Value: NRMA
|
| 8 |
GREF_GEN_OBSV |
Number(4,0) |
SMALLINT NOT NULL |
Minimum Observations
Default Value: 30
|
| 9 |
GREF_GEN_SGRP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Subgroup Statistics
Y/N Table Edit
Default Value: N
|
| 10 |
GREF_GEN_GRTYP_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
graph preferences - default graph type selector
602=Spreadsheet
603=Histogram
604=Bar Graph
605=Control Chart
609=Line Graph
610=Pareto Chart
612=Stats Matrix
615=Box Plots
Default Value: 603
|
| 11 |
GREF_GEN_GRSEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Graph Selections
Y/N Table Edit
Default Value: Y
|
| 12 |
GREF_GEN_GRINT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interactive Graphics
Y/N Table Edit
Default Value: Y
|
| 13 |
GREF_GEN_GRMOD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Graph Modifications
Y/N Table Edit
Default Value: Y
|
| 14 |
GREF_HST_SPEC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate Specs on Histogram
Y/N Table Edit
Default Value: Y
|
| 15 |
GREF_HST_CURVE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Overlay Distribution Curve
Y/N Table Edit
Default Value: Y
|
| 16 |
GREF_HST_BXW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Overlay Box and Whisker Plot
Y/N Table Edit
Default Value: N
|
| 17 |
GREF_HST_STATS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Summary Stats List
Y/N Table Edit
Default Value: Y
|
| 18 |
GREF_HST_STSLST |
Character(254) |
VARCHAR2(254) NOT NULL |
Statistics List
|
| 19 |
GREF_CTL_FITWN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fit Points to Window
Y/N Table Edit
Default Value: Y
|
| 20 |
GREF_CTL_CLLBL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Control Limit Labels
Y/N Table Edit
Default Value: Y
|
| 21 |
GREF_CTL_INDALM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Control Chart Alarms
Y/N Table Edit
Default Value: Y
|
| 22 |
GREF_CTL_DETAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Point Detail List
Y/N Table Edit
Default Value: Y
|
| 23 |
GREF_CTL_ZONES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Test Zones
Y/N Table Edit
Default Value: Y
|
| 24 |
GREF_CTL_HCLIM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Varying Limits
Y/N Table Edit
Default Value: Y
|
| 25 |
GREF_PAR_FITWN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fit Cells to Window
Y/N Table Edit
Default Value: Y
|
| 26 |
GREF_PAR_CUML_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Overlay Cumulative Percentages
Y/N Table Edit
Default Value: Y
|
| 27 |
GREF_PAR_ORD_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Cell Graphing Order
ASC=Ascending Values
DSC=Descending Values
Default Value: DSC
|
| 28 |
GREF_PAR_TOPN |
Number(2,0) |
SMALLINT NOT NULL |
Pareto Cell Display Limit
Default Value: 25
|
| 29 |
GREF_PAR_ITEM |
Character(2) |
VARCHAR2(2) NOT NULL |
Default Pareto Chart Item
14=Control Test Violations
15=Defects
16=Probable Causes
17=Corrective Actions
Default Value: 15
|
| 30 |
GREF_BRG_FITWN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fit Bars to Window
Y/N Table Edit
Default Value: Y
|
| 31 |
GREF_BRG_VALS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Bar Values
Y/N Table Edit
Default Value: Y
|
| 32 |
GREF_BRG_MNMX_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate Min and Max Bars
Y/N Table Edit
Default Value: N
|
| 33 |
GREF_BRG_ORD_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Bar Graphing Order
ASC=Ascending Values
DSC=Descending Values
SELS=By Selection
Default Value: SELS
|
| 34 |
GREF_BRG_STITEM |
Number(4,0) |
SMALLINT NOT NULL |
Default Statistic
Default Value: 1
Prompt Table:
QS_STATITEM
|
| 35 |
GREF_BRG_TOPN |
Number(2,0) |
SMALLINT NOT NULL |
Bar Graph Display Limit
Default Value: 25
|
| 36 |
GREF_LNG_FITWN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fit Points to Window
Y/N Table Edit
Default Value: Y
|
| 37 |
GREF_LNG_DETAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Point Detail List
Y/N Table Edit
Default Value: Y
|
| 38 |
GREF_LNG_PTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Draw Points
Y/N Table Edit
Default Value: Y
|
| 39 |
GREF_LNG_LINE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Draw Connecting Lines
Y/N Table Edit
Default Value: Y
|
| 40 |
GREF_BXP_FITWN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fit Plots to Window
Y/N Table Edit
Default Value: Y
|
| 41 |
GREF_BXP_STATS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Summary Stats List
Y/N Table Edit
Default Value: Y
|
| 42 |
GREF_BXP_CURVE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Overlay 3 Sigma Regions
Y/N Table Edit
Default Value: N
|
| 43 |
GREF_BXP_STYLE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Graph Style
1=Box and Whisker
2=Capability Graph
3=Min and Max Plot
Default Value: 1
|
| 44 |
GREF_BXP_STSLST |
Character(254) |
VARCHAR2(254) NOT NULL |
Statistics List
|
| 45 |
GREF_XYZ_INACTV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Draw Inactive Points
Y/N Table Edit
Default Value: Y
|
| 46 |
GREF_XYZ_ORIG0_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Scale Origin at 0,0
Y/N Table Edit
Default Value: N
|
| 47 |
GREF_XYZ_STATS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Summary Stats List
Y/N Table Edit
Default Value: Y
|
| 48 |
GREF_XYZ_DETAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Point Detail List
Y/N Table Edit
Default Value: Y
|
| 49 |
GREF_XYZ_CONF |
Character(4) |
VARCHAR2(4) NOT NULL |
Confidence Interval
.0=None
.682=.682
.900=.900
.950=.950
.990=.990
Default Value: .682
|
| 50 |
GREF_DMX_ORIENT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
stats matrix orientation type code
1=Subset vs Statistic
2=Statistic vs Subset
3=Statistic vs Group/Subset
Default Value: 1
|
| 51 |
GREF_DMX_SSETLBL |
Character(24) |
VARCHAR2(24) NOT NULL |
Subset Label
|
| 52 |
GREF_DMX_COMLBL |
Character(24) |
VARCHAR2(24) NOT NULL |
Common Col Label
|
| 53 |
GREF_DMX_DATLBL |
Character(24) |
VARCHAR2(24) NOT NULL |
Data Col Label
|
| 54 |
GREF_DMX_STSLST |
Character(254) |
VARCHAR2(254) NOT NULL |
Statistics List
|