PROCESS_INSTANCE1=1
2=2
1=1
2=2
3=3
ANY=Any
DEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
1=X & Moving Range
2=Xbar & Range
3=Xbar & Sigma
4=c Chart
5=u Chart
6=p Chart
7=np Chart
UPG_QS_CHRT_AET(SQL Table) |
Index Back |
|---|---|
AEState-Upgrade Charts7.5 to 8.0 -- rre |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CHART_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Control Chart Name |
| 5 | CHART_PROTOTYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Chart Prototype
1=1 2=2 |
| 6 | CHART_ZONES_CD | Character(1) | VARCHAR2(1) NOT NULL |
Test Zones
1=1 2=2 3=3 |
| 7 | 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 |
| 8 | CHART_CONSTANT_SW | Character(1) | VARCHAR2(1) NOT NULL | Constant Subgroup Size |
| 9 | CHART_OBSERV | Character(64) | VARCHAR2(64) NOT NULL | Observ |
| 10 | CHART_C1_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |
| 11 | CHART_C1_PLOT_EQ | Character(64) | VARCHAR2(64) NOT NULL | Plot X = |
| 12 | CHART_C1_VARS_EQ | Character(64) | VARCHAR2(64) NOT NULL | Vars V = |
| 13 | CHART_C1_L1_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL1 = |
| 14 | CHART_C1_L1_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 15 | CHART_C1_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 16 | CHART_C1_L2_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 17 | CHART_C1_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 18 | CHART_C1_L3_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 19 | CHART_C2_LABEL | Character(12) | VARCHAR2(12) NOT NULL | Object used for Charts |
| 20 | CHART_C2_PLOT_EQ | Character(64) | VARCHAR2(64) NOT NULL | Plot X = |
| 21 | CHART_C2_VARS_EQ | Character(64) | VARCHAR2(64) NOT NULL | Vars V = |
| 22 | CHART_C2_L1_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL1 = |
| 23 | CHART_C2_L1_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 24 | CHART_C2_L2_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL2 = |
| 25 | CHART_C2_L2_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 26 | CHART_C2_L3_EQ | Character(64) | VARCHAR2(64) NOT NULL | CL3 = |
| 27 | CHART_C2_L3_ORD | Number(1,0) | SMALLINT NOT NULL | |
| 28 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 29 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |
| 30 | QS_UPG_COUNTER | Number(9,0) | DECIMAL(9) NOT NULL | COUNTER |
| 31 | 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 |