View Source

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 DSS_ table provided in the Dashboard Service 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.

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 'DSS_%'
AND A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_TYPE = 'BASE TABLE'

ORDER BY TABLE_NAME

DSS_CENTRAL_SELECTION

This table stores modules which are selected for computation:

APPLICATION_ID	int	NULL	Module's parent application ID
COMPUTE_NOW	int	NULL	0: not to compute 1: to compute
MODULE_ID	int	NULL	Module ID
SNAPSHOT_ID	int	NULL	Module's parent snapshot ID

DSS_CONFIG_EXPORT

OBJECT_ID	int	NULL	Object ID
OBJECT_INDEX	int	NULL	Object index

DSS_DATE_SNAPSHOT

This table stores date information about snapshots that have been generated

APPLICATION_ID	int	NULL	Constituent application ID
FUNCTIONAL_DATE	datetime	NULL	Snapshot generation date in the form MM/DD/YYYY
IS_COMPUTED	int	NULL	1: real snapshot 0: false snapshot
SNAPSHOT_ID	int	NULL	Snapshot ID
TEXT_DATE	varchar	30	Snapshot generation date in the form YYYYMMDDHHMM

DSS_DIAGDETAILS

This table is used by the CAST Engineering Dashboard during a data computation after the finalization of snapshot for performance reasons.

This table is an extract of DSS_METRIC_RESULTS containing only pure violations. A "pure violation" is a simple violation (triplet object/quality rule/value), not an aggregate, grade or other Quality Rule.

CONTEXT_ID	int	NULL	The ID of the context you're looking at (the ID of the module)
DIAG_ID	int	NULL	CAST Quality Rule ID
DIAG_OBJ	int	NULL	CAST Quality Rule (optional) reference to a participating object (see Quality Rule description for more information)
DIAG_TEXT	varchar	1000	CAST Quality Rule (optional) text value (see Quality Rule description for more information)
DIAG_VALUE	float	NULL	CAST Quality Rule (optional) numerical value (see Quality Rule description for more information)
OBJECT_ID	int	NULL	ID number of the object as assigned in the Dashboard Service
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_FUNC_MODULE_LINKS

The table stores the functional modules and their parents:

MODULE_ID	int	NULL	Functional module ID
OBJECT_ID	int	NULL	Parent ID (object, Techno object, Organization object). The functional module is also a parent itself.
OBJECT_TYPE_ID	int	NULL	Parent type ID - see DSS_OBJECT_TYPES
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_HISTORY

Contains the trace of the procedures/Quality Rule procedures that are called during a snapshot generation process:

ACTION_DATE

datetime

NULL

This date on which the action started in the form MM/DD/YYYY

DESCRIPTION

varchar

500

The description of the action that has been carried out. For example:

The snapshot <SNAPSHOT_ID> is in the CAST AIP version <CAST VERSION>. Consolidation mode is <CONSOLIDATION_MODE> for the snapshot <SNAPSHOT_ID>.

HISTORY_ID

int

NULL

The order in which an action has been launched. This column was added to this table because the ACTION_DATE does not clearly highlight the exact order in which the actions are carried out.

DSS_IN_LINKS

Entry table for transfer of data from the DSS_LINKS table:

LINK_TYPE_ID	int	NULL	Link type ID. See DSS_LINK_TYPES.
NEXT_OBJECT_ID	int	NULL	ID of next object (callee)
PREVIOUS_OBJECT_ID	int	NULL	ID of previous object (caller)
SITE_ID	int	NULL	Snapshot ID

DSS_IN_METRIC_RESULTS

Entry table for transfer of data from the DSS_METRIC_RESULTS table:

METRIC_CHAR_VALUE	varchar	1000	When not null, the string result.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_NUM_VALUE	float	NULL	When not null, the numeric result.
METRIC_OBJECT_ID	int	NULL	When not null or 0, the Dashboard Service OBJECT_ID of a target.
METRIC_VALUE_INDEX	int	NULL	0: grade 1: detail 2: total 10: smart ranking 11: smart ranking -1: status 1 -2: status 2 -3: status 3 -4: status 4
OBJECT_ID	int	NULL	Object ID for the Quality Rule
SITE_ID	int	NULL	Site ID

