pa_dimensions
The table below describes the pa_dimensions table.
This table contains the following foldable columns:
- sys_id_value
- sys_overrides_value
- active_display_value
- active_value
- conditions_display_value
- conditions_value
- description_display_value
- description_value
- empty_value_display_value
- empty_value_value
- facts_table_display_value
- facts_table_value
- field_display_value
- field_value
- manual_breakdown_display_value
- manual_breakdown_value
- name_display_value
- name_value
- security_type_display_value
- security_type_value
- sys_class_name_display_value
- sys_class_name_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_customer_update_display_value
- sys_customer_update_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_name_display_value
- sys_name_value
- sys_overrides_display_value
- sys_package_display_value
- sys_package_value
- sys_policy_display_value
- sys_policy_value
- sys_replace_on_upgrade_display_value
- sys_replace_on_upgrade_value
- sys_scope_display_value
- sys_scope_value
- sys_tags_display_value
- sys_tags_value
- sys_update_name_display_value
- sys_update_name_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
sys_overrides_value Foreign Key linked to column sys_id_value in pa_dimensions table |
SQL_VARCHAR(64) | True | True |
|
active_display_value |
SQL_VARCHAR(500) | True | True |
|
active_value |
SQL_BIT | True | True |
|
conditions_display_value |
SQL_VARCHAR(8000) | True | True |
|
conditions_value |
SQL_VARCHAR(8000) | True | True |
|
description_display_value |
SQL_VARCHAR(8000) | True | True |
|
description_value |
SQL_VARCHAR(8000) | True | True |
|
empty_value_display_value |
SQL_VARCHAR(500) | True | True |
|
empty_value_value |
SQL_VARCHAR(256) | True | True |
|
facts_table_display_value |
SQL_VARCHAR(500) | True | True |
|
facts_table_value |
SQL_VARCHAR(256) | True | True |
|
field_display_value |
SQL_VARCHAR(500) | True | True |
|
field_value |
SQL_VARCHAR(256) | True | True |
|
manual_breakdown_display_value |
SQL_VARCHAR(500) | True | True |
|
manual_breakdown_value |
SQL_VARCHAR(64) | True | True |
|
name_display_value |
SQL_VARCHAR(500) | True | True |
|
name_value |
SQL_VARCHAR(256) | True | True |
|
security_type_display_value |
SQL_VARCHAR(500) | True | True |
|
security_type_value |
SQL_VARCHAR(80) | True | True |
|
sys_class_name_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_class_name_value |
SQL_VARCHAR(160) | False | 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_customer_update_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_customer_update_value |
SQL_BIT | True | 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_name_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_name_value |
SQL_VARCHAR(510) | True | True |
|
sys_overrides_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_package_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_package_value |
SQL_VARCHAR(64) | True | True |
|
sys_policy_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_policy_value |
SQL_VARCHAR(80) | True | True |
|
sys_replace_on_upgrade_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_replace_on_upgrade_value |
SQL_BIT | True | True |
|
sys_scope_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_scope_value |
SQL_VARCHAR(64) | True | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_update_name_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_update_name_value |
SQL_VARCHAR(200) | True | 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 |