pa_scores

The table below describes the pa_scores table.

This table contains the following foldable columns:

  • sys_id_value
  • breakdown_level2_value
  • breakdown_value
  • indicator_value
  • breakdown_display_value
  • breakdown_level2_display_value
  • element_display_value
  • element_level2_display_value
  • element_level2_value
  • element_value
  • indicator_display_value
  • start_at_display_value
  • start_at_value
  • sys_created_by_display_value
  • sys_created_by_value
  • sys_created_on_display_value
  • sys_created_on_value
  • sys_domain_display_value
  • sys_domain_path_display_value
  • sys_domain_path_value
  • sys_domain_value
  • sys_id_display_value
  • sys_mod_count_display_value
  • sys_mod_count_value
  • sys_tags_display_value
  • sys_tags_value
  • sys_updated_by_display_value
  • sys_updated_by_value
  • sys_updated_on_display_value
  • sys_updated_on_value
  • value_display_value
  • value_value
Column Name SQL Type Updatable Nullable

sys_id_value

Primary Key
 SQL_VARCHAR(64) False False

breakdown_level2_value

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

breakdown_value

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

indicator_value

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

breakdown_display_value

 SQL_VARCHAR(500) True True

breakdown_level2_display_value

 SQL_VARCHAR(500) True True

element_display_value

 SQL_VARCHAR(500) True True

element_level2_display_value

 SQL_VARCHAR(500) True True

element_level2_value

 SQL_VARCHAR(256) True True

element_value

 SQL_VARCHAR(256) True True

indicator_display_value

 SQL_VARCHAR(500) True True

start_at_display_value

 SQL_VARCHAR(500) True True

start_at_value

 SQL_VARCHAR(256) 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_domain_display_value

 SQL_VARCHAR(500) False True

sys_domain_path_display_value

 SQL_VARCHAR(500) False True

sys_domain_path_value

 SQL_VARCHAR(510) False True

sys_domain_value

 SQL_VARCHAR(64) 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_tags_display_value

 SQL_VARCHAR(500) False True

sys_tags_value

 SQL_VARCHAR(256) 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

value_display_value

 SQL_VARCHAR(500) True True

value_value

 SQL_NUMERIC(38,3) True True