metric_instance

The table below describes the metric_instance table.

This table contains the following foldable columns:

  • sys_id_value
  • definition_value
  • business_duration_display_value
  • business_duration_value
  • calculation_complete_display_value
  • calculation_complete_value
  • definition_display_value
  • duration_display_value
  • duration_value
  • end_display_value
  • end_value
  • field_display_value
  • field_value
  • field_value_display_value
  • field_value_value
  • id_display_value
  • id_value
  • start_display_value
  • start_value
  • sys_created_by_display_value
  • sys_created_by_value
  • sys_created_on_display_value
  • sys_created_on_value
  • sys_id_display_value
  • sys_mod_count_display_value
  • sys_mod_count_value
  • sys_updated_by_display_value
  • sys_updated_by_value
  • sys_updated_on_display_value
  • sys_updated_on_value
  • table_display_value
  • table_value
  • value_display_value
  • value_value
Column Name SQL Type Updatable Nullable

sys_id_value

Primary Key
 SQL_VARCHAR(64) False False

definition_value

Foreign Key linked to column sys_id_value in metric_definition table
 SQL_VARCHAR(64) True True

business_duration_display_value

 SQL_VARCHAR(500) True True

business_duration_value

 SQL_TIMESTAMP True True

calculation_complete_display_value

 SQL_VARCHAR(500) True True

calculation_complete_value

 SQL_BIT True True

definition_display_value

 SQL_VARCHAR(500) True True

duration_display_value

 SQL_VARCHAR(500) True True

duration_value

 SQL_TIMESTAMP True True

end_display_value

 SQL_VARCHAR(500) True True

end_value

 SQL_TIMESTAMP True True

field_display_value

 SQL_VARCHAR(500) True True

field_value

 SQL_VARCHAR(256) True True

field_value_display_value

 SQL_VARCHAR(500) True True

field_value_value

 SQL_VARCHAR(80) True True

id_display_value

 SQL_VARCHAR(500) True True

id_value

 SQL_VARCHAR(256) True True

start_display_value

 SQL_VARCHAR(500) True True

start_value

 SQL_TIMESTAMP True True

sys_created_by_display_value

 SQL_VARCHAR(500) False True

sys_created_by_value

 SQL_VARCHAR(80) False True

sys_created_on_display_value

 SQL_VARCHAR(500) False True

sys_created_on_value

 SQL_TIMESTAMP False True

sys_id_display_value

 SQL_VARCHAR(500) False False

sys_mod_count_display_value

 SQL_VARCHAR(500) False True

sys_mod_count_value

 SQL_INTEGER(signed) False True

sys_updated_by_display_value

 SQL_VARCHAR(500) False True

sys_updated_by_value

 SQL_VARCHAR(80) False True

sys_updated_on_display_value

 SQL_VARCHAR(500) False True

sys_updated_on_value

 SQL_TIMESTAMP False True

table_display_value

 SQL_VARCHAR(500) True True

table_value

 SQL_VARCHAR(256) True True

value_display_value

 SQL_VARCHAR(500) True True

value_value

 SQL_VARCHAR(200) True True