BUSINESS_UNITQS_APP_CONTEXTMASS_QCPLAN_IDPR=Production
RW=Rework
SV=Service
TD=Teardown
N=Inactive
X=Do not use in Search
Y=Active
Default Value: Y
QS_QCPLAN_MASS(SQL Table) |
Index Back |
|---|---|
Create mulitiple QCPlansThis record is used as a work record -- it does not store data, however in order to use it in a scroll, it needs to be defined in SQL. User defines in a panel creteria for creating Multiple QCPlans. Data is combined in a work scroll with this record. Data is then moved to QS_STREAM_ROOT record, where it is ultimately stored. rre - 01/24/01 -- Add QC_STEP_TEXT to copy over from Measurement Plan (QS_MFDS_PLAN) to QC Plan (QS_STREAM_ROOT). |
| # | 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 | MASS_QCPLAN_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 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |
| 19 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
| 20 | QS_TRACESET_ID | Number(5,0) | INTEGER NOT NULL | Trace Set ID |
| 21 | MFDS_SAMPL_FRQ_CD | Character(4) | VARCHAR2(4) NOT NULL | MFDS Plan - sampling frequency code |
| 22 | QS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive X=Do not use in Search Y=Active Default Value: Y |
| 23 | QC_STEP_TEXT | Long Character | CLOB | Measurement Plan Instructions |