QS_CL_CHART(SQL Table) |
Index Back |
|---|---|
Control Chart DefinitionsRS 12/8/97 Made Changes for Related Language Display MT 12/10/98 Replaces QS_CHART record for rel 8 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CHART_ID |
Number(4,0) | SMALLINT NOT NULL |
Quality control chart ID
Default Value: 1 |
| 2 | CHART_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Control Chart Name |
| 3 | CHART_PROTOTYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Chart Prototype
1=1 2=2 Default Value: 2 |
| 4 | CHART_ZONES_CD | Character(1) | VARCHAR2(1) NOT NULL |
Test Zones
1=1 2=2 3=3 Default Value: 3 |
| 5 | 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 Default Value: VAR |
| 6 | CHART_CONSTANT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Constant Subgroup Size
Y/N Table Edit Default Value: N |
| 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 |
Default Value: 1 |
| 13 | CHART_C1_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 14 | CHART_C1_L2_ORD | Number(1,0) | SMALLINT NOT NULL |
Default Value: 2 |
| 15 | CHART_C1_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 16 | CHART_C1_L3_ORD | Number(1,0) | SMALLINT NOT NULL |
Default Value: 3 |
| 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 |
Default Value: 1 |
| 22 | CHART_C2_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 23 | CHART_C2_L2_ORD | Number(1,0) | SMALLINT NOT NULL |
Default Value: 2 |
| 24 | CHART_C2_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 25 | CHART_C2_L3_ORD | Number(1,0) | SMALLINT NOT NULL |
Default Value: 3 |
| 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 |