{"id":22164,"date":"2024-02-15T14:48:40","date_gmt":"2024-02-15T22:48:40","guid":{"rendered":"https:\/\/docs.extraview.com\/v22\/book\/data-dictionary-0\/"},"modified":"2024-02-15T14:48:40","modified_gmt":"2024-02-15T22:48:40","slug":"data-dictionary-0","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/","title":{"rendered":"Data Dictionary"},"content":{"rendered":"<p>The Data Dictionary is the central place where all field definitions are stored and maintained. The data dictionary is found within the System Configuration administrative menu.<\/p>\n<p><img decoding=\"async\" src=\"\/extraview-media\/images\/ag\/fields_and_layouts\/data_dictionary_tabs3.png\" style=\"width: 90%;\" \/><\/p>\n<p><span class=\"imageCaption\">Data Dictionary screen tabs<\/span><\/p>\n<h3>\n\tFields<\/h3>\n<p>These are the fields within ExtraView that are used within all processes. There are two types of fields, built-in fields and users defined fields (UDF\u2019s). Built-in fields are provided as part of all ExtraView installations. Although you may modify various attributes of built-in fields, such as their title and their default value, you should never delete an built-in field. You may create as many UDF\u2019s as you require for your installation. There is no limit on the number of UDF\u2019s that may be created. All fields have four basic properties, their scope, a fixed name, a title and a display type. It is the display type<\/p>\n<p>that gives a field most of its functionality. See later in this section for a complete explanation of all the field types. Once any UDF is defined in the data dictionary it will behave the same as if it were an inbuilt field. You will be able to attach permissions to the field, place it on any layout, report on the field, etc. End users will not be able to detect the difference between an inbuilt field and a UDF. When viewing a list of fields in the data dictionary, you will only see the fields in the Business Areas and Projects to which you have permission. This typically includes all the fields which are global in their scope.<\/p>\n<p>As a technical point, there is no real limit to the number of UDF\u2019s you create. In addition, creating a UDF does not result in any change to the underlying database schema. There is no system degradation in creating a large number of UDF\u2019s.<\/p>\n<h3>\n\tExpressions<\/h3>\n<p>Expression fields are used in reporting to derive or calculate the value of a reporting column. Each expression may have a default expression which is then automatically used on any report which contains the expression field. Expression fields also have a range of display types, although this range is more limited than a field display type. You may define any number of additional expression fields, or reuse the same expression fields for different purposes on different reports.<\/p>\n<h3>\n\tLabels \/ Buttons<\/h3>\n<p>This section is where field screen elements that are not database fields can be defined or altered. Buttons for menubars are also maintained within this tab.&nbsp; Once again, it is unlikely that the administrator will remove fields from this section. Labels can also be added as User Defined Fields, so it is unlikely that the administrator will add new fields to this section of the data dictionary.<\/p>\n<h3>\n\tScreens<\/h3>\n<p>These fields are for the inbuilt screens within ExtraView. A few additional supporting fields in this area affect screen displays. Administrators should not need to add or remove entries from this section, but can rename the individual screens within their installation.<\/p>\n<h3>\n\tSession Variables<\/h3>\n<p>Fields found in this area pertain to options having to do with the user\u2019s current, active ExtraView session. Fields defined in this section are principally used in reporting<\/p>\n<h3>\n\tReserved Field Names<\/h3>\n<p>This is an informational section which displays the names of fields which are used internally within the ExtraView software.&nbsp; These names may not be used as User Defined Field names.<\/p>\n<h3>\n\tSpecial Variables<\/h3>\n<p>These fields generally are those that manage functions involving calculations of some kind, such as the internal data\/time stamping functionality.<\/p>\n<h3>\n\tKey Uses of the Data Dictionary<\/h3>\n<p>This core component of ExtraView controls many of the attributes of each field, such as:<\/p>\n<ul>\n<li>\n\t\tDisplay type of each field<\/li>\n<li>\n\t\tDisplay title for each field. The title that is used for all screen labels can be altered at will for each field<\/li>\n<li>\n\t\tWhether the field is selectable for reports<\/li>\n<li>\n\t\tSetting up field dependencies<\/li>\n<li>\n\t\tPopulating the values into lists<\/li>\n<li>\n\t\tDefault values<\/li>\n<li>\n\t\tHelp text<\/li>\n<\/ul>\n<h3>\n\tDocumenting the Purpose and Use of Fields<\/h3>\n<p>It is often useful for the administrator to document the purpose of any field within their system.&nbsp; To achieve this, add a global attribute to any field, with the type of ADMIN_NOTES.&nbsp; The text entered within this field is not utilized outside the data dictionary, but serves as documentation regarding that field.&nbsp; This text is also visible within the design center when a field is placed on a layout.&nbsp; It can be viewed within the Cell Attributes section of the screen.<\/p>\n<p>Note that if you want to view where a field is used within the overall system, you can use the <strong>Where Used<\/strong> tab within the data dictionary.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Data Dictionary is the central place where all field definitions are stored and maintained. The data dictionary is found within the System Configuration administrative menu. Data Dictionary screen tabs Fields These are the fields within ExtraView that are used within all processes. There are two types of fields, built-in fields and users defined fields&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-22164","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Dictionary - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Dictionary - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"The Data Dictionary is the central place where all field definitions are stored and maintained. The data dictionary is found within the System Configuration administrative menu. Data Dictionary screen tabs Fields These are the fields within ExtraView that are used within all processes. There are two types of fields, built-in fields and users defined fields...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/\",\"url\":\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/\",\"name\":\"Data Dictionary - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\"},\"datePublished\":\"2024-02-15T22:48:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v22\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Dictionary\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Dictionary - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/","og_locale":"en_US","og_type":"article","og_title":"Data Dictionary - Product Documentation","og_description":"The Data Dictionary is the central place where all field definitions are stored and maintained. The data dictionary is found within the System Configuration administrative menu. Data Dictionary screen tabs Fields These are the fields within ExtraView that are used within all processes. There are two types of fields, built-in fields and users defined fields...","og_url":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/","url":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/","name":"Data Dictionary - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v22\/#website"},"datePublished":"2024-02-15T22:48:40+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v22\/data-dictionary-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v22\/"},{"@type":"ListItem","position":2,"name":"Data Dictionary"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v22\/#website","url":"https:\/\/docs.extraview.com\/v22\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v22\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v22\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v22\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v22\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/comments?post=22164"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22164\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/media?parent=22164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}