CHART_DESCRANY=Any
DEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
1=1
2=2
3=3
1=1
2=2
1=X & Moving Range
2=Xbar & Range
3=Xbar & Sigma
4=c Chart
5=u Chart
6=p Chart
7=np Chart
QS_CL_CHARTS_VW(SQL View) |
Index Back |
|---|---|
Variables Charts Viewmt - new for release 8. Select "copy from" chart in add mode. |
| SELECT chart_descr ,chart_id , chart_data_type_cd , chart_zones_cd ,chart_prototype_cd , chart_constant_sw ,chart_observ , chart_c1_label ,chart_c1_plot_eq , chart_c1_vars_eq , chart_c1_l1_eq ,chart_c1_l1_ord , chart_c1_l2_eq ,chart_c1_l2_ord , chart_c1_l3_eq ,chart_c1_l3_ord , chart_c2_label , chart_c2_plot_eq ,chart_c2_vars_eq , chart_c2_l1_eq ,chart_c2_l1_ord , chart_c2_l2_eq ,chart_c2_l2_ord , chart_c2_l3_eq ,chart_c2_l3_ord , qs_mod_date ,qs_mod_by , qs_chart_std FROM PS_QS_CL_CHART |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHART_DESCR |
Character(36) | VARCHAR2(36) NOT NULL | Control Chart Name |
| 2 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 3 | CHART_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Object used for Charts- indicates data type to be displayed on chart.
ANY=Any DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 4 | CHART_ZONES_CD | Character(1) | VARCHAR2(1) NOT NULL |
Test Zones
1=1 2=2 3=3 |
| 5 | CHART_PROTOTYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Chart Prototype
1=1 2=2 |
| 6 | CHART_CONSTANT_SW | Character(1) | VARCHAR2(1) NOT NULL | Constant Subgroup Size |
| 7 | CHART_OBSERV | Character(64) | VARCHAR2(64) NOT NULL | Observ |
| 8 | CHART_C1_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |
| 9 | CHART_C1_PLOT_EQ | Character(64) | VARCHAR2(64) NOT NULL | Plot X = |
| 10 | CHART_C1_VARS_EQ | Character(64) | VARCHAR2(64) NOT NULL | Vars V = |
| 11 | CHART_C1_L1_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL1 = |
| 12 | CHART_C1_L1_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 13 | CHART_C1_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 14 | CHART_C1_L2_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 15 | CHART_C1_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 16 | CHART_C1_L3_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 17 | CHART_C2_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |
| 18 | CHART_C2_PLOT_EQ | Character(64) | VARCHAR2(64) NOT NULL | Plot X = |
| 19 | CHART_C2_VARS_EQ | Character(64) | VARCHAR2(64) NOT NULL | Vars V = |
| 20 | CHART_C2_L1_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL1 = |
| 21 | CHART_C2_L1_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 22 | CHART_C2_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 23 | CHART_C2_L2_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 24 | CHART_C2_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 25 | CHART_C2_L3_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 26 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 27 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |
| 28 | QS_CHART_STD | Character(4) | VARCHAR2(4) NOT NULL |
standard control chart type
1=X & Moving Range 2=Xbar & Range 3=Xbar & Sigma 4=c Chart 5=u Chart 6=p Chart 7=np Chart |