sys_dictionary
The table below describes the sys_dictionary table.
This table contains the following foldable columns:
- sys_id_value
- reference_value
- active_display_value
- active_value
- array_display_value
- array_value
- attributes_display_value
- attributes_value
- audit_display_value
- audit_value
- calculation_display_value
- calculation_value
- choice_display_value
- choice_field_display_value
- choice_field_value
- choice_table_display_value
- choice_table_value
- choice_value
- column_label_display_value
- column_label_value
- comments_display_value
- comments_value
- create_roles_display_value
- create_roles_value
- default_value_display_value
- default_value_value
- defaultsort_display_value
- defaultsort_value
- delete_roles_display_value
- delete_roles_value
- dependent_display_value
- dependent_on_field_display_value
- dependent_on_field_value
- dependent_value
- display_display_value
- display_value
- dynamic_creation_display_value
- dynamic_creation_script_display_value
- dynamic_creation_script_value
- dynamic_creation_value
- dynamic_default_value_display_value
- dynamic_default_value_value
- dynamic_ref_qual_display_value
- dynamic_ref_qual_value
- element_display_value
- element_reference_display_value
- element_reference_value
- element_value
- foreign_database_display_value
- foreign_database_value
- internal_type_display_value
- internal_type_value
- mandatory_display_value
- mandatory_value
- max_length_display_value
- max_length_value
- name_display_value
- name_value
- next_element_display_value
- next_element_value
- primary_display_value
- primary_value
- read_only_display_value
- read_only_value
- read_roles_display_value
- read_roles_value
- reference_cascade_rule_display_value
- reference_cascade_rule_value
- reference_display_value
- reference_floats_display_value
- reference_floats_value
- reference_key_display_value
- reference_key_value
- reference_qual_condition_display_value
- reference_qual_condition_value
- reference_qual_display_value
- reference_qual_value
- reference_type_display_value
- reference_type_value
- sizeclass_display_value
- sizeclass_value
- spell_check_display_value
- spell_check_value
- staged_display_value
- staged_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_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_name_display_value
- sys_name_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_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
- table_reference_display_value
- table_reference_value
- text_index_display_value
- text_index_value
- unique_display_value
- unique_value
- use_dependent_field_display_value
- use_dependent_field_value
- use_dynamic_default_display_value
- use_dynamic_default_value
- use_reference_qualifier_display_value
- use_reference_qualifier_value
- virtual_display_value
- virtual_value
- widget_display_value
- widget_value
- write_roles_display_value
- write_roles_value
- xml_view_display_value
- xml_view_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 |
|
reference_value Foreign Key linked to column sys_id_value in sys_db_object table |
SQL_VARCHAR(160) | True | True |
|
active_display_value |
SQL_VARCHAR(500) | True | True |
|
active_value |
SQL_BIT | True | True |
|
array_display_value |
SQL_VARCHAR(500) | True | True |
|
array_value |
SQL_BIT | True | True |
|
attributes_display_value |
SQL_VARCHAR(500) | True | True |
|
attributes_value |
SQL_VARCHAR(510) | True | True |
|
audit_display_value |
SQL_VARCHAR(500) | True | True |
|
audit_value |
SQL_BIT | True | True |
|
calculation_display_value |
SQL_LONGVARCHAR(1024) | True | True |
|
calculation_value |
SQL_LONGVARCHAR(1024) | True | True |
|
choice_display_value |
SQL_VARCHAR(500) | True | True |
|
choice_field_display_value |
SQL_VARCHAR(500) | True | True |
|
choice_field_value |
SQL_VARCHAR(256) | True | True |
|
choice_table_display_value |
SQL_VARCHAR(500) | True | True |
|
choice_table_value |
SQL_VARCHAR(256) | True | True |
|
choice_value |
SQL_INTEGER(signed) | True | True |
|
column_label_display_value |
SQL_VARCHAR(500) | True | True |
|
column_label_value |
SQL_VARCHAR(256) | True | True |
|
comments_display_value |
SQL_VARCHAR(8000) | True | True |
|
comments_value |
SQL_VARCHAR(8000) | True | True |
|
create_roles_display_value |
SQL_VARCHAR(500) | True | True |
|
create_roles_value |
SQL_VARCHAR(256) | True | True |
|
default_value_display_value |
SQL_VARCHAR(5000) | True | True |
|
default_value_value |
SQL_VARCHAR(5000) | True | True |
|
defaultsort_display_value |
SQL_VARCHAR(500) | True | True |
|
defaultsort_value |
SQL_INTEGER(signed) | True | True |
|
delete_roles_display_value |
SQL_VARCHAR(500) | True | True |
|
delete_roles_value |
SQL_VARCHAR(256) | True | True |
|
dependent_display_value |
SQL_VARCHAR(500) | True | True |
|
dependent_on_field_display_value |
SQL_VARCHAR(500) | True | True |
|
dependent_on_field_value |
SQL_VARCHAR(256) | True | True |
|
dependent_value |
SQL_VARCHAR(80) | True | True |
|
display_display_value |
SQL_VARCHAR(500) | True | True |
|
display_value |
SQL_BIT | True | True |
|
dynamic_creation_display_value |
SQL_VARCHAR(500) | True | True |
|
dynamic_creation_script_display_value |
SQL_VARCHAR(8000) | True | True |
|
dynamic_creation_script_value |
SQL_VARCHAR(8000) | True | True |
|
dynamic_creation_value |
SQL_BIT | True | True |
|
dynamic_default_value_display_value |
SQL_VARCHAR(500) | True | True |
|
dynamic_default_value_value |
SQL_VARCHAR(64) | True | True |
|
dynamic_ref_qual_display_value |
SQL_VARCHAR(500) | True | True |
|
dynamic_ref_qual_value |
SQL_VARCHAR(64) | True | True |
|
element_display_value |
SQL_VARCHAR(500) | True | True |
|
element_reference_display_value |
SQL_VARCHAR(500) | True | True |
|
element_reference_value |
SQL_BIT | True | True |
|
element_value |
SQL_VARCHAR(160) | True | True |
|
foreign_database_display_value |
SQL_VARCHAR(500) | True | True |
|
foreign_database_value |
SQL_VARCHAR(80) | True | True |
|
internal_type_display_value |
SQL_VARCHAR(500) | True | True |
|
internal_type_value |
SQL_VARCHAR(80) | True | True |
|
mandatory_display_value |
SQL_VARCHAR(500) | True | True |
|
mandatory_value |
SQL_BIT | True | True |
|
max_length_display_value |
SQL_VARCHAR(500) | True | True |
|
max_length_value |
SQL_INTEGER(signed) | True | True |
|
name_display_value |
SQL_VARCHAR(500) | True | True |
|
name_value |
SQL_VARCHAR(256) | True | True |
|
next_element_display_value |
SQL_VARCHAR(500) | True | True |
|
next_element_value |
SQL_VARCHAR(160) | True | True |
|
primary_display_value |
SQL_VARCHAR(500) | True | True |
|
primary_value |
SQL_BIT | True | True |
|
read_only_display_value |
SQL_VARCHAR(500) | True | True |
|
read_only_value |
SQL_BIT | True | True |
|
read_roles_display_value |
SQL_VARCHAR(500) | True | True |
|
read_roles_value |
SQL_VARCHAR(256) | True | True |
|
reference_cascade_rule_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_cascade_rule_value |
SQL_VARCHAR(40) | True | True |
|
reference_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_floats_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_floats_value |
SQL_BIT | True | True |
|
reference_key_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_key_value |
SQL_VARCHAR(80) | True | True |
|
reference_qual_condition_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_qual_condition_value |
SQL_VARCHAR(256) | True | True |
|
reference_qual_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_qual_value |
SQL_VARCHAR(510) | True | True |
|
reference_type_display_value |
SQL_VARCHAR(500) | True | True |
|
reference_type_value |
SQL_VARCHAR(20) | True | True |
|
sizeclass_display_value |
SQL_VARCHAR(500) | True | True |
|
sizeclass_value |
SQL_INTEGER(signed) | True | True |
|
spell_check_display_value |
SQL_VARCHAR(500) | True | True |
|
spell_check_value |
SQL_BIT | True | True |
|
staged_display_value |
SQL_VARCHAR(500) | True | True |
|
staged_value |
SQL_BIT | 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_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_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_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 |
|
table_reference_display_value |
SQL_VARCHAR(500) | True | True |
|
table_reference_value |
SQL_BIT | True | True |
|
text_index_display_value |
SQL_VARCHAR(500) | True | True |
|
text_index_value |
SQL_BIT | True | True |
|
unique_display_value |
SQL_VARCHAR(500) | True | True |
|
unique_value |
SQL_BIT | True | True |
|
use_dependent_field_display_value |
SQL_VARCHAR(500) | True | True |
|
use_dependent_field_value |
SQL_BIT | True | True |
|
use_dynamic_default_display_value |
SQL_VARCHAR(500) | True | True |
|
use_dynamic_default_value |
SQL_BIT | True | True |
|
use_reference_qualifier_display_value |
SQL_VARCHAR(500) | True | True |
|
use_reference_qualifier_value |
SQL_VARCHAR(80) | True | True |
|
virtual_display_value |
SQL_VARCHAR(500) | True | True |
|
virtual_value |
SQL_BIT | True | True |
|
widget_display_value |
SQL_VARCHAR(500) | True | True |
|
widget_value |
SQL_VARCHAR(80) | True | True |
|
write_roles_display_value |
SQL_VARCHAR(500) | True | True |
|
write_roles_value |
SQL_VARCHAR(256) | True | True |
|
xml_view_display_value |
SQL_VARCHAR(500) | True | True |
|
xml_view_value |
SQL_BIT | True | True |