PROCESS_INSTANCE1=X & Moving Range
2=Xbar & Range
3=Xbar & Sigma
4=c Chart
5=u Chart
6=p Chart
7=np Chart
UPG_QS_USE_AET(SQL Table) |
Index Back |
|---|---|
AEState-Upgrade ConfigState record used In App Engine program to upgrade Quality release 7.5 to 8.0 ??? 05/31/00 Removed SetCtlFld value per audit as this record does not require it. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 6 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
| 7 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 8 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 9 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 10 | OLD_GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Pref ID |
| 11 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 12 | OLD_PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure ID |
| 13 | TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |
| 14 | OLD_TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |
| 15 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 16 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 17 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 18 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 19 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 20 | TR_ID | Number(3,0) | SMALLINT NOT NULL | Trace Set |
| 21 | QS_TRACESET_ID | Number(5,0) | INTEGER NOT NULL | Trace Set ID |
| 22 | QC_STEP_TEXT | Long Character | CLOB | Measurement Plan Instructions |
| 23 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 24 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 25 | QS_ROOT_COUNT | Number(5,0) | INTEGER NOT NULL | Number of active streams created |
| 26 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 27 | OLD_CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 28 | QS_UPG_CNTR | Number(3,0) | SMALLINT NOT NULL | upgrade sequence number field |
| 29 | CLIM_CRE_DTTM | DateTime(26) | TIMESTAMP | Object used for Contorl Limits storage,calculation, and/or display |
| 30 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 31 | OLD_CHART_ID | Number(4,0) | SMALLINT NOT NULL | Chart ID |
| 32 | NEW_CHART_ID | Number(4,0) | SMALLINT NOT NULL | Chart ID |
| 33 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 34 | 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 |