QS_CONTROL_VW(SQL View) |
Index Back |
|---|
| SELECT C.BUSINESS_UNIT , C.QS_APP_CONTEXT , E.QS_MFDS_PLAN_NAME , D.MFDS_NAME , E.QS_MOD_DATE , E.QS_MOD_BY , B.STREAM_ROOT_ID , A.STREAM_ID , B.MFDS_ID , B.MFDS_COLLECT_SW , A.CLIM_ID , A.CLIM_STS_CD , A.CLIM_UPPER_X , A.CLIM_UX_IND , A.CLIM_MEAN_X , A.CLIM_MX_IND , A.CLIM_LOWER_X , A.CLIM_LX_IND , A.CLIM_UPPER_MRANGE , A.CLIM_UMRANGE_IND , A.CLIM_MEAN_RANGE , A.CLIM_MRANGE_IND , A.CLIM_LOWER_MRANGE , A.CLIM_LMRANGE_IND , A.CLIM_CRE_DTTM , A.CLIM_CRE_BY , C.INV_ITEM_ID , C.WORK_CENTER_CODE , C.MACHINE_CODE , C.STATION_CODE , C.CUST_ID , C.VENDOR_ID , C.TASK_CODE , C.PRDN_AREA_CODE , C.CREW_CODE , C.TOOL_CODE , C.COMPL_OP_SEQ , C.PRODUCTION_TYPE , C.QC_STEP_ID , C.DE_SETUP_NAME FROM PS_QS_CNTL_LIM_HIS A , PS_QS_STREAM8 B , PS_QS_STREAM_ROOT C , PS_QS_MFDS_MST D , PS_QS_MFDS_PLAN E WHERE (B.STREAM_ID = A.STREAM_ID) AND (C.STREAM_ROOT_ID = B.STREAM_ROOT_ID) AND (D.MFDS_ID = B.MFDS_ID) AND (E.QS_MFDS_PLAN_ID = D.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 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 4 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 5 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 6 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |
| 7 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 8 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 9 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 10 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 11 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 12 | CLIM_STS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Status of Control Limit Calculations
ASGN=Assigned MON=Monitor NONE=None ONG=OnGoing PRE=Preliminary RCLC=ReCalc RSET=Reset |
| 13 | CLIM_UPPER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 14 | CLIM_UX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 15 | CLIM_MEAN_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 16 | CLIM_MX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display--indicates if value is a zero or null
N=Null S=System Assigned U=User Defined |
| 17 | CLIM_LOWER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 18 | CLIM_LX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates whether value is zero or null
N=Null S=System Assigned U=User Defined |
| 19 | CLIM_UPPER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 20 | CLIM_UMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 21 | CLIM_MEAN_RANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 22 | CLIM_MRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates if the value is a zero or a null
N=Null S=System Assigned U=User Defined |
| 23 | CLIM_LOWER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 24 | CLIM_LMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined |
| 25 | CLIM_CRE_DTTM | DateTime(26) | TIMESTAMP | Object used for Contorl Limits storage,calculation, and/or display |
| 26 | CLIM_CRE_BY | Character(30) | VARCHAR2(30) NOT NULL | object used for Contorl Limits storage,calculation, and/or display |
| 27 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 28 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 29 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 30 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 31 | 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. |
| 32 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 33 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 34 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 35 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 36 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 37 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 38 | 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 |
| 39 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 40 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |