Classic View: CO State Reporting > Data Pipeline > Student Interchange > School Association

Search Terms: Student Interchange

The School Association Report lists all students enrolled in the selected calendar as of the entered effective date in grades EE-12.

School Association Extract

Report Logic

Students are included in the report when a student has a primary enrollment in a state grade with an enrollment start date that is before the Effective Date. When the Include Partial Enrollments checkbox is marked on the Extract Editor, partial enrollments in the selected calendar are also included.

Students are not included in this report when:

Enrollment records are marked as No Show.
Enrollment records are marked as State Exclude.
Grade level is mapped to a state grade level of 002.
Grade levels are marked as State Exclude.
Calendars in which the student is enrolled are marked as State Exclude.

When the student's Start Status is 00: No/Not Applicable - summer dropouts only (reported in field 10, Entry Type) and when the student's End Status is 40: Discontinued schooling/dropped out (reported in field 12, Exit/Withdraw Type), these fields report as zeros up to the length of the field:

Field 3, School Code (4 digits)
Field 8, Entry Date (8 digits)
Field 11, Exit/Withdraw Date (8 characters)

Attendance Calculations

This report uses the Attendance Day Aggregation table for calculating attendance. See the following articles for more information on this table:

Continuous in District/School

A student is considered continuous in district as long as the student had a primary enrollment as of the Continuous in District Dates and any primary enrollment from that date to the end of the school term, as long as the student was enrolled in all instructional days to the end of the school term. Multiple primary enrollments must be considered.

A student is considered continuous in school as long as they had a primary enrollment as of the Continuous in District Dates and any primary enrollment from that date to the end of the school term as long as the student was enrolled in all instructional days to the end of the school term. Multiple primary enrollments must be considered.

When the Continuous in School value reports as a 1 for a student, the Continuous in District value also reports as a 1.

Override fields exist on the state reporting enrollment editor. Values chosen in those fields report. When there are no values chosen, the report follows this logic:

Reported Value	Reporting Population
Continuous in District
1	Student has a single enrollment: The end date that is either null or greater than the Effective Date entered on the report editor; AND The student's start date is either before the Count Date. Student has multiple enrollments: The end date on the latest enrollment is either null, greater than the Effective Date entered on the report editor; AND The student's start date of the first enrollment is before the Count Date; AND The end status on any primary enrollments is not 40, 45, 50, 55 or 25; AND The count of all instructional days between enrollments is less than 10 (see exceptions). Any days before the Count Date of the calendar year are NOT counted.
0	Student has a single enrollment: The end date is before the effective date entered on the report editor; OR The student's start date is after the Count Date. Student has multiple enrollments: The end date on the latest enrollment is before the Effective Date; OR The enrollment start date of the first enrollment is after the Count Date; OR The end status on any primary enrollment is 40, 45, 50, 55 or 25; OR The count of all instructional days between enrollments is less than 10 (see exceptions).
Continuous in School
1	Student has a single enrollment: The end date is either null, greater than the effective date; AND The student's start date is either before the Count Date. Student has multiple enrollments: The end date for the last enrollment in the selected school is null or greater than the effective date. The student's start date of the first enrollment in the selected school is before the Count Date. The student's end status on any primary enrollment is not 40, 45, 55, 56 or 25; AND The count of all instructional days between enrollments at the reporting school is less than 10 (see exceptions).
0	Student has a single enrollment: The end date is before the effective date; OR The start date is after the Count Date. Student has multiple enrollments: The end date for the last enrollment is before the Effective Date; OR The start date of the first enrollment is after the Count Date; OR The end status on any primary enrollment is 40, 45, 50, 55, 56 or 25; OR The count of all instructional days between enrollments at the reporting school is more than 10 (see exceptions).
Exceptions
When a student has an end status of 10, instructional days missed from this enrollment are not counted until next one starts. When a student has an end status of 06 or 11, instructional days missed from this enrollment until next one starts are not counted when the number of days between the enrollments is less than 10. When greater than 10 days between enrollments, reports 0. When a student has a start status of 02, instructional days missed from this enrollment and the previous one are not counted. Summer school enrollments are not be used in any calculations. When Continuous in School is 1, then Continuous in District must also be 1.

Report Editor

