Page tree
Skip to end of metadata
Go to start of metadata
This method of extracting information is deprecated. You should now use the CAST RestAPI to extract the information you require.

This document provides a detailed description of each CAST System View provided in the Dashboard Service (all tables/views beginning with CSV_) together with column information. Depending on your specific configuration, some tables/views may not be available.

Choose the item you would like to know more about from the menu above.

Tables

To extract the following information you can use this query in a Microsoft SQL Server environment:

SELECT
A.TABLE_NAME,
B.COLUMN_NAME,
B.DATA_TYPE,
B.CHARACTER_MAXIMUM_LENGTH

FROM
INFORMATION_SCHEMA.TABLES A,
INFORMATION_SCHEMA.COLUMNS B

WHERE
A.TABLE_NAME LIKE 'CSV_%'
AND A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_TYPE = 'BASE TABLE'

ORDER BY TABLE_NAME

CSV_PARAM

Reference table for labels used in the CSV_ views

Column Name

Label

Column Type

PARAM_TYPE

Type of the label

varchar(10)

ID

Numeric value used as ID (join on DSS_METRIC_RESULTS.METRIC_NUM_VALUE)

int(null)

LIB

Label of the status

varchar(250)

Views

To extract the following information you can use this query in a Microsoft SQL Server environment:

SELECT
A.TABLE_NAME,
B.COLUMN_NAME,
B.DATA_TYPE,
B.CHARACTER_MAXIMUM_LENGTH

FROM
INFORMATION_SCHEMA.VIEWS A,
INFORMATION_SCHEMA.COLUMNS B

WHERE
A.TABLE_NAME LIKE 'CSV_%'
AND A.TABLE_NAME = B.TABLE_NAME

ORDER BY TABLE_NAME

CSV_BCRIT_STATUS

Provides access to statuses for all contexts and all Business Criteria (both Health Factors and Rule Compliance)

Column Name

Label

Column Type

CRITERION_ID

ID number of the criterion

int(null)

CRITERION_NAME

Name of the criterion

varchar(255)

CRITERION_STATUS

Current status of the criterion (Low, Moderate, High, Very High Risk)

varchar(250)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_BCRIT_VALUES

Provides access to grades for all contexts and all Business Criteria (both Health Factors and Rule Compliances)

Column Name

Label

Column Type

CRITERION_ID

ID number of the criterion

int(null)

CRITERION_NAME

Name of the criterion

varchar(255)

CRITERION_GRADE

Current grade (1-to-4 decimal grade) of the criterion as determined by the snapshot generation process

float(null)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_DIAGDETAILS

Provides access to Quality Rule based Metric details, i.e., defect lists with associated values

Column Name

Label

Column Type

DIAG_ID

CAST Quality Rule ID number

int(null)

DIAG_NAME

CAST Quality Rule name

varchar(255)

OBJECT_ID

ID number of the object as assigned in the Analysis Service

int(null)

OBJECT_NAME

Name of the object as stored in the Analysis Service

varchar(1000)

DIAG_VALUE

CAST Quality Rule optional numerical value (cf. description)

float(null)

DIAG_OBJ

CAST Quality Rule optional reference to a participating object (cf. description)

int(null)

DIAG_TEXT

CAST Quality Rule optional text value (cf.  description)

varchar(1000)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_DISTDETAILS

Provides access to Distribution-based Metric details, i.e., Category lists with associated values

Column Name

Label

Column Type

DIST_ID

CAST distribution ID number

int(null)

DIST_NAME

CAST distribution name

varchar(255)

CAT_ID

CAST category ID number

int(null)

CAT_NAME

CAST category name

varchar(255)

OBJECT_ID

ID number of the object as assigned in the Dashboard Service

int(null)

OBJECT_NAME

Name of the object as stored in the Dashboard Service

varchar(1000)

DIST_VALUE

CAST distribution value

float(null)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_EXCEPTIONS

Provides access to the list of excluded objects for all Quality Rule- and Distribution-based Metrics

Column Name

Label

Column Type

DIAG_ID

CAST Quality Rule ID number

int(null)

DIAG_NAME

CAST Quality Rule name

varchar(255)

OBJECT_ID

ID number of the application/module as assigned in the Dashboard Service

int(null)

OBJECT_NAME

Name of the application/module as stored in the Dashboard Service

varchar(255)

OBJECT_TYPE

Object type as assigned in the Dashboard Service

int(null)

CSV_MEASDETAILS

Provides access to Measure-based Metric details, i.e., measured values on Modules

Column Name

Label

Column Type

MEASURE_ID

CAST metric ID number

int(null)

MEASURE_NAME

CAST metric name

varchar(255)

MEAS_VALUE

CAST measure value (cf. metric description)

float(null)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you're looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_METRIC_STATUS

Provides access to statuses for all Quality Rule-, Distribution- and Measure-based Metrics

Column Name

Label

Column Type

METRIC_ID

CAST metric ID number

int(null)

METRIC_NAME

CAST metric name

varchar(255)

METRIC_STATUS

Current status of the metric (Low, Moderate, High, Very High Risk)

varchar(250)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_METRIC_VALUES

Provides access to grades for all Quality Rule-, Distribution- and Measure-based Metrics

Column Name

