Check Parameters (CDM/LDM/PDM)

Check parameters are set of conditions which data must satisfy to remain valid.

There are three types of check parameters:

Parameter type	Description	Can be attached to
Standard check parameters	Common data constraints which define a data range. For example minimum and maximum values for a column	Columns/Entity attributes Domains
Additional check parameters	SQL expression defining a data constraint using the %MINMAX%, %LISTVAL%, and %RULES% variables that are instantiated with standard parameter values	Columns/Entity attributes Domains
Validation rule	Business rule that is defined as a server expression, and is attached to one of the following listed objects	Tables/Entities Columns/Entity attributes Domains

Parameter type

Description

Can be attached to

Standard check parameters

Common data constraints which define a data range. For example minimum and maximum values for a column

Columns/Entity attributes

Domains

Additional check parameters

SQL expression defining a data constraint using the %MINMAX%, %LISTVAL%, and %RULES% variables that are instantiated with standard parameter values

Columns/Entity attributes

Domains

Validation rule

Business rule that is defined as a server expression, and is attached to one of the following listed objects

Tables/Entities

Columns/Entity attributes

Domains

Setting Standard Check Parameters for Objects in a Data Model
Standard parameters indicate common data constraints.
Defining Additional Check Parameters for Objects in a Data Model
You define additional check parameters for data constraints where standard check parameters are not sufficient.
Using a Validation Rule in Check Parameters in a Data Model
A validation rule is a rule that validates data based on a corresponding business rule. A validation rule can be generated as a check parameter when the following conditions apply:
Managing Quotation Marks Around Values (PDM)
For a domain or a column, standard parameters can indicate minimum, maximum, and default values as well as a list of values.

Parent topic: Building Physical Diagrams