Pre-ID Ohio State Assessment Extract

Schools for which to run?*

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students*

Indicate which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.
• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students before running the report.

Block Scheduling Override (default today’s date)

Indicate a date for which student records should be extracted. The date must be during the block course start and end dates.

JVSD*

Select Yes if a JVS entity is running the report.

Alternate Assessment (Grade Level)

Select the grade levels for the report for students taking an Alternate Assessment.

Re-Take Assessment Override*

Select if the student(s) to be included in the file are only retake students with applicable data entered on the PreID tab.

Grade 3-8 Tests

Select the test Mode for the appropriate test(s). If any 3- through 8-grade levels are checked on the Alternate Assessment (Grade Level) parameter, the opportunity to select a test mode will display for the appropriate assessment based on grade level.

Test Override*

Select if pre-selected students have been identified and are to be assigned to the selected tests. No course/staff information will be included.

OELPA Test*

Select if the file is for students who are required to take the OELPA.

High School Tests

Select the test Mode for the appropriate test(s).  If any 9- through 12-grade levels are checked on the Alternate Assessment (Grade Level) parameter, the opportunity to select a test mode will display for the appropriate assessments.

Scheduling

Run Now

Select this option to execute the report in the order it is received in the report queue.

Schedule (available Version 7.1.1.)

Enter the start date and start time for the report.

• Select Run Once and Submit to run the report at the specified date and time.
• Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

1

Attending District IRN

The number identifying the school district the student attends. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.

[Prefs]DistrictNumber

CST_SUBDISTRICTS.Subdistrict_number

Alpha-numeric

6

1–6

2

Attending District Name

The name of the district. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.

[Prefs]DistrictName

Alpha-numeric

30

7-36

3

Attending School IRN

The number identifying the school the student attends. This field value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info.

[S_OH_STU_FS_X]Attending_Building_IRN

or

[S_OH_STU_COMMON_X]Building_IRN

or

District default – School Number

or

Alt School Number

Alpha-numeric

6

37-42

4

Attending School Name

The name of the school. This field value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info.

[Schools]Name

Alpha-numeric

30

43–72

5

Statewide Student Identifier (SSID)

The student ID number assigned by the State of Ohio to this student. This value is extracted from the FS tab, Start Page > Student Selection > Ohio State Information - Student Standing Record (FS).

[Students]State_StudentNumber

Alpha-numeric

9

73-81

6

District Student ID Number (DSID)

The student number as assigned by the district.

[Students]Student_Number

Alpha-numeric

9

82-90

7

Last Name

The student’s last name. This value is extracted from the Demographics page, Start Page > Student Selection > General Demographics.

[Students]Last_Name

Alpha-numeric

35

91-125

8

First Name

The student’s first name. This value is extracted from the Demographics page, Start Page > Student Selection > General Demographics.

[Students]First_Name

Alpha-numeric

35

126-160

9

Middle Name

The middle name of the student. This value is extracted from the Demographics page, Start Page > Student Selection > General Demographics. If a student has no middle name and the field contains an asterisk to reflect this, the Middle Name will be reported as blank.

[Students]Middle_Name

Alpha-numeric

35

161-195

10

Date of Birth (YYYY-MM-DD)

The month of the student’s date of birth. This value is extracted from the Demographics page, Start Page > Student Selection > General Demographics.

[Students]DOB

Numeric

10

196-205

11

Gender

The student’s gender. This value is extracted from the This field contains the student ID number assigned by the State of Ohio to this student. This value is extracted from the Demographics page, Start Page > Student Selection > General Demographics.

[Students]Gender

Numeric

1

206

12

Enrolled Grade

The grade level in which the student is currently enrolled. This value is extracted from the Transfer Info page, Start Page > Student Selection > Transfer Information.

[Students]Grade_Level

Alpha-numeric

2

207-208

13

Demographic race two or more races

This value = Y when the student has more than one race identified, else ‘N’. This value is extracted from the Demographics tab, Start Page > Student Selection > General Demographics.

[StudentRace]RaceCd

Alpha-numeric

1

209

14

Hispanic or Latino Ethnicity

This value = Y when the student’s Ethnicity is marked ‘Yes’, else ‘N’. This value is extracted from the Demographics tab, Start Page > Student Selection > General Demographics.

[Students]FedEthnicity

Alpha-numeric

1

210

15

American Indian or Alaska Native

This value = Y when this race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

211

16

Asian

This value = Y when this race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

212

17

Black or African American

