UPG_QS_HIST_AET

(SQL Table)
Index Back

AE State-Upgrade session data

State record for data mover application engine program - used to pass values between program steps

# 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 QS_SESSN_ID_75 Number(8,0) INTEGER NOT NULL session id, 7.5 format
4 SESSN_ID Character(30) VARCHAR2(30) NOT NULL Session ID
5 STREAM_ROOT_ID Number(8,0) INTEGER NOT NULL Stream Root ID - hierarchal structure
6 QS_SESSN_DESCR Character(30) VARCHAR2(30) NOT NULL Session
7 SESSN_CRE_DTTM DateTime(26) TIMESTAMP Date Created
8 SESSN_STS_CD Character(4) VARCHAR2(4) NOT NULL Select Session for Edit
ALLO=Allocated
ANLZ=Analyzed
DISC=Discarded
DISP=Dispatched
SAVE=Saved
SUBM=Submitted
9 STREAM_ID Number(8,0) INTEGER NOT NULL Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
10 SESSN_STREAM_SEQ Number(6,0) INTEGER NOT NULL Stream Seq #
11 SESSN_STRM_STS Character(4) VARCHAR2(4) NOT NULL Session Stream Status
12 SESSN_SGRP_SEQ Number(6,0) INTEGER NOT NULL Subgroup ID
13 SESSN_SGRP_SIZE Number(13,5) DECIMAL(12,5) NOT NULL Subgroup Size
14 SESSN_SUBMIT_DTTM DateTime(26) TIMESTAMP Date Submitted
15 MFDS_DATA_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Data Type
DEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
16 SESSN_ANLZ_READY Character(1) VARCHAR2(1) NOT NULL Ready for Analysis
17 SPEC_ID Number(7,0) INTEGER NOT NULL Specification
18 SETID Character(5) VARCHAR2(5) NOT NULL SetID
19 OPERATOR Character(30) VARCHAR2(30) NOT NULL User ID
20 SRSLT_CRE_DTTM DateTime(26) TIMESTAMP Created
21 SRSLT_P1 Signed Number(14,5) DECIMAL(12,5) NOT NULL Chart 1 Result
22 SRSLT_P1_IND Character(1) VARCHAR2(1) NOT NULL
23 SRSLT_P2 Signed Number(14,5) DECIMAL(12,5) NOT NULL Chart 2 Result
24 SRSLT_P2_IND Character(1) VARCHAR2(1) NOT NULL
25 SRSLT_P3 Signed Number(14,5) DECIMAL(12,5) NOT NULL Point value, chart 3 (when chart 3 gets implemented)
26 SRSLT_P3_IND Character(1) VARCHAR2(1) NOT NULL
27 STR_SGRP_CNT Number(7,0) INTEGER NOT NULL SubGroup Count
28 QS_ATTRIB_SET_ID Number(5,0) INTEGER NOT NULL Attribute set ident
29 QS_ALARM_CNT Signed Number(4,0) DECIMAL(3) NOT NULL # control test violations occuring for a single subgroup
30 QS_ACTION_CNT Number(3,0) SMALLINT NOT NULL Corrective Actions
31 QS_CAUSE_CNT Number(3,0) SMALLINT NOT NULL Pobable Causes
32 QS_NVALUES Number(3,0) SMALLINT NOT NULL number of values
33 SPEC_VIO_SW Character(1) VARCHAR2(1) NOT NULL Spec Violation
34 QS_CLIM_CHNGD_FLAG Signed Number(4,0) DECIMAL(3) NOT NULL Control Limits Changed Flag
35 CLIM_ID Character(30) VARCHAR2(30) NOT NULL Object used for Contorl Limits storage,calculation, and/or display
36 OLD_CLIM_ID Character(30) VARCHAR2(30) NOT NULL Object used for Contorl Limits storage,calculation, and/or display
37 CLIM_STS_CD Character(4) VARCHAR2(4) NOT NULL Status of Control Limit Calculations
ASGN=Assigned
MON=Monitor
NONE=None
ONG=OnGoing
PRE=Preliminary
RCLC=ReCalc
RSET=Reset