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 |