DSS_IN_OBJECTS

Entry table for transfer of data from the DSS_OBJECTS table:

OBJECT_CHECKSUM	int	NULL	-
OBJECT_DESCRIPTION	varchar	1000	Object description
OBJECT_FULL_NAME	varchar	1000	Object full name
OBJECT_ID	int	NULL	Object ID - this ID is unique in the Dashboard Service. Use DSS_TRANSLATION_TABLE to find the ID of the Object in the Analysis Service.
OBJECT_NAME	varchar	255	Object name
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES
SITE_ID	int	NULL	Site ID

DSS_LINK_INFO

This table stores links per snapshot:

LINK_TYPE_ID	int	NULL	Link type ID. See DSS_LINK_TYPES.
NEXT_OBJECT_ID	int	NULL	ID of next object (callee)
PREVIOUS_OBJECT_ID	int	NULL	ID of previous object (caller)
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_LINK_TYPES

This table stores the different types of link:

LINK_GROUP	int	NULL	Link group: 0: link without Status (for link: 1,3,4) 1 : link with status
LINK_TYPE_DESCRIPTION	varchar	1000	Link description
LINK_TYPE_ID	int	NULL	Link type ID
LINK_TYPE_NAME	varchar	255	Link name

DSS_LINKS

LINK_TYPE_ID	int	NULL	Link type ID. See DSS_LINK_TYPES.
NEXT_OBJECT_ID	int	NULL	ID of next object (callee)
PREVIOUS_OBJECT_ID	int	NULL	ID of previous object (caller)

DSS_LOCKS

This table stores DSS locks - i.e. locks are set when an item is using the Dashboard Service:

HOST_NAME	varchar	255	Host name (for information display and connection validity check) - not available on all platforms
LOCK_NAME	varchar	255	Lock type name
LOCK_TIME	datetime	NULL	Date and time when lock was set in the form MM/DD/YYYY
PROGRAM_NAME	varchar	255	Program name (for information display and connection validity check) - not available on all platforms
SESSION_ID	int	NULL	Connection ID
SESSION_ID_2	int	NULL	Connection ID 2 (for connection validity check) - not available on all platforms
USER_NAME	varchar	255	User name (for information display and connection validity check) - not available on all platforms

DSS_LOG_LINKS

Log table for saving transferred DSS_LINKS table:

LINK_TYPE_ID	int	NULL	Link type ID. See DSS_LINK_TYPES.
NEXT_OBJECT_ID	int	NULL	ID of next object (callee)
PREVIOUS_OBJECT_ID	int	NULL	ID of previous object (caller)
SITE_ID	int	NULL	Site ID
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_LOG_METRIC_RESULTS

Log table for saving transferred DSS_METRIC_RESULTS table:

METRIC_CHAR_VALUE	varchar	1000	When not null, the string result.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_NUM_VALUE	float	NULL	When not null, the numeric result.
METRIC_OBJECT_ID	int	NULL	When not null or 0, the Dashboard Service OBJECT_ID of a target.
METRIC_VALUE_INDEX	int	NULL	0: grade 1: detail 2: total 10: smart ranking 11: smart ranking -1: status 1 -2: status 2 -3: status 3 -4: status 4
OBJECT_ID	int	NULL	Object ID for the Quality Rule
SITE_ID	int	NULL	Site ID
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_LOG_METRIC_SCOPES

Log table for saving transfered DSS_METRIC_SCOPES table:

COMPUTE_VALUE	int	NULL	-
METRIC_CHAR_VALUE	varchar	1000	When not null, the string result.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_NUM_VALUE	float	NULL	When not null, the numeric result.
METRIC_OBJECT_ID	int	NULL	When not null or 0, the Dashboard Service OBJECT_ID of a target.
METRIC_PARENT_ID	int	NULL	Quality Rule parent ID
OBJECT_ID	int	NULL	Object ID used for the scope
OBJECT_PARENT_ID	int	NULL	Object parent ID used for the scope
SITE_ID	int	NULL	Site ID
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_LOG_OBJECTS

