Overview
This command will list the characteristics associated with the MSA study.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
RRMSA
|
MSA study data
|
CDMSA
|
RRMSAITEMCHARACT
|
RRMSAITEMCHARACT
|
Association of characteristics with the MSA study
|
CDMSAITEMCHARACT
|
RRMSA
OBOBJECT
OBINPUTCHARAC
|
OBOBJECT
|
Item data
|
CDOBJECT
CDREVISION
|
RRMSAITEMCHARACT
OBINPUTCHARAC
|
GNREVISION
|
Item revision data
|
CDREVISION
|
OBOBJECT
|
OBINPUTCHARAC
|
Characteristic data
|
CDCHARACTERISTIC
|
OBOBJECT
GNREVISION
RRMSAITEMCHARACT
|
Oracle/Postgres/SQL Server
SELECT
MSA.IDMSA,
OBJ.IDOBJECT AS IDITEM,
OBJ.NMOBJECT AS NMITEM,
REV.IDREVISION AS IDITEMREVISION,
OBCHAR.IDCHARACTERISTIC,
OBCHAR.NMCHARACTERISTIC,
RRCHAR.VLPROCESSVAR,
RRCHAR.VLTOLERANCE
FROM
RRMSAITEMCHARACT RRCHAR
INNER JOIN RRMSA MSA ON (MSA.CDMSA = RRCHAR.CDMSA)
INNER JOIN OBOBJECT OBJ ON (RRCHAR.CDITEM = OBJ.CDOBJECT AND RRCHAR.CDREVISION = OBJ.CDREVISION)
INNER JOIN GNREVISION REV ON (RRCHAR.CDREVISION = REV.CDREVISION)
INNER JOIN OBINPUTCHARAC OBCHAR ON (RRCHAR.CDCHARACTERISTIC = OBCHAR.CDCHARACTERISTIC)
WHERE
OBCHAR.FGENABLED = 1
AND MSA.IDMSA LIKE 'MSAI_D' /* NOTE1 */
AND OBCHAR.IDCHARACTERISTIC LIKE 'CHARACTERISTIC_ID' /* NOTE2 */
|
Notes
▪1: ID # of the MSA study to be filtered in the search. ▪2: ID # of the characteristic associated with the MSA study to be filtered in the search.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDMSA
|
VARCHAR(50) NULL
|
|
2
|
IDITEM
|
VARCHAR(50) NULL
|
Item ID #
|
2
|
NMITEM
|
VARCHAR(255) NULL
|
Item name
|
3
|
IDITEMREVISION
|
VARCHAR(50) NULL
|
|
4
|
IDCHARACTERISTIC
|
VARCHAR(50) NULL
|
Characteristic ID #
|
4
|
NMCHARACTERISTIC
|
VARCHAR(255) NULL
|
Characteristic name
|
5
|
VLPROCESSVAR
|
NUMERIC(28,12) NULL
|
Process variation (available in some studies)
|
5
|
VLTOLERANCE
|
NUMERIC(28,12) NULL
|
Tolerance (available in some studies)
|
|