Check Type
User Guide — The Library of Quality Checks
| Last updated: September 2026
Contents
- Overview
- Finding Your Way Around
- Reading the List
- Adding, Editing, and Deleting a Check Type
- Quick Reference
1. Overview
Check Type defines the library of quality checks the rest of the module can use. Every check you switch on for a data element in Define Rule — a "not empty" check, a range check, and so on — comes from an entry on this screen. In other words, this is where the kinds of check are set up, so they're ready to be applied to your data elsewhere.
This is an advanced setup screen. Most people building rules never need to open it — they simply pick from the checks it provides. It's aimed at administrators who are tailoring the set of checks available across the Quality module.
What you can do here
- See every check type available in the module.
- Add a new check type to the library.
- Adjust how a check type behaves and where it can be used.
- Remove a check type that's no longer needed.
WHERE TO FIND IT — Open Quality → Check Type. The screen's heading reads "Data Quality Check Type."
AN ADVANCED SCREEN — Changing a check type affects everyone who uses it in Define Rule. If you only want to apply checks to your data, you don't need this screen — use Define Rule instead.
2. Finding Your Way Around
The screen is a single table, with one row per check type. A plus (+) button in the bottom-right adds a new one, and each row has a Delete button in the Action column on the left.
The important thing to understand is how this list connects to the rest of the module: the entries here are exactly the checks that appear in Define Rule. Each entry also carries settings that control where it shows up and how it behaves when someone configures it — those are the columns explained next.
3. Reading the List
Each row describes one check type. Some columns are everyday, and a few are more technical — the table below explains all of them in plain terms.
| Column | What it shows |
|---|---|
| Action | The first column on the left, holding the Delete button for the check type. |
| DQ Check Name | The name of the check, as it appears to people in Define Rule. |
| Seq Num | The position of the check in the list — used to control the order checks are shown in. |
| Default Dimension | The quality dimension the check is assigned to by default (Completeness, Validity, and so on). |
| Rule Name Suffix | A short piece of text automatically added to the end of the names of rules created from this check, so they stay easy to recognise. |
| Check Type | The kind of check this is, chosen from a set of built-in types. |
| DisplayField Type | How the check's input is presented when someone sets it up — for example choosing a single column, choosing two columns, or entering a value. |
| Has Multiple Instance | Ticked when the check can be applied more than once on the same data element (for example two separate ranges). |
| Valid For Types | Which data types the check can be used on. This is what makes Define Rule show only the checks that fit a given element — so a number check won't appear on a text field. |
| DropDownSQL1 / DropDownSQL2 | Behind-the-scenes queries that fill in the choices offered when someone configures the check. These are technical settings, best left to an administrator. |
| Updated By / Updated Date | Who last changed the check type, and when. |
A FEW COLUMNS ARE TECHNICAL — DisplayField Type, Valid For Types, and the two DropDownSQL columns control the inner workings of a check. They decide how it looks and where it's allowed, and the SQL columns are for administrators. If you're not sure what a value should be, it's best to check with your system administrator before changing it.
4. Adding, Editing, and Deleting a Check Type
Adding. Select the plus (+) button in the bottom-right. A new row is added to the table with a starter name (like "check type 5"). Fill in its columns directly in the table to describe the new check — give it a clear DQ Check Name, set its Default Dimension, choose its Check Type and DisplayField Type, and set Valid For Types so it appears on the right kinds of data.
Editing. Change any value directly in the table — click a cell, choose or type a new value, and it saves on its own. Tick or untick Has Multiple Instance the same way.
Deleting. Use the Delete button in the Action column, then confirm.
CHANGES REACH DEFINE RULE STRAIGHT AWAY — Because this list is what Define Rule offers, adding a check type makes it available there, and removing one takes it away. Before deleting a check type, it's worth making sure it isn't relied on by existing rules.
5. Quick Reference
A fast lookup for the most common actions.
| I want to… | Do this |
|---|---|
| See every available check type | Open Quality → Check Type |
| Add a new kind of check | Select the + button, then fill in the new row |
| Rename a check | Edit its DQ Check Name in the table |
| Set which data types a check fits | Edit its Valid For Types value |
| Set the default dimension for a check | Edit its Default Dimension value |
| Allow a check to be used more than once | Tick Has Multiple Instance |
| Remove a check type | Use the Delete button in the Action column and confirm |
| Apply these checks to my data | Use Define Rule instead |
Source: OnCoor Quality module product documentation, written for end users. For the latest screens and options, always refer to the in-app interface.