QS_ALM_WF_AET

(SQL Table)
Index Back

Temp table for QS_ALM_DISP AE

This 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.