Field	Description
Report Type	Selection determines the Student Interchange report that generates. Choose School Association.
Report Format	Selection indicates which layout of the report generates. When choosing a 2021-22 calendar, choose the 2021-2022 Format; when choosing a 2022-23 calendar, choose the 2022-23 Format.
Ad hoc Filter	Select a saved ad hoc filter to only include those students in the filter in the report, assuming those students meet the reporting logic and business rules of this report.
Effective Date	The entered date is auto-populated to the current date and returns those students actively enrolled in the selected calendar on this date.
Attendance Start Date	Entered start date is used to calculate attendance day information from the entered start date through the entered end date.
Attendance End Date	Entered end date is used to calculate attendance day information from the entered start date through the entered end date.
Include Partial Enrollment	When marked, students who have partial enrollments are included in the report population.
Report Legal Name	When marked, the student's name and gender report from the Protected Identity Information section on the student's Identities record.
Exclude Attendance	When marked, the following fields are zero-filled in the extract: Total Days Attended Total Days Excused Total Days Unexcused Total Possible Attendance Days Habitually Truant Status Total Days Missed Due to Out of School Suspensions Mark this checkbox when generating this report for your own district needs. When submitting this to the state, DO NOT mark this checkbox.
Format	The School Association report can be generated in either CSV or HTML formats.
Calendar Selection	At least one calendar needs to be selected in order to generate the report. Reports can be selected by Active Year, School or Year.
Report Generation	The Student Layout extract can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality.

Generate the Report

Select the School Association from the Report Type field.
Select the correct Report Format.
If desired, select students from an existing Ad hoc Filter.
Enter the desired Effective Date, Attendance Start Date and Attendance End Date.
Mark the Include Partial Enrollment checkbox, if desired.
Mark the Report Legal Name checkbox, if desired.
Mark the Exclude Attendance checkbox, if desired.
Select the Format of the report.
Select the Calendar(s) from which to report information.
Click the Generate Extract button or use the Submit to Batch button. The report displays in the desired format.

School Association Report - HTML Format

School Association Report - CSV Format

Report Layout

