Overview

This command will list the general data of the MSA study.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
RRMSA	MSA study data	CDMSA	OBOBJECT ADDOCUMENT DCDOCREVISION ADTEAM ADAPPROVALROUTE
OBOBJECT	Data of the asset used in the MSA study	CDOBJECT CDREVISION	RRMSA
ADDOCUMENT	Procedures (SE Asset)	CDDOC	RRMSA
DCDOCREVISION	Document data (SE Document)	CDDOCUMENT CDREVISION	RRMSA
ADTEAM	Team data	CDTEAM	RRMSA
ADAPPROVALROUTE	Draft / Approval route data	CDAPPROVALROUTE	RRMSA

Oracle/Postgres/SQL Server

SELECT
   MSA.CDMSA,
   MSA.IDMSA,
   GAGE.IDOBJECT AS IDGAGE,
   GAGE.NMOBJECT AS NMGAGE,
   MSA.DTMSA,
   MSA.FGTYPEMSA,
   MSA.FGSTATUS,
   MSA.QTSAMPLE,
   MSA.QTSAMPLESIZE,
   MSA.DSOBSERVATION,
   MSA.FGDEGFREEDOM,
   MSA.FGTYPERESULTRR,
   MSA.VLRRTOLERANCE,
   MSA.VLCRITERIARRAPP,
   MSA.VLCRITERIARRREP,
   CASE
   WHEN MSA.FGUSEISODOC = 1 THEN DCDOC.IDDOCUMENT
   ELSE ADDOC.IDDOC
   END AS IDDOCUMENT,
   CASE
   WHEN FGUSEISODOC = 1 THEN DCDOC.NMTITLE
   ELSE ADDOC.NMDOC
   END AS NMDOCUMENT,
   TEAM.IDTEAM AS IDCOLLECTTEAM,
   TEAM.NMTEAM AS NMCOLLECTTEAM,
   ELABROUTE.IDAPPROVALROUTE AS IDELABROUTE,
   ELABROUTE.NMAPPROVALROUTE AS NMELABROUTE,
   APPROVALROUTE.IDAPPROVALROUTE AS IDAPPROVALROUTE,
   APPROVALROUTE.NMAPPROVALROUTE AS NMAPPROVALROUTE
FROM
   RRMSA MSA
   INNER JOIN OBOBJECT GAGE ON (MSA.CDGAGE = GAGE.CDOBJECT AND GAGE.FGCURRENT = 1)
   LEFT JOIN ADDOCUMENT ADDOC ON (MSA.CDDOCUMENT = ADDOC.CDDOC)
   LEFT JOIN DCDOCREVISION DCDOC ON (MSA.CDDOCISODOC = DCDOC.CDDOCUMENT AND DCDOC.FGCURRENT = 1)
   LEFT JOIN ADTEAM TEAM ON (MSA.CDCOLLECTTEAM = TEAM.CDTEAM)
   LEFT JOIN ADAPPROVALROUTE ELABROUTE ON (MSA.CDELABROUTE = ELABROUTE.CDAPPROVALROUTE)
   LEFT JOIN ADAPPROVALROUTE APPROVALROUTE ON (MSA.CDAPPROVALROUTE = APPROVALROUTE.CDAPPROVALROUTE)
WHERE
   1=1
   AND MSA.IDMSA LIKE 'MSA_ID' /* NOTE1 */
   AND GAGE.IDOBJECT LIKE 'GAGE_ID' /* NOTE2 */

Notes

▪1: ID # of the MSA study to be filtered in the search.

▪2: ID # of the asset associated with the MSA study to be filtered in the search.

Fields used on the view screen

msa-02

#	Field ID	Type	Description
1	IDMSA	VARCHAR(50) NULL
2	IDASSET	VARCHAR(50) NULL	Asset ID #
2	NMASSET	VARCHAR(255) NULL	Asset name
3	DTMSA	DATETIME NULL
4	FGTYPEMSA	NUMERIC(2) NULL	MSA type: 1 - Linearity 2 - Range 3 - RR (Average and Range / Anova) 4 - Cross tabulation method 5 - Signal detection method 6 - Analytic method 7 - Trend - Independent sample 8 - Trend - Chart/Stability method
5	FGSTATUS	NUMERIC(2) NULL	Study status
6	QTSAMPLE	NUMERIC(10) NULL
7	QTSAMPLESIZE	NUMERIC(10) NULL
8	DSOBSERVATION	TEXT NULL
9	FGDEGFREEDOM	NUMERIC(2) NULL	Confidence interval 1 - 68.3% 2 - 95.0% 3 - 95.45% 4 - 99.0% 5 - 99.7% 6 - 90.0%
10	VLRRTOLERANCE	NUMERIC(28,12) NULL
11	VLCRITERIARRAPP	NUMERIC(28,12) NULL
12	VLCRITERIARRREP	NUMERIC(28,12) NULL
13	IDDOCUMENT	VARCHAR(50) NULL	Document ID #
13	NMDOCUMENT	VARCHAR(255) NULL	Document name
14	IDCOLLECTTEAM	VARCHAR(50) NULL	Team ID #
14	NMCOLLECTTEAM	VARCHAR(255) NULL	Team name
15	IDELABROUTE	VARCHAR(50) NULL	Draft route ID #
15	NMELABROUTE	VARCHAR(255) NULL	Draft route name
16	IDAPPROVALROUTE	VARCHAR(50) NULL	Approval route ID #
16	NMAPPROVALROUTE	VARCHAR(255) NULL	Approval route name

General MSA study data

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen