Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

   

Column Name

Label

Column Type

Notes

OBJECT_ID

ID of object as stored in the Dashboard Service

int NULL

 

OBJECT_NAME

Name of the object as stored in the Dashboard Service

varchar 1000


MODULE_ID

ID number of the module the object belongs to

int NULL


MODULE_NAME

Name number of the module the object belongs to

varchar 255


SNAPHOT_ID

ID number of the current snapshot the object belongs to

int NULL

In CAST AIP ≥ 8.3.3, the column SNAPSHOT_ID has been added to correct the typographical error on the existing column name SNAPHOT_ID. The column SNAPHOT_ID will be deprecated in a future release: please update any scripts or queries that use the column SNAPHOT_ID.
SNAPSHOT_IDID number of the current snapshot the object belongs toint NULL
SNAPSHOT_NAMEName of the current snapshot the object belongs tovarchar 255 
PREVIOUS_SNAPSHOT_IDID number of the previous snapshot the object belonged to (-1 if not)int NULL 
PREVIOUS_SNAPSHOT_NAMEName of the previous snapshot the object belonged tovarchar 255 
OBJECT_STATUS

Status of the object in the current snapshot:

  • Added
  • Deleted
  • Updated
  • Unchanged
varchar 9 
OBJECT_IS_ARTIFACTWhether the object is considered to be an artifact or notvarchar 15 
OBJECT_COST_COMPLEXITY-float NULL 
OBEJCT_TECHNO_TYPE_IDID of the Technology the object is classed asint NULLIn CAST AIP ≥ 8.3.3, the column OBJECT_TECHNO_TYPE_ID has been added to correct the typographical error on the existing column name OBEJCT_TECHNO_TYPE_ID. The column OBEJCT_TECHNO_TYPE_ID will be deprecated in a future release: please update any scripts or queries that use the column OBEJCT_TECHNO_TYPE_ID.
OBJECT_TECHNO_TYPE_IDID of the Technology the object is classed asint NULL

...

 

Column Name

Label

Column Type

Notes

DIAG_ID

ID number of the rule that has been violatedint NULL
DIAG_NAMEName of the rule that has been violatedvarchar 255 
OBJECT_IDID number of the object that is violating the ruleint NULL 
OBJECT_NAMEName of the object that is violating the rulevarchar 1000 
SNAPHOT_IDID number of the current snapshot which the object belongs toint NULLIn CAST AIP ≥ 8.3.3, the column SNAPSHOT_ID has been added to correct the typographical error on the existing column name SNAPHOT_ID. The column SNAPHOT_ID will be deprecated in a future release: please update any scripts or queries that use the column SNAPHOT_ID.
SNAPSHOT_IDID number of the current snapshot which the object belongs toint NULL
SNAPSHOT_NAMEName of the current snapshot which the object belongs tovarchar 255 
VIOLATION_STATUS

Status of the violation in the current snapshot:

  • Added
  • Deleted
  • Updated
  • Unchanged
varchar 9