Log table for saving transfered DSS_OBJECTS table:

OBJECT_CHECKSUM	int	NULL	-
OBJECT_DESCRIPTION	varchar	1000	Object description
OBJECT_FULL_NAME	varchar	1000	Object full name
OBJECT_ID	int	NULL	Object ID - this ID is unique in the Dashboard Service. Use DSS_TRANSLATION_TABLE to find the ID of the Object in the Analysis Service.
OBJECT_NAME	varchar	255	Object name
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES
SITE_ID	int	NULL	Site ID
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_DESCRIPTIONS

This table stores the description of the Quality Rules:

DESCRIPTION_TYPE_ID	int	NULL	Description type ID 0: Name 1: Rationale 2: Description 3: Remediation 4: Reference 5: Sample 6: Remediation sample 7: Output 8: Total
LANGUAGE	varchar	200	Language used for description string: ENGLISH FRENCH GERMAN ITALIAN
METRIC_DESCRIPTION	varchar	1500	Quality Rule description string
METRIC_ID	int	NULL	Quality Rule ID

DSS_METRIC_EXCEPTION_STATUSES

This table stores the history of exceptions encountered during the previous snapshot generation processes:

METRIC_ID	int	NULL	ID of Quality Rule in exception
OBJECT_ID	int	NULL	ID of Object in exception
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_EXCEPTIONS

This table stores the exceptions encountered during current the snapshot generation process:

METRIC_ID	int	NULL	ID of Quality Rule in exception
OBJECT_ID	int	NULL	ID of Object in exception
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_EXECUTION_LIST

This table contains a list of operations to execute during a snapshot generation process:

FLAT_INDEX	varchar	255	-
METRIC_CHILD_OR_VALUE	int	NULL	-
METRIC_ID	int	NULL	Quality Rule ID
METRIC_PARENT_ID	int	NULL	Quality Rule's parent ID
OPERATION_AGGREGATE	int	NULL
OPERATION_DONE	int	NULL	0: The operation has not made yet. 1: The operation is finished. 2: The operation is disabled. 999: The operation is on the way. 888: The operation was started, but cancelled.
OPERATION_ID	int	NULL	-
OPERATION_PROCNAME	varchar	255	-
OPERATION_TYPE	int	NULL	1: scope 2: results 3: aggregate

DSS_METRIC_FLAT_TREE

Shows Quality Rules with Parent and Grandparent

FLAT_INDEX	varchar	255	-
FLAT_LEVEL	int	NULL	-
METRIC_GRAND_PARENT_ID	int	NULL	Quality Rule's grandparent ID
METRIC_ID	int	NULL	Quality Rule ID
METRIC_INDEX	int	NULL
METRIC_PARENT_ID	int	NULL	Quality Rule's parent ID

DSS_METRIC_FOLDERS

Internal Table, folders to delete before importing metric tree:

FOLDER_ID

int

NULL

FOLDER_ID of the branch to delete

DSS_METRIC_HISTO_DELTA

This table stores delta flags on metrics between all snapshots

IS_PARAM_CHANGED	int	NULL	1 if Quality Rule parameters have changed, 0 otherwise
IS_THRESHOLD_CHANGED	int	NULL	1 if grade calculation thresholds have changed, 0 otherwise
IS_TREE_CHANGED	int	NULL	1 if child tree has changed, 0 otherwise
METRIC_ID	int	NULL	Quality Rule ID for delta examination
SNAPSHOT_ID	int	NULL	Snapshot ID for which change is defined

DSS_METRIC_HISTO_PARAMS

This table contains Quality Rule parameter values for each snapshot:

