Level Data is a simple plug-in that ensures the cleanliness and accuracy of district data. The suite validates data in real-time, flagging any errors or inconsistencies that may exist before they ever enter your system for state data reporting. This lesson provides the Business Rules for the Level Data export Zap.
Before you Begin
Need a refresher on installing a Zap? Visit to Pre-Built Export Zaps learn more.
Business Rules
Students
The output will be in double-quoted CSV format with the header included.
Filters available are School Type, School, and Grade.
Students who were enrolled at any point during the school year will be pulled, and the filters will be applied to their school and grade enrollment records.
If a student is marked as pre-registered and currently has an open grade enrollment record, their last closed grade enrollment record during the current school year will be checked. If the student has no such closed grade enrollment record or has been transferred out with the pre-registered flag still on, the student will be ignored.
| Field | Logic |
|---|---|
| StudentID | Student's ID number |
| FirstName | Student's first name |
| LastName | Student's last name with all commas removed |
| Password | Left blank |
| SchoolName | Student's current school or last closed enrolled school of the current school year |
| GradeLevel | Student's current grade or last closed enrolled grade of the current school year. Grade levels are restricted to PK, K and 1-12 in this export, so the following grade levels will be converted: 1. Grades PK, K, 1 - 12: Export as is 2. NY-specific grades 2a. GED, UGS: Export as 12 2b. UG: Export as 7 2c. KA, KH, KP: Export as K 2d. PKA, PKF, PKH, PKP, PP, PS, PS2: Export as PK 3. PA-specific grades 3a. AAP, SUG: Export as 12 3b. EUG: Export as 7 3c. K4A, K4P, K4F, K5A, K5F, K5P: Export as K 3d. PKA, PKF, PKP, PS, PSA, PSP, K3A, K3F, K3P: Export as PK |
| WithdrawDate | Left blank if student is currently in the building, or the student's last grade enrollment end date of the current school year if student is not actively enrolled |
| EnrollStatus | "Y" if the student's last grade enrollment of the current year is active or has ended in June and is not pre-registered, else "N". This takes the Zap filters into account, so if a student was previously enrolled in an allowed school and grade and is currently enrolled in an ignored school or grade, this will display "N". |
| AUP | Left blank |
| Username | Left blank |
| Homeroom | Student's current homeroom |
| Middlename | Student's middle name |
| Wildcard | NY districts: BEDS code of the student's current school or last enrolled school of the current school year PA districts: PDE Location Code of the student's current school or last enrolled school of the current school year |
| Wildcard2 | Left blank |
| Wildcard3 | Left blank |
| Wildcard4 | Left blank |
| Wildcard5 | Left blank |