QS_GRSETS_VW

(SQL View)
 Index Back

List target grsets for copy


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GREF_NAME Character(30) VARCHAR2(30) NOT NULL Graph Preference Name
2 GREF_ID Number(4,0) SMALLINT NOT NULL Graph Preference ID
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
7 GREF_GEN_DIST_CD Character(4) VARCHAR2(4) NOT NULL Data Distribution
BFIT=Pearson Best Fit
NRMA=Normality Assumed
NRMT=Test For Normality
8 GREF_GEN_OBSV Number(4,0) SMALLINT NOT NULL Minimum Observations
9 GREF_GEN_SGRP_SW Character(1) VARCHAR2(1) NOT NULL Calculate Subgroup Statistics
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
11 GREF_GEN_GRSEL_SW Character(1) VARCHAR2(1) NOT NULL Allow Graph Selections
12 GREF_GEN_GRINT_SW Character(1) VARCHAR2(1) NOT NULL Interactive Graphics
13 GREF_GEN_GRMOD_SW Character(1) VARCHAR2(1) NOT NULL Enable Graph Modifications
14 GREF_HST_SPEC_SW Character(1) VARCHAR2(1) NOT NULL Indicate Specs on Histogram
15 GREF_HST_CURVE_SW Character(1) VARCHAR2(1) NOT NULL Overlay Distribution Curve
16 GREF_HST_BXW_SW Character(1) VARCHAR2(1) NOT NULL Overlay Box and Whisker Plot
17 GREF_HST_STATS_SW Character(1) VARCHAR2(1) NOT NULL Enable Summary Stats List
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
20 GREF_CTL_CLLBL_SW Character(1) VARCHAR2(1) NOT NULL Display Control Limit Labels
21 GREF_CTL_INDALM_SW Character(1) VARCHAR2(1) NOT NULL Display Control Chart Alarms
22 GREF_CTL_DETAIL_SW Character(1) VARCHAR2(1) NOT NULL Enable Point Detail List
23 GREF_CTL_ZONES_SW Character(1) VARCHAR2(1) NOT NULL Display Test Zones
24 GREF_CTL_HCLIM_SW Character(1) VARCHAR2(1) NOT NULL Display Varying Limits
25 GREF_PAR_FITWN_SW Character(1) VARCHAR2(1) NOT NULL Fit Cells to Window
26 GREF_PAR_CUML_SW Character(1) VARCHAR2(1) NOT NULL Overlay Cumulative Percentages
27 GREF_PAR_ORD_CD Character(4) VARCHAR2(4) NOT NULL Cell Graphing Order
ASC=Ascending Values
DSC=Descending Values
28 GREF_PAR_TOPN Number(2,0) SMALLINT NOT NULL Pareto Cell Display Limit
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
30 GREF_BRG_FITWN_SW Character(1) VARCHAR2(1) NOT NULL Fit Bars to Window
31 GREF_BRG_VALS_SW Character(1) VARCHAR2(1) NOT NULL Display Bar Values
32 GREF_BRG_MNMX_SW Character(1) VARCHAR2(1) NOT NULL Indicate Min and Max Bars
33 GREF_BRG_ORD_CD Character(4) VARCHAR2(4) NOT NULL Bar Graphing Order
ASC=Ascending Values
DSC=Descending Values
SELS=By Selection
34 GREF_BRG_STITEM Number(4,0) SMALLINT NOT NULL Default Statistic
35 GREF_BRG_TOPN Number(2,0) SMALLINT NOT NULL Bar Graph Display Limit
36 GREF_LNG_FITWN_SW Character(1) VARCHAR2(1) NOT NULL Fit Points to Window
37 GREF_LNG_DETAIL_SW Character(1) VARCHAR2(1) NOT NULL Enable Point Detail List
38 GREF_LNG_PTS_SW Character(1) VARCHAR2(1) NOT NULL Draw Points
39 GREF_LNG_LINE_SW Character(1) VARCHAR2(1) NOT NULL Draw Connecting Lines
40 GREF_BXP_FITWN_SW Character(1) VARCHAR2(1) NOT NULL Fit Plots to Window
41 GREF_BXP_STATS_SW Character(1) VARCHAR2(1) NOT NULL Enable Summary Stats List
42 GREF_BXP_CURVE_SW Character(1) VARCHAR2(1) NOT NULL Overlay 3 Sigma Regions
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
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
46 GREF_XYZ_ORIG0_SW Character(1) VARCHAR2(1) NOT NULL Set Scale Origin at 0,0
47 GREF_XYZ_STATS_SW Character(1) VARCHAR2(1) NOT NULL Enable Summary Stats List
48 GREF_XYZ_DETAIL_SW Character(1) VARCHAR2(1) NOT NULL Enable Point Detail List
49 GREF_XYZ_CONF Character(4) VARCHAR2(4) NOT NULL Confidence Interval
.0=None
.682=.682
.900=.900
.950=.950
.990=.990
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
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