Adding a check constraint to a domain

  1. Select System > Agency Personalization > Schema Manager.
  2. Click the Domains node below the Infor Product Families tree.
  3. Enable editing in the grid and select the domain that you want to add a check constraint to.
  4. Enable editing in the Check Constraints grid at the bottom of the Edit Domain dialog box and click Add.
  5. In the Name field, type a name for the check constraint.
  6. In the Common ID field, type an identification code for the check constraint.
    You will use this common ID throughout Infor Public Sector to identify this check constraint.
  7. Type the statement in SQL that defines the check constraint in the Statement field.
  8. Type a description of the check constraint in the Description field.
  9. Click Save.
    Infor Public Sector assigns a key value to the check constraint and adds the check constraint to the domain. The new check constraint is displayed in the Check Constraints grid. Note that changing or deleting an existing check constraint will cause errors wherever it has already been used. If you change or delete a check constraint, you must update any references to it throughout your system.
  10. When you're finished adding check constraints to this domain, click Save.