Classic View: CO State Reporting > Data Pipeline > EDIS/RITS Import
Search Terms: EDIS/RITS Import
The EDIS/RITS Import tool allows districts to import student State IDs and Staff State IDs into Campus.
EDIS/RITS Import Tool
Report Logic
EDIS Logic
Staff State IDs import when ALL of the following matching criteria is met:
- District Code matches the State District Number (District Information).
- LAEDID matches the Local Staff Number (Demographics).
- Last Name matches the current identity Last Name (Demographics).
- First Name matches the current identity First Name (Demographics).
- Gender matches the current identity Gender (Demographics).
If the Staff State ID is not null and all matching criteria is met, data is overwritten when importing. This data is archived on the ID History Tab for reference.
Data is NOT imported:
- If any of the matching criteria is not met. This information is included as an error on the Result Report.
- If there is more than one match. This information is included as an error on the Result Report.
RITS Logic
Student State IDs import as long as the matching criteria is met.
- District Code matches the State District Number (District Information)
- LASID matches the Local Student Number (Demographics)
- Last Name matches the current identity Last Name (Demographics)
- First Name matches the current identity First Name (Demographics)
- Gender matches the current identity Birth Date (Demographics)
If the Student State ID is not null and all matching criteria is met, data is overwritten when importing. This data is archived on the ID History Tab for reference.
Data is NOT imported:
- If any of the matching criteria is not met. This information is included as an error on the Result Report.
- If there is more than one match. This information is included as an error on the Result Report.
EDIS/RITS Import Editor
The following fields are available for selection on the import tool.
| Field | Description |
|---|---|
| Select the Import Type | Selection indicates what type of file is imported, either the RITS (students) or EDIS (staff). |
| Does this file include headers? | When marked, indicates the imported file has header rows. |
| File | Use the Browse icon to locate the CSV file to import. |
Using the Import Tool
- Select the import type from the dropdown list.
- If the file includes header rows, mark the Does this file include headers? checkbox.
- Click the Browse button to locate the file to upload. Once located, click the Open button on the File Upload window.
- Click the Upload button on the editor to import the information. The import occurs. If any information in the file cannot be imported, that information displays on the Result Report.
The ID History tab is updated to display the name of the person who performed the import.
Result Summary Report
The Results Summary Report displays AFTER the import has completed. It lists the number of State IDs added, changed and already existing. A total error count also displays and then a list of the students or staff who had errors in their data and were not imported.
RITS Import Results Summary
EDIS Import Results Summary
EDIS/RITS Import Format
EDIS Import
| Data Element | Description | Location |
|---|---|---|
| EDID | State-assigned State ID Number Numeric, 8 digits |
Census > People > Demographics > Staff State ID Person.staffStateID |
| SSN | Educator's Social Security number Numeric 9 digits |
Census > People > Demographics > Person Information > Soc Sec Number Census > People > Identities > Person Information > Soc Sec Number Identity.SSN |
| District Code | Code assigned to the reporting district. This field must be populated and must match the Reporting District. Numeric, 4 digits |
System Administration > Resources > District Information > District Info > State District Number District.Number |
| LAEDID | Local staff ID number Numeric, 10 digits |
Census > People > Demographics > Person Identifiers > Local Staff Number Person.staffID |
| Last Name | Educator's last name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > Last Name Census > Identities > Demographics > Person Information > Last Name Identity.lastName |
| First Name | Educator's first name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > First Name Census > Identities > Demographics > Person Information > First Name Identity.firstName |
| Middle Name | Educator's middle name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > Middle Name Census > Identities > Demographics > Person Information > Middle Name Identity.middleName |
| Birth Date | Educator's birth date Date field, 8 characters (MMDDYYYY) |
Census > People > Demographics > Person Information > Birth Date Census > Identities > Demographics > Person Information > Birth Date Identity.birthDate |
| Gender | Educator's gender Numeric, 2 digits (Female = 01, Male = 02) |
Census > People > Demographics > Person Information > Gender Census > Identities > Demographics > Person Information > Gender Identity.gender |
RITS Import
| Data Element | Description | Location |
|---|---|---|
| SASID | State-assigned Student number Numeric, 10 digits |
Census > People > Demographics > Person Identifiers > State ID Number Person.stateID |
| District Code | Code assigned to the reporting district Numeric, 4 digits |
System Administration > Resources > District Information > District Info > State District Number District.Number |
| School Code | Code assigned to the reporting school Numeric, 4 digits |
System Administration > Resources > School > School Editor > School Detail > School Number School.Number |
| LASID | Local studentID number Numeric, 10 digits |
Census > People > Demographics > Person Identifiers > Student Number Person.studentID |
| Last Name | Student's last name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > Last Name Census > People > Identities > Demographics > Person Information > Last Name Identity.lastName |
| Suffix | Student's suffix Alphanumeric, 3 characters |
Census > People > Demographics > Person Information > Suffix Census > People > Identities > Demographics > Person Information > Suffix Identity.suffix |
| First Name | Student's first name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > First Name Census > Identities > Demographics > Person Information > First Name Identity.firstName |
| Middle Name | Student's middle name Alphanumeric, 30 characters |
Census > People > Demographics > Person Information > Middle Name Census > Identities > Demographics > Person Information> Middle Name Identity.middleName |
| Birth Date | Student's birth date Date field, 8 characters (MMDDYYYY) |
Census > People > Demographics > Person Information > Birth Date Census > Identities > Demographics > Person Information > Birth Date Identity.birthDate |
| Grade | Student's current grade level Numeric, 3 digits |
Student Information > General > Enrollments > General Enrollment Information > Grade System Administration > Calendar > Calendar > Grade Levels Tab > Grade Level Editor > Kindergarten Code Enrollment.grade |
