This Data Schema document provides a list of useful fields in each worksheet to reference by field name (or by the defined Synonym) as you are developing queries.
Assessment Worksheet
Student ID
Student IEP Status
Student Current Grade
Completion Date
Student First Name
Student Gifted Status
Status504
Overall Scale Score
Student Last Name
Student ELL Status
Academic Year
Overall Placement
Gender
Student School Name
Start Date
Overall Relative Placement
Attendance Worksheet
Student ID
IEP Status
Grade
Absence Category
First Name
Gifted Status
504 Status
Missed Hours (Time Missed)
Last Name
ELL Status (English Language Learner Status)
Absence Date (Attendance Date)
Gender
School Name
Absence Code (Attendance Code)
Behavior Worksheet
Student ID
IEP Status
Grade
Violation Code
Incident School Code
First Name
Gifted Status
504 Status
Action Code (Action Type)
Owner Name
Last Name
ELL Status
Behavior Date (Incident Date)
Action Total Days
Offense Code
Gender
School Name
Referring Staff
Total Days
Enrollment Worksheet
Student ID
Current IEP Status
Current Grade (Grade Level)
Current Enrolled School Code (Building Code)
Student First Name
Current Gifted Status
Current 504 Status (504)
Social Studies Assessment
Student Last Name
Current English Learner Status (English Language Learner Status)