Classic View: CO State Reporting > Data Pipeline > Student Interchange > EOY Adjustments
Search Terms: Student Interchange
The End of Year Adjustments Report lists students whose Adj fields on the State Reporting Enrollment editor are not null or 00: Not Applicable within the Calendar. A student is included in the report when there is data in any one of the Adj. fields:
- Adj Cohort Year
- Adj Cohort School
- Adj Cohort Justification
EOY Adjustments Report
Report Logic
If multiple calendars are selected, a record reports for every enrollment a student may have in the calendar year(s) selected. Duplicate records may display for a single student.
If the student is marked as State Exclude, the student still reports as long as the Adj. Cohort fields are populated.
- If the Adj Cohort information within the single calendar is between multiple enrollments is the same, only one record reports.
- If the information between multiple enrollments is different, all differing records report.
Report Editor
| Field | Description |
|---|---|
| Report Type |
Selection determines the Student Interchange report that generates. Choose EOY Adjustments. |
| 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. |
| Report Legal Name | When marked, the student's name and gender report from the Protected Identity Information section on the student's Identities record. |
| Format | This 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 | This report 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 EOY Adjustments option from the Report Type field.
- If desired, select students from an existing Ad hoc Filter.
- Select the Format of the report.
- Mark the Report Legal Name checkbox, if desired.
- Select the Calendar(s) from which to report information.
- Click the Generate Extract button or the Submit to Batch button. The report displays in the desired format.
EOY Adjustments - HTML Format
EOY Adjustments - 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. If the student does not have a State ID number, this field reports ten zeros (0000000000). Numeric, 10 digits |
Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| 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 Name | 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.legalLastName |
| Gender | Reports the student's gender.
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 Identity.brithDate Census > People > Identities > Identities Editor > Birth Date |
| Adjustment Justification Code | Reports the code selected in the Adj. Cohort Justification field. If that field is blank, 00 reports. If a school district has received notification that a student who was reported as a dropout, expulsion or GED Transfer during a previous reporting period is completing their education or has completed their education through another education agency, a cohort membership base adjustment can be made. Adjustments can only be made for students who were reported as dropouts, expulsions, or GED Transfers from a school administered by the reporting district. All adjustment fields that are not used are zero-filled. Adjustment codes are only be used for high school students (grades 09-12). Numeric, 2 digits |
Student Information > General > Enrollments > State Reporting Fields > Adj. Justification Code Enrollment.adjCohortJustification |
| Adjustment School Code | Reports the code for the school the student was attending when the student dropped enrollment, was expelled or transferred to an external GED program. If this field is blank, 0000 reports. Alphanumeric, 4 characters |
Student Information > General > Enrollments > State Reporting Fields > Adj. School Code Enrollment.adjCohortSchool |
| Adjustment Year | Reports the code in which the student was reported as a dropout or expulsion. This cannot be the currently reported school year. If this field is blank, 0000 reports. Alphanumeric, 4 characters |
Student Information > General > Enrollments > State Reporting Fields > Adj. Cohort Year Enrollment.adjCohortYear |
