Previous Topic

Next Topic

Book Contents

Book Index

Adding Your Own Data Validation Checks

Purpose

Use this procedure to configure checks in addition to the default set of checks provided. You can associate a new check with any existing category, which defines when the check is executed.

Procedure

  1. Choose Tools > Code File Maintenance > General > Data Validation Checks.

    The Data Validation Checks Maintenance dialog box is displayed.

  2. Click Add and type the code name for your data validation check.
  3. Select the view that the system will use to populate the results.

    Note Your view must be on the database so that you can select it from the drop-down list. Further, the view must return a specific schema as specified below.

    View Schema

    Field ID

    Requirements

    check_cd

    15 character string; this code must match the code entered in the dialog when creating the check

    entity_id

    integer, not required, should be the entity_id of the entity related to this check or 0 if not applicable to the view

    ic_ref_id

    integer, not required, should be 0, unless joining to export-related information, in which case it should be the export dataset_id

    owner_id

    integer, not required, should be the owner_id of the owner related to this check or 0 if not applicable to the view

    prop_id

    integer, required, associated with the property's prop_id

    sup_num

    integer, required, associated with sup_num

    year

    integer, required, associated with prop_val_yr

  4. Enter a description for the check.

    Note The window for the Batch History activity (Activities > Data Validation Checks > Batch History) displays the description you enter in this step.

  5. Select the rating that specifies the severity of errors resulting from the check.
  6. To activate the check for use, select Use Check.
  7. Click OK to save the check and add it to the appropriate category.

    Caution Caution Icon If you do not perform the next step, the system does not save any of your entries for the new data validation check.

  8. Click Generate View to generate the category view with the new check incorporated.

Additional Information

A rating reflects the severity of an error. If a check is assigned a rating of Critical and errors result from the check, the system prevents both the appraisal export and supplement acceptance process from continuing. Checks assigned a rating of High, Medium, or Low do not cause the system to cancel the export.