This value = Y when this race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

213

18

Native Hawaiian or Other Pacific Islander

This value = Y when this race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

214

19

White

This value = Y when this race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

215

20

Other/Unknown

This value = Y when no race is identified for the student from the Demographics tab, Start Page > Student Selection > General Demographics, else ‘N’.

[StudentRace]RaceCd

Alpha-numeric

1

216

21

Test Eligibility: AASCD

This value = Y based on the latest AIEP, IIEP, REIP, or TIEP, where the IEP Test Type = ALT, else ‘N’. The value is extracted from the Special Program Enrollment Page, Start Page > Student Selection > Special Programs > Edit Special Program Enrollment or if the user hand selects students and uses the IEP Test Type Override field on the report parameter page.

[S_OH_SPENROLLMENTS_X]SpecialEd_Date_Type

and

[S_OH_SPENROLLMENTS_X]Test_Type

Alpha-numeric

1

217

22

Accelerated ELA Grade

The grade level in which the student is accelerated. If the value = 3-8, that value is extracted, else blank. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID.

[S_OH_STU_PREID_X]AT_Reading

Numeric

1

218

23

Accelerated Mathematics Grade

The grade level in which the student is accelerated. If the value = 3-8, that value is extracted, else blank. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID.

[S_OH_STU_PREID_X]AT_Math

Numeric

1

219

24

Accelerated Social Studies Grade

The grade level in which the student is accelerated. If the value = 4 or 6 that value is extracted, else blank. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID.

[S_OH_STU_PREID_X]AT_SocialStudies

Numeric

1

220

25

Accelerated Science Grade

The grade level in which the student is accelerated. If the value = 5 or 8 that value is extracted, else blank. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID.

[S_OH_STU_PREID_X]AT_Science

Numeric

1

221

26

Test mode: ELA (Grades 3-8)

The parameter value as set on the State Reports page, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

222

27

Test mode: Mathematics (Grades 3-8)

The parameter value as set on the State Reports page, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

223

28

Test mode: HS Social Studies Alternate Assessment

The parameter value as set on the State Reports page, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

224

29

Test mode: Grade 5 or 8 Science

The parameter value as set on the State Reports page, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

225

30

Test eligibility & mode: HS ELA 1

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 050160, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

226

31

Test eligibility & mode: HS ELA 2

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 050170, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

227

32

Test eligibility & mode: Algebra 1

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 110065, 110301, or 110480, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

228

33

Test eligibility & mode: Geometry

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 111200 or 110490, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

229

34

Test eligibility & mode: Integrated Mathematics 1

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 110065, 110480, or 110010, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

230

35

Test eligibility & mode: Integrated Mathematics 2

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject code, 110020 or 110490, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract

NA

Alpha-numeric

1

231

36

Test eligibility & mode: American Government

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject codes, 150300, 150308, or 159950, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

232

37

Test eligibility & mode: American History

The parameter value as set on the State Reports page, if the student is enrolled in a course with subject codes, 150810 or 152300, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

233

38

Test eligibility & mode: Biology

The parameter value as set on the State Reports page, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

234

39

Test eligibility & mode: Physical Science

The parameter value, as set on the State Reports page, if the student is enrolled in a course with subject code, 132220, Start Page > Reports > Reports (State Reports) > Pre-ID Ohio State Assessment Extract.

NA

Alpha-numeric

1

235

40

Test eligibility & mode: OELPA

Test eligibility & mode: ELPA21 Screener

An indicator of whether the student is eligible to take the Ohio English Language Proficiency Assessment (OELPA) or the ELPA21 Screener.

Students identified with an L, M, S or Y on the FD Tab, Start Page > Student Selection > Ohio State Information - Effective Date Record (FD), Limited English Proficiency field will be extracted when the parameter is set to extract.

Students identified with a checkmark on the Pre-ID Tab, Start Page > Student Selection > Ohio State Information - Pre-ID ELPA21 Screener will be extracted when the parameter ELPA21 Screener is set to extract.

[S_OH_STU_FD_X]Limited_English_Proficiency

[S_OH_STU_PREID_X]ELPAScreener

Alpha-numeric

1

236

41

Limited English Proficient (LEP)

This value = Y where the student LEP status = Y, L or M on the FD Tab, Start Page > Student Selection > Ohio State Information - Student Attributes - Effective Date Record (FD), else ‘N’.

[S_OH_STU_FD_X]Limited_English_Proficiency

Alpha-numeric

1

237

42

Migrant Student

This value = Y when the student is identified as migrant = Y on the FD Tab, Start Page > Student Selection > Ohio State Information - Student Attributes - Effective Date Record (FD), else ‘N’.

[S_OH_STU_FD_X]Migrant_Status

Alpha-numeric

1

238

43

Gifted and Talented

This value = Y when identified as gifted on the Gifted Tab, Start Page > Student Selection > Ohio State Information - Student Gifted Education Record, else N.

[S_OH_STU_GIFTED_C]Type

and

[S_OH_STU_GIFTED_C]Identification

Alpha-numeric

1

239

44

504

This value = Y when the student is identified as 504 on the FD Tab, Start Page > Student Selection > Ohio State Information - Student Attributes - Effective Date Record (FD), else ‘N’.

[S_OH_STU_FD_X]Section_504

Alpha-numeric

1

240

45

IEP

This value = Y when the student is identified with a disability on the FD Tab, Start Page > Student Selection > Ohio State Information - Student Attributes - Effective Date Record (FD), else ‘N’.

[S_OH_STU_FD_X]Disability

Alpha-numeric

1

241

46

Primary Disability Category

This field is mapped to the disability noted on the FD Tab, Start Page > Student Selection > Ohio State Information - Student Attributes - Effective Date Record (FD).

The Disability Category /OH Disability mapping:

AUT = Autism=12

DB = Deaf/Blindness=02

EMN = Emotional disturbance=08

HI =Hearing impairment=03

ID=Intellectual Disability=09

MD=Multiple disabilities=01

OI=Orthopedic impairment=06

OHI=Other health impairment=14 or 15

SLD = Specific learning disability=10

SLI=Speech or language impairment=05

TBI=Traumatic brain injury=13

VI=Visual impairment=04

Blank=** or blank

[S_OH_STU_FD_X]Disability

Alpha-numeric

3

242-244

47

Accommodations - ELA

N/A

1

245

48

Accommodations - Mathematics

N/A

1

246

49

Accommodations – Social Studies

N/A

1

247

50

Accommodations - Science

N/A

1

248

51

Home Room

The Home Room PID to be identified with the student.

[S_OH_STU_PREID_X]PID_Room

Alpha-numeric

38

249-286

52

Staff Member

The homeroom teacher associated with the Home Room PID identified on the Pre-ID Tab.

Alpha-numeric

30

287-316

53

Section Number/ClassName/Course Code—ELA or HS ELA 1

The ELA or ELA 1 course in which the student is currently enrolled. A course is identified by the course subject code(s)

Note: If the course is not identified as an ELA or HS ELA 1 course, this field is blank in the extract.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

317-336

54

Section Number/ClassName/Course Code—HS ELA 2

The HS ELA 2 course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a HS ELA 2 course, this field is blank in the extract.

[CC] Section_Number

[CC]Course_Number

Alpha-numeric

20

337-356

55

Section Number/ClassName/Course Code—Mathematics or Integrated Mathematics 1

The Mathematics or Integrated Mathematics 1 course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a Mathematics or Integrated Mathematics 1 course, this field is blank in the extract.

[CC] Section_Number

[CC]Course_Number

Alpha-numeric

20

357-376

56

Section Number/ClassName/Course Code—Integrated Mathematics 2

The Integrated Mathematics 2 course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as an Integrated Mathematics 2 course, this field is blank in the extract.

[CC] Section_Number

[CC]Course_Number

Alpha-numeric

20

377-396

57

Section Number/ClassName/Course Code—Algebra 1

The Algebra 1 course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as an Algebra 1 course, this field is blank in the extract.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

397-416

58

Section Number/ClassName/Course Code—Geometry

The Geometry course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a Geometry course, this field is blank in the extract.

[CC] Section_Number

[CC]Course_Number

Alpha-numeric

20

417-436

59

Section Number/ClassName/Course Code—Social Studies or American History

The Social Studies or American History course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a Social Studies or American history course, this field is blank in the extract.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

437-456

60

Section Number/ClassName/Course Code—American Government

The American Government course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as an American Government course, this field is blank in the extract.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

457-476

61

Section Number/ClassName/Course Code—Physical Science or Science

The Physical Science or Science course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a Physical Science or Science course, this field is blank in the extract.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

477-496

62

Section Number/ClassName/Course Code—Biology

The Biology course in which the student is currently enrolled. A course is identified by the course subject code.

[CC]Section_Number

[CC]Course_Number

Alpha-numeric

20

497-516

63

Teacher Name – ELA or HS ELA 1

The name of the teacher that teaches the ELA or HS ELA 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an ELA or HS ELA 1 course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

517-536

64

Teacher Name –HS ELA 2

The name of the teacher that teaches the HS ELA 2 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a HS ELA 2 course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

537-556

65

Teacher Name – Mathematics or Integrated Mathematics 1

The name of the teacher that teaches the Mathematics or Integrated Mathematics 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Mathematics or Integrated Mathematics 1 course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

557-576

66

Teacher Name –Integrated Mathematics 2

The name of the teacher that teaches the Integrated Mathematics 2 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an Integrated Mathematics 2 course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

577-596

67

Teacher Name –Algebra 1

The name of the teacher that teaches the Algebra 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an Algebra 1 course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

597-616

68

Teacher Name –Geometry

The name of the teacher that teaches the Geometry course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Geometry course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

617-636

69

Teacher Name – Social Studies or American History

The name of the teacher that teaches the Social Studies or American History course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Social Studies or American History course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

637-656

70

Teacher Name – American Government

The name of the teacher that teaches the American Government course in which the student is currently enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an American Government course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

657-676

71

Teacher Name – Physical Science or Science

The name of the teacher that teaches the Physical Science or Science course in which the student is currently enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Physical Science or Science course, this field is blank in the extract.

[Users]LastFirst

Alpha-numeric

20

677-696

72

Teacher Name – Biology

The name of the teacher that teaches the Biology course in which the student is currently enrolled. A course is identified by the course subject code.

[Users]LastFirst

Alpha-numeric

20

697-716

73

Teacher Identification Number – ELA or HS ELA 1

The Ohio Credential ID of the teacher that teaches the ELA or HS ELA 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an ELA or HS ELA 1 course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

717-725

74

Teacher Identification Number –HS ELA 2

The Ohio Credential ID of the teacher that teaches the HS ELA 2 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a HS ELA 2 course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

726-734

75

Teacher Identification Number – Mathematics or Integrated Mathematics 1

The Ohio Credential ID of the teacher that teaches the Mathematics or Integrated Mathematics 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Mathematics or Integrated Mathematics 1 course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

735-743

76

Teacher Identification Number –Integrated Mathematics 2

The Ohio Credential ID of the teacher that teaches the Integrated Mathematics 2 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an Integrated Mathematics 2 course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

744-752

77

Teacher Identification Number –Algebra 1

The Ohio Credential ID of the teacher that teaches the Algebra 1 course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an Algebra 1 course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

753-761

78

Teacher Identification Number –Geometry

The Ohio Credential ID of the teacher that teaches the Geometry course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Geometry course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

762-770

79

Teacher Identification Number – Social Studies or American History

The Ohio Credential ID of the teacher that teaches the Social Studies or American History course in which the student is enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Social Studies or American History course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

771-779

80

Teacher Identification Number – American Government

The Ohio Credential ID of the teacher that teaches the American Government course in which the student is currently enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as an American Government course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

780-788

81

Teacher Identification Number – Physical Science or Science

The Ohio Credential ID of the teacher that teaches the Physical Science or Science course in which the student is currently enrolled. A course is identified by the course subject code.

Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information.

If the course is not identified as a Physical Science or Science course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

20

789-797

82

Teacher Identification Number – Biology

The Ohio Credential ID of the teacher that teaches the Biology course in which the student is currently enrolled. A course is identified by the course subject code.

Note: If the course is not identified as a Biology course, this field is blank in the extract.

[S_OH_USR_X]Teacher_Credential_ID

or

[Users]SSN,

or

[SchoolStaff]SchoolID and [Users]TeacherNumber

Alpha-numeric

9

798-806

83

Home District (JVS Only)

The Home District IRN of the student taking an applicable course at the JVS. This field value is extracted from the Start Page > Student Selection > Ohio State Information - Student Standing Record (FS).

[S_OH_STU_FS_X]How_Received_IRN

or

[Students]districtofresidence

Alpha-numeric

6

807-812

84

Home District Name (JVS Only)

The Home District Name of the student taking an applicable course at the JVS.

Alpha-numeric

30

813-842

85

Home School IRN (JVS Only)

Alpha-numeric

6

843-848

86

Home School Name (JVS Only)

The name of the student's home school, if a name is present in the Code Set Home Building IRN.  If the Code Set is blank, nothing is included.

Code Set Home Building IRN

Alpha-numeric

30

849-878