AssignColumnValueDomains

A Column, once initially created does not have an assigned value domain. This essentially means that any value would be considered acceptable. To restrict the value set, a Value Domain needs to be assigned. The process to assign Column Value Domains includes:

• Start the Implemented Database Model Metabase System Module
• Select the DBMS
• Enter User Name and Password
• Select the Menu Item, Columns, then the subordinate menu item Maintenance, and the subordinate menu item, Column Value Domain
• Select a Schema
• Select a Table
• Within the Column Value Domain hierarchy, select the Column to which a value domain should be assigned. The currently assigned value domain will be shown at the end of the entry-line. It will most likely be "Unknown."
• Select the Value Domain Type, Containment
• Shown will then be all the value domains that can be assigned based on the Column's parent Attribute, Data Element, Dataa Element Concept, and its parent Conceptual Value Domain.
• Select one one of the allowed value domains. If the selected value domain is already assigned to the Column's parent Attribute, the "Assign" button will be greyed-out.
• If assignable, Press the Assign button

For Sales and Corporate: 1-301-249-1142 Whitemarsh@Wiscorp.com

Whitemarsh Information Systems Corporation

 Bowie, Maryland 20716 USA

Copyright 1981 - 2020 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved