QS_UPG_QCMFD_KY(SQL Table) |
Index Back |
|---|---|
MAP:QCSTEP to Measurement PlanDuring the upgrade from Release 7.5 to Release 8.0, this record was populated with the keys from the release 7.5 record/s AND the corresponding NEW keys in the 8.0 record/s. Though this record was used as a component of the upgrade, it van be used by the customer as a resource for identifying their changed data. RRE 1/18/2000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 5 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
| 6 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 7 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 8 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 9 | OLD_CHART_ID | Number(4,0) | SMALLINT NOT NULL | Chart ID |
| 10 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 11 | OLD_GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Pref ID |
| 12 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 13 | OLD_PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure ID |
| 14 | TR_ID | Number(3,0) | SMALLINT NOT NULL | Trace Set |