Label

Column Type

METRIC_ID

CAST metric ID number

int(null)

METRIC_NAME

CAST metric name

varchar(255)

METRIC_GRADE

Current grade of the metric as determined by the snapshot generation process

float(null)

SNAPSHOT_ID

ID number assigned to the snapshot

int(null)

SNAPSHOT_NAME

Name assigned to the snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_OBJ_MAPPING

Provides access to object ID mapping between Dashboard and Analysis Services

Column Name

Label

Column Type

FULL_NAME

Full name of object as stored in the Dashboard Service

varchar(1000)

LOCAL_OBJECT_ID

ID number assigned to the object in the Analysis Service

int(null)

LOCAL_SITE_NAME

Name assigned to the Analysis Service in the Dashboard Service

varchar(255)

LOCAL_SITE_ID

ID number assigned to the Analysis Service in the Dashboard Service and the Analysis Service

int(null)

CENTRAL_OBJECT_ID

ID number assigned to the object in the Dashboard Service

int(null)

CSV_ORG_TREE

Provides a description of the Organization Tree (if uploaded) - see Background Facts and Business Value Metric upload.

Column Name

Label

Column Type

ORG_ID

ID number of the organization

int(null)

ORG_NAME

Name of the organization

varchar(255)

TEAM_ID

ID number of the team

int(null)

TEAM_NAME

Name of the team

varchar(255)

DEV_ID

ID number of the developer

int(null)

DEV_NAME

Name of the developer

varchar(255)

MODULE_ID

ID number of the module

int(null)

MODULE_NAME

Name of the module

varchar(255)

SNAPSHOT_ID

ID number of the Snapshot

int(null)

SNAPSHOT_NAME

Name of the Snapshot

varchar(255)

CSV_PORTF_TREE

Provides a description of the Portfolio Tree (System, Application, Module, Snapshot)

Column Name

Label

Column Type

SYST_ID

ID number of the system

int(null)

SYST_NAME

Name of the system

varchar(255)

APP_ID

ID number of the application

int(null)

APP_NAME

Name of the application

varchar(255)

MODULE_ID

ID number of the module

int(null)

MODULE_NAME

Name of the module

varchar(255)

SNAPSHOT_ID

ID number of the Snapshot

int(null)

SNAPSHOT_NAME

Name of the Snapshot

varchar(255)

SNAPSHOT_DATE

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_QUALITY_TREE

Provides a description of the Quality Rules in the Assessment Model in hierarchical form

Column Name

Label

Column Type

B_CRITERION_ID

Business criterion ID

int(null)

B_CRITERION_NAME

Business criterion name

varchar(255)

T_CRITERION_ID

Technical criterion ID

int(null)

T_CRITERION_NAME

Technical criterion name

varchar(255)

T_WEIGHT

Technical weight

float(null)

METRIC_ID

Metric ID

int(null)

METRIC_NAME

Metric name

varchar(255)

M_WEIGHT

Metric weight

float(null)

T_CRIT

Critical contribution of Technical Criterion: 1=true, 0=false

int(null)

M_CRIT

Critical contribution of Quality Rule, Distribution, Measure: 1=true, 0=false

int(null)

CSV_QUANTITY_TREE

Provides a description of the quantity metrics in the Assessment Model

Column Name

Label

Column Type

FOLDER_NAME

Name of the quantity folder

varchar(255)

FOLDER_ID

ID of the quantity folder

int(null)

METRIC_NAME

Metric name

varchar(255)

METRIC_ID

Metric ID

int(null)

CSV_QUANTITY_VAL

Provides access to quantity values for all quantity metrics

Column Name

Label

Column Type

MEASURE_ID

CAST metric ID number

int(null)

MEASURE_NAME

CAST metric name

varchar(255)

MEAS_VALUE

CAST measure value (cf. metric description)

float(null)

SNAPSHOT_ID

ID number of the Snapshot

int(null)

SNAPSHOT_NAME

Name of the Snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(1000)

CSV_TCRIT_STATUS

Provides access to statuses for all contexts and all Technical Criteria

Column Name

Label

Column Type

CRITERION_ID

ID number of the criterion

int(null)

CRITERION_NAME

Name of the criterion

varchar(255)

CRITERION_STATUS

Current status of the criterion (Low, Moderate, High, Very High Risk)

varchar(250)

SNAPSHOT_ID

ID number of the Snapshot

int(null)

SNAPSHOT_NAME

Name of the Snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_NAME

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

CSV_TCRIT_VALUES

Provides access to grades for all contexts and all Technical Criteria

Column Name

Label

Column Type

CRITERION_ID

ID number of the criterion

int(null)

CRITERION_NAME

Name of the criterion

varchar(255)

CRITERION_GRADE

Current grade of the criterion as determined by the snapshot generation process

float(null)

SNAPSHOT_ID

ID number of the Snapshot

int(null)

SNAPSHOT_NAME

Name of the Snapshot

varchar(255)

CONTEXT_ID

The id of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

int(null)

CONTEXT_NAME

The name of the context you’re looking at (the id of the module, the application, the system, the team, the developer)

varchar(255)

SNAPSHOT_NAME

Snapshot generation date in the format MM/DD/YYYY

datetime(null)

  • No labels