METRIC_ID	int	NULL	ID of the parametrized metric
OBJECT_TYPE_ID	int	NULL	Object type ID implied for the parameter. 0 if ignored - see DSS_OBJECT_TYPES
PARAM_CHAR_VALUE	varchar	1000	When the parameter type is string, this field contains the string.
PARAM_INDEX	int	NULL	Parameter index. First parameter index is 1.
PARAM_NUM_VALUE	float	NULL	When the parameter type is numeric, this field contains the numeric value.
SNAPSHOT_ID	int	NULL	SNAPSHOT_ID when parameter value is defined

DSS_METRIC_HISTO_THRESHOLDS

This table contains the threshold of Quality Rules for each snapshot:

METRIC_ID	int	NULL	Quality Rule ID for status distribution threshold
SNAPSHOT_ID	int	NULL	Snapshot ID when threshold value is defined
STATUS	int	NULL	Status (1-4 for Quality Rules with full distributions, 0 for binary diagnostics)
THRESHOLD_1	float	NULL	Percentage threshold between grades 1 and 2
THRESHOLD_2	float	NULL	Percentage threshold between grades 2 and 3
THRESHOLD_3	float	NULL	Percentage threshold between grades 3 and 4
THRESHOLD_4	float	NULL	Percentage threshold after grade 4

DSS_METRIC_HISTO_TREE

This table contains the Assessment Model by snapshot

AGGREGATE_WEIGHT	float	53	Weight of the current Quality Rule in order to compute the parent value.
METRIC_CRITICAL	int	NULL	1 when metric is a critical contribution for its parent, 0 otherwise
METRIC_ID	int	NULL	Quality Rule ID
METRIC_INDEX	int	NULL	Quality Rule index
METRIC_PARENT_ID	int	NULL	Quality Rule's parent ID
METRIC_TYPE	int	NULL	Metric type ID
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_PARAM_TYPES

This table lists the type of parameter for each Quality Rule:

METRIC_ID	int	NULL	Quality Rule ID
OBJECT_TYPE_ID	int	NULL	The Object type involved - because the parameter value can vary depending on the type of object. E.g. the maximum number of characters per line of code is different in Cobol than in C++ - see DSS_OBJECT_TYPES
PARAM_DESCRIPTION	varchar	1000	The parameter description, e.g.: "Maximum number of characters per line of code"
PARAM_INDEX	int	NULL	The index of parameter - the first parameter starts at 1.
PARAM_NAME	varchar	255	Parameter name, e.g.: "Maximum length"
PARAM_TYPE	int	NULL	The parameter type: 0: float 1: text 2: integer 100: float list 101: text list 102: integer list

DSS_METRIC_PARAM_VALUES

This table lists the parameter value for each Quality Rule:

METRIC_ID	int	NULL	ID of the parametrized metric
OBJECT_TYPE_ID	int	NULL	Object type ID implied for the parameter. 0 if ignored - see DSS_OBJECT_TYPES
PARAM_CHAR_VALUE	varchar	1000	When the parameter type is string, this field contains the string.
PARAM_INDEX	int	NULL	Parameter index. First parameter index is 1.
PARAM_NUM_VALUE	float	NULL	When the parameter type is numeric, this field contains the numeric value.

DSS_METRIC_RESULTS

This table stores the results of the Quality Rule calculation for a given snapshot:

METRIC_CHAR_VALUE	varchar	1000	When not null, the string result.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_NUM_VALUE	float	NULL	When not null, the numeric result.
METRIC_OBJECT_ID	int	NULL	When not null or 0, the Dashboard Service OBJECT_ID of a target.
METRIC_VALUE_INDEX	int	NULL	0: grade 1: detail 2: total 10: smart ranking 11: smart ranking -1: status 1 -2: status 2 -3: status 3 -4: status 4
OBJECT_ID	int	NULL	Object ID for the Quality Rule
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_RUN_HISTORY

Internal Table, metrics already processed during computing:

METRIC_ID	int	NULL	Quality Rule ID of the processed scope
METRIC_PARENT_ID	int	NULL	Quality Rule parent ID of the processed scope

DSS_METRIC_SCOPES

This table stores objects returned by Quality Rules

COMPUTE_VALUE	int	NULL	0: metric values to be computed 1: metric values already computed on central 2: metric values already computed on local
METRIC_CHAR_VALUE	varchar	1000	When not null, the string result.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_NUM_VALUE	float	NULL	When not null, the numeric result.
METRIC_OBJECT_ID	int	NULL	When not null or 0, the Dashboard Service OBJECT_ID of a target.
METRIC_PARENT_ID	int	NULL	Quality Rule parent ID
OBJECT_ID	int	NULL	Object ID used for the scope
OBJECT_PARENT_ID	int	NULL	Object parent ID used for the scope
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_METRIC_SIDE_PROCESS

This table lists treatments that occur before a snapshot or after a snapshot:

OPERATION_DESCRIPTION	varchar	1000	0: Treatment before the snapshot 1: Treatment after the snapshot 2: Treatment for re-consolidation -1 : Treatment after snapshot deletion
OPERATION_ID	int	NULL	ID denoting order of execution
OPERATION_PROCNAME	varchar	255	Indicates the the name of the procedure governing the treatment
PROCESS_NAME	varchar	255	-
PROCESS_SIDE	int	NULL	-

DSS_METRIC_STATUS_THRESHOLDS

This table stores thresholds (in percentages) for calculating the grade from the distribution of statute:

METRIC_ID	int	NULL	Quality Rule ID
STATUS	int	NULL	Status (1-4 for Quality Rules with full distributions, 0 for binary diagnostics)
THRESHOLD_1	float	NULL	Percentage threshold between grades 1 and 2
THRESHOLD_2	float	NULL	Percentage threshold between grades 2 and 3
THRESHOLD_3	float	NULL	Percentage threshold between grades 3 and 4
THRESHOLD_4	float	NULL	Percentage threshold after grade 4

DSS_METRIC_TYPE_TREES

Definition of Quality Rule hierarchy:

AGGREGATE_WEIGHT	float	NULL	Weight of the current Quality Rule in order to compute the parent value.
METRIC_CRITICAL	int	NULL	1 when metric is a critical contribution for its parent.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_INDEX	int	NULL	Default execution order. If the Quality Rules are independent, all values can be set to 1.
METRIC_PARENT_ID	int	NULL	Quality Rule parent ID
METRIC_SCOPE_PROCEDURE_NAME	varchar	255	Scope procedure executed for the current (METRIC_PARENT_ID, METRIC_ID)
METRIC_SCOPE_PROCEDURE_NAME_2	varchar	255	Scope procedure executed for the current (METRIC_PARENT_ID, METRIC_ID)

DSS_METRIC_TYPE_TREES_UPGRADE

Internal table (similar to DSS_METRIC_TYPE_TREES) used during a Dashboard Service upgrade process:

AGGREGATE_WEIGHT	float	NULL	Weight of the current Quality Rule in order to compute the parent value.
METRIC_ID	int	NULL	Quality Rule ID
METRIC_INDEX	int	NULL	Default execution order. If the Quality Rules are independent, all values can be set to 1.
METRIC_PARENT_ID	int	NULL	Quality Rule parent ID
METRIC_SCOPE_PROCEDURE_NAME	varchar	255	Scope procedure executed for the current (METRIC_PARENT_ID, METRIC_ID)
METRIC_SCOPE_PROCEDURE_NAME_2	varchar	255	Scope procedure executed for the current (METRIC_PARENT_ID, METRIC_ID)

DSS_METRIC_TYPES

This table describes each Quality Rule:

METRIC_ID	int	NULL	Quality Rule ID
METRIC_NAME	varchar	255	Quality Rule name (do not use - use DSS_METRIC_DESCRIPTIONS.METRIC_DESCRIPTION with DESCRIPTION_TYPE_ID=0 and LANGUAGE="ENGLISH" instead).
METRIC_DESCRIPTION	varchar	1500	Description of Quality Rule (do not use - use DSS_METRIC_DESCRIPTIONS.METRIC_DESCRIPTION with DESCRIPTION_TYPE_ID=2 and LANGUAGE="ENGLISH" instead).
METRIC_TYPE	int	NULL	0: disabled. 1: executed in central 2: executed in local 3: executed both in central and local
METRIC_GROUP	int	NULL	0: quantity Quality Rule 1: Quality Rule summary 2: Quality Rule detail 3: folder 4: distribution of category 5: distribution 6: user Quality Rule 10: business criteria 13: technical criteria 15: measure based Quality Rule 999: internal (Cost Estimation) (7,8,9,11,12) not used but reserved
METRIC_DEPENDS_ON	varchar	255	List of metrics whose results are needed to compute the current Quality Rule (comma separated list of metric IDs).
METRIC_OPTIONS	int	NULL	0: Unified: N/A, XXL: N/A 1: Unified: N/A, XXL: XXL 2: Unified: N/A, XXL: Non-XXL 4: Unified: Not Unified, XXL: N/A 5: Unified: Not Unified, XXL: XXL 6: Unified: Not Unified, XXL: Non-XXL 8: Unified: Unified, XXL: N/A 9: Unified: Unified, XXL: XXL 10: Unified: Unified, XXL: Non-XXL
SCOPE_ID	int	null	When not zero, displays the scope dataset id.
PROPERTY_ID	int	null	When not zero, displays the property id used to filter the scope.

DSS_METRIC_VALUE_TYPES

METRIC_AGGREGATE_OPERATOR	int	NULL	0: non 1: count 2: sum 3: avg 4: min 5: max 11: count distinct
METRIC_AGGREGATE_OPERATOR_2	int	NULL	Same as above
METRIC_ID	int	NULL	Quality Rule ID
METRIC_VALUE_DESCRIPTION	varchar	1000	Description of Quality Rule value
METRIC_VALUE_INDEX	int	NULL	0: grade 1: detail 2: total
METRIC_VALUE_NAME	varchar	255	Quality Rule value name
METRIC_VALUE_PROCEDURE_NAME	varchar	255	Procedure used to compute the current value
METRIC_VALUE_PROCEDURE_NAME_2	varchar	255	Same as above
METRIC_VALUE_TYPE	int	NULL	0: numeric1: percentage of numeric 2: character 3: object 4: character date 5: numeric 6: non value

DSS_METRIC_WORK_EXCEPT

This table stores expanded exceptions during compute:

METRIC_ID	int	NULL	ID of Quality Rule in exception
OBJECT_ID	int	NULL	ID of object in exception

DSS_METRIC_WORK_TABLES

Internal table

TABLE_NAME	varchar	255	Name used to define the category of the current work. Several WORK_CATEGORY can use the same TABLE_NAME.ID of Quality Rule in exception.
WORK_CATEGORY	varchar	30	Work table

DSS_MODULE_LINKS

Direct links to modules in a snapshot:

MODULE_ID	int	NULL	ID of module
OBJECT_ID	int	NULL	ID of object using the module
OBJECT_TYPE_ID	int	NULL	ID type of object using the module - see DSS_OBJECT_TYPES
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_OBJECT_EXCEPTIONS

This table stores object exceptions:

FIRST_SNAPSHOT_ID	int	NULL	First snapshot ID including exception
JUSTIFY	varchar	1000	Textual justification given while setting exception
LAST_SNAPSHOT_ID	int	NULL	Last snapshot ID including exception (1,000,000,000 for infinite)
LAST_UPDATE	datetime	NULL	Date of last modification (set or reset) in the form MM/DD/YYYY
METRIC_ID	int	NULL	Quality Rule ID
OBJECT_ID	int	NULL	Object ID to ignore during Quality Rule calculation
USER_NAME	varchar	255	User who set the exception

DSS_OBJECT_INFO

This table contains for each Snapshot the list of objects and their checksum at the time of the Snapshot (objects belonging to group 8 are not stored in this table). Between any two snapshots, for example Snapshot S1 and Snapshot S2,

An added object is simply an object present in S2 and absent from S1
A deleted object is simply an object present in S1 and absent from S2
An updated object is simply an object present in S1 and S2 yet with a different checksum
An unchanged object is simply an object present in S1 and S2 with the same checksum

OBJECT_CHECKSUM	int	NULL	Checksum used to detect changes between snapshots
OBJECT_ID	int	NULL	Object ID
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_OBJECT_TYPES

This table stores the object type description list:

OBJECT_GROUP	int	NULL	0: artifacts and other objects 1: technical module 2: technologic objects 3: APM Consolidated Objects Application (-102) Functional module ( 20000) 4: Organization objects: organization, teams, developers. 8: APM_HierarchicalObject Corp ( -100 ) System ( -101)
OBJECT_TYPE_DESCRIPTION	varchar	1000	Object type description
OBJECT_TYPE_ID	int	NULL	Object type ID
OBJECT_TYPE_NAME	varchar	255	Object type name
OBJECT_TYPE_NAME_EX	varchar	255	Object type internal name

DSS_OBJECTS

This table lists all the object objects currently stored in the Dashboard Service following an analysis:

OBJECT_DESCRIPTION	varchar	1000	Object description
OBJECT_FULL_NAME	varchar	1000	Object full name
OBJECT_ID	int	NULL	Object ID - this ID is unique in the Dashboard Service. Use DSS_TRANSLATION_TABLE to find the ID of the Object in the Analysis Service.
OBJECT_NAME	varchar	255	Object name
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES

DSS_PORTF_TREE

Denormalization table for objects:

APP_ID	int	NULL	Application ID
MODULE_ID	int	NULL	Module ID
SNAPSHOT_ID	int	NULL	Snapshot ID
SYST_ID	int	NULL	System ID

DSS_PROCESSING

This table stores DSS processing information (compute progression, stop requests):

PROCESS_CURRENT_TIME	datetime	NULL	Timestamp when current value was updated
PROCESS_CURRENT_VALUE	int	NULL	Current value
PROCESS_MAX_VALUE	int	NULL	Maximum value
PROCESS_START_TIME	datetime	NULL	Timestamp when operation started
PROCESS_TYPE	varchar	255	Processing type

DSS_QUALITY_TREE

Denormalization table for Quality Rule information:

B_CRITERION_ID	int	NULL	-
M_CRIT	int	NULL	-
M_WEIGHT	float	NULL	-
METRIC_ID	int	NULL	Quality Rule ID
T_CRIT	int	NULL	-
T_CRITERION_ID	int	NULL	-
T_WEIGHT	float	NULL	-

DSS_SITES

This table contains all sites found. It describes the different Analysis Services registered in the Dashboard Service. It also contains the necessary parameters in order to connect to them:

ENCRYPTION_TYPE	int	NULL	Encryption used for the User password
LAST_UPDATE	datetime	NULL	Date of last update
LOCAL_DSS_NAME	varchar	255	Name of DSS database or schema in Analysis Service
SERVER_TYPE	int	NULL	1: MS/Sybase 2: Oracle 3: DB2
SITE_DESCRIPTION	varchar	1000	Analysis Service description
SITE_ID	int	NULL	Analysis Service ID
SITE_NAME	varchar	255	Analysis Service name
SITE_PASSWORD	varchar	255	Password of the user/login used to connect
SITE_SERVER	varchar	255	Server or instance name
SITE_SRVADDRESS	varchar	1000	When using CMS/Server Address mode, contains the server address. Otherwise NULL
SITE_SRVADDRESS_TYPE	varchar	255	When using CMS/Server Address mode, contains the server type: SQLServer, Sybase, Oracle, or DB2. Otherwise NULL
SITE_SYSTEM	varchar	255	System (for DB2 only)
SITE_TYPE	int	NULL	1: Central 2: Local
SITE_USER	varchar	255	Database user/login used to connect
SNAPSHOT_STATUS	int	NULL	-1: site erased 0: no metrics 1: wait to transfer 2: wait to import 3: consolidated

DSS_SNAPSHOT_INFO

Snapshot information for a given high level object:

OBJECT_ID	int	NULL	Object ID
OBJECT_VERSION	varchar	50	Object version
SNAPSHOT_ID	int	NULL	Snapshot ID

DSS_SNAPSHOT_TYPES

This table stores the types of snapshot:

SNAPSHOT_TYPE_ID	int	NULL	1: APM snapshots 2: Enforce snapshot 3: ADG snapshots
SNAPSHOT_TYPE_NAME	varchar	255	Snapshot type name

DSS_SNAPSHOTS

This table stores the snapshots:

APPLICATION_ID	int	NULL	Application ID
COMPUTE_END_DATE	datetime	NULL	Snapshot calculation end date
COMPUTE_START_DATE	datetime	NULL	Snapshot calculation start date
EXTERNAL_ID	int	NULL	External object ID (-1 for none): Used in the Enforce Diagnostics
FUNCTIONAL_DATE	datetime	NULL	Date
SNAPSHOT_CONSO_ID	int	NULL	-
SNAPSHOT_DATE	datetime	NULL	Snapshot creation date
SNAPSHOT_DESCRIPTION	varchar	1000	Snapshot description
SNAPSHOT_ID	int	NULL	Snapshot ID
SNAPSHOT_NAME	varchar	255	Snapshot name
SNAPSHOT_STATUS	int	NULL	0: empty 1: in progress 2: consolidated
SNAPSHOT_TYPE_ID	int	NULL	1: APM snapshots 2: Enforce snapshot 3: ADG snapshot

DSS_TECHNOLOGIES

This table indicates different type of technologies associated to technical modules:

MODULE_TYPE_ID	int	NULL	Module type ID
TECHNO_TYPE_ID	int	NULL	Techno type ID

DSS_TRANSLATION_TABLE

This table stores objects both from Analysis and Dashboard Services:

OBJECT_ID	int	NULL	Object ID
SITE_ID	int	NULL	Site ID
SITE_OBJECT_ID	int	NULL	-

DSS_WORK_FOLDER_METRICS

Internal Table, Quality Rules to delete before importing Assessment Model:

METRIC_ID	int	NULL	Object ID
METRIC_PARENT_ID	int	NULL	Site ID
TREE_LEVEL	int	NULL	-

DSS_WORK_FUNC_MODULE_TREE

FLAT_LEVEL	int	NULL	-
MODULE_ID	int	NULL	Module ID
OBJECT_ID	int	NULL	Object ID
OBJECT_PARENT_ID	int	NULL	Object's parent ID

DSS_WORK_IN_OBJECTS

Temporary table for import of DSS_OBJECTS table:

OBJECT_CHECKSUM	int	NULL	-
OBJECT_DESCRIPTION	varchar	1000	Object description
OBJECT_FULL_NAME	varchar	1000	Object full name
OBJECT_ID	int	NULL	Object ID
OBJECT_NAME	varchar	255	Object name
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES

DSS_WORK_OBJ_TYP

LINK_TYPE_ID	int	NULL	Link type ID
OBJECT_TYPE_ID	int	NULL	Object type ID

DSS_WORK_OBJECTS

Temporary table for import of DSS_OBJECTS table:

OBJECT_CHECKSUM	int	NULL	-
OBJECT_DESCRIPTION	varchar	1000	Object description
OBJECT_FULL_NAME	varchar	1000	Object full name
OBJECT_ID	int	NULL	Object ID
OBJECT_NAME	varchar	255	Object name
OBJECT_TYPE_ID	int	NULL	Object type ID - see DSS_OBJECT_TYPES

DSS_WORK_OBJECTS_FLAT_TREE

FLAT_LEVEL	int	NULL	-
OBJECT_ID	int	NULL	Object ID
OBJECT_PARENT_ID	int	NULL	Object's parent ID