QS_GRSET_VW

(SQL View)
 Index Back

View of all Graph Settings


SELECT GREF_ID , gref_version , GREF_NAME , QS_MOD_DATE , QS_MOD_BY , GREF_NOTE , GREF_GEN_TRANS , GREF_GEN_DIST_CD , GREF_GEN_OBSV , GREF_GEN_SGRP_SW , GREF_GEN_GRTYP_CD , GREF_GEN_GRSEL_SW , GREF_GEN_GRINT_SW , GREF_GEN_GRMOD_SW , GREF_HST_SPEC_SW , GREF_HST_CURVE_SW , GREF_HST_BXW_SW , GREF_HST_STATS_SW , GREF_HST_STSLST , GREF_CTL_FITWN_SW , GREF_CTL_CLLBL_SW , GREF_CTL_INDALM_SW , GREF_CTL_DETAIL_SW , GREF_CTL_ZONES_SW , GREF_CTL_HCLIM_SW , GREF_PAR_FITWN_SW , GREF_PAR_CUML_SW , GREF_PAR_ORD_CD , GREF_PAR_TOPN , GREF_PAR_ITEM , GREF_BRG_FITWN_SW , GREF_BRG_VALS_SW , GREF_BRG_MNMX_SW , GREF_BRG_ORD_CD , GREF_BRG_STITEM , GREF_BRG_TOPN , GREF_LNG_FITWN_SW , GREF_LNG_DETAIL_SW , GREF_LNG_PTS_SW , GREF_LNG_LINE_SW , GREF_BXP_FITWN_SW , GREF_BXP_STATS_SW , GREF_BXP_CURVE_SW , GREF_BXP_STYLE_CD , GREF_BXP_STSLST , GREF_XYZ_INACTV_SW , GREF_XYZ_ORIG0_SW , GREF_XYZ_STATS_SW , GREF_XYZ_DETAIL_SW , GREF_XYZ_CONF , GREF_DMX_ORIENT_CD , GREF_DMX_SSETLBL , GREF_DMX_COMLBL , GREF_DMX_DATLBL , GREF_DMX_STSLST FROM PS_QS_GRSET , PS_QS_VERSION

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