Data Validation

On this page:

PowerSchool now provides data validation to promote data integrity by preventing invalid data from being entered or imported into PowerSchool. Data validation is automatically enabled and appears throughout PowerSchool for certain Students and Teachers fields. For a detailed list of fields, refer to the Appendix.

Localized versions of PowerSchool support data validation. All dates, numbers, text, and messaging appear in the localized format and all data is validated against applicable rules.

State-specific pages are currently not validated using this new validation capability. Validation of state-specific pages will be implemented in a future version and deployed on a state-by-state basis.

Data Types

PowerSchool supports validation for the following data types:

Date
Number
Text

Rules

PowerSchool supports the following data validation rules:

Rule	Description	Data Type
Exclude Characters	Enter any characters you want to prevent users from entering in a text field, including alphabetical characters, numbers, and special characters, such as punctuation. The field level data validation error message remains until a valid field entry is made. 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. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Text
Integer	Only numeric values may be entered as field value.	Number
Maximum Date	The field value entered must be less than or equal to the maximum date. If a user attempts to enter a field value greater than the maximum field value allowed, a field level data validation error message appears. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Date
Maximum Length	The length of characters entered in a field must be less than or equal to the maximum length. If a user attempts to enter more characters than allowed, the user is prohibited from entering additional characters.	NumberText
Maximum Value	The field value entered must be less than or equal to the maximum value. If a user attempts to enter a field value greater than the maximum field value allowed, a field level data validation error message appears. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Number
Minimum Date	The field value entered must be greater than or equal to the minimum date. If a user attempts to enter a field value less than the minimum field value allowed, a field level data validation error message appears. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Date
Minimum Length	The length of characters entered in a field must be greater than or equal to the minimum length. A user cannot enter a field value less than the minimum length. If the user exits a field without entering the minimum length, a field level data validation error message appears. The field level data validation error message remains until the minimum length is entered. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	NumberText
Minimum Value	The field value entered must be greater than or equal to the minimum value. If a user attempts to enter a field value less than the minimum field value allowed, a field level data validation error message appears. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Number
Required	A field value must be entered. The field value cannot be whitespace, such as tabs or spaces. An asterisk appears to the right of the field. If the user exits a required field without entering a value, a field level data validation error message appears. The field level data validation error message remains until a valid field entry is made. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	DateNumberText
Text Mask	A field value must be entered in the user-defined format. The field level data validation error message remains until a valid field entry is made. If the user attempts to submit the page without correcting the error, a page level data validation error message appears. For more information, refer to Page Submission.	Text

Rules by Data Type

Date

The following table outlines the data validation rules and error messaging for date:

Rule	Description	Error Message
Date Type	The date value entered must be valid.	Not a valid date
Maximum Date	The date value entered must be less than or equal to the maximum value.	Date must be on or before [date]
Minimum Date	The date value entered must be greater than or equal to the minimum value.	Date must be on or after [date]
Required	A field value must be entered. The field value cannot be whitespace, such as tabs or spaces.	Missing required field

Number

The following table outlines the data validation rules and error messaging for number:

Rule	Description	Error Message
Integer	Only numeric values may be entered as field value.	Number must be an integer, containing only numeric characters
Maximum Length	The length of characters entered in a field must be less than or equal to the maximum length.	Number cannot be greater than [#] digits in length
Maximum Value	The field value entered must be less than or equal to the maximum value.	Number cannot be greater than [#]
Minimum Length	The length of characters entered in a field must be greater than or equal to the minimum length.	Number cannot be less than [#] digits in length
Minimum Value	The field value entered must be greater than or equal to the minimum value.	Number cannot be less than [#]
Number Type	The numeric value entered must be valid.	Not a valid number
Required	A field value must be entered. The field value cannot be whitespace, such as tabs or spaces.	Missing required field

Text

The following table outlines the data validation rules and error messaging for text:

Rule	Description	Error Message
Exclude Characters	Characters marked for exclusion may not be entered in a text field.	Text must not contain characters !@#$%'^&*()<>"
Maximum Length	The length of characters entered in a field must be less than or equal to the maximum length.	Text cannot be greater than [#] digits in length
Minimum Length	The length of characters entered in a field must be greater than or equal to the minimum length.	Text cannot be less than [#] digits in length
Required	A field value must be entered. The field value cannot be whitespace, such as tabs or spaces.	Missing required field
Text Mask	A field value must be entered in the user-defined format.	Entries must be unique Set Name cannot start with 'Pearson_ Set Name cannot contain the characters: < > ‘ or ”

Icon Legend

For PowerSchool pages that include the following field icons, a legend appears of the bottom of page indicating each icon used and its meanings. The legend only contains references for validation items on the page. If the page contains no validation items, the legend does not appear.

Icon	Description
*	Required Field
	Date Entry
	Time Entry
	Time Entry (5 minute interval)
	Time Entry (15 minute interval)
	Time Entry (30 minute interval)
	Time Entry (hour only interval)