Master Data Management

Create Tables and Views for Content WebApp Pages Overview

A Designer can create control tables and views, including Page Control Views (PCV), Data Control Views (DCV) and validation views, for a scenario > role > task combination. These objects are created and stored in the Content WebApp’s database.

Tables are based on the Content WebApp page’s column settings for control status (Hide, Enable, Disable) set in MDM. Refer to Configure Column Status for a Task for a Scenario Role Combination for more information.

If a task has active variants assigned under any scenario > role combination in the category, MDM builds a DCV. In other words, a specific scenario > role > task combination may not have an active variant. However, if the task has an active variant in a different scenario > role > task combination, MDM builds the DCV.

If a task does not have active variants in any scenario > role > task combinations in the category, MDM builds a PCV.

Refer to Activate and Configure Column Variants for more information.

NOTE: A Designer must register views to a page(s) in the Content WebApp.

NOTE: The prefix of the table name can be updated if needed. Refer to Set the Control Table Prefix for more information.

To generate control tables and validation views:

  1. Create a control table that contains a list of relevant columns from the page table registered to the corresponding Column PageID on the Scenario Role Task Column page. This table stores the data to be used as the basis for DCVs and PCVs. Refer to Generate a Control Table for Content WebApp Pages for more information.

    NOTE: Relevant columns are columns used for data entry, not internal reserved columns.

    NOTE: If the control tables and control views have already been created, a Designer can click the Create Control Table icon on the Scenario Role Task Page page to drop and rebuild the table and repopulate the control data.

  2. Create a validation view for each required column based on the Required setting on the Scenario Role Task Column page. Refer to  Create Validation Views for a Content WebApp Task Page and Create Validation Views for Content WebApp Task Pages for more information.

    NOTE: If column configuration is updated on the Scenario Role Task Column page, the data in the control table can be updated with the Update Control Data button. In this case, the tables do not need to be rebuilt and views do not need to be updated to capture these sort of changes. If columns are added to or removed from the content page use the Update Column List icon on the Scenario Role Task Column page to capture the column additions or subtractions, then rebuild the control table. Refer to Update Control Table Data for more information.

NOTE: Users can add two columns, one containing the role owner and the other the SLA minutes late for the request roles, to the Requests page in the Content WebApp using an API view included with the Stewardship Tier. Include the view apiRequestAllOwnersMinutesLateSel.sql using an outer join in the Content WebApp’s Request page view to show Minutes Late and Role Owner for each request.