SSID Extract (Ohio)

PATH: OH State Reporting > SSID Extract

The SSID Extract collects basic student data for submission to the state department of education. The extract can also be used to report students who do not have state IDs.

 
 Image 1: SSID Extract Editor 

Report Logic

This extract returns one record for each student enrolled in the selected calendar on or before the Snapshot Date entered. If the Students w/o SSIDs checkbox is selected in the extract editor, only students who do not have Student State IDs will report.

Generating the Extract

  1. Enter a Snapshot Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
  2. Indicate if only Students w/o SSIDs should be included in the report.
  3. Enter an SSID User Name, which is the user name assigned by IBM. 
  4. Select a Batch File Type of Normal Processing or Validate SSIDs. The option selected reportes at the beginning of the extract.
  5. Select the Format in which the report should be generated. Use State Format (CSV) for submission to the state or HTML for data review and verification.
  6. Select which Calendar(s) should be included in the report.
  7. Click Generate Extract to view the report in the designated format.


 Image 2: SSID Extract - State Format (CSV) 


 Image 3: SSID Extract - HTML Format - Students w/o SSIDs Selected 

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 this value 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. Reports the Building IRN Override from the student's Enrollment, or the State School Number if the Override is null.


Numeric, 6 digits

Student Information > General > Enrollments > State Reporting Fields > Building IRN Override; System Administration > Resources > School > School Editor > State School Number


Enrollment.buildingIRNOverride

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.


Identity.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 

 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