More K-12 schools and districts use Follett Destiny Library Manager for managing their library resources than any other platform. There’s a reason why: Our solution not only allows librarians and administrators keep thorough, real-time track of a library’s inventory and media assets, but also gives students a fun means of discovery and reading. The Destiny Zap includes student and staff data so that districts can easily provision accounts within Destiny. The Zap can be configured to extract this information on a scheduled basis, ensuring that your data remains synchronized between the two products. Intro text. This lesson provides the Business Rules for the Destiny Follett export Zap.
Before you Begin
Need a refresher on installing a Zap? Visit to Pre-Built Export Zaps learn more.
Business Rules
Student
Students.csv
- The output will be in comma-delimited format with double quotes and with the header included.
- Filters available are School Type, School, and Grade.
- The Source Year from the Zaps page will be read. When the next year is selected, the student's scheduling school and scheduling grade will be used and next year classes will be included instead.
- Active registered students will be pulled.
- Students who ended their enrollment in the filtered school or school type during the Source Year will be included as inactive students.
- Inactive students as noted above are included as Destiny explicitly inactivates students using the Status field instead of implicitly by absence of their records.
| Field | Logic |
|---|---|
| Site Short Name | School code of the student's current school if the Source Year is the current year or the student's scheduling school if the Source Year is next year |
| Barcode | Student's ID number |
| District ID | Student's ID number |
| Last Name | Student's last name |
| First Name | Student's first name |
| Middle Name | Student's middle name |
| Nickname | Student's nickname |
| Patron Type | Always "Student" |
| Status | "A" if the student is currently active in the filtered school and grade or "I" if the student has ended their enrollment in the filtered school as of the Source Year |
| Gender | Student's gender code |
| Homeroom | Student's homeroom |
| Grade Level | If the student is active, pull the student's current grade if the Source Year is the current year or the student's scheduling grade if the Source Year is the next year. If the student is inactive, pull the student's last grade level |
| Card Expires | 1. If the student has a projected graduation year, pull that graduation year with "0630" added at the end (ex. "20240630") 2. If the student has no projected graduation year and the student is in grades 1-12, pull a prediction of the student's graduation year based off their grade level and add "0630" at the end 3. If the student does not fulfill any of the above criteria, pull "99990630" |
| Is Teacher | Always "N" |
| Graduation Year | 1. If the student has a projected graduation year, pull that graduation year 2. If the student has no projected graduation year and the student is in grades 1-12, pull a prediction of the student's graduation year based off their grade level 3. If the student does not fulfill any of the above criteria, pull "9999" |
| Birth Date | Student's date of birth in YYYYMMDD format |
| User Name | Student's integration ID |
| Email 1 | Student's email address |
| Email 2 | Primary guardian's primary email address if available. If the primary guardian has no primary email address, pull one of their existing email addresses. The primary guardian is determined by being first in their derived contact priority to the student and have the Correspondence and Custodial flags on. A contact priority of 0 will be considered to be 100. If there are eligible guardians who are tied for highest contact priorities, the mother will have first priority, then the father has the next priority, and then everyone else will have the next priority after that |
| Address 1 Line 1 | Student's household street number, street suffix and street name |
| Address 1 Line 2 | Student's household apartment prefixed with "Apt " if available |
| Address 1 City | Student's household city |
| Address 1 State | Student's household state fully spelled out |
| Address 1 Postal Code | Student's household zip code |
| Address 1 Phone 1 | Primary guardian's highest priority Home Phone or Home Cell number. If there is a primary guardian without any such phone number and they are residing in the household, pull the student's household phone. |
| Address 1 Phone 2 | Primary guardian's highest priority Cell Phone number |
| Address 2 Line 1 | Student's mailing street number, street suffix and street name. If there is no mailing street number, street suffix or street name, pull the student's mailing PO Box prefixed by "P.O. Box " |
| Address 2 Line 2 | Student's mailing apartment prefixed with "Apt " if available |
| Address 2 City | Student's mailing city |
| Address 2 State | Student's mailing state fully spelled out |
| Address 2 Postal Code | Student's mailing zip code |
| Address 2 Phone 1 | Secondary guardian's highest priority Home Phone or Home Cell number. If there is a secondary guardian without any such phone number and they are residing in the household, pull the student's household phone. The secondary guardian is determined by being second in their their derived contact priority to the student and have the Correspondence and Custodial flags on. A contact priority of 0 will be considered to be 100. If there are eligible guardians who are tied for highest contact priority, the mother will have first priority, then the father has the next priority, and then everyone else will have the next priority after that |
| Address 2 Phone 2 | One of the primary guardian's other Cell Phone number if available, else the secondary guardians' highest priority Home Cell or Cell Phone number. |
Staff
Staff.csv
- The output will be in comma-delimited format with double quotes and with the header included.
- Filters available are School Type, School, and Grade.
- Only building-level active staff will be pulled.
- The Grade filter is not applicable for the Staff.csv output.
| Field | Logic |
|---|---|
| Site Short Name | School code of the staff's building |
| Barcode | Pull the staff's ID number if one is available, else pull the staff's internal primary key |
| District ID | Pull the staff's ID number if one is available, else pull the staff's internal primary key |
| Last Name | Staff's last name |
| First Name | Staff's first name |
| Middle Name | Staff's middle name |
| Nickname | Left blank |
| Patron Type | Always "Faculty" |
| Status | Always "A" |
| Gender | Staff's gender code |
| Homeroom | Staff's homeroom |
| Grade Level | Always blank |
| Card Expires | Always blank |
| Is Teacher | Always "Y" |
| Graduation Year | Always "9999" |
| Birth Date | Staff's date of birth in YYYYMMDD format if available, else "19000101" |
| User Name | Staff's integration ID |
| Email 1 | Staff's email address per their staff record |
| Email 2 | Staff's alternate email address per their staff record |
| Address 1 Line 1 | Staff's street number, street suffix and street name. If there is no street number, street suffix or street name, pull the staff's PO Box prefixed by "P.O. Box " |
| Address 1 Line 2 | Staff's apartment prefixed with "Apt " if available |
| Address 1 City | Staff's city |
| Address 1 State | Staff's state fully spelled out |
| Address 1 Postal Code | Staff's zip code |
| Address 1 Phone 1 | Staff's first entered Work Phone number |
| Address 1 Phone 2 | Staff's first entered Cell Phone number |
| Address 2 Line 1 | Left blank |
| Address 2 Line 2 | Left blank |
| Address 2 City | Left blank |
| Address 2 State | Left blank |
| Address 2 Postal Code | Left blank |
| Address 2 Phone 1 | Left blank |
| Address 2 Phone 2 | Left blank |