QS_ALM_WF_AET(SQL Table) |
Index Back |
---|---|
Temp table for QS_ALM_DISP AEThis temp table is neede by the QS_ALM_DISP AE program to store the selected values and use these values will be used to trigger workflow through a BC. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | SESSN_ID | Character(30) | VARCHAR2(30) NOT NULL | Session ID |
4 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
5 | SESSN_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Date Submitted |
6 | SESSN_SGRP_SEQ | Number(6,0) | INTEGER NOT NULL | Subgroup ID |
7 | SESSN_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
8 | QS_NVALUES | Number(3,0) | SMALLINT NOT NULL | number of values |
9 | QS_VALUEREADING_1 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
10 | QS_VALUEREADING_2 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
11 | QS_VALUEREADING_3 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
12 | QS_VALUEREADING_4 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
13 | QS_VALUEREADING_5 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
14 | QS_VALUEREADING_6 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
15 | QS_VALUEREADING_7 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
16 | QS_VALUEREADING_8 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
17 | QS_VALUEREADING_9 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
18 | QS_VALUEREADING_10 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
19 | QS_VALUEREADING_11 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
20 | QS_VALUEREADING_12 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
21 | QS_VALUEREADING_13 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
22 | QS_VALUEREADING_14 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
23 | QS_VALUEREADING_15 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
24 | QS_VALUEREADING_16 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
25 | QS_VALUEREADING_17 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
26 | QS_VALUEREADING_18 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
27 | QS_VALUEREADING_19 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
28 | QS_VALUEREADING_20 | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Value |
29 | SPEC_VIO_SW | Character(1) | VARCHAR2(1) NOT NULL | Spec Violation |
30 | QS_ALARM_CNT | Signed Number(4,0) | DECIMAL(3) NOT NULL | # control test violations occuring for a single subgroup |
31 | QS_ACTION_CNT | Number(3,0) | SMALLINT NOT NULL | Corrective Actions |
32 | QS_CAUSE_CNT | Number(3,0) | SMALLINT NOT NULL | Pobable Causes |
33 | QS_COMM_CNT | Number(2,0) | SMALLINT NOT NULL | Comments |
34 | OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
35 | DISPATCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Dispatch Flag |
36 | MFDS_ID | Number(6,0) | INTEGER NOT NULL | ID of the Characteristic. |
37 | QS_APP_CONTEXT | Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
38 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
39 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
40 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
41 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
42 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
43 | 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. |
44 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
45 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
46 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
47 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
48 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
49 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
50 | 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 |
51 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
52 | QS_MFDS_PLAN_ID | Number(8,0) | INTEGER NOT NULL | ADDED label field name for display purposes |
53 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |
54 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
55 | MFDS_NAME | Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
56 | QS_MFDS_PLAN_NAME | Character(38) | VARCHAR2(38) NOT NULL | Measurement plan identifier Note: replaces qc_step_id for release 8. |