# Data Governance Portal ## Data Governance Portal The **Data Governance Portal** provides a user interface to define data governance scopes based on repository filters and tracked fields. These scopes determine which fields will be audited for completeness and currentness. For example, productive and critical Business Applications may require certain fields to be maintained and reviewed at specific intervals. To open the portal navigate to Data Governance -> Data Governance Portal and open the portal to start creating data governance scopes. ![](/files/zoARSJJsFcs2gDE7CQQK) A – Indicates the amount of scopes ( 1 ), the amount of fields tracked \[ 1 ] and table 'Symbol + Table Name'. Hover over the icon to check if it is a scope or field. B – These ‘cards’ represent a Data Governance Scope C – Click here to create a new Scope for the selected/expanded table D – Click here to create a new Scope for a new table not being tracked yet ## Creating a new Scope: step-by-step guide ![](/files/AoPpzta8hG2JOgKWDypA) A – Click the plus sign in the center of a card within a table definition to create a new scope for that table or the plus sign in the bottom right to create a new scope for a new table B – Provide a meaningful name, e.g. ‘Bus. Applications in Production’ C – These buttons are used for saving or discarding the scope D – Specify the target table E – Specify the steward type – steward type can be assigned to a person or group. If a the type is assigned to a single person, they must be referenced from the user-table. F – Review cycle specifies how frequently the data's validity will be reset. Once reset the data must be again verified (as current) G – Reminder cycle determines the interval people are reminded to verify. The interval begins from the day the scope is created. H – You can toggle the audit option off if the field is not required for data completeness and currentness reviews. If audit is active, the steward, or steward group members, will receive notifications directly. Additionally, completeness and currentness will appear in the form view. You can also switch off the notifications and check the form view only for status updates. I – Select the checkbox to include all records in the table or click on the ‘Filters’ button to open a window to specify filter criteria for the scope records to satisfy J – Specify your filter criteria here and confirm with ‘Save’ K – After the scope card has been created, you can add fields relevant to the scope/to monitor {% hint style="warning" %} **Large Data Sets** When creating scopes for Data Governance, YouDesign Command creates evaluation entries in the data quality table (x\_inpgh\_upmx\_data\_quality) for each tuple of table and field. For tables with large amounts of data (over 10,000 elements), we recommend creating the scope with 2-3 fields, waiting for the evaluation to complete, and then adding the next set of fields. {% endhint %} ## Data Quality Widget The Data Quality Widget provides an overview of tracked fields and allows you to easily verify fields that are due for verification. Control its visibility with ACLs on the Data Quality tab of an element or table where data quality is tracked. !\[]\(../images/99fbe78-YouDesign Command-DQ-Widget-Admin.png "YouDesign Command-DQ-Widget-Admin.png") A – Field tracked by Data Governance B – Current value of the field or ‘(Empty)’ C – Completeness Indicator – either ‘Complete’ or ‘Missing’ D – Currentness Indicator – either ‘Current’, ‘Overdue’ or ‘Missing’/’No Value’ E – ‘Next verification in’ indicates when the next review is due according to the review cycle definition, or how many days/months/years it is overdue F – Verification button to instantly verify the field content G – ‘Verify All’ – instantly verifies all fields where a verification is due H – Example of countdown to next due verification ## Data Governance Reporting YouDesign Command stores Data Governance data in the following tables: * x\_inpgh\_upmx\_data\_quality - Main data quality table * x\_inpgh\_upmx\_portfolio\_element - All YouDesign Command tables extend from this table and include calculated ‘Data Completeness’ and ‘Data Currentness’ fields * Since v4.2, calculated ‘Data Completeness’ and ‘Data Currentness’ values are available on all tables inherited from ‘cmdb\_ci’ To create Data Governance Reports and Dashboards, start with the Data Quality table. If you need to filter on additional criteria, switch to the attributes directly on the tables themselves. !\[]\(../images/d936f1c-YouDesign Command-DQ-Dashboard.png "YouDesign Command-DQ-Dashboard.png") ## Scheduled Jobs in Data Governance The Data Governance feature in YouDesign Command leverages Scheduled Jobs, mainly to conduct administrative work. The following scripts are available for use on scheduled jobs. !\[]\(../images/a4a8695-YouDesign Command-dq-options2.png) These have the following actions | Name | Function | | --------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | | IGNORE: YouDesign Command DO Create Data Quality for CIs created in last 15 minutes | **DEPRECATED** | | ON DEMAND: YouDesign Command DQ Add missing data in Data Definition Scope table | Sets the Steward Type, Reminder Cycle and Last notified Date fields on Data Definition Scope  ‘Legacy/pre-v4.1’ for migration purposes | | ON DEMAND: YouDesign Command DQ Create Data Quality from all Scoped Fields | Recreates content of the Data Quality table based on the definition/configuration | | ON DEMAND: YouDesign Command DQ Fill Table Reference field in Data Quality | Forces update for the table\_reference in the Data Quality table for all records | | ON DEMAND: YouDesign Command DQ Remove complete Data Quality configuration | Removes the entire Data Quality configuration – e.g. in case you want to get rid of demo data/configuration and start with a clean slate | | ON DEMAND: YouDesign Command DQ Set 'Verification History' on Data Quality from 'Data Verification' table | **DEPRECATED** Takes the last verified day from the Data Verification table to the Data Quality table | | ON DEMAND: YouDesign Command DQ Set Average Data Quality. | Sets the average data completeness and currentness for an element in ‘Data Completeness’ and ‘Data Currentness’ fields of the element | | PERIODIC: YouDesign Command DQ Create Data Quality from recently created Scoped Fields | Calculates Data Quality values after the scope is created. | | PERIODIC: YouDesign Command DO Update Data Quality for recently created/updated CIs | Re-calculates Data Quality values for recently updated records. | | PERIODIC: YouDesign Command DQ Update Data Quality when Scope changes | Calculates Data Quality values after the scope is updated. | | YouDesign Command DQ Notify Currentness and Completeness info to Steward/Steward Group | Sends the notification containing information about Data Completeness and Currentness to a steward/steward group if the reminder cycle is overdue | | YouDesign Command DQ Set Data Currentness on Data Quality table | Sets data currentness to zero on Data Quality table when the previous cycle becomes overdue | {% hint style="warning" %} **Data Quality Cleanup** Use "Remove complete Data Quality configuration" with caution as it removes everything related to Data Governance. It may be an alternative to clearing the x\_inpgh\_upmx\_data\_quality table to achieve the desired outcome. {% endhint %} {% hint style="info" %} **Deprecation Notice** If an ON DEMAND feature is not already marked deprecated, it may be deprecated in the future. {% endhint %} ## Notifications in Data Quality YouDesign Command leverages ServiceNow platform functionality to send notifications to stakeholders. Notifications are sent for scopes defined in the data governance portal that are flagged with ‘audit=yes’. * To edit Notifications, navigate to **System Notification** > **Notifications** * To edit Email scripts, navigate to **System Notification** > **Notification Email Scripts** !\[]\(../images/6bed354-YouDesign Command-DQ-Notifications.png "YouDesign Command-DQ-Notifications.png") A – List of notifications in the context of YouDesign Command Data Governance. The notification invokes a corresponding Notification Email Script B – Name of the Notification C – Name of the Notification Email Script invoked D – List of Notification Email Scripts in the context of YouDesign Command Data Governance. {% hint style="info" %} **Notification Schedule** The schedule for sending notifications is controlled by the Data Governance Portal settings in the individual scopes. {% endhint %} --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.ins-pi.com/command/configuration/data-governance-portal.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.