S_OH_STU_HISTORY_C ver 17.9.0
This table is a child table of the [Students] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
Unique_ID | 17.9.0 | Number | Unique ID for the record. Migrated from [OH_student_history.unique_ID]. |
ForeignKey | 17.9.0 | Number | Primary key that relates the child table back to the Students table. Migrated from [OH_student_history.foreignKey]. |
ForeignKey_alpha | 17.9.0 | Varchar2(31) | Legacy field that is being migrated. Migrated from [OH_student_history.foreignKey_alpha]. |
Admission_date | 17.9.0 | Varchar2(10) | Student's most recent admission date to the district. Migrated from [OH_student_history.admission_date]. |
Admission_reason | 17.9.0 | Varchar2(1) | Describes how the student arrived at the district. Migrated from [OH_student_history.admission_reason]. |
Admitted_From_IRN | 17.9.0 | Varchar2(6) | Identifies the prior public or nonpublic school where the student was enrolled. Migrated from [OH_student_history.admitted_from_irn]. |
Assigned_Builiding_IRN | 17.9.0 | Varchar2(6) | Identifies the IRN of the building the student would normally attend according to the standard district attendance policy. Migrated from [OH_student_history.assigned_building_irn]. |
Attendance_pattern | 17.9.0 | Varchar2(2) | The pattern of attendance which a student attends on a weekly basis (prior to FY14). Migrated from [OH_Student_History.attendance_pattern]. Obsolete field. |
Attending_Building_IRN | 17.9.0 | Varchar2(6) | Identifies the IRN of the building within the district that the student attends between the effective dates, inclusive, of the record being reported. Migrated from [OH_student_history.attending_building_irn]. |
County_of_residence | 17.9.0 | Varchar2(20) | Identifies the two-digit State of Ohio designation of the county of the student’s domicile. Migrated from [OH_student_history.county_of_residence]. |
Disability_condition | 17.9.0 | Varchar2(2) | Describes the disability of a student. Migrated from [OH_Student_History.disability_condition]. |
Disadvantagement | 17.9.0 | Varchar2(1) | Identifies if a student meets the definition of economic and/or academic disadvantage. Migrated from [OH_Student_History.disadvantagement]. |
District_Relationship | 17.9.0 | Varchar2(1) | Describes the educational relationship between the student and the district. Migrated from [OH_student_history.district_relationship]. |
Effective_end_date | 17.9.0 | Date | Effective end date for the record. Migrated from [OH_student_history.user_defined_date]. |
Foreign_Exch_Grad_Plan | 17.9.0 | Varchar2(1) | The foreign exchange status of a student as it relates to the student’s graduation plan. Migrated from [OH_Student_History.foreign_exchange_grad_plan]. |
Homeless_status | 17.9.0 | Varchar2(1) | Identifies if a homeless student. Migrated from [OH_Student_History.homeless_status]. |
Homeless_Unaccompanied | 17.9.0 | Varchar2(1) | Identifies if a homeless student is in the physical custody of a parent or guardian. [OH_Student_History.homeless_unaccompanied]. |
Hours_Excused | 17.9.0 | Varchar2(7) | Override to manually report student's excused absences. Migrated from [OH_student_history.Hrs_excused]. |
Hours_Present | 17.9.0 | Varchar2(7) | Override to manually report student's days in attendance. Migrated from [OH_student_history.Hrs_present]. |
Hours_Unexcused | 17.9.0 | Varchar2(7) | Override to manually report student's unexcused absences. Migrated from [OH_student_history.Hrs_unexcused]. |
How_Received | 17.9.0 | Varchar2(1) | Describes how the student arrived in the district. Migrated from [OH_student_history.How_received]. |
How_Received_IRN | 17.9.0 | Varchar2(20) | Identifies the entity from which a student is received. Migrated from [OH_student_history.How_received_irn]. |
Immigrant_status | 17.9.0 | Varchar2(1) | Identifies if the student is an immigrant per Section 3301 (6) of the Elementary and Secondary Education Act. [OH_Student_History.immigrant_status]. |
Legal_district_residence | 17.9.0 | Varchar2(6) | Student's legal district of residence for the record. Migrated from [OH_student_history.legal_district_residence]. |
Limited_English_Proficiency | 17.9.0 | Varchar2(1) | The Limited English Proficiency status of a student. [OH_Student_History.limited_english_proficiency]. |
Local_Attendance_Pattern | 17.9.0 | Varchar2(2) | The district's locally defined attendance patterns for specific groups of students.(Post-FY15) Migrated from [OH_Student_History.local_attendance_pattern]. |
Migrant_Status | 17.9.0 | Varchar2(1) | The migrant status of student. Migrated from [OH_Student_History.migrant_status]. |
Percent_of_Time | 17.9.0 | Varchar2(3) | Identifies the average percent of time, for the week, that the student participates in any instruction provided by a certified/licensed employee. Migrated from [OH_student_history.percent_of_time]. |
Plan_504 | 17.9.0 | Varchar2(1) | Identifies if a student is identified and served with a disability under Section 504 of the Rehabilitation Act of 1973. Migrated from [OH_Student_History.504_plan]. |
Preschool_Poverty_Level | 17.9.0 | Varchar2(1) | The poverty level of the preschool student’s family. Migrated from [OH_Student_History.preschool_poverty_level]. |
SchoolID | 17.9.0 | Number | School associated with the record. Migrated from [OH_student_history.schoolID]. |
Sent_Reason_1 | 17.9.0 | Varchar2(2) | Identifies the reason a student is sent to a another district. Migrated from [OH_student_history.sent_reason_1]. |
Sent_Reason_2 | 17.9.0 | Varchar2(2) | Identifies the reason a student is sent to a second district. Migrated from [OH_student_history.sent_reason_2]. |
Sent_To_IRN_1 | 17.9.0 | Varchar2(6) | Identifies the district to which a student is being sent. Migrated from [OH_student_history.Sent_To_IRN_1]. |
Sent_To_IRN_2 | 17.9.0 | Varchar2(6) | Identifies the district to which a student is being sent,if the student is simultaneously being sent to a second district. Migrated from [OH_student_history.Sent_To_IRN_2]. |
Sent_To_POT_1 | 17.9.0 | Varchar2(3) | Identifies the average percent of time, for the week, that the student participates in any instruction provided by a non-EMIS reporting entity. Migrated from [OH_student_history.Sent_To_POT_1]. |
Sent_To_POT_2 | 17.9.0 | Varchar2(3) | Identifies the average percent of time, for the week, that the student participates in any instruction provided by a non-EMIS reporting entity. Migrated from [OH_student_history.Sent_To_POT_2]. |
State_Equiv_Grade | 17.9.0 | VarChar2(2) | The grade level in which the student is included for reporting purposes. [OH_Student_History.state_equiv_grade]. |
State_student_id | 17.9.0 | Varchar2(9) | Student's State Student ID number. Migrated from [OH_student_history.state_student_id]. |
Tuition_Type | 17.9.0 | Varchar2(1) | Identifies the manner in which the student is paying tuition to the reporting district. Migrated from [OH_student_history.tuition_type]. |
Withdrawn_To_IRN | 17.9.0 | Varchar2(6) | Identifies the IRN of a public or nonpublic school into which the student will be enrolling. Migrated from [OH_student_history.withdrawn_to_irn]. |