Data Element	Description	Location
District Code	The number assigned to a school district by the state department of education. Numeric, 4 digits	System Administration > Resources > District Information > District Information > State District Number District.number
SASID	A unique number assigned to a student by the Department of Education. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > Student State ID Person.stateID
School Code	Reports the School of Accountability. When that field is not populated on the enrollment record. reports the State School Number. When both fields are null, reports 0000. When the Enrollment Start Status is 00 and the Enrollment End Status is 40, reports 0000. Numeric, 4 digits	Student Information > General > Enrollments > State Reporting Fields > School of Accountability Enrollment.resident School
First Name	Reports the student's first name. When the Report Legal Name checkbox is marked, the student's First Name reports from the Legal First Name field. Alphanumeric, 30 characters	Census > People > Demographics > Person Information > First Name Identity.first Name Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName
Last Surname	Reports the student's last name. When the Report Legal Name checkbox is marked, the student's Last Name reports from the Legal Last Name field. Alphanumeric, 30 characters	Census > People > Demographics > Person Information > Last Name Identity.last Name Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legal LastName
Sex	Reports the student's gender. 01 - Female 02 - Male When the Report Legal Name checkbox is marked, the student's Gender reports from the Legal Gender field. Numeric, 2 digits	Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Protected Identity Information > Legal Gender Identity.legalGender
Birth Date	Student's date of birth. Date field, 8 characters (MMDDYYYY)	Census > People > Demographics > Person Information > Birth Date Census > People > Identities > Identities Editor > Birth Date Identity.birthDate
Entry Date	Student's start date of enrollment. When the Enrollment Start Status is 00 and the Enrollment End Status is 40, this field reports 00000000 (8 zeros). Date field, 8 characters (MMDDYYYY)	Student Information > General > Enrollments > General Enrollment Information > Start Date Enrollment. startDate
Entry Grade Level	Student's grade level of enrollment. Numeric, 3 digits	System Administration > Calendar > Calendar > Grade Levels > State Grade Level Calendar.stateGradeLevel
Entry Type	Student's start status of enrollment. When the start status is not populated, the field reports blank. Numeric, 2 digits	Student Information > General > Enrollment > General Enrollment Information > Start Status Enrollment.startStatus
Exit Withdrawal Date	Student's end date of enrollment. When the student does not have a withdrawal date, field reports 00000000 (8 zeros). When the Enrollment Start Status is 00 and the Enrollment End Status is 40, this field reports 00000000 (8 zeros). Date field, 8 characters (MMDDYYYY)	Student Information > General > Enrollment > General Enrollment Information > End Date Enrollment.endDate
Exit Withdrawal Type	Student's end status of enrollment. When there is no end status, field reports 00. When the Start Status is 00, this field reports from the End Status. Numeric, 2 digits	Student Information > General > Enrollment > General Enrollment Information > End Status Enrollment.endStatus
Retention Code	Indicates whether the student was promoted, demoted or retained following the end of the enrollment record. Reports 1 when the End Action field is R: Retain on the reporting enrollment AND the Post Secondary Program Next Year check box is not marked. Reports 2 when the End Action field is R: Retain on the reporting enrollment AND the Post Secondary Program Next Year check box is marked, regardless of SPED status. Reports 3 when the End Action field is R: Retain AND student is receiving Special Education services (defined as the student has an active Special Education Status of IEP = Yes during the reporting period or the student has an active IEP during the reporting period) AND the student's State Grade Level Code is 120: Grade 12 AND the student's reporting enrollment has an End Status of 27 or 90. A value of 0 reports for all other situations. Numeric, 1 digit	Student Information > General > Enrollment > General Enrollment Information > End Action Enrollment.endAction Student Information > General > Enrollments > State Reporting Fields > Post Secondary Program > Post Secondary Program Next Year Enrollment.Ascent Student Information > General > Enrollments > Special Ed Start Date, Special Ed Exit Date, IEP Enrollment.spedStartDate Enrollment.spedExitDate Enrollment.specialEdStatus Student Information > General > Special Ed
Pupils Attendance Information	Indicates the type of school and education the student is attending. Numeric, 2 digits	Student Information > General > Enrollment > State Reporting Fields > Pupil Attendance Enrollment.stateAid
County Code of Residence for Joint School Districts	Indicates the student's county of residence. Numeric, 2 digits	Student Information > General > Enrollment > State Reporting Fields > Resident County Enrollment.servingCounty
District Parents Residence	Reports the district code when the Resident District or State Field is populated with a 4-digit code. Otherwise, reports a value of 0000. Numeric, 4 digits	Student Information > General > Enrollment > State Reporting Fields > Resident District Enrollment.residentDistrict
Parents Residence for Non-Resident Student Country	Indicates the student's 3-digit resident country. Alphanumeric, 3 digits	Student Information > General > Enrollment > State Reporting Fields > Resident District Enrollment.residentDistrict
Parents Residence for Non-Resident Students State	Indicates the student's resident 2-character state (CO, WY, etc.). Alphanumeric, 2 characters	Student Information > General > Enrollment > State Reporting Fields > Resident District Enrollment.residentDistrict
Public School Finance Act Funding Status	Indicates the type of state funding the student receives. When the Funding Code field is not populated, value reports 80. Numeric, 2 digits	Student Information > General > Enrollments > State Reporting Fields > Funding Code Enrollment.stateFunding Code
Date First Enrolled in the US	Reports the Date Enrolled in US when the value is a valid date in MMDDYYYY format. Otherwise, this field reports 00000000. Date field, 8 characters (MMDDYYYY)	Student Information > General > Enrollments > State Reporting Fields > Date Enrolled in US Enrollment.enrollInUS
Primary School	Reports the student's Enrollment Service Type: Reports 1 when service type is P: Primary Reports 0 when service type is S: Partial Reports 0 whens service type is N: Special Ed Services Numeric, 1 digit	Student Information > General > Enrollments > General Enrollment Information > Service Type Enrollment.serviceType
Innovative Learning Opportunities Pilot	Reports the value selected from the ELO record that was active during the reporting period. Acceptable values are 0, 1 or 2. When a student does NOT have an ELO record, a value of 0 reports. Numeric, 1 digit	Student Information > Program Participation > State Programs > Extended Learning Opportunities > Innovative Learning Opportunities Pilot ExtendedLearningOpportunity.programType
Program Participations: Expelled Education	Indicates the student participates in special programs due to being expelled. Reports 1: Behavior Resolution Code is 04, 05 or 08 AND The Behavior Resolution Expulsion Service Provided checkbox is marked. The Behavior Resolution Start Date is ON or BEFORE the Effective Date of the Report. When the Resolution Start Date is Null, the Resolution Assigned Date is used. The Behavior Resolution End Date is ON or AFTER the Effective Date of the report. Reports 0 when the Behavior Resolution End Date is BEFORE the Effective Date of the report. Numeric, 1 digit	Student Information > General > Behavior > Behavior Resolution > Behavior Resolution Behavior.resolution
Home Based Education	Indicates the student is home schooled and receives some services from the districts. Reports 1 when the Home Based Education checkbox is marked; reports 0 when the Home Based Education checkbox is NOT marked. Numeric, 1 digit	Student Information > General > Enrollments > State Reporting Fields > Home Based Education Enrollment.homeBasededucation
Gifted General Intellect	Reports a value of 1 when the Gifted General Intellect field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason1
Gifted Creativity	Reports a value of 1 when the Gifted Creativity field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason2
Gifted Leadership	Reports a value of 1 when the Gifted Leadership field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason3
Gifted Reading	Reports a value of 1 when the Gifted Reading field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason4
Gifted Writing	Reports a value of 1 when the Gifted Writing field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason5
Gifted Math	Reports a value of 1 when the Gifted Math field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason6
Gifted Science	Reports a value of 1 when the Gifted Science field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason7
Gifted Social Studies	Reports a value of 1 when the Gifted Social Studies field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason8
Gifted World Language	Reports a value of 1 when the Gifted World Language field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason9
Gifted Visual Arts	Reports a value of 1 when the Gifted Visual Arts field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.meetingReason10
Gifted Drama and Theater	Reports a value of 1 when the Gifted Drama and Theater field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.rightsCheck17
Gifted Musical	Reports a value of 1 when the Gifted Musical field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.rightsCheck18
Gifted Dance	Reports a value of 1 when the Gifted Dance field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.hearingCheck
Gifted Psychomotor	Reports a value of 1 when the Gifted Psychomotor field is marked on the PLP form as of the effective date. Otherwise, a value of 0 (zero) reports. Numeric, 1 digit	Student Information > Special Education > PLP > General > Documents > PLP SEPlan.visionCheck
Non-School Program	Reports the value entered in the Non-School Program field. Numeric, 2 digits	Student Information > General > Enrollments > Non-School Program Enrollment.nonSchoolProgram
Total Days Attended	Reports the total number of days the student attended school based on the Attendance Start Date and Attendance End Date fields populated on the Report editor. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. For each student in the report population, total the minutes present for each day. Periods with attendance codes that are Absent/Exempt count as present time. Divide the total number of present minutes by the total number of minutes for which the student was scheduled that day to get the days attended. A student who is present for all scheduled minutes reports as 1.0 days; a student who is present for 180 minutes out of a scheduled 360-minute day reports as 0.5 days. Sum the result for the student for each instructional day in the calendar (all 1.0 and 0.5 days). When there is no attendance, a value of 0.0 reports. Numeric, 4 digits (XXX.X)	Student Information > General > Attendance
Total Days Excused	Reports the total number of days the student was marked Absent/Excused based on the Attendance Start Date and Attendance End Date fields populated on the Report editor. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. For each student in the report population, total the minutes of excused absence for each day. Periods with Attendance codes of Absent/Excused are counted. Divide the total number of excused absence minutes by the total number of minutes for which the student was scheduled that day. Sum the results for the student for each instructional day in the calendar (all 1.0 and 0.5 days). When there is no attendance, a value of 0.0 reports. Numeric, 4 digits (XXX.X)	Student Information > General > Attendance
Total Days Unexcused	Reports the total number of days the student was marked Absent/Unexcused based on the Attendance Start Date and Attendance End Date fields populated on the Report editor. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. For each student in the report population, total the minutes of unexcused absence for each day. Periods with Attendance codes of Absent/Unexcused, Absent/Unknown, and Absent/No Excuse (teacher-entered absences) are counted. Divide the total number of unexcused absence minutes by the total number of minutes for which the student was scheduled that day. Sum the results for the student for each instructional day in the calendar (all 1.0 and 0.5 days). When there is no attendance, a value of 0.0 reports. Numeric, 4 digits (XXX.X)	Student Information > General > Attendance
Total Possible Attendance Days	Reports the student's total possible days of attendance, using the value reported in Total Days Attended, Total Days Excused and Total Days Unexcused fields based on the Attendance Start Date and Attendance End Date fields populated on the Report editor. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. Numeric, 4 digits (XXX.X)	Student Information > General > Attendance
Habitually Truant Status	Reports the student's habitually truant status based on the Attendance Start Date and Attendance End Date fields populated on the Report editor: A value of 1 reports when a student is Truant Four or More Days in a Month: Students ages 6-16, with 4 or more days of absence in at least one calendar month. Unexcused absences are calculated as noted above (see Total Days Unexcused). The number of days of unexcused absences for each calendar month is summed. A value of 2 reports when the student is Truant Ten or More Days in a School Year: Students ages 6-16, who have 10 or more days of unexcused absence in the year but who do not have 4 or more days of unexcused absence in any one calendar month. Unexcused absences are calculated as noted above (see Total Days Unexcused). The number of days of unexcused absence for each student in the year is summed. A value of 3 reports when a student is Truant for Both Conditions: Unexcused absences are calculated as noted above (see Total Days Unexcused). The total number of days of unexcused absence for each student in the year is summed. When the student does not meet the requirements of habitually truants, a value of 0 reports. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. Numeric, 1 digits	Student Information > General > Attendance
Total Days Missed Due to Out of School Suspensions	Reports the number of school days the student was absent due to a suspension based on the Attendance Start Date and Attendance End Date fields populated on the Report editor. The Duration in School Days field on Behavior Resolutions is summed for the entire calendar where the Resolution is 03. When the Exclude Attendance checkbox is marked on the Report Editor, this field is zero-filled. Numeric, 3 digits	Student Information > General > Behavior

Student Interchange - School Association (Colorado) [.2235 - .2323]