BUSINESS_UNITQS_APP_CONTEXTQUEUE_QCPLAN_IDQS_SOURCEPR=Production
RW=Rework
SV=Service
TD=Teardown
DROP=Delete
HOLD=Remain On Hold
SAVE=Move to QCPlan Area
Default Value: HOLD
QS_QCPLAN_QUEUE(SQL Table) |
Index Back |
|---|---|
QCPlans from external sourcesQCPlans can be generated from applications other than Quality. They are stored in this record. A Quality administrator would then open this record and move the rows over to QS_STREAM_ROOT where they ultimately are saved as QCPlans. |
| # | 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 | QUEUE_QCPLAN_ID |
Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 4 | QS_SOURCE |
Character(15) | VARCHAR2(15) NOT NULL | Source of QCPlan Creation |
| 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_QCPROW_ACTION | Character(4) | VARCHAR2(4) NOT NULL |
Row Action
DROP=Delete HOLD=Remain On Hold SAVE=Move to QCPlan Area Default Value: HOLD |
| 19 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 20 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |