CAST System Views - Analysis Service

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.

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 '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

CDT_OBJECTS

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)

CSV

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)

CSV_ANA_APPLI

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)

CSV_LINKTYPE

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)

CSV_PARENT

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)

CSV_STATUS

Column Name	Label	Column Type
CSV_VER	-	int(null)
CSV_TYP	-	int(null)
USRLCK	-	char(3)
LASTUPDDATE	-	datetime
STATUS	-	int(null)

CTT_LINK_DECODE_CATEGORY

Column Name	Label	Column Type
LINK_CATEGORY	-	int(null)
LINK_CATEGORY_STR	-	varchar(255)

CTT_LINK_DECODE_TYPE

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)

CTT_OBJECT_APPLICATIONS

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)

CTT_OBJECT_CONTAINERS

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)

CTT_OBJECT_DECODE_TYPE

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)

CTT_OBJECT_PARENTS

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)

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 'CDV_%'
OR A.TABLE_NAME LIKE 'CSV_%'
OR A.TABLE_NAME LIKE 'CTV_%')
AND A.TABLE_NAME = B.TABLE_NAME

ORDER BY TABLE_NAME

CDV_JAVADOC

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)

CDV_OBJECT_METRICS

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)

CDV_PARAMS

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)

CSV_ANALYSIS_APPLICATIONS

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)

CSV_BF_1ST_ROWS

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_CALLED_OBJECTS

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)

CSV_CALLER_OBJECTS

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)

CSV_COMMENT_1ST_ROWS

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_DESCRIPTION_LIST

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)

CSV_FILE_OBJECTS

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)

CSV_FUNC_DOMAIN_LIST

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_FUNC_DOMAIN_OBJECTS

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_IMPACT_LIST

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_IMPACT_RESULTS

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_JAVA_FILES

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)

CSV_JAVA_PROPERTIES

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)

CSV_JAVADOC

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)

CSV_LIBRARY_OBJECTS

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)

Info

Note that this view is no longer used and is therefore deemed obsolete.

CSV_LINK_DESCRIPTIONS

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)

CSV_OBJECT_COLUMNS

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)

CSV_OBJECT_DATES

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)

CSV_OBJECT_DESCRIPTIONS

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)

CSV_OBJECT_METRICS

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)

CSV_OBJECTS

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)

CSV_PARAMS

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)

CSV_USERPROJECT_ANALYSIS

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)

CSV_USERPROJECT_APPLICATIONS

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)

CSV_VIEW_OBJECTS

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)

CSV_VIEWS

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)

CTV_GUID_LINKS

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)

CTV_GUID_OBJECTS

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)

CTV_GUID_PARENTS

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)

CTV_LINK_TYPES

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)

CTV_LINKS

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)

CTV_OBJECT_DESCRIPTIONS_STRING

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)

CTV_OBJECT_POSITION

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)

CTV_OBJECT_PROPERTIES

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)

CTV_OBJECT_TYPES

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)

CTV_OBJECTS

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)

CTV_PROPERTIES

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)