Tool Search: 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.
SSID Extract EditorReport 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
- Enter a Snapshot Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Indicate if only Students w/o SSIDs should be included in the report.
- Enter an SSID User Name, which is the user name assigned by IBM.
- Select a Batch File Type of Normal Processing or Validate SSIDs. The option selected reportes at the beginning of the extract.
- 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.
- Select which Calendar(s) should be included in the report.
- Click Generate Extract to view the report in the designated format.
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. 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 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 |
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 |
