QS_MFDSINQ_VW(SQL View) |
Index Back |
|---|---|
MFDS inquire view |
| SELECT A.BUSINESS_UNIT , A.QS_APP_CONTEXT , A.STREAM_ROOT_ID , A.QS_MFDS_PLAN_ID , A.INV_ITEM_ID , A.WORK_CENTER_CODE , A.MACHINE_CODE , A.STATION_CODE , A.CUST_ID , A.VENDOR_ID , A.TASK_CODE , A.PRDN_AREA_CODE , A.CREW_CODE , A.TOOL_CODE , A.COMPL_OP_SEQ , A.PRODUCTION_TYPE , A.QC_STEP_ID , B.QS_MFDS_PLAN_NAME , C.MFDS_NAME , C.MFDS_CLASS_TYPE_CD , C.SPEC_USL_IND , C.SPEC_USL , C.SPEC_LSL_IND , C.SPEC_LSL , C.MFDS_UNITS , C.MFDS_ID , C.MFDS_COLLECT_SW FROM PS_QS_STREAM_ROOT A , PS_QS_MFDS_PLAN B , PS_QS_MFDS_MST C WHERE (B.QS_MFDS_PLAN_ID = A.QS_MFDS_PLAN_ID) AND (C.QS_MFDS_PLAN_ID= B.QS_MFDS_PLAN_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | QS_APP_CONTEXT | Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 3 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 4 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 7 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 8 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 9 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 10 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 11 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 12 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 13 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 14 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 15 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 16 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 17 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 18 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 19 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 20 | MFDS_CLASS_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | characteristic - class type code |
| 21 | SPEC_USL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 22 | SPEC_USL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper |
| 23 | SPEC_LSL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 24 | SPEC_LSL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower |
| 25 | MFDS_UNITS | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 26 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 27 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |