SSID Import (Ohio)

 PATH: OH State Reporting > SSID Import 

The SSID Import is used to import student data files from the state department of education into Campus.


 Image 1: SSID Import Editor 

Report 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

  1. 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. 
  2. Click Browse to select a file to be imported.
  3. 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 NameThe 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 TypeThe 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