QS_STRM_SRCH_VW(SQL View) |
Index Back |
|---|---|
Stream search view |
| SELECT a.business_unit , a.qs_app_context , a.stream_root_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 , a.qs_mfds_plan_id , a.qs_attrib_set_id , b.mfds_id , b.stream_id , b.str_sgrp_seq , b.mfds_collect_sw , b.clim_id , b.spec_id , b.spec_lsl , b.spec_lsl_ind , b.spec_usl , b.spec_usl_ind , b.spec_factor1 , b.spec_factor1_ind , b.spec_factor2 , b.spec_factor2_ind , b.clim_sts_cd , c.mfds_name , c.mfds_sgrp_size , c.mfds_data_type_cd , c.mfds_class_type_cd , c.mfds_units , c.chart_id , c.proc_id , c.gref_id , d.qs_mfds_plan_name , e.clim_upper_x , e.clim_ux_ind , e.clim_mean_x , e.clim_mx_ind , e.clim_lower_x , e.clim_lx_ind , e.clim_upper_mrange , e.clim_umrange_ind , e.clim_mean_range , e.clim_mrange_ind , e.clim_lower_mrange , e.clim_lmrange_ind , e.clim_cre_dttm FROM PS_QS_STREAM_ROOT a , ps_qs_stream8 b , ps_qs_mfds_mst c , ps_qs_mfds_plan d , ps_qs_cntl_lim_his e WHERE (b.stream_root_id = a.stream_root_id AND c.mfds_id = b.mfds_id AND d.qs_mfds_plan_id = c.qs_mfds_plan_id) AND (e.clim_id = b.clim_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 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 6 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 7 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 8 | 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. |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 11 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 12 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 13 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 14 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 15 | 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 |
| 16 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 17 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
| 18 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
| 19 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
| 20 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 21 | STR_SGRP_SEQ | Number(7,0) | INTEGER NOT NULL | SubGroup Sequence |
| 22 | MFDS_COLLECT_SW | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 23 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 24 | SPEC_ID | Number(7,0) | INTEGER NOT NULL | Specification |
| 25 | SPEC_LSL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower |
| 26 | SPEC_LSL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 27 | SPEC_USL | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper |
| 28 | SPEC_USL_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 29 | SPEC_FACTOR1 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 1 |
| 30 | SPEC_FACTOR1_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 31 | SPEC_FACTOR2 | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Factor 2 |
| 32 | SPEC_FACTOR2_IND | Character(1) | VARCHAR2(1) NOT NULL |
N=Null U=User Specified |
| 33 | 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 |
| 34 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 35 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 36 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables Default Value: VAR |
| 37 | MFDS_CLASS_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | characteristic - class type code |
| 38 | MFDS_UNITS | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 39 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 40 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 41 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 42 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |
| 43 | CLIM_UPPER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 44 | 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 |
| 45 | CLIM_MEAN_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 46 | 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 |
| 47 | CLIM_LOWER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 48 | 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 |
| 49 | CLIM_UPPER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 50 | 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 |
| 51 | CLIM_MEAN_RANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 52 | 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 |
| 53 | CLIM_LOWER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 54 | 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 |
| 55 | CLIM_CRE_DTTM | DateTime(26) | TIMESTAMP | Object used for Contorl Limits storage,calculation, and/or display |