Skip to main content
Skip table of contents

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, see 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.

Note: 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, see 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, see 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, see 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, see 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, see 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, see 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, see 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, see 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)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.