A RangeCheck defines a constraint on the value of the enclosing item. It represents an expression that evaluates to True when the ItemData value is valid or False when the ItemData value is invalid. The expression is specified using either Comparator and CheckValue or using FormalExpressions.
| Element Name | RangeCheck |
|---|---|
| Parent Elements | ItemDef, WhereClauseDef |
| Element XPath(s) | /ODM/Study/MetaDataVersion/WhereClauseDef/RangeCheck /ODM/Study/MetaDataVersion/ItemDef/RangeCheck |
| Element Textual Value | None |
| Attributes | Comparator, SoftHard, ItemOID |
| Child Elements | ((CheckValue+ | (MethodSignature?, FormalExpression+)), ErrorMessage?) |
| Usage/Business Rules |
| Attribute | Schema Datatype or Enumeration | Usage | Definition | Business Rules |
|---|---|---|---|---|
| Comparator | (LT | LE | GT | GE | EQ | NE | IN | NOTIN) | Conditional | Comparison operator used to compare the item and value(s). | Required when at least a child element CheckValue is present. |
| SoftHard | (Soft | Hard) | Conditional | Type of range check. Soft indicates that a warning occurs when the RangeCheck fails. Hard indicates that an error occurs when the RangeCheck fails. | Required when Comparator is present. |
| ItemOID | oidref | Conditional | Identifies a variable to compare against. | Required when Comparator is present. Must match the ItemOID for an ItemRef sibling element within the ItemGroupDef. |
Range Checks using Comparator and CheckValue
When using Comparator and Check Value each Range Check represents a one-sided constraint. Multiple Range Checks can be used to specify more complex constraints, e.g., an upper and lower bound would require two Range Checks.
Each constraint is equivalent to:
itemValue comparator checkValue(s)
If an actual data value fails the constraint, it is either rejected (a Hard constraint) or a warning is produced (a Soft constraint).
For the following comparison operators, one Check Value is required.
| LT | Less than |
| LE | Less than or equal to |
| GT | Greater than |
| GE | Greater than or equal to |
| EQ | Equal to |
| NE | Not equal to |
A set of Check Values is required for these comparators:
| IN | One of listed values |
| NOTIN | Not any of list values |
If a Measurement Unit is specified, the corresponding Item values must have interconvertible Measurement Units (either explicitly or by default). Proper conversion of units must be done as part of the Range Check. If a Measurement Unit is not specified, the corresponding Item values must not have Measurement Units (either explicitly or by default).
Example
<RangeCheck Comparator="GT">
<CheckValue>0</CheckValue>
</RangeCheck>
Example
<RangeCheck Comparator="IN">
<CheckValue>1</CheckValue>
<CheckValue>3</CheckValue>
<CheckValue>5</CheckValue>
</RangeCheck>
Example
<RangeCheck Comparator="GE">
<CheckValue>18</CheckValue>
</RangeCheck>
<RangeCheck Comparator="LE">
<CheckValue>65</CheckValue>
</RangeCheck>
Range Checks using FormalExpression
When using FormalExpression a Range Check can represent anything, e.g., one sided or multi-sided checks. These type of checks must not provide CheckValue or Comparator as they would all be expressed in the FormalExpression itself. The FormalExpression takes the value of the ItemData element and returns a boolean value which is the result of the expression. Multiple FormalExpressions can be provided if each has a different Context attribute, allowing the same expression to be represented in forms appropriate to multiple systems. Multiple different expressions, with different meanings, must be represented as separate RangeChecks
Example
<RangeCheck>
<FormalExpression Context="PL/SQL">
<Code>IT.DM.AGE between 18 and 65</Code>
</FormalExpression>
</RangeCheck>