Table Specific Metadata Fields
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. |