Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 7 Next »

This method of extracting information is deprecated. You should now use the CAST RestAPI to extract the information you require.

This document provides a detailed description of each CAST System View provided in the 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)

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)

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

Column Name

Label

Column Type

OBJECT_ID

Object ID

int(null)

OBJECT_BF

Business Function for object, as set in CAST Enlighten

varchar(255)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

  • No labels