Validation Rules

Tool Search: Validation Rules

The Validation Rules tool is used to create and manage rules used within Validation Groups and report data within the Data Validation Report. Validation Rules, which operate based on the chosen end year and calendar, are reusable queries used for filtering and reporting specific data. These rules are grouped together in Validation Groups which are used to report data for each rule in the group within the same report.

Tool Access

Full Access is available to State Editions and District Editions that have purchased the Campus Data Suite. Restricted Access is available to all other District Editions.

Restricted Access

By default, all District Edition customers have full access to the Data Validation Report but restricted access to the following Data Validation admin tools:

  • Stored Procedure Setup
  • Validation Rules
  • Validation Groups

Customers with restricted access are only able to tag Validation Rules and assign Tool Right User Groups to Validation Groups, the latter of which controls Validation Group availability for reporting in the Data Validation Report editor. Validation Rules and Validation Groups will only be available directly from Infinite Campus or State Edition via DIS publishing.

Full Access

Full access to the Data Validation admin tools, which allows for local indexing of Stored Procedures and creation/maintenance of Validation Rules and Groups, is available through Campus Data Suite.

Full access is limited to Data Validation admin tool items created in the local database. For example, District Edition customers have full access to District-owned Validation Rules created locally but restricted access to System-owned Validation Rules delivered by Infinite Campus.

Screenshot of validation rules.Path: Data Integrity > Data Validation > Validation Rules

Tool Rights 

The following table describes how tool rights work with the Definition Rules tool. 

Screenshot of validation rules tool rights

ToolRWAD
Validation RulesUsers can view existing Rules and preview results.Users can view and modify existing Rules as well as preview results.Users can view, modify and create Rules as well as preview results.Users can view, modify and create Rules as well as preview results.

Preloaded Validation Rules

Five rules are included in the base/non-paid version of Validation Rules:

  • Active students not in a household
  • Households with more than 1 primary mailing address
  • Students who have no birth date
  • Students who have the same student number
  • Transcripts with no GPA value

Screenshot of the five preloaded validation rules

Creating a New Validation Rule

Users can create Validation Rules which filter and report data based on Ad hoc filters, Direct SQL, or Stored Procedures. These rules are then put into Validation Groups which are used to report subsets of data within a single Data Validation Report.

District Edition Users: Rules created at the district level are maintained and reported only within the district which created the rule. 

State Edition Users: Rules created at the state level are maintained by the state. These Rules are not published down to districts however, definitions created at the state which are included within published validation groups are published down within the validation group and are read-only in the district-level Validation Group tool.

If a definition is created which contains fields or data not available at the district level, any definition groups which include this definition will not be allowed to be published down to districts.

When publishing a Validation Rule from State Edition to District Edition, logic looks to see if the Validation Group and Validation Rule exist. If these do not exist, they are inserted. If they already exist and there are changes, they are updated as long as the district-owned Validation Rule and Group do not have the same name as a state-owned Validation Rule and Group.

Screenshot of validation rule detail editor

Validation Rule Detail Editor

FieldDescription
NameThe Name of the Validation Rule. The Name cannot match the the Name of an existing Rule from the same owner.
ArchivedIf marked, the Rule cannot be added to a Validation Group. This does not affect Validation Groups previously set up.
DescriptionUser-defined description. This description displays in the Validation Group Detail editor.
BaselineAllows the user to select an existing Validation Rule to run the current Validation Rule against. The results of the Baseline Rule will be reported in the Total column of the report; it will also affect the Rate column which is calculated by dividing the current Validation Rule by the Baseline Rule.
SourceAd Hoc
  • Allows the user to select an Ad Hoc filter for the Rule.
    • Only Student based Ad Hoc filters are allowed.
  • If the Ad Hoc filter is not published, the Rule will be flagged as State Edition Only.
  • State Edition Only Rules will block Validation Groups from being Published to District Editions.
Direct SQL
  • Allows the user to create a Rule based on Direct SQL.
  • The Direct SQL option is limited to SELECT statements only. Complex SELECT statements are supported.
  • The following SQL Parameters may be added to the Direct SQL textbox. These parameters are sensitive to the selections in the Campus Toolbar:
    • District
    • Year
    • School
    • Calendar
Stored Procedure
  • Allows the user to select a Stored Procedure for the Rule.
  • The user is allowed to define how parameters from the Stored Procedure ought to behave.
TagsAllows the user to create or select tags. Tags make searching for Rules easier.
Save & StayThe rule is saved and the user stays on the current page.
CancelReturns the user to the Validation Rules Master page. The Rule is not saved.
DeleteDeletes the Validation Rule Detail and returns the user to the Validation Rules Master.
PreviewGenerates a real-time HTML report of the Validation Rule.
PublishPushes the Rule to all District Editions linked via DIS.
For State Editions only.

Create a Validation Rule via Ad Hoc Filter

