Overview:

This command will list the data displayed in the fields of the scorecard indicator data screen.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
STSCMETRIC	Stores the scorecard indicators	CDSCMETRIC CDSCORECARD CDREVISION	STSCORECARD STMETRIC STSCORECARDTREE STCONFIGVIEW GNCALENDAR
STSCORECARD	Stores the scorecards	CDSCORECARD CDREVISION	STSCSTRUCTITEM STSCMETRIC STCONFIGVIEW
STMETRIC	Stores the indicators	CDMETRIC	STSCMETRIC
STSCORECARDTREE	Stores the scorecard structure	CDSCORECARDTREE CDSCORECARD CDREVISION	STSCSTRUCTITEM STSCMETRIC
STCONFIGVIEW	Stores the view profile	CDCONFIGVIEW	STSCORECARD STSCMETRIC
STSCSTRUCTITEM	Stores the scorecard elements	CDSCSTRUCTITEM CDSCORECARD CDREVISION	STSCOREITEM
STSCOREITEM	Stores the elements	CDSCOREITEM	STSCSTRUCTITEM
STRANGE	Stores the ranges	CDRANGE	STMETRIC
GNCALENDAR	Stores the calendars	CDCALENDAR	STSCMETRIC

Oracle/Postgres/SQL Server

SELECT
   STSCMETRIC.IDSCMETRIC,
   STMETRIC.IDMETRIC,
   STMETRIC.NMMETRIC,
   STSCMETRIC.FGMULTIDIMENSIONAL,
   STSCORECARD.IDSCORECARD,
   STSCORECARD.NMSCORECARD,
   COALESCE(STSCSTRUCTITEM.IDSCSTRUCTITEM, STSCORECARD.IDSCORECARD) AS IDOWNER,
   COALESCE(STSCOREITEM.NMSCOREITEM, STSCORECARD.NMSCORECARD) AS NMOWNER,
   STRANGE.IDRANGE,
   STRANGE.NMRANGE,
   COALESCE(METRICPROFILE.IDCONFIGVIEW, SCPROFILE.IDCONFIGVIEW) AS IDCONFIGVIEW,
   COALESCE(METRICPROFILE.NMCONFIGVIEW, SCPROFILE.NMCONFIGVIEW) AS NMCONFIGVIEW,
   GNCALENDAR.IDCALENDAR,
   GNCALENDAR.NMCALENDAR,
   STSCMETRIC.NMMETRICSOURCE,
   STSCMETRIC.QTTREND,
   STSCMETRIC.VLWEIGHT,
   STSCMETRIC.FGALTERWEIGHT,
   STSCMETRIC.FGSCALEDEFAULT,
   STSCMETRIC.FGTODOTASK,
   STSCMETRIC.QTDUEMEASURE,
   STSCMETRIC.DTDUETARGET,
   STSCMETRIC.DTDUEMEASURE
FROM STSCMETRIC
   INNER JOIN STSCORECARD ON(STSCORECARD.CDSCORECARD = STSCMETRIC.CDSCORECARD AND STSCORECARD.CDSCORECARD = STSCMETRIC.CDSCORECARD AND STSCORECARD.FGCURRENT = 1) /* NOTE 1 */
   INNER JOIN STMETRIC ON(STMETRIC.CDMETRIC = STSCMETRIC.CDMETRIC)
   INNER JOIN STSCORECARDTREE TREE ON(TREE.CDSCMETRIC = STSCMETRIC.CDSCMETRIC AND TREE.CDSCORECARD = STSCMETRIC.CDSCORECARD AND TREE.CDREVISION = STSCMETRIC.CDREVISION AND TREE.FGNODETYPE = 2) /* NOTE 2 */
   INNER JOIN STCONFIGVIEW SCPROFILE ON(SCPROFILE.CDCONFIGVIEW = STSCORECARD.CDCONFIGVIEW)
   LEFT OUTER JOIN STCONFIGVIEW METRICPROFILE ON(METRICPROFILE.CDCONFIGVIEW = STSCMETRIC.CDCONFIGVIEW)
   LEFT OUTER JOIN STSCORECARDTREE OWNER ON(OWNER.CDSCORECARDTREE = TREE.CDSCORECARDTREEOWNER) /* NOTE 3 */
   LEFT OUTER JOIN STSCSTRUCTITEM ON(STSCSTRUCTITEM.CDSCSTRUCTITEM = OWNER.CDSCSTRUCTITEM AND STSCSTRUCTITEM.CDSCORECARD = OWNER.CDSCORECARD AND STSCSTRUCTITEM.CDREVISION = OWNER.CDREVISION)
   LEFT OUTER JOIN STSCOREITEM ON(STSCOREITEM.CDSCOREITEM = STSCSTRUCTITEM.CDSCOREITEM)
   LEFT OUTER JOIN STRANGE ON(STRANGE.CDRANGE = STMETRIC.CDRANGE)
   LEFT OUTER JOIN GNCALENDAR ON(GNCALENDAR.CDCALENDAR = STSCMETRIC.CDCALENDAR)
WHERE STSCMETRIC.IDSCMETRIC = 'SCORECARD_INDICATOR_ID' /* NOTE 4 */

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.

▪2: The FGNODETYPE field equal to 2 determines that only records that are scorecard indicators will be filtered from the scorecard structure.

▪3: The relationship with the STSCORECARDTREE table, that uses the CDSCORECARDTREE field with the CDSCORECARDTREEOWNER field of the scorecard indicator in the structure, causes the upper level indicator element to return in the scorecard structure.

▪4: ID # of the scorecard indicator to be filtered in the search.

Fields used on the view screen

performance-01

#	Field ID	Type	Description
1	STSCMETRIC.IDSCMETRIC	VARCHAR(50) NULL
2	STME.IDMETRIC STME.NMMETRIC	VARCHAR(50) NULL VARCHAR(255) NULL
3	STSCMETRIC.FGMULTIDIMENSIONAL	NUMERIC(2) NULL	1-Yes 2-No
4	STSCORECARD.IDSCORECARD STSCORECARD.NMSCORECARD	VARCHAR(50) NULL VARCHAR(255) NULL
5	IDOWNER NMOWNER	VARCHAR(50) NULL VARCHAR(255) NULL
6	STRANGE.IDRANGE STRANGE.NMRANGE	VARCHAR(50) NULL VARCHAR(255) NULL
7	IDCONFIGVIEW NMCONFIGVIEW	VARCHAR(50) NULL VARCHAR(255) NULL
8	GNCALENDAR.IDCALENDAR GNCALENDAR.NMCALENDAR	VARCHAR(50) NULL VARCHAR(255) NULL
9	STSCMETRIC.NMMETRICSOURCE	VARCHAR(255) NULL
10	STSCMETRIC.QTTREND	NUMERIC(2) NULL
11	STSCMETRIC.VLWEIGHT	NUMERIC(28,12) NULL
12	STSCMETRIC.FGALTERWEIGHT	NUMERIC(2) NULL	1-Variable; 2-Fixed;
13	STSCMETRIC.FGSCALEDEFAULT	NUMERIC(2) NULL	1-Yes;2-No
14	STSCMETRIC.QTDUEMEASURE	NUMERIC(2) NULL
15	STSCMETRIC.DTDUETARGET	NUMERIC(2) NULL
16	STSCMETRIC.DTDUEMEASURE	DATETIME NULL
17	STSCMETRIC.FGTODOTASK	DATETIME NULL	1-Yes;2-No

Scorecard indicator data

Overview:

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen