Acadience Learning Online (ALO) is a digital platform that allows assessors to administer the Acadience assessment measures online and provides immediate results through its dashboard so educators can take action with their data. This lesson provides the Business Rules for the Acadience Learning Online export Zap.
Before you Begin
Need a refresher on installing a Zap? Visit to Pre-Built Export Zaps learn more.
Business Rules
Manifest
This export has 7 outputs. This is 1 of 7 outputs.
This file will be exported with a header row in a regular CSV format (no "double-quotes")
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
Manifest.csv
This file does not pull data from any tables, it only outputs one record as per below:
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| Property Name | Required | Should list “Version” | List "Version" |
| Value | Required | Should be set to “1.0”. | List "1.0" |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments), multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Schools
This export has 7 outputs. This is 2 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
Schools.csv
All the filtered schools will be included in this export.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique identifier of the school. This ID will be referenced in other import files and must be consistent across imports. | Primary key of the school |
| NCES ID | Optional, unique, numeric | National Center for Education Statistics (NCES) identifier for this school. | NCES value of the school if entered in the front-end - District > Schools > School Information |
| Name | Required, unique, alphanumeric | Name of the school | Name of the school - District > Schools > School Information |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Classes
This export has 7 outputs. This is 3 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
Classes.csv
All classes according to the filtered school, school type, and/or subject will be included in this export.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique identifier of the class. This ID will be referenced in other import files and must be consistent across imports. | Primary key of the class meeting time |
| School ID | Required, alphanumeric | ID of the school containing this class. This must match the ID of a school in the Schools.csv import file. | Primary key of the school the class is in, will match to "ID" of the Schools.csv file |
| Name | Required, alphanumeric | Name of the class Class names must be unique within a school, although they may be duplicated in other schools within the district. |
Data will be provided in the following format, otherwise it won't be unique within a school: "(School's School Code (District > Schools > School Information)) (Course Name) Sect:(Section Number) Days:(Day Pattern) Per:(From Period)-(To Period) (If a teacher is associated, "Teach: (teacher's primary key)") (Primary key of the class meeting time)" Example: "003 2nd Grade Art Sect:123 Days:H Per:6-6 Teach:Smith, John (12345)" |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Students
This export has 7 outputs. This is 4 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
Students.csv
Students with the filtered school, school type and grades will be included in the export. If a subject filter is provided, students will be additionally filtered for students enrolled in courses with the subject filter.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique identifier of the student. This ID will be referenced in other import files and must be consistent across imports. | Student's assigned ID number |
| Primary ID | Required, unique, alphanumeric | Student’s unique Primary ID, usually a district-issued ID. | Student's assigned ID number |
| Secondary ID | Optional, unique, alphanumeric | Secondary ID for a student, sometimes a state-issued ID or other ID that is different from the student’s Primary ID. | Student's state ID number if available |
| Last Name | Required, alphanumeric | The student’s last name | Student's last name |
| First Name | Required, alphanumeric | The student’s first name | Student's first name |
| Nickname | Optional, alphanumeric | A nickname for the student, useful to distinguish students who have the same name | Student's nickname if available |
| Optional, unique, valid email | The student’s email address | Student's email address if available | |
| DOB | Required, date | The student’s date of birth, formatted mm/dd/yyyy | Student's date of birth in MM/DD/YYYY format |
| Grade Level | Required, alphanumeric | The current grade level in which the student is enrolled. Must be K or 1-6. | Student's current grade level. If the student's current grade level starts with "K" (such as "KA" and "K5A"), "K" will be pulled instead. |
| Teacher ID | Optional, alphanumeric | The ID of the student’s teacher of record. If included, this value must match the ID of a teacher in the Staff.csv import file. | Primary key of the student's assigned homeroom teacher if available |
| Gender | Optional, alphanumeric | Allowed values: ● Female ● Male ● Nonbinary |
Pull student's identified gender if available ("X" in eSD will be listed as "Nonbinary" in this file), else pull student's birth gender. |
| Race/Ethnicity | Optional, alphanumeric | Allowed values: ● American Indian/Alaskan Native ● Asian ● Black or African-American ● Hispanic or Latino ● Native Hawaiian/Pacific Islander ● White non-Hispanic ● Two or more races |
Pull "Hispanic or Latino" if the student has Hispanic Indicator checked yes. If Hispanic Indicator is not checked yes, pull the following as per the assigned race: American Indian/Alaska Native: List "American Indian/Alaskan Native" Asian: List "Asian" Black/African American: List "Black or African-American" Native Hawaiian/Other Pacific Islander: List "Native Hawaiian/Pacific Islander" White: List "White non-Hispanic" Multiracial: List "Two or more races" |
| ELL Status | Optional, alphanumeric | Allowed values: ● English Speaking/Fluent English Proficient ● ELL/LEP |
Pull "ELL/LEP" if student has an open 0231 status, else pull "English Speaking/Fluent English Proficient" |
| Section 504 | Optional, alphanumeric | Allowed values: ● Yes ● No |
Pull "Yes" if student has an open 0264 status, else pull "No" |
| Special Education | Optional, alphanumeric | Allowed values: ● Yes ● No |
Pull "Yes" if student has an open SE status or would have a value provided in the "Special Education Category" column, else pull "No" |
| Special Education Category | Optional, alphanumeric | Allowed values: ● Autism ● Developmental Delay ● Deaf-Blindness ● Emotional Disturbance ● Hearing Impairment ● Intellectual Disability ● Multiple Disabilities ● Orthopedic Impairment ● Other Health Impairment ● Specific Learning Disability ● Speech or Language Impairment ● Traumatic Brain Injury ● Visual Impairment Including Blindness |
Pull value for one of the following open statuses: 0352 (Autism) - "Autism" 0407 (Deaf) - "Other Health Impairment" (No value for specifically "Deaf" exists in the specs) 0484 (Deaf-Blindness) - "Deaf-Blindness" 0363 (Emotional Disturbance) - "Emotional Disturbance" 0418 (Hearing Impairment) - "Hearing Impairment" 0396 (Intellectual Disability) - "Intellectual Disability" 0385 (Learning Disability) - "Specific Learning Disability" 0473 (Multiple Disabilities) - "Multiple Disabilities" 0451 (Orthopedic Impairment) - "Orthopedic Impairment" 0462 (Other Health Impairment) - "Other Health Impairment" 0429 (Speech or Language Impairment) - "Speech or Language Impairment" 0495 (Traumatic Brain Injury) - "Traumatic Brain Injury" 0440 (Visual Impairment) - "Visual Impairment Including Blindness" "Developmental Delay" will be left unused since there is no appropriate special education status to match it to If a student has more than one applicable open status, "Multiple Disabilities" will be pulled |
| Title 1 Reading | Optional, alphanumeric | Allowed values: ● Yes ● No |
Pull "Yes" if student has an open 0803 status, else pull "No" |
| Title 1 Math | Optional, alphanumeric | Allowed values: ● Yes ● No |
Pull "Yes" if student has an open 0814 status, else pull "No" |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Staff
This export has 7 outputs. This is 5 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
Staff.csv
All staff according to the filtered school and school type will be included in this export.
If a subject filter is provided, staff will be additionally filtered for staff enrolled in courses with the subject filter. The subject filter will not be applied to "Administrator" staff.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique identifier of the staff member. This ID will be referenced in other import files and must be consistent across imports. | If the staff record is tied to an account with a cross-building assignment, pull the primary key of the staff record tied to the primary account. Else, pull the primary key of the staff record as is. |
| Primary ID | Required, unique, alphanumeric | The staff member’s Primary ID, usually a district-issued ID. | If the staff record is tied to an account with a cross-building assignment, pull the primary key of the staff record tied to the primary account. Else, pull the primary key of the staff record as is. |
| Secondary ID | Optional, unique, alphanumeric | Secondary ID for a staff member, sometimes a state-issued ID or other ID that is different from the staff member’s Primary ID. | If the staff record is tied to an account with a cross-building assignment, pull the assigned state ID number of the staff record tied to the primary account if available. Else, pull the assigned state ID number of the staff record as is if available. |
| Last Name | Required, alphanumeric | Last name of the staff member | If the staff record is tied to an account with a cross-building assignment, pull the last name of the staff record tied to the primary account. Else, pull the assigned state ID number of the staff record as is. |
| First Name | Required, alphanumeric | First name of the staff member | If the staff record is tied to an account with a cross-building assignment, pull the first name of the staff record tied to the primary account. Else, pull the assigned state ID number of the staff record as is. |
| Nickname | Optional, alphanumeric | Nickname for the staff member, useful to distinguish staff members who have the same name. | Leave blank |
| Required, unique, valid email | Email address for the staff member. This will also be used for logging in. | If the staff record is tied to an account with a cross-building assignment, pull the email of the staff record tied to the primary account if available. Else, pull the email of the staff record as is if available. | |
| Job Title | Optional, alphanumeric | The staff member’s job title. This is for display only, it will not be used to assign permissions. | Leave blank |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Student Enrollments
This export has 7 outputs. This is 6 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
StudentEnrollment.csv
All students according to the filtered school, school type, and/or grade level will be included in this export.
All classes according to the filtered school, school type, and/or subject will be included in this export.
Only current class enrollments will be included in the export.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique ID for this enrollment record, not linked to any other files or prior imports (can be ascending numbers) | Primary key of the student's class enrollment, followed by a dash, and then followed by the primary key of the class meeting time tied to the class. Example: "12345-223344" |
| Student ID | Required, unique, alphanumeric | ID of the user referenced by this enrollment record. This must match an ID value in either the Students.csv or Staff.csv file. NOTE: This is not the student’s primary or secondary ID, it is the field called ID in the Students.csv file. |
Student's ID number, which matches to the "ID" in the Students.csv export. |
| Class ID | Required, unique, alphanumeric | ID of the class referenced by this enrollment record. This must match the ID of a class in the Classes.csv file. You may include multiple rows for a student in this file, each with a different Class ID, in order to enroll a student in multiple classes. |
Primary key of the class meeting time tied to the class. |
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.
Staff Enrollments
This export has 7 outputs. This is 7 of 7 outputs.
This file will be exported with a header row in a double-quoted CSV format.
Only students with grade levels K through 6 will be pulled. Grade levels KA, KP, KH, K3F, K3A, K3P, K4A, K4P, K4F, K5A, K5P and K5F will be considered to be grade level K.
StaffEnrollments.csv
All staff according to the filtered school and school type will be included in this export.
Staff records with the "Administrator" staff type in eSD will be included with the "Administrator" role. The subject filter will not be applicable to "Administrator" staff.
Staff records with a staff type having the word "Teacher" and staff records tied to a class for the source year in eSD will be included with the "Teacher" role. If a subject filter is applied, only teachers tied to a class will be included.
All other staff records who do not fit the above two criteria will have the "Data Viewer" role. If a subject filter is applied, no "Data Viewer" records will be included.
| Column Name | Constraints | Description | eSD Business Rules |
|---|---|---|---|
| ID | Required, unique, alphanumeric | Unique ID for this enrollment record, not linked to any other files or prior imports (can be ascending numbers) | Two values will be included separated by a dash to make this field unique: 1. If the staff record is tied to an account with a cross-building assignment, pull the primary key of the staff record tied to the primary account. Else, pull the primary key of the staff record as is. 2. If the record is derived from a staff's association to a class and the zap is not set up to leave the School ID and Class ID fields blank, the class meeting time the staff is tied to is pulled. Otherwise, pull nothing else and have just the staff's primary key in this field. |
| Staff ID | Required, alphanumeric | ID of the staff member referenced by this enrollment record. This must match an ID value in the Staff.csv file. NOTE: This is not the staff member’s primary or secondary ID, it is the field called ID in the Staff.csv file. You may include multiple rows for a staff member in this file. For example, you may enroll a staff member in any combination of classes, schools, and at the district level, each with its own set of permissions determined by the value specified in the Role field. However, you can only enroll a staff member in a particular class, school, or district a single time. | If the staff record is tied to an account with a cross-building assignment, pull the primary key of the staff record tied to the primary account. Else, pull the primary key of the staff record as is. |
| School ID | Optional, alphanumeric | ID of the school referenced by this enrollment record. If present, this must match the ID of a school in the Schools.csv file. | Pull the course's school primary key only if the zap is not set up to leave this field blank, which will match to the IDs in the Schools.csv file. |
| Class ID | Optional, alphanumeric | ID of the class referenced by this enrollment record. If present, this must match the ID of a class in the Classes.csv file. | Pull the class meeting time primary key only if the zap is not set up to leave this field blank, which will match to the IDs in the Classes.csv file. |
| Role | Required, alphanumeric | Role is used to assign this staff member certain permissions to the specified class, school, or district. Allowed values: Assessor, Teacher, Administrator, Data Viewer, Data Manager. User permissions are granted as follows: Assessor: assess students Teacher: assess students, view assessment data Administrator: assess students, view assessment data, manage rosters (not applicable for classes) Data Viewer: view assessment data Data Manager: view assessment data, manage rosters (not applicable for classes) | If the staff record is tied to an account with a cross-building assignment, the related information will be pulled from the staff record tied to the primary user account, else pull from the staff record itself. If the staff has an "Administrator" staff type, "Administrator" will be pulled. If the staff is tied to a class or the staff has a staff type with the word "Teacher" in it, "Teacher" will be pulled. For all other staff, pull "Data Viewer". The same staff can have an "Administrator" record without a class associated and then "Teacher" records associated to classes that the staff teaches. |
| Additional description for School ID and Class ID | School ID and Class ID are used to assign a staff member permissions to either a specific class, school, or the entire district, as follows: To assign permissions at the district level, leave both School ID and Class ID empty. To assign permissions at the school level, specify the School ID and leave Class ID empty. To assign permissions to a specific class, specify the Class ID. If both School ID and Class ID contain non-empty values, School ID will be ignored and permissions will be assigned at the class level. Use multiple entries in this file to assign a staff member permissions for any combination of classes, schools, and the district. Different permissions (roles) may be used for each entry. |
||
Please note that...
- when setting up the zap, there will be an option for including or excluding School ID and Class ID from the StaffEnrollments.csv.
- if a staff does not have a valid email, all corresponding records to that staff will be ignored and not sent out in the output.
- if the same staff exists in multiple buildings and they are not linked (cross-building assignments),
multiple records will be sent for each building, invalidating the uniqueness rules set by the Acadience system. This cannot be corrected in any code-base and has to be physically corrected in eSD as this would be a data issue.