Validation Rules can be created using an Ad hoc filter as the source of identifying which data to report within the rule.

Ad Hoc Filters need to be published or else they will be State Edition Only.

Screenshot of a published validation rule

To create a new Validation Rule:

  1. Click New.
  2. Enter the Name of the definition.
  3. Enter a Description of the definition. This appears when viewing the definition within the Validation Rules and Validation Group tools.
  4. Select a Baseline rule if desired.
  5. Select a Source of Ad Hoc.
  6. Select an Ad Hoc Filter. This filter will determine which data is pulled within the definition and reported within validation group. Ad hoc filters are created within the Filter Designer tool.
  7. Enter any Tags (optional). Tags are used to easier search for and identify related definitions when creating Validation Groups.
  8. A Preview of the Rule can be viewed by selecting Preview.
  9. Select the Save & Stay. The definition is now saved within Campus and can now be used within Validation Groups.

Once the rule has been created it can be used within Validation Groups. Once the rule has been added to a Validation Group, data for the Validation Group can be reported via the Data Validation Report.

Create a Validation Rule via Direct SQL

Validation Rules can also be created using direct SQL as the source of identifying which data to report within the rule. 

  • Users can only do SELECT statements (update, insert, delete, drop, stored procedures, SQL injections, cursors, etc are not supported).
  • SELECT * is not supported at this time. Users must select specific fields they wish to report.
  • Column aliases are supported (e.g., SELECT scaleScore as Score).
  • This functionality is intended for users who are familiar with Campus schema and proficient in SQL.

Screenshot of a new Validation Rule using Direct SQL

To create a new Validation Rule using Direct SQL:

  1. Select New.
  2. Enter the Name of the rule
  3. Enter a Description of the rule. This appears when viewing the definition within the Validation Rules and Validation Group tools.
  4. Select a Baseline Rule if necessary (optional).
  5. Select a Source of Direct SQL.
  6. Enter SQL Query. If the SQL contains unsupported parameters you will be prevented from saving the rule.
  7. Select the District button to add the reporting district within the rule (optional).
  8. Select the Year button to add the reporting year within the rule (optional).
  9. Select the School button to add the reporting school within the rule (optional).
  10. Select the Calendar button to add the reporting calendar within the rule (optional).
  11. Enter any Tags (optional). Tags are used to easily search for and identify related definitions when creating Validation Groups.
  12. A Preview of the Rule can be generated is desired.
  13. Select the Save + Stay. The definition is now saved within Campus and can now be used within Validation Groups.

A timeout function is included which aborts the query if it ever surpasses the database timeout limit, which can be manually set for each individual site/database.

Create a Validation Rule via Stored Procedure

Validation Rules can also be created using a previously created Stored Procedure. 

Screenshot of a a new Validation Rule using a Stored Procedure

To create a new Validation Rule using a Stored Procedure:

  1. Select New.
  2. Enter the Name of the rule
  3. Enter a Description of the rule. This appears when viewing the definition within the Validation Rules and Validation Group tools.
  4. Select a Baseline Rule if necessary (optional).
  5. Select a Source of Stored Procedure.
  6. Select the Procedure that is being used for the Rule.
  7. Enter the parameters that will be used for the Stored Procedure.
  8. Enter any Tags (optional). Tags are used to easily search for and identify related rules when creating Validation Groups.
  9. A Preview of the Rule can be generated is desired.
  10. Select the Save + Stay. The Rule is now saved within Campus and displays within the Validation Groups editor.

Publishing Validation Rules (State Edition Only)

State Edition users can publish validation rules down to all DIS-link districts.

To publish a validation group, select the group from the Data Validation Groups Editor and select Publish. A pop-up message will appear, confirming the publishing action.

Once the Validation Rule has been published down to districts, it will be available for use within the Validation Groups tool.

Screenshot of validation group detail tool

Searching for Existing Validation Rules

Existing rules can be searched for and found by name, tag, Published, owner, and status.

Screenshot of validation rules

FieldDescription
NameAllows users to search for existing rules based on the name of the rule.
 Tag

Allows users to search for rules based on tags entered on definitions.

For example, if you have tagged all EL-related rules as EL, searching for a tag of EL will display search results for all rules with that tag.

Published

Allows users to search for existing rules based on the status of the rule.

Published - Validation Rules that have been published by the state appear in search results.

Unpublished Changes - Validation Rules that have been edited but not published appear in search results.

Not Published - Validation Rules that have not been published appear in search results.

Published Failed - Validation Rules which did not publish correctly appear in the search results.

Unknown - Status of the Validation Rule is not known.

Owner

Allows users to search for existing rules based on the owner of the rule. Options are State, District, or System.

Status

Allows users to search for existing rules based on the status of the rule.

Active - Only Active rules appear in search results.

Archived - Only Archived rules appear in search results.

Next Steps

Once Validation Rules have been created, users should: