Classic View: CO State Reporting > Data Pipeline > RITS Export
Search Terms: READ Act Extract
The Records Integration Tracking System (RITS) Export is used as a locating file for synching student state IDs. This report is an update to the existing RITS Export. See the CDE website for additional information on this change.
RITS Export
Report Logic
One record reports for each primary enrollment a student has in the selected calendar.
Students are not included when:
- Their enrollment record is marked as State Exclude or as No Show.
- The grade level of enrollment is marked as State Exclude
- The calendar or enrollment is marked as State Exclude.
- The enrollment is not a Primary enrollment.
Report Editor
The following fields are available for selection.
| Field | Description |
|---|---|
| Effective Date | Student enrollment records within the selected calendar(s) as of this date are included in the extract. |
| Report Legal Name | When marked, the student's name and gender reports from the Legal Name and Gender fields in the Protected Identity Information section of the Identities record. |
| Format | Selection indicates how the extract generates, either in CSV or HTML format. |
| Students without State IDs | When marked, ONLY students who are not currently assigned a state ID are included in the report. |
| Active/Inactive | Allows users to include or exclude students from reporting based on whether or not they have an active or inactive enrollment as of the Effective Date entered. |
| Calendar Selection | All calendars selected within this field are included in the extract. |
| Report Generation | The 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
- Enter the Effective Date of the report.
- Mark the Report Legal Name checkbox, if desired.
- Select the desired Format.
- If only those students who do not have state IDs should be included in the report, mark the Students without state IDs checkbox.
- Select the option to include Active Students Only, Inactive Students Only or All Students.
- Select the calendar(s) from which to report the data.
- Click the Generate Extract button or use the Submit to Batch option. The report displays in the selected format.
RITS Export - CSV Format, with Student IDS and Inactive Students
RITS Export - HTML Format, without Student IDS and All Students
Report Layout
Element | Description | Location |
|---|---|---|
SASID | Reports the state-assigned student identifier. Numeric, 10 characters | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
District Code | Reports the unique code indicating the reporting district. Alphanumeric, 4 characters | System Administration > Resources > District Information > District Info > State District Number District.districtID |
School Code | Reports the unique code indicating the reporting school. Alphanumeric, 4 characters | System Administration > Resources > School > School Editor > School Detail > State School Number School.number |
LASID | Reports the locally assigned Student ID.
Alphanumeric, 10 characters | System Administration > Resources > District information > District Info > State District Number District.districtID Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
Last Name | Reports the student's legal 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.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
| Suffix | Reports the student's legal Suffix, if available (otherwise reports blank). When the Report Legal Name checkbox is marked, the student's Suffix reports from the Legal Suffix field. Punctuation is not accepted for this field. The value must be Jr, IV, etc. (no periods). Alphanumeric, 3 characters | Census > People > Demographics > Person Information > Suffix Identity.suffix Census > People > Identities > Protected Identity Information > Legal Suffix Identity.legalSuffix |
First Name | Reports the student's legal 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.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
Middle Name | Reports the student's middle name. When the Report Legal Name checkbox is marked, the student's Middle Name reports from the Legal Middle Name field. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName Census > People > Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
Birth Date | Reports the student's date of birth. Date field, 8 characters | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
Grade | The student's grade level.
Numeric, 3 characters | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade System Administration > Calendar > Calendar > Grade Levels Tab > Grade Level Editor > Kindergarten Code GradeLevel. kindergartenCode |
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 characters | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Protected Identity Information > Legal Gender Identity.legalGender |
Active/Inactive Indicator | Indicates if the student has an active or inactive enrollment record as of the Effective Date entered on the report editor.
Numeric, 1 character | Student Information > General > Enrollments > Start Date, End Date Enrollment.endDate Enrollment.startDate |
