Overview:
Command that returns data between indicators, events, and the parties responsible for system events.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
STSCMETRICSEC
|
Stores the scorecard indicator securities
|
CDSCMETRIC
CDSCORECARD
CDREVISION
CDSECURITY
|
STSCMETRIC
STSECURITYMAT
|
STSECURITYMAT
|
Stores the scorecard indicator security user materialization
|
CDSECURITY
CDUSER
CDPROFILEPERMISSION
FGPERMISSIONTYPE
|
STSECURITYDEF
GNPROFILEPERMISSION
|
GNPROFILEPERMISSION
|
Stores permission profiles
|
CDPROFILEPERMISSION
|
GNPROFILEPERMISSIONDEF
|
GNPROFILEPERMISSIONDEF
|
Stores the permission profile control definition
|
CDPROFILEPERMISSION
|
STSECURITYDEF
|
STSCMETRIC
|
Stores the scorecard indicators
|
CDSCMETRIC
CDSCORECARD
CDREVISION
|
STSCORECARD
STMETRIC
STSCORECARDTREE
STCONFIGVIEW
GNCALENDAR
|
STSCORECARD
|
Stores the scorecards
|
CDSCORECARD
CDREVISION
|
STSCSTRUCTITEM
STSCMETRIC
STCONFIGVIEW
|
ADUSER
|
Stores system users
|
CDUSER
|
STSECURITYMAT
|
Oracle/Postgres/SQL Server
SELECT
STSCORECARD.IDSCORECARD,
STSCMETRIC.IDSCMETRIC,
COALESCE(ADUSER.NMUSER, 'All') AS NMUSER,
CASE GNPROFILEPERMISSIONDEF.FGPERMISSION
WHEN 2 THEN 'Edit'
WHEN 6 THEN 'View'
WHEN 24 THEN 'Target'
WHEN 25 THEN 'Measurement'
WHEN 26 THEN 'Alert'
WHEN 27 THEN 'NA'
WHEN 28 THEN 'Responsible'
ELSE
'Others'
END AS PERMISSAO
FROM STSCMETRICSEC
INNER JOIN STSECURITYMAT ON (STSECURITYMAT.CDSECURITY = STSCMETRICSEC.CDSECURITY)
INNER JOIN GNPROFILEPERMISSION ON (GNPROFILEPERMISSION.CDPROFILEPERMISSION = STSECURITYMAT.CDPROFILEPERMISSION)
INNER JOIN GNPROFILEPERMISSIONDEF ON (GNPROFILEPERMISSIONDEF.CDPROFILEPERMISSION = GNPROFILEPERMISSION.CDPROFILEPERMISSION)
INNER JOIN STSCMETRIC ON (STSCMETRIC.CDSCMETRIC = STSCMETRICSEC.CDSCMETRIC)
INNER JOIN STSCORECARD ON (STSCORECARD.CDSCORECARD = STSCMETRIC.CDSCORECARD AND STSCORECARD.CDREVISION = STSCMETRIC.CDREVISION AND STSCORECARD.FGCURRENT = 1) /*NOTE 1*/
LEFT OUTER JOIN ADUSER ON (ADUSER.CDUSER = STSECURITYMAT.CDUSER)
|
Notes
▪1: The FGCURRENT field equal to 1 determines that only scorecard indicators that are in scorecards in the current revision or without revision will be displayed.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
STSCORECARD.IDSCORECARD
|
VARCHAR(50) NULL
|
Scorecard ID #
|
2
|
STSCMETRIC.IDSCMETRIC
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
Scorecard indicator ID #
|
3
|
NMUSER
|
NUMERIC(2) NULL
|
User name
|
4
|
PERMISSAO
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
|