Tool Search: SSID Import
The SSID Import is used to import student data files from the state department of education into Campus.
SSID Import EditorReport Logic
Import logic functions as follows:
- Records are matched beginning with the Vendor ID field, then Student Name (first and last), DoB, Gender and Ethnicity.
- If no SSID exists at the district level, the SSID from the import file is added.
- If an SSID does exist at the district level but does not match the SSID, the existing SSID is replaced with the SSID in the import file, the student is be added to the warning list and a new ID History record will be created for the student.
- If a partial match exists or no match exists, the student is added to the error list.
Importing a File
- Select an option in Work to Perform. Options are:
- Validate and Test File: Generates the report with results but does not import data to the database.
- Load File: Generates the report and imports data to the database.
- Click Browse to select a file to be imported.
- Once a file is chosen, click Upload to import the file. A report will generate indicating how many new State IDs were added and how many State IDs were changed.
Errors and Warnings
If any data cannot be uploaded properly, the import file will generate an error report describing each issue.
The error report will being with a count of Warnings and Errors. Warnings indicate an SSID was changed as a result of the import. Errors indicate a student is missing an SSID in both locations.
Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
SID | The unique identification number assigned a student by the Department of Education. Alphanumeric, 9 characters | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
First Name | The student's legal first name. Alphanumeric 30 characters | Census > People > Person Identifiers > First Name Identity.firstName |
Last Name | The student's legal last name Alphanumeric 30 characters | Census > People > Person Identifiers > Last Name Identity.lastName |
DoB | The date on which the individual being reported was born. YYYYMMDD, 8 characters | Census > People > Person Identifiers > Birth Date Identity.birthDate |
Gender | The student's Gender. Reports M for Male, F for Female. Alphanumeric 1 character | Census > People > Person Identifiers > Gender Identity.Gender |
SSN | The social security number of the student. Numeric, 9 digits | Census > People > Demographics > SSN Identity.ssn |
Mothers Maiden Name | The maiden name of the student's mother. Currently reports as blank | N/A |
Existing Student Code | Indicates if the student is likely to already have an SSID. Reports as Y the Admission Reason field reports as 6, indicating that the student is enrolled in an Ohio public school. If Y reports, the record will not be updated. Otherwise reports as N. Alphanumeric, Y or N | Student Information > General > Enrollments > State Reporting Fields > Entry Reason Enrollment.entryReason |
IRN Current Building | The School IRN where the student is currently enrolled. Numeric, 6 digits | System Administration > Resources > School > School Editor > State School Number School.number |
IRN Current District | The District IRN where the student is currently enrolled. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Majority of Attendance IRN Enrollment.attendanceIRN |
IRN Previous District | The District IRN where the student was enrolled prior to transferring into the current district. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Admitted from IRN Enrollment.admittedFromIRN |
IRN Original District | The original district where the student was first enrolled. Currently reports as blank. | N/A |
Admission Reason | The reason the district is requesting an SID to be issued for a newly enrolled student. Numeric, 1 digit | Student Information > General > Enrollments > State Reporting Fields > Entry Reason Enrollment.entryReason |
Native Language | The person's first and primary language. This is often the language spoken at home. Alphanumeric 3 characters | Student Information > General > Enrollments > State Reporting Fields > Native Language Enrollment.language |
Ethnicity | The Race/Ethnicity of the person being reported. Alphanumeric 1 character | Census > People > Person Identifiers > Race/Ethnicity Identity.raceEthnicity |
Birth Place City | The city the student was born in. Alphanumeric 30 characters | Census > People > Demographics > Birth Place City. customPersonIdentity.birthCity |
Birth Place Zip | The zip code of the student's place of birth. Currently reports as blank. | N/A |
Polio Immunization Date | The date the student was vaccinated for Polio. Currently reports as blank. | N/A |
MMR Immunization Date | The date the student was vaccinated for MMR. Currently reports as blank. | N/A |
DTaP Immunization Date | The date the student was vaccinated for DTaP. Currently reports as blank. | N/A |
| Middle Name | The student's legal middle name. Alphanumeric, 30 characters | Census > People > Demographics > Middle Name Identity.middleName |
Called Name | The other name, such as a nickname, the student may be called. Currently reports as blank. | N/A |
Given Name | The other given name of the student. Currently reports as blank. | N/A |
Mothers First Name | The student's mother's first name. Currently reports as blank. | N/A |
Mothers Last Name | The student's mother's last name. Currently reports as blank. | N/A |
Fathers First Name | The student's father's first name. Currently reports as blank. | N/A |
Fathers Last Name | The student's father's last name. Currently reports as blank. | N/A |
Street Number | The street number of the student's address. Currently reports as blank. | N/A |
Street Apt Char | The apartment character of the student's address. Currently reports as blank. | N/A |
Street Name | The name of the street of the student's address. Currently reports as blank. | N/A |
| Street Type | The type of street of the address, such as Street, Drive, Avenue, etc. Currently reports as blank. | N/A |
Full Address 1 | The full street address of the student. Currently reports as blank. | N/A |
Full Address 2 | The second line of the student's full street address. Currently reports as blank. | N/A |
City | The city of the student's address. Currently reports as blank. | N/A |
State | The state of the student's address. Currently reports as blank. | N/A |
Zip Code | The zip code of the student's address. Currently reports as blank. | N/A |
County | The county of the student's address. Currently reports as blank. | N/A |
Country | The country of the student's address. Currently reports as blank. | N/A |
Home Phone | The student's home phone number. Currently reports as blank. | N/A |
Other Phone | An additional phone number at which the student can be reached. Currently reports as blank. | N/A |
Vendor ID | The student's local identification number. Numeric, 8 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
