Data Validation Settings
PowerSchool can validate data when submitting date and alphabetical field values. Data validation ensures that the day, month, and year for a date field is within a valid range and that an alphabetical field does not contain characters with ASCII codes between and including 1 and 31. If an invalid date is entered, PowerSchool sets the date to 00/00/00. If an invalid character in an alphabetical field is entered, PowerSchool deletes that character.
Note: In addition to enabling basic date validation, PowerSchool also recommends configuring field-specific data validation rules using Data Validation Configuration.
Set Up Data Validation
- On the start page, choose System under Setup in the main menu.
- Under Server, click System Settings.
- Click Data Validation.
Use the following table to enter information in the fields:
Field
Description
Data Validation Disabled
Select the checkbox to disable data validation.
Send Messages to Log Window
Select the checkbox to send information regarding invalid values to the server log window.
Year: Lower Limit
Enter the lower limit for the years considered to be valid. The default value is 1930.
Note: If you set the lower limit to a value greater than 2000 or less than 0, the default value 1930 is used for the lower limit.
- Click Submit.