Frontline RTI/MTSS Program Management software helps you collect, store, and organize data to elevate intervention planning. This lesson provides the Business Rules for Frontline export zap.
Business Rules
Student Data
The output will be in double-quoted CSV format with the header included.
Filters provided in the zap are School Type, School, and Grade.
Only active students will be included in this zap.
The Frontline specifications has multiple file outputs, but this zap will only provide the Student Data and Student Contact outputs.
Please note that the Student Data output missing a State field is intended as the original specs does not include it.
Student Data.csv
| Student Data | ||
| Field | NY Logic | PA Logic |
|---|---|---|
| District ID | District's Central Office BEDS code formatted as in Level 0 (ex. NY519040) | Student's current building's District of Location AUN |
| Local Student ID | Student's ID Number | Student's ID Number |
| Student State ID | Student's State ID Number | Student's State ID Number |
| Student First Name | Student's first name | Student's first name |
| Student Last Name | Student's last name | Student's last name |
| Student Middle Name | Student's middle name | Student's middle name |
| Suffix | Student's suffix | Student's suffix |
| Birthdate | Student's date of birth in MM/DD/YYYY format | Student's date of birth in MM/DD/YYYY format |
| Sex | Student's Identified Gender code if available or Gender code | Student's Identified Gender code if available or Gender code |
| School ID | Student's current building's location code | Student's current building's School Code |
| Grade | 1. If the student's current grade level is K, KA, KH, or KP, display KG. 2. If the student's current grade level is PK, PKA, PKF, PKH, or PKP, display PK. 3. If the student's current grade level is 1 through 12, display it as is. 4. For all other grade levels, display NA. |
1. If the student's current grade level is K4A, K4P, K4F, K5A, K5P OR K5F, display KG. 2. If the student's current grade level is PKA, PKP, PKF, K3A, K3P OR K3F, display PK. 3. If the student's current grade level is 1 through 12, display it as is. 4. For all other grade levels, display NA. |
| Address | Student's household's residence street number, street suffix and street name | Student's household's residence street number, street suffix and street name |
| Address 2 | If it exists, Student's household's residence apartment with "Apt " added at the beginning, else leave blank | If it exists, Student's household's residence apartment with "Apt " added at the beginning, else leave blank |
| City | Student's household's residence city | Student's household's residence city |
| Zip | Student's household's residence zip code | Student's household's residence zip code |
| Status | Always displays "Active" | Always displays "Active" |
| Race | 1. If the student's race is "American Indian/Alaska Native", display "American Indian or Alaska Native". 2. If the student's race is "Asian", display "Asian". 3. If the student's race is "Black/African American", display "Black or African-American". 4. If the student's race is "Native Hawaiian/Other Pacific Islander", display "Native Hawaiian or Other Pacific Islander". 5. If the student's race is "White", display "White". 6. If the student's race is "Multiracial", display one of the student's multiracial selections as per the previous points. |
1. If the student's race is "American Indian/Alaska Native", display "American Indian or Alaska Native". 2. If the student's race is "Asian", display "Asian". 3. If the student's race is "Black or African American", display "Black or African-American". 4. If the student's race is "Native Hawaiian or Pacific Islander", display "Native Hawaiian or Other Pacific Islander". 5. If the student's race is "White", display "White". 6. If the student's race is "Multiracial", display one of the student's multiracial selections as per the previous points. |
| Student Language | Student's language | Student's language |
| Home Language | Student's household language | Student's household language |
| EB/EL Status | 1. If the student currently has the student status code 0231, display "Emergent Bilingual/English Learner". 2. If the student has the student status code 0231 that ended 365 days ago or less, display "Monitor Year 1". 3. If the student has the student status code 0231 that ended between 366 and 730 days ago, display "Monitor Year 2". 4. If the student has the student status code 0231 that ended more than 730 days ago, display "Former Emergent Bilingual/English Learner". 5. If the student has no student status code 0231, display "English Proficient". |
1. If the student currently has the student status code ELL or ELLIFE, display "Emergent Bilingual/English Learner". 2. If the student currently has the student status code ELL1YR, display "Monitor Year 1". 3. If the student currently has the student status code ELL2YR, display "Monitor Year 2". 4. If the student currently has the student status code ELLEXIT, display "Former Emergent Bilingual/English Learner". 5. If the student has none of the above current student statuses, display "English Proficient". |
| Ethnicity | If the student's Hispanic flag is on, display "H", else leave blank | If the student's Hispanic flag is on, display "H", else leave blank |
| At Risk Indicator | Left blank | Left blank |
| Dyslexia Status | Left blank | Left blank |
Student Contact
This output will include both custodial and non-custodial guardians.
Filters provided in the zap are School Type, School, and Grade.
Only guardians associated to active students will be included in this zap.
The Frontline specifications has multiple file outputs, but this zap will only provide the Student Data and Student Contact outputs.
| Student Data | ||
| Field | NY Logic | PA Logic |
|---|---|---|
| Local Student ID | Student's ID Number | Student's ID Number |
| Contact ID | Internal primary key of the relationship record between the student and guardian | Internal primary key of the relationship record between the student and guardian |
| Contact Order | Derived contact priority of the guardian in relation to all other guardians pulled for the specific student. For example, if the student has two guardians and one guardian has a contact priority of 1 while the other has a contact priority of 3, the first guardian will have a Contact Order of 1 while the other has a Contact Order of 2. Guardians with a contact priority of 0 will not be included. | Derived contact priority of the guardian in relation to all other guardians pulled for the specific student. For example, if the student has two guardians and one guardian has a contact priority of 1 while the other has a contact priority of 3, the first guardian will have a Contact Order of 1 while the other has a Contact Order of 2. Guardians with a contact priority of 0 will not be included. |
| Contact First Name | Guardian's first name | Guardian's first name |
| Contact Last Name | Guardian's last name | Guardian's last name |
| Contact Middle Name | Guardian's middle name | Guardian's middle name |
| Relationship | Guardian's relationship to the student | Guardian's relationship to the student |
| Address | Guardian's street number, street suffix and street name | Guardian's street number, street suffix and street name |
| Address 2 | If it exists, Guardian's apartment with "Apt " added at the beginning, else leave blank | If it exists, Guardian's apartment with "Apt " added at the beginning, else leave blank |
| City | Guardian's city | Guardian's city |
| State | Guardian's state | Guardian's state |
| Zip | Guardian's zip code | Guardian's zip code |
| Status | Always displays "Active" | Always displays "Active" |
| Home Phone | Guardian's home cell or home phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 | Guardian's home cell or home phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 |
| Mobile Phone | Guardian's home cell, cell phone or work phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 | Guardian's home cell, cell phone or work phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 |
| Work Phone | Guardian's work cell or work phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 | Guardian's work cell or work phone that is first in derived priority. Blank phone priorities are treated as having a priority of 99 |
| One of the guardian's email addresses, preferring email addresses flagged as the primary email | One of the guardian's email addresses, preferring email addresses flagged as the primary email | |
| Legal Guardian | Display "Yes" if the guardian has the Custodial Parent flag on for the student, else display "No" | Display "Yes" if the guardian has the Custodial Parent flag on for the student, else display "No" |
| Lives With Student | Display "Yes" if the guardian resides in the household, else display "No" | Display "Yes" if the guardian resides in the household, else display "No" |