QS_STRM_XCFG_VW

(SQL View)
 Index Back

Stream config view

selects a single stream and all related and current configuration settings

SELECT a.stream_id , 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 , a.mfds_id , a.str_sgrp_seq , a.mfds_collect_sw , a.clim_id , a.spec_id , a.spec_lsl , a.spec_lsl_ind , a.spec_usl , a.spec_usl_ind , a.spec_factor1 , a.spec_factor1_ind , a.spec_factor2 , a.spec_factor2_ind , a.clim_sts_cd , a.mfds_name , a.mfds_sgrp_size , a.mfds_data_type_cd , a.mfds_class_type_cd , a.mfds_units , a.chart_id , a.proc_id , a.gref_id , a.qs_mfds_plan_name , 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 FROM PS_QS_STRM_SRCH_VW a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STREAM_ID Number(8,0) INTEGER NOT NULL Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 QS_APP_CONTEXT Character(18) VARCHAR2(18) NOT NULL QC application context identifier
4 STREAM_ROOT_ID Number(8,0) INTEGER NOT NULL Stream Root ID - hierarchal structure
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_ID Number(8,0) INTEGER NOT NULL ADDED label field name for display purposes
19 QS_ATTRIB_SET_ID Number(5,0) INTEGER NOT NULL Attribute set ident
20 MFDS_ID Number(6,0) INTEGER NOT NULL ID of the 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