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:
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.