QS_STRMROOT_VW(SQL View) |
Index Back |
|---|---|
Process Stream instances |
| SELECT a.business_unit , a.stream_root_id , a.qs_app_context , a.qs_seq , 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.de_setup_name , b.qc_step_text , a.qs_attrib_set_id , a.qs_traceset_id , a.create_streams , a.qs_stream_count , a.qs_mod_date , a.de_method , b.descr , a.mfds_sampl_frq_cd , b.qs_mfds_plan_name FROM PS_QS_STREAM_ROOT a , ps_qs_mfds_plan b WHERE b.business_unit = a.business_unit AND b.qs_app_context = a.qs_app_context AND b.qs_mfds_plan_id = a.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 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 3 | QS_APP_CONTEXT | Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 4 | QS_SEQ | Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 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 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |
| 20 | QC_STEP_TEXT | Long Character | CLOB | Measurement Plan Instructions |
| 21 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
| 22 | QS_TRACESET_ID | Number(5,0) | INTEGER NOT NULL | Trace Set ID |
| 23 | CREATE_STREAMS | Character(1) | VARCHAR2(1) NOT NULL | Streams Created |
| 24 | QS_STREAM_COUNT | Number(5,0) | INTEGER NOT NULL | Number of active streams created |
| 25 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 26 | DE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Data Entry Method
IND=By Sample SGRP=By Subgroup |
| 27 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 28 | MFDS_SAMPL_FRQ_CD | Character(4) | VARCHAR2(4) NOT NULL | MFDS Plan - sampling frequency code |
| 29 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |