The STAR Renaissance Zap includes student, staff, section, roster, demographic, and status data so that districts can easily provision accounts and classes within the Renaissance family of products. The Zap can be configured to extract this information on a scheduled basis, ensuring that your data remains synchronized between the two products.
Business Rules
School File
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 1/11)School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
SchoolFile.csv
| Field Name | Business Rules |
|---|---|
| UniqueSchoolNumber | School code of buildings with an additional default record "DISTRICT" |
| FullSchoolName | Building names with an additional default record of the district name |
| LowestGrade | For school records besides Central Office, send lowest grade being used in school itself in the range of K-12. For district and Central Office record, send lowest grade used throughout the schools being exported. Do not send UG, UGS, EUG and SUG for this field. Grades K4F, K4A, K4P, K5F, K5A, K5P, KA, KH, KP will export as "K" Grades PKA, PKP, PKF, PK, PKH, PS, PSA, PSP, PA, PS, PS2, PP will export as "Pre-K" All other grades will export as is |
| HighestGrade | For school records besides Central Office, send highest grade being used in school itself in the range of K-12. For district and Central Office record, send highest grade used throughout the schools being exported. Do not send UG, UGS, EUG and SUG for this field. Grades K4F, K4A, K4P, K5F, K5A, K5P, KA, KH, KP will export as "K" Grades PKA, PKP, PKF, PK, PKH, PS, PSA, PSP, PA, PS, PS2, PP will export as "Pre-K" All other grades will export as is |
| StateSchoolNumber | For school records, use BEDS field from record itself. For district record, derive BEDS field from Central Office record. |
| Address1 | Send in street number and street name in format "StreetNumber StreetName" from school records and additional default record from Central Office. |
| City | For school records, use CITY field from record itself. For district record, derive CITY field from Central Office record. |
| State | For school records, use STAT field from record itself. For district record, derive STAT field from Central Office record. |
| Zip | For school records, use ZIP field from record itself. For district record, derive ZIP field from Central Office record. |
| Country | Send "United States" |
School Year File
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 2/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
SchoolYearFile.csv
| Field Name | Business Rules |
|---|---|
| UniqueSchoolYearId | Send school year primary key of current year |
| Description | School year |
| Start_Date | Send "07/01/" + year of starting date |
| End_Date | Send "06/30/" + year of ending date |
School Term
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 3/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
SchoolTerm.csv
| Field Name | Business Rules |
|---|---|
| UniqueSchoolNumber | School code of buildings |
| UniqueSchoolYearID | Send school year primary key of current year |
| SchoolPeriodId | Send primary keys of semesters in the building for current year |
| School_Period_Description | Semester number |
| SchoolPeriodStartDate | Semester start date in MM/DD/YYYY format |
| SchoolPeriodEndDate | Semester end date in MM/DD/YYYY format |
School Program File
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 4/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
SchoolProgramFile.csv
| Field Name | Business Rules |
|---|---|
| SchoolProgramId | NY: Send status codes SE, 0264, 0231, 5806, 5817, FL. PA: Send ELL, 504, IEP, IEPM, 5817, FL, 1, 2, 3. Append "_" + status code primary key at end of statuses 5817 and FL (ex. "5817_5" and "FL_2") to account for multiple meal statuses sharing the same code. |
| Description | Status description |
| UniqueSchoolNumber | Send "DISTRICT" |
Student
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 5/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
Students.csv
| Field Name | Business Rules |
|---|---|
| StudentIDNumber | NA |
| FirstName | NA |
| MiddleName | NA |
| LastName | NA |
| UniqueSchoolNumber | School Code of student's current school |
| GradeLevel | Student's current grade. Grades K4F, K4A, K4P, K5F, K5A, K5P, KA, KH, KP will export as "K" Grades PKA, PKP, PKF, PK, PKH, PS, PSA, PSP, PA, PS, PS2, PP will export as "Pre-K" All other grades will export as is |
| BirthDate | Birth date in MM/DD/YYYY format |
| Gender | Student's gender as "Male" or "Female" |
| EnrollmentStatus | Send "Active" |
| Ethnicity | Send "Hispanic" if student has the Hispanic flag on, or student's race spelled out as shown in eSD if not Hispanic. "Multiracial" race will be sent out as is. |
| Student's email | |
| IntegrationId | Student's integration ID |
Student Program File
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 6/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
StudentProgramFile.csv
| Field Name | Business Rules |
|---|---|
| SchoolProgramId | NY: Send status codes SE, 0264, 0231, 5806, 5817, FL. PA: Send ELL, 504, IEP, IEPM, 5817, FL, 1, 2, 3. Append "_" + status code primary key at end of statuses 5817 and FL (ex. "5817_5" and "FL_2") to account for multiple meal statuses sharing the same code. |
| UniqueSchoolNumber | Send "DISTRICT" |
| StudentIdNumber | Referenced in the Student file |
| StartDate | Send in MM/DD/YYYY format. |
| EndDate | Send in MM/DD/YYYY format. Only pull statuses with no end date or with an end date on or after today's date. |
Personnel
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 7/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
Personnel.csv
| Field Name | Business Rules |
|---|---|
| StaffId | Primary key of active staff record. Do not send out eSchoolData Administrator and Portal Updater staff records. |
| FirstName | NA |
| MiddleName | NA |
| LastName | NA |
| UniqueSchoolNumber | Send CODE field for building staff and send "DISTRICT" for district-level staff. |
| Position | Send all Staff Types associated to staff, separated by semicolon |
| Gender | Send gender as "Male" or "Female" |
| StateStaffNumber | NA |
| Staff record's email | |
| IntegrationId | Staff's integration ID |
Course
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 8/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
Course.csv
| Field Name | Business Rules |
|---|---|
| LocalCourseNumber | Course number of courses that do not have the course type Placeholder. Ignore courses with course type Placeholder if Source Year in GURU is set to next year. |
| UniqueSchoolNumber | School code of building course is in |
| CourseName | Display name of course |
| UniqueCourseID | Primary key of course |
Class
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 9/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
Class.csv
| Field Name | Business Rules |
|---|---|
| SectionNumber | Only send records based on the first class meeting time of the section. |
| UniqueSchoolNumber | School code of building course is in |
| UniqueCourseID | Primary key of course |
| UniqueClassID | Primary key of class section |
| TermDuration | Send pattern associated with first meeting time |
Class Staff
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 10/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
ClassStaff.csv
| Field Name | Business Rules |
|---|---|
| SectionNumber | Only send records based on the first class meeting time of the section. |
| UniqueClassID | Primary key of class section |
| StaffIDNumber | NY: If TOR records exists for class meeting time, send only staff from TOR records. If TOR records do not exist for class meeting time, send only staff assigned to the class meeting time itself. PA: Send both staff assigned to the class meeting time itself and TOR records |
| UniqueSchoolNumber | School code of building course is in |
| LocalCourseNumber | Course number |
| UniqueCourseID | Primary key of course |
| TermDuration | Send pattern associated with first meeting time |
| TeacherPrimaryFlag | NY: If TOR records exists for class meeting time, and role = "Teacher of Record", "TOR and TOR S/E", "TOR/Substitute" or "TOR/College", send true. If TOR records' role are not these four, send false. If TOR record does not exist, send true. PA: If TOR record has the role = "Teacher of Record", send true, else send false. If the teacher is pulled from the meeting time itself, send true. If the teacher is being pulled from both the class meeting time and TOR record, send one record with True |
Class Roster
ACTIVE STUDENTS WITH GRADES K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, UG, UGS, K4F, K4A, K4P, K5F, K5A, K5P, PKA, PKP, PKF, PK, PKH, KA, KH, KP, SUG, EUG, PS, PSA, PSP, PA, PS, PS2, PP, AND STAFF ONLY ARE BEING EXTRACTED
TOTAL OUTPUTS: 11 - EACH ARE INCLUDED IN ADDITIONAL SHEETS (THIS OUTPUT IS 11/11)
School Name, Grade Levels, School Type and Subject are being allowed as parameters and the extract will consider these before sending the information out.
ClassRoster.csv
| Field Name | Business Rules |
|---|---|
| SectionNumber | Section number. Only send records that have no end date or with an end date on or after today. |
| UniqueClassID | Primary key of class section |
| StudentIDNumber | ID number of student |
| UniqueSchoolNumber | School code of building class is in |
| LocalCourseNumber | Course number |
| UniqueCourseID | Primary key of course |
| TermDuration | Send pattern associated with first meeting time |