Overview

This command will list the operators associated with the MSA study.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
RRMSA	MSA study data	CDMSA	RRMSAOPERATOR
RRMSAOPERATOR	Association of operators with the MSA study	CDMSA CDOPERATOR	RRMSA
ADUSER	Operator data	CDUSER	RRMSAOPERATOR ADUSERDEPTPOS
ADUSERDEPTPOS	Association of the operator with the department and position	CDUSER CDDEPARTMENT CDPOSITION	ADUSER ADDEPARTMENT ADPOSITION
ADDEPARTMENT	Operator department data	CDDEPARTMENT	ADUSERDEPTPOS
ADPOSITION	Operator position data	CDPOSITION	ADUSERDEPTPOS

Oracle/Postgres/SQL Server

SELECT
   MSA.IDMSA,
   USR.IDUSER,
   USR.NMUSER,
   ADDPT.IDDEPARTMENT,
   ADDPT.NMDEPARTMENT,
   ADPOS.IDPOSITION,
   ADPOS.NMPOSITION
FROM
   RRMSAOPERATOR OPER
   INNER JOIN RRMSA MSA ON (MSA.CDMSA = OPER.CDMSA)
   INNER JOIN ADUSER USR ON (USR.CDUSER = OPER.CDOPERATOR)
   LEFT OUTER JOIN ADUSERDEPTPOS ADUDP ON (ADUDP.CDUSER = USR.CDUSER AND ADUDP.FGDEFAULTDEPTPOS = 1)
   LEFT OUTER JOIN ADDEPARTMENT ADDPT ON (ADDPT.CDDEPARTMENT = ADUDP.CDDEPARTMENT)
   LEFT OUTER JOIN ADPOSITION ADPOS ON (ADPOS.CDPOSITION = ADUDP.CDPOSITION)
WHERE
   1=1
   AND MSA.IDMSA LIKE 'MSA_ID' /* NOTE1 */
   AND USR.IDUSER LIKE 'USER_ID' /* NOTE2 */

Notes

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

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

Fields used on the view screen

msa-03

#	Field ID	Type	Description
1	IDMSA	VARCHAR(50) NULL
2	IDUSER	VARCHAR(50) NULL	Operator ID #
2	NMUSER	VARCHAR(255) NULL	Operator name
3	IDDEPARTMENT	VARCHAR(50) NULL	Operator department ID #
3	NMDEPARTMENT	VARCHAR(255) NULL	Operator department name
4	IDPOSITION	VARCHAR(50) NULL	Operator position ID #
4	NMPOSITION	VARCHAR(255) NULL	Operator position name

MSA study operators

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen