This document provides a detailed description of each CAST System View provided in the Analysis Service (all tables/views beginning with CDT_, CDV_, CSV_, CTT_, CTV_) 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 'CDT_%' OR A.TABLE_NAME LIKE 'CSV%' OR A.TABLE_NAME LIKE 'CSV_%' OR A.TABLE_NAME LIKE 'CTT_%') AND A.TABLE_NAME = B.TABLE_NAME AND A.TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME |
Lists all objects stored in the Analysis Service from analyses
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
OBJECT_TYPE_STR | Object Description | varchar(255) |
OBJECT_MANGLING | Object Name with parameters | varchar(255) |
OBJECT_TYPE_EXT | Object Type Extended : sub-type for object | varchar(255) |
OBJECT_LANGUAGE_NAME | Object Language | varchar(255) |
Lists all objects stored in the Analysis Service from analyses by Object Type
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
BITAND16 | - | int(null) |
OBJECT_TYPE | Object type | varchar(255) |
List all analyses and maps them to an ID and an Application ID
Column Name | Label | Column Type |
---|---|---|
ANALYSIS_ID | Analysis ID | int(null) |
APPLICATION_ID | Application ID: more than on application may exist for one analysis | int(null) |
ANALYSIS_NAME | Analysis Name | varchar(255) |
Reference table to decode link type
Column Name | Label | Column Type |
---|---|---|
AccTypLo | Link type (Low value) | int(null) |
AccTypHi | Link type (High value) | int(null) |
StaticDesc | Decoded Type (for static link) | varchar(255) |
AccTypLo2 | Link type (Low value) | int(null) |
AccTypHi2 | Link type (High value) | int(null) |
DynamicDesc | Decoded Type (for dynamic link) | varchar(255) |
No longer used - see CAST System Views - CSV
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object name | varchar(255) |
OBJECT_FULLNAME | Object full name | varchar(255) |
OBJECT_MANGLING | Object mangling naùe | varchar(255) |
OBJECT_TYPE | Object type | varchar(255) |
OBJECT_TYPE_EXT | - | varchar(255) |
PARENT_ID | - | int(null) |
CONTAINER_ID | - | int(null) |
APPLICATION_ID | - | int(null) |
ANALYSIS_ID | - | int(null) |
LANGUAGE_NAME | - | varchar(30) |
LVL | - | int(null) |
Column Name | Label | Column Type |
---|---|---|
CSV_VER | - | int(null) |
CSV_TYP | - | int(null) |
USRLCK | - | char(3) |
LASTUPDDATE | - | datetime |
STATUS | - | int(null) |
Column Name | Label | Column Type |
---|---|---|
LINK_CATEGORY | - | int(null) |
LINK_CATEGORY_STR | - | varchar(255) |
Link type description
Column Name | Label | Column Type |
---|---|---|
LINK_TYPE_LO | Link type (Low value) | int(null) |
LINK_TYPE_HI | Link type (High value) | int(null) |
LINK_CATEGORY | Currently not used | int(null) |
LINK_TYPE_STR | Link type Name | varchar(255) |
List objects by application using ID
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
APPLICATION_ID | Application ID : more than one application may exist for one analysis | int(null) |
OBJECT_TYPE | Object Type | int(null) |
APPLICATION_TYPE | Application Type | int(null) |
PROPERTIES | int(null)ernal (0) / external (1) objects | int(null) |
List objects by container using ID. The container for an object is the first parent in the parent list matching a specific list of Object Types. To get this list, you can execute the following request:
select ObjTypStr from ObjTypStr where BrwProp=1 |
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
CONTAINER_ID | Container ID | int(null) |
APPLICATION_ID | Application ID: Id reference in CSV_ANALYSIS_APPLICATION | int(null) |
OBJECT_TYPE | Object Type | int(null) |
CONTAINER_TYPE | Container Type | int(null) |
APPLICATION_TYPE | Application Type | int(null) |
Provides a description and ID for each object type
Column Name | Label | Column Type |
---|---|---|
OBJECT_TYPE | Object Type | int(null) |
OBJECT_TYPE_STR | Object Description | varchar(255) |
OBJECT_LANGUAGE | Object Language | varchar(255) |
Maps objects, parents and applications (as well as their type) by ID
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
PARENT_ID | Parent ID for Object | int(null) |
APPLICATION_ID | Application ID: Id reference in CSV_ANALYSIS_APPLICATION | int(null) |
OBJECT_TYPE | Object Type | int(null) |
PARENT_TYPE | Parent Object Type | int(null) |
APPLICATION_TYPE | Application Type | int(null) |
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 'CDV_%' OR A.TABLE_NAME LIKE 'CSV_%' OR A.TABLE_NAME LIKE 'CTV_%') AND A.TABLE_NAME = B.TABLE_NAME ORDER BY TABLE_NAME |
Displays information specific to JavaDoc data stored in the Analysis Service - see also CSV_JAVADOC
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
JAVADOC_TYPE | Java Documentation Type | varchar(255) |
FIRST_WORD | First word of the JavaDoc string | varchar(255) |
Displays metric data and values for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
METRIC_TYPE | Metric Type | varchar(255) |
BLOCK_NUMBER | - | int(null) |
METRIC_VALUE | Metric Value | int(null) |
Displays metric parameter/column data for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
PARAM_NAME | Parameter/column name | varchar(255) |
PARAM_POSITION | Parameter position : negative value means return values (more than one for T-SQL function return table) | int(null) |
PARAM_TYPE | Parameter/column type | varchar(255) |
Displays and maps analyses to applications using ID, name and type
Column Name | Label | Column Type |
---|---|---|
ANALYSIS_ID | Analysis ID | int(null) |
ANALYSIS_NAME | Analysis Name | varchar(255) |
APPLICATION_ID | Application ID : more than on application may exist for one analysis | int(null) |
APPLICATION_NAME | Application Name | varchar(255) |
APPLICATION_TYPE | Application Type | varchar(255) |
Displays the first line of Business Function description for objects stored in the Analysis Service, as configured in the CAST Enlighten.
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_BF | Business Function for object, as set in CAST Enlighten | varchar(255) |
Note that this view is no longer used and is therefore deemed obsolete. |
Displays and maps objects stored in the Analysis Service using ID and name to any called objects.
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
CALLED_OBJECT_NAME | Name of called object | varchar(255) |
CALLED_ACCESS_TYPE | Type of access | varchar(255) |
CALLED_ACCESS_TYPE_D | - | varchar(255) |
LINK_PROPERTIES | - | varchar(30) |
CALLED_FULLNAME | Full name of called object | varchar(255) |
CALLED_TYPE | Object type of called object | varchar(255) |
APPLICATION_NAME | Name of application | varchar(255) |
APPLICATION_TYPE | Type of application | varchar(255) |
APPLICATION_ID | ID of application | int(null) |
CALLED_ID | ID of called object | int(null) |
LINK_ID | ID of link | int(null) |
Displays and maps objects stored in the Analysis Service using ID and name to any calling objects.
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
CALLER_OBJECT_NAME | Name of called object | varchar(255) |
CALLER_ACCESS_TYPE | Type of access | varchar(255) |
CALLER_ACCESS_TYPE_D | - | varchar(255) |
LINK_PROPERTIES | - | varchar(30) |
CALLER_FULLNAME | Full name of calling object | varchar(255) |
CALLER_TYPE | Object type of calling object | varchar(255) |
APPLICATION_NAME | Name of application | varchar(255) |
APPLICATION_TYPE | Type of application | varchar(255) |
APPLICATION_ID | ID of application | int(null) |
CALLER_ID | ID of calling object | int(null) |
LINK_ID | ID of link | int(null) |
Displays the first line of Comment description for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_COM | Comment for object, set in CAST Enlighten | varchar(255) |
Note that this view is no longer used and is therefore deemed obsolete. |
Displays a list of descriptions reused in CSV_OBJECT_DESCRIPTIONS and CSV_LINK_DESCRIPTIONS
Column Name | Label | Column Type |
---|---|---|
DESC_TYPE | Description type | varchar(255) |
Displays the ID, name, full name and file path for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name : include full path | varchar(255) |
FILE_PATH | Object Full Name : file path | varchar(255) |
Lists all Functional Domains as created in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
DOMAIN_ID | Domain ID | int(null) |
DOMAIN_NAME | Domain Name | varchar(255) |
DOMAIN_PARENT_NAME | Parent Domain Name | varchar(255) |
DOMAIN_PARENT_ID | Parent Domain ID | int(null) |
Note that this view is no longer used and is therefore deemed obsolete. |
Lists all Functional Domains and the objects associated with them as created in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
DOMAIN_NAME | Domain Name | varchar(255) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
OBJECT_ID | Object ID | int(null) |
DOMAIN_ID | Domain ID | int(null) |
Note that this view is no longer used and is therefore deemed obsolete. |
Lists all Column Level/Fine Grained Impact Analyses defined in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
IMPACT_ID | Impact Analysis ID | int(null) |
IMPACT_NAME | Impact Analysis Name | varchar(30) |
IMPACT_LABEL | Impact Analysis Description | varchar(255) |
IMPACT_TYPE | Impact Analysis Type | varchar(19) |
JOB_ID | Job ID | int(null) |
JOB_NAME | Job Name | varchar(30) |
JOB_LABEL | Job Description | varchar(255) |
JOB_TYPE | Job Type | varchar(32) |
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_TYPE | Object Full Name : include full path | varchar(255) |
COLUMN_ID | Column ID | int(null) |
CHANGED_COLUMN | Changed column name | varchar(128) |
NEW_COLUMN | New column name | varchar(128) |
DROPPED_COLUMN | Dropped column name | varchar(128) |
NEW_DATATYPE | New datatype name | varchar(128) |
Note that this view is no longer used and is therefore deemed obsolete. |
Lists the results of all Column Level/Fine Grained Impact Analyses that have been successfully executed in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
IMPACT_NAME | Impact Analysis Name | varchar(30) |
JOB_NAME | Jon Name | varchar(30) |
LEVEL_NUMBER | Impact Analysis level | int(null) |
LANGUAGE | Language used | varchar(255) |
OBJECT_TYPE | Object Full Name : include full path | varchar(255) |
OBJECT_TYPE_EXT | Object Type Extended : sub-type for object | varchar(255) |
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name : include full path | varchar(255) |
IMPACT_ID | Impact Analysis ID | int(null) |
JOB_ID | Job ID | int(null) |
Note that this view is no longer used and is therefore deemed obsolete. |
Displays all Java objects that are stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_PATH | Object Path | varchar(255) |
PACKAGE_ID | Package ID | int(null) |
APPLICATION_ID | Application ID | int(null) |
Displays property information for all Java objects that are stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_PROPERTY | Property Name | varchar(121) |
PATH | Property Path | varchar(255) |
Displays information specific to JavaDoc data stored in the Analysis Service - see also CDV_JAVADOC
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
JAVADOC_TYPE | Java Documentation Type | varchar(255) |
FIRST_WORD | First word of the JavaDoc string | varchar(255) |
Lists all Libraries and the objects associated with them as created in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
LIBRARY_NAME | Library Full Name | varchar(255) |
Note that this view is no longer used and is therefore deemed obsolete. |
Displays a description for links stored in the Analysis Service (see CSV_DESCRIPTION_LIST)
Column Name | Label | Column Type |
---|---|---|
LINK_ID | Link ID | int(null) |
DESC_TYPE | Description type | varchar(255) |
BLOCK_NUMBER | Block Number : only for some descriptions | int(null) |
DESCRIPTION | Value for description : numeric or string | varchar(255) |
ORDER_NUMBER | Sort Order for string : information is limited to 255 for each line for multiple line this information give correct order for text | int(null) |
Displays information about SQL objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
PARENT_ID | Index or Table owning column | int(null) |
OBJECT_NAME | Column Name | varchar(255) |
OBJECT_TYPE_STR | Column Type | varchar(151) |
OBJECT_LENGTH | Column Type length or zero | int(null) |
OBJECT_PRECISION | Column Type precision or zero | int(null) |
OBJECT_POSITION | Column Position in the table or index (1 based) | int(null) |
OBJECT_NULLISABLE | 1 if column allow NULL, 0 otherwise. Value is always 0 if column belongs to an index | int(null) |
OBJECT_PK | 1 if column is a Primary Key, 0 otherwise. Value is always 0 if column belongs to an index | int(null) |
OBJECT_FK | 1 if column is a Foreign Key, 0 otherwise. Value is always 0 if column belongs to an index | int(null) |
Displays date information (creation, analysis, documentation etc.) for all objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name : include full path | varchar(255) |
CREATION_DATE | Creation date in Knowledge Base | datetime(null) |
LAST_ANALYSIS_DATE | Last analysis date | datetime(null) |
DOCUMENTATION_DATE | Documentation date (for Label, Business function, Comment ..) as set in CAST Enlighten | datetime(null) |
FLAG_SET_DATE | Flag date (as set in CAST Enlighten) otherwise 01/01/1970 | datetime(null) |
Displays a description for objects stored in the Analysis Service (see CSV_DESCRIPTION_LIST)
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
DESC_TYPE | Description Type | varchar(255) |
BLOCK_NUMBER | Block Number : only for some description | int(null) |
DESCRIPTION | Value for description : numeric or string | varchar(255) |
ORDER_NUMBER | Sort Order for string : information is limited to 255 for each line for multiple line this information give correct order for text | int(null) |
Displays numeric metric value information for objects stored in the Analysis Service : line number, loop number, complexity ...
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_TYPE | Object Type | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
PARENT_NAME | Parent Object Name | varchar(255) |
PARENT_TYPE | Parent Object Type | varchar(255) |
APPLICATION_NAME | Application Name | varchar(255) |
APPLICATION_ID | Application ID : Id reference in CSV_ANALYSIS_APPLICATION | int(null) |
DESC_TYPE | Description Type | varchar(255) |
BLOCK_NUMBER | Block Number : only for some description | int(null) |
DESCRIPTION | Value for description : numeric or string | int(null) |
ORDER_NUMBER | - | int(null) |
Displays all data for all objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
LANGUAGE | Object technology type | varchar(255) |
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object name | varchar(255) |
OBJECT_NAME_EXT | - | varchar(255) |
OBJECT_LABEL | - | varchar(255) |
OBJECT_FULLNAME | Object full name | varchar(255) |
OBJECT_TYPE | Object type | varchar(255) |
OBJECT_TYPE_EXT | - | varchar(255) |
PARENT_NAME | Parent name | varchar(255) |
PARENT_TYPE | Parent type | varchar(255) |
CONTAINER_NAME | Container name (usually the same as parent name) | varchar(255) |
CONTAINER_TYPE | Container type (usually the same as parent name) | varchar(255) |
APPLICATION_NAME | Application name | varchar(255) |
APPLICATION_TYPE | Application type | varchar(255) |
BUSINESS_FUNCTION | Business function as defined in the code or in CAST Enlighten | varchar(255) |
COMMENTS | Comments as defined in the code or in CAST Enlighten | varchar(255) |
PARENT_ID | Parent ID | int(null) |
CONTAINER_ID | Container ID | int(null) |
APPLICATION_ID | Application ID | int(null) |
Displays metric parameter/column data for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
PARAMETER_POSITION | Parameter position. Negative value mean return values (more than one for T-SQL function return table) | int(null) |
PARAM_NAME | Parameter/Column Name | varchar(255) |
PARAM_TYPE | Parameter/column Type | varchar(255) |
PARAM_PROP | Property for parameter (in, out, by ref...) | varchar(40) |
APPLICATION_NAME | Application Name | varchar(255) |
Displays all analysis names associated to a given User Project
Column Name | Label | Column Type |
---|---|---|
USER_PROJECT_NAME | User Project Name | varchar(255) |
ANALYSIS_NAME | Analysis Name | varchar(255) |
USER_PROJECT_ID | User Project ID | int(null) |
ANALYSIS_ID | Analysis ID | int(null) |
Displays all application names associated to a given User Project
Column Name | Label | Column Type |
---|---|---|
USER_PROJECT_NAME | User Project Name | varchar(255) |
APPLICATION_NAME | Application Name | varchar(255) |
USER_PROJECT_ID | User Project ID | int(null) |
APPLICATION_ID | Application ID : Id reference in CSV_ANALYSIS_APPLICATION | int(null) |
Displays all Graphical Views saved in CAST Enlighten together with any objects present in the Graphical View
Column Name | Label | Column Type |
---|---|---|
VIEW_NAME | View Name | varchar(255) |
OBJECT_ID | Object ID | int(null) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_FULLNAME | Object Full Name | varchar(255) |
VIEW_ID | View ID | int(null) |
Displays information about all Graphical Views saved in CAST Enlighten
Column Name | Label | Column Type |
---|---|---|
VIEW_ID | View ID | int(null) |
VIEW_NAME | View Name | varchar(255) |
VIEW_LABEL | View Label | varchar(255) |
VIEW_TYPE | View type | varchar(12) |
VIEW_PATH | View path | varchar(255) |
DOMAIN_NAME | Domain Name | varchar(10) |
DOMAIN_ID | Domain ID | int(null) |
Displays GUIDs for links stored in the Analysis Service (not all called/calling objects may have a GUID)
Column Name | Label | Column Type |
---|---|---|
LINK_ID | Link ID | int(null) |
CALLER_ID | Caller object ID : Id reference in view CSV_OBJECTS | int(null) |
CALLER_NAME | Caller object name | varchar(255) |
CALLER_GUID | Caller object GUID | varchar(1000) |
CALLED_ID | Called object ID: Id reference in view CSV_OBJECTS | int(null) |
CALLED_NAME | Called object name | varchar(255) |
CALLED_GUID | Called object GUID | varchar(1000) |
ESCLATED_LINK | 0 = Not Escalated, 1 = Escalated | int(null) |
PROJECT_NAME | Project name | varchar(255) |
Displays GUIDs for objects stored in the Analysis Service (not all objects may have a GUID)
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | int(null) | |
OBJECT_NAME | varchar(255) | |
OBJECT_FULLNAME | varchar(255) | |
OBJECT_TYPE_STR | varchar(255) | |
OBJECT_LANGUAGE_NAME | varchar(255) | |
OBJECT_GUID | varchar(1000) |
Displays GUIDs for parents of objects stored in the Analysis Service (not all objects (whether parent or child) may have a GUID)
Column Name | Label | Column Type |
---|---|---|
PARENT_ID | Parent ID | int(null) |
PARENT_NAME | Parent name | varchar(255) |
PARENT_GUID | Parent object GUID | varchar(255) |
OBJECT_ID | Object ID | varchar(255) |
OBJECT_NAME | Object Name | varchar(255) |
OBJECT_GUID | Child object GUID | varchar(1015) |
Displays link type information for all links stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
LINK_TYPE_NAME | Name of link | varchar(255) |
LINK_TYPE_DESCRIPTION | Link description | varchar(255) |
LINK_TYPE_LO | Link type (Low value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_HI | Link type (High value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_LO2 | Link type (Low value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_HI2 | Link type (High value) see CSV_LINKTYPE | int(null) |
Provides link description information without decoding
Column Name | Label | Column Type |
---|---|---|
LINK_ID | Link ID | int(null) |
CALLER_ID | Caller object ID : Id reference in view CSV_OBJECTS | int(null) |
CALLED_ID | Called object ID : Id reference in view CSV_OBJECTS | int(null) |
LINK_TYPE_LO | Link type (Low value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_HI | Link type (High value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_LO2 | Link type (Low value) see CSV_LINKTYPE | int(null) |
LINK_TYPE_HI2 | Link type (High value) see CSV_LINKTYPE | int(null) |
Displays object information (Source Code Comments, Header Information etc.) for objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
DESC_TYPE | String Type | varchar(255) |
BLOCK_NUMBER | - | int(null) |
DESCRIPTION | Text string | varchar(255) |
ORDER_NUMBER | - | int(null) |
Lists position of objects and links
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECTREF_ID | Reference Object ID or Null if object is a Link | int(null) |
POSMODE | Position mode : 1 = line, 2 = line column | int(null) |
POS1 | Start line position | int(null) |
POS2 | End line position when POSMODE = 1, Start column position when POSMODE = 2 | int(null) |
POS3 | -1 when POSMODE = 1, End line position when POSMODE = 2 | int(null) |
POS4 | -1 when POSMODE = 1, End column position when POSMODE = 2 | int(null) |
Displays properties for objects stored in the Analysis Service (Number of code lines, number of inner comment lines etc.)
Column Name | Label | Column Type |
---|---|---|
OBJECT_NAME | Object name | varchar(255) |
OBJECT_GUID | Object GUID (not all objects have a GUID) | varchar(1000) |
OBJECT_FULLNAME | Object full name | varchar(255) |
OBJECT_TYPE_STR | Object type | varchar(255) |
PROP_NAME | Property name (e.g. BodyCommentLinesCount) | varchar(255) |
PROP_DESCRIPTION | Property description (e.g. Number of inner comment lines) | varchar(255) |
PROP_TYPE | Property type (string/value) | varchar(7) |
BLOCK_NUMBER | - | int(null) |
VALUE | Property value | varchar(255) |
ORDER_NUMBER | - | int(null) |
Displays a name and description for all possible objects that can be stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
TYPE_NAME | - | varchar(255) |
TYPE_DESCRIPTION | - | varchar(255) |
Lists all existing objects stored in the Analysis Service
Column Name | Label | Column Type |
---|---|---|
OBJECT_ID | Object ID | int(null) |
OBJECT_TYPE | Object Type | int(null) |
OBJECT_CLASS | Object Class | int(null) |
OBJECT_PROP | Object Prop | int(null) |
Displays a name and description for all possible properties that can be stored in the Analysis Service for a given object
Column Name | Label | Column Type |
---|---|---|
PROP_NAME | Property name | varchar(255) |
PROP_DESCRIPTION | Property description | varchar(255) |