SAT PreID (Ohio)

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

  1. Enter the Date Range in mmddyy format or by clicking the calendar icons and selecting dates.
  2. Select which calendar(s) to include within the extract.
  3. Select a Test Indicator to indicate which SAT or PSAT assessment to report.
  4. 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. 
  5. Select an Ad hoc Filter, if applicable.
  6. Indicate if the extract should Include Protected Identity Info.
  7. 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 CodeThe 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
and the PSAT/NMSQT 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
and the PSAT/NMSQT 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
and the PSAT/NMSQT 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
and the PSAT/NMSQT 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 InitialThe 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

GradeThe 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/LatThe 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: CubanThe student's ethnicity. Does not report.

Alphanumeric, 1 character
N/A
Ethnicity: MexicanThe student's ethnicity. Does not report.

Alphanumeric, 1 character
N/A
Ethnicity: Puerto RicanThe student's ethnicity. Does not report.

Alphanumeric, 1 character
N/A
Ethnicity: OtherThe student's ethnicity. Does not report.

Alphanumeric, 1 character
N/A
Race: Am Ind/AkThe 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: AsianThe 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 AmThe 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/PacifThe 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: WhiteThe 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 AddressThe 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 2The student's mailing street address. Does not report.

Alphanumeric, 50 characters
N/A
Mailing CityThe 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 CodeThe 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
PhoneThe student's telephone number. Does not report.

Alphanumeric, 2 characters
N/A
EmailThe 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 NumberThe student's local identification number.

Numeric, 30 digits
Census > People > Demographics > Person Identifier > Local Student Number

Person.studentNumber
School Student ID NumberThe student's school identification number. Does not report.

Numeric, 30 digits
N/A
Free and Reduced LunchDoes not report.

Alphanumeric, 1 character
N/A
SAT Test CenterDoes not report.

Alphanumeric, 5 characters
N/A
Sort GroupDoes not report.

Alphanumeric, 10 characters
N/A