The following fields appear in the validation results and provide identifying information about the record with the validation error. The fields that appear on the Pre-Migration Validation page depend upon the table to which the dataset links.
|
Table |
Field |
Description |
|
Students |
ID |
The ID number generated by PowerSchool. |
|
LastFirst |
The student’s name. |
|
|
Student_Number |
The student number assigned by the school. |
|
|
SchoolID |
The School_Number of the associated Schools record. |
|
|
Teachers |
ID |
The ID number generated by PowerSchool. |
|
SchoolID |
The School_Number of the associated Schools record. |
|
|
LastFirst |
The teacher’s name. |
|
|
Teacher_Number |
The number assigned to the teacher. |
|
|
Courses |
ID |
The ID number generated by PowerSchool. |
|
Course_Number |
The course number. |
|
|
Course_Name |
The name of the course. |
|
|
Schools |
ID |
The ID number generated by PowerSchool. |
|
School_Number |
The school number for all non-district level entities. |
|
|
Name |
The name of the school. |
|
|
Log |
ID |
The ID number generated by PowerSchool. |
|
StudentID |
The internal number and ID of the associated Students record. |
|
|
Entry_Date |
The date of the log. |
|
|
Subject |
The title of the log. |
|
|
Reenrollments |
ID |
The ID number generated by PowerSchool. |
|
StudentID |
The internal number and ID of the associated Students record. |
|
|
SchoolID |
The School_Number of the associated Schools record. |
|
|
Sections |
ID |
The ID number generated by PowerSchool. |
|
Section_Number |
The number for the section. |
|
|
SchoolID |
The School_Number of the associated Schools record. |
|
|
CC |
ID |
The ID number generated by PowerSchool. |
|
StudentID |
The internal number and ID of the associated Students record. |
|
|
SectionID |
The internal number and ID of the associated Sections record. |
|
|
SchoolID |
The School_Number of the associated Schools record. |
|
|
SPEnrollments |
StudentID |
The internal number and ID of the associated Students record. |
|
ID |
The ID number generated by PowerSchool. |
|
|
Enter_Date |
The date the student enters a program. |
|
|
Exit_Date |
The date the student left the program. |
|
|
SchoolID |
The School_Number of the associated Schools record. |