Data Validation Rule Status
Using the Data Validation Rule Status page, you can view and edit existing rules, as well as add data validation rules for Students and Teachers standard and database extensions (legacy custom fields).
Certain Students and Teachers fields are pre-configured with system rules.
View Data Validation Rule Status
This page can only be accessed at the District level.
- Navigate to the Data Validation Rules page.
- Select the Rule Name to Add or Edit the Data Validation Rules.
- The Invalid Rule column is only visible if there are invalid user rules that conflict with system rules. A user rule may be considered invalid if it is less restrictive than a system rule. If the caution icon appears, the rule is invalid and requires editing.
- In the User Rules column, the system indicates if a rule is enabled or applied by the district.
- In the System Rules column, the system indicates if a rule is enabled or applied by the system (pre-configured by PowerSchool).
Add a Data Validation Rule
This page can only be accessed at the District level.
- Navigate to the Data Validation Rules page.
- Click Add.
- Choose the PowerSchool table you want to add the field to.
- Click Choose Fieldname to select a Students or Teachers field. Do not select a Students or Teachers field that has already been defined with validation rules.
- Choose the rule data type. The selected data type determines the rules that may be applied to the selected field.
Click Submit.
- Only certain rule types appear editable based on the data Type of the selected field/rule and whether a system rule already exists.
- If a system value already exists, only a more restrictive user value may be defined.
- If a system value already exists for Minimum Length, Minimum Date, or Minimum Number, the user value may not be less than the system-defined minimum.
- If a system value already exists for Maximum Length, Maximum Date, or Maximum Number, the user value may not be greater than the system-defined maximum.
Use the following table to enter a valid value for each User Value you want to edit:
Enter any characters you want to prevent users from entering in a text field, including alphabetical characters, numbers, and special characters, such as punctuation. If certain characters have already been excluded in PowerSchool by a system rule, the characters entered here are added to the list of excluded characters.
- Select Integer to indicate only numeric values may be entered as field value. This will prevent entry of decimal numbers.
- Indicate the maximum date that may be entered in this field by entering a specific date or choosing a date from By Reference which appears if you are adding/editing a maximum date rule to a Students field.
- Enter the maximum number of characters that may be entered for the Maximum Length.
- Enter the maximum numeric value that may be entered for the Maximum Number.
- Indicate the minimum date that may be entered in this field by entering a specific date or choosing a date from By Reference which appears if you are adding/editing a maximum date rule to a Students field.
- Enter the minimum numbers of characters that may be entered for the Minimum Length.
- Enter the minimum numeric value that may be entered for the Minimum Number.
Select Required to indicate a non-blank value must be entered. This checkbox may not be disabled if already set at the system level.
- Choose the appropriate text mask.
Click Submit.
If there are any data validation errors, an orange warning message appears at the top of the page indicating that the information could not be saved, each type of error encountered and the number of occurrences of each error.
Edit a Data Validation Rule
This page can only be accessed at the District level.
- Navigate to the Data Validation Rules page.
- A PowerSchool-defined system rule may not be editable. If a rule is not editable, the Edit (pencil) icon appears as shaded. When clicked, information is read-only.
- Click the Rule Name you want to edit. T
If a PowerSchool-defined system rule is not editable, a Lock (padlock) icon appears next to the Rule Name. - Enter a valid value for each User Value you want to edit.
- Click Submit.
If there are any data validation errors, an orange warning message appears at the top of the page indicating that the information could not be saved, each type of error encountered and the number of occurrences of each error.
Delete a Data Validation Rule
This page can only be accessed at the District level.
- Navigate to the Data Validation Rules page.
- A PowerSchool-defined system rule may not be editable. If a rule is not editable, the Edit (pencil) icon appears as shaded. When clicked, information is read-only.
- Click the Rule Name you want to delete.
If a PowerSchool-defined system rule is not editable, a Lock (padlock) icon appears next to the Rule Name. - Click Delete.
The Delete button does not display for fields associated with a system rule. - Click Confirm Delete.