This documentation is no longer maintained and may contain obsolete information.


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,

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
  • 5: CSS

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