The SAT PreID extract generates PreIDs for students taking the SAT assessment or a PSAT assessment. All 11th grade students in Ohio are required to take the SAT test.
Image 1: Ohio SAT PreID Extract Editor
Report Logic
Students report based on the most recent enrollment within the date range with a Service Type of P or N. Enrollments marked as No Show or Exclude and Grade Levels or Calendars marked as Exclude do not report.
Generating the Extract
- Enter the Date Range in mmddyy format or by clicking the calendar icons and selecting dates.
- Select which calendar(s) to include within the extract.
- Select a Test Indicator to indicate which SAT or PSAT assessment to report.
- Select the Format of the generated report. For submission to the State, select the State Format (CSV), or select HTML to review data prior to submission.
- Select an Ad hoc Filter, if applicable.
- Indicate if the extract should Include Protected Identity Info.
- Click the Generate Extract button to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Image 2: SAT PreID extract - State Format (CSV)
Image 3: SAT PreID extract - HTML
Extract Layout
If the Include Protected Identity Info checkbox is marked in the extract editor, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.
Element Name | Description & Format | Campus Location |
|---|---|---|
| AI Code | The Attending Institution (AI) Code is a unique identifying number for schools. Reports SAT Attending Institution Code. Numeric, 1 digit | System Administration > Resources > School > SAT Attending Institution Code School.satInstitutionCode |
| PSAT 8/9 Test Indicator | Indicates if the student's registration is for a PSAT 8/9 test. Reports as Y if the Test Indicator is PSAT 8/9. Otherwise reports as N. A PSAT 8/9 event must also be selected during file submission. (Each student must have at least one test indicatorselected. More than one may be selected with the exception of the PSAT 10 Indicator Alphanumeric, 1 character | OH State Reporting > SAT PreID > Test Indicator Not Dynamically Stored |
| PSAT 10 Test Indicator | Indicates if the student's registration is for The PSAT 10 test. Reports as Y if the Test Indicator is PSAT10. Otherwise reports as N. A PSAT 10 event must also be selected during file submission. (Each student must have at least one test indicator selected. More than one may be selected with the exception of the PSAT 10 Indicator Alphanumeric, 1 character | OH State Reporting > SAT PreID > Test Indicator Not Dynamically Stored |
| PSAT/NMSQT Test Indicator | Indicates if the student's registration is for the PSAT/NMSQT test. Reports as Y if the Test Indicator is PSAT/NMSQT. Otherwise reports as N. A PSAT/NMSQT event must also be selected during file submission. (Each student must have at least one test indicator selected. More than one may be selected with the exception of the PSAT 10 Indicator Alphanumeric, 1 character | OH State Reporting > SAT PreID > Test Indicator Not Dynamically Stored |
| SAT Test Indicator | Indicates if the student's registration is for the SAT test. Reports as Y if the Test Indicator is SAT. Otherwise reports as N. The SAT event must also be selected during file submission. (Each student must have at least one test indicator selected. More than one may be selected with the exception of the PSAT 10 Indicator Alphanumeric, 1 character | OH State Reporting > SAT PreID > Test Indicator Not Dynamically Stored |
| Last Name | The student’s last name. If the Include Protected Identity Info checkbox is marked, reports the Legal Last Name. Otherwise, reports the Last Name. Alphanumeric, 35 characters | Census > People > Demographics > Person Information > Last Name Census > People > Identities > Legal Last Name Identity.lastName |
| First Name | The student’s first name. If the Include Protected Identity Info checkbox is marked, reports the Legal First Name. Otherwise, reports the First Name. Alphanumeric, 20 characters | Census > People > Demographics > Person Information > First Name Census > People > Identities > Legal First Name Identity.firstName |
| Middle Initial | The first letter of the student's middle name. If the Include Protected Identity Info checkbox is marked, reports the first initial of the Legal Middle Name. Otherwise, reports the first initial of the Middle Name. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Middle Name Identity.middleName |
| Sex | The student's gender. If the Include Protected Identity Info checkbox is marked, reports the Legal Gender. Otherwise, reports the Gender. Alphanumeric, 1 character | Census > People > Identities > Legal Gender Census > People > Demographics > Gender Identity.Gender |
| Date of Birth | The date on which the individual being reported was born. YYYYMMDD, 8 characters | Census > People > Demographics > Birth Date Identity.birthDate |
| Grade | The State Grade Level of the grade in which the student is enrolled. Reports as 10, 11, or 12. Numeric, 2, digits | Student Information > General > Enrollments > Grade GradeLevel.stateGrade Enrollment.grade |
| Ethnicity: Not Hisp/Lat | The student's ethnicity. If the student is Hispanic/Latino, reports No. If null, reports Y. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.hispanicEthnicity |
| Ethnicity: Cuban | The student's ethnicity. Does not report. Alphanumeric, 1 character | N/A |
| Ethnicity: Mexican | The student's ethnicity. Does not report. Alphanumeric, 1 character | N/A |
| Ethnicity: Puerto Rican | The student's ethnicity. Does not report. Alphanumeric, 1 character | N/A |
| Ethnicity: Other | The student's ethnicity. Does not report. Alphanumeric, 1 character | N/A |
| Race: Am Ind/Ak | The student's race. If the student is an American Indian or Alaska Native, reports Y. Otherwise, reports as blank. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race: Asian | The student's race. If the student is Asian, reports Y. Otherwise, reports as blank. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race: Bl/Afr Am | The student's race. If the student is Black or African American, reports Y. Otherwise, reports as blank. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race: Nh/Pacif | The student's race. If the student is a Native Hawaiian or Other Pacific Islander, reports as Y. Otherwise, reports as blank. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race: White | The student's race. If the student is White, reports as Y. Otherwise, reports as blank. Alphanumeric, 1 character | Census > people > Demographics > Race/Ethnicity Identity.raceEthnicity |
| Mailing Street Address | The student's mailing street address. Alphanumeric, 50 characters | Census > Household > Address > Number, Prefix, Street, Tag, Direction, Apt Address.number Address.prefix Address.street Address.tag Address.direction Address.apt |
| Mailing Street Address 2 | The student's mailing street address. Does not report. Alphanumeric, 50 characters | N/A |
| Mailing City | The student's mailing city name as indicated in the student's primary household address. Alphanumeric, 50 characters | Census > Household > Address > Number, Prefix, Street, Tag, Direction, Apt Address.number Address.prefix Address.street Address.tag Address.direction Address.apt |
| Mailing State Abbreviation | The student's mailing state abbreviation as indicated in the student's primary household address. Alphanumeric, 2 characters | Census > Household > Address > Number, Prefix, Street, Tag, Direction, Apt Address.number Address.prefix Address.street Address.tag Address.direction Address.apt |
| Mailing Zip Code | The student's zip code as indicated in the student's primary household address. Numeric, 10 digits | Census > Household > Address > Number, Prefix, Street, Tag, Direction, Apt Address.number Address.prefix Address.street Address.tag Address.direction Address.apt |
| Mailing Country code | The student's two character mailing country code. Does not report. Alphanumeric, 2 characters | N/A |
| Phone | The student's telephone number. Does not report. Alphanumeric, 2 characters | N/A |
| The student's email address. Alphanumeric, 50 characters | Census > People > Demographics > Personal Contact Information > Email Contact.email | |
| State Student ID Number | The student ID number. Reports the State ID. Numeric, 30 digits | Census > People > Demographics > Person Identifier > Student State ID Person.stateID |
| District Student ID Number | The student's local identification number. Numeric, 30 digits | Census > People > Demographics > Person Identifier > Local Student Number Person.studentNumber |
| School Student ID Number | The student's school identification number. Does not report. Numeric, 30 digits | N/A |
| Free and Reduced Lunch | Does not report. Alphanumeric, 1 character | N/A |
| SAT Test Center | Does not report. Alphanumeric, 5 characters | N/A |
| Sort Group | Does not report. Alphanumeric, 10 characters | N/A |
