(FN) Student Attributes — No Date Record
Contents
Introduction
The (FN) Student Attributes — No Date Record extract contains data for students which are not date qualified such as enrolled students who were absent from school for the entire week of the district’s count week and graduation related information.
Note that in some reporting periods, very little data will be reported on this record, as most elements are not included in all reporting periods.
You must create requirements for one graduation set for the CORE Economics and Financial Literacy element and one graduation set for the CORE Fine Arts element prior to generating this extract. If the CORE Economics and Financial and CORE Fine Arts requirement fields are blank on the State/Province – OH page FN tab, the CORE Economics and Financial and CORE Fine Arts requirements included in the extract are calculated based on the graduation sets. This calculation works as follows.
CORE Economics and Financial Requirement
Based on the graduation set chosen for the Grad Set to Use for Core Econ field on the report interface, the program will determine whether or not the student meets the required number of passing credit hours for each requirement. When the requirement type is Course Number or Course Group, the earned credit hours for each historical grade are summed for those specific courses in the historical grade records of the student. When the requirement type is Credit Type, the earned credit hours for each historical grade are summed for that credit type for all courses linked to historical grades for that student. If the requirements are met, Y is extracted for the CORE Economics and Financial Literacy Requirement Met; otherwise, N is extracted.
CORE Fine Arts Requirement
Based on the graduation set chosen for Grad Set to Use for Core Arts field on the report interface, the program will determine whether or not the student meets the required number of passing credit hours for each requirement. When the requirement type is Course Number or Course Group, the earned credit hours for each historical grade are summed for those specific courses in the historical grade records of the student. When the requirement type is Credit Type, the earned credit hours for each historical grade are summed for that credit type for all courses linked to historical grades for that student. If the requirements are met, Y is extracted for the CORE Economics and Financial Literacy Requirement Met; otherwise, N is extracted.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Student Attributes — No Date Record, student records are selected. The data is extracted from from the FN tab, Start Page > Student Selection > Ohio State Information > FN, unless otherwise noted.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- For the (S) Students Reporting Period:
- The student is enrolled at any time between the Start and End Dates.
- The student is not excluded from state reporting (Start Page > Student Selection > Ohio State Information - Home State_ExcludeEnrollment).
- The student is not identified as a ‘Grad Only’ Student (Start Page > Student Selection > Ohio State Information - Home)
- For the (G) Graduate Reporting Period:
- The student was exited any time between the Start and End Dates and has an exit code of 99, including students identified as ‘Grad Only’ students (Start Page > Student Selection > Ohio State Information – Home)
- The student is not excluded from state reporting (Start Page > Student Selection > Ohio State Information - Home).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
The report input is done in Incident Management with the codes and subcodes used in IM.
Field | Description |
Schools for which to run? | Choose one of the following from the pop-up menu:
|
Report Start Date | Enter the start date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY |
Report End Date | Enter the end date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY |
Current Selection of Students* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Grade Set to Use for Core Arts | Select the graduation set to use to determine if a student has met the CORE Fine Arts graduation requirement. This calculation is used only if the CORE Fine Arts Requirements Met field on the Student Attributes — Effective Date Record page, Start Page > Reports > Run Reports > Student Attributes — No Date Record (FN), is blank for the student. |
Grade Set to Use for Core Econ | Select the graduation set to use to determine if a student has met the CORE Economics and Financial Literacy graduation requirement. This calculation is used only if the CORE Economic and Financial Requirements Met field on the Student Attributes — Effective Date Record page, Start Page > Reports > Run Reports > Student Attributes — No Date Record (FN), is blank for the student. |
Reporting Period | Select the reporting period for which you are creating the extract. |
Fiscal Year | Enter the fiscal year for the report. |
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.
|
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin/End Position |
N/A | Filler | Filler | N/A | Numeric | 8 | 1–8 |
FN010 | Sort Type | The sort type equals FN for the Student Attributes — No Date Record extract. | N/A | Alpha-numeric | 2 | 9–10 |
N/A | Filler | Filler | N/A | Alpha-numeric | 1 | 11 |
FN020 | Fiscal Year | The fiscal year entereded on the Student Attributes — Effective Date Record page, Start Page > Reports > Run Reports > Student Attributes — No Date Record (FN). | N/A | Alpha-numeric | 4 | 12–15 |
FN030 | Reporting Period | This is the reporting period selected on the Student Attributes — Effective Date Record page, Start Page > Reports > Run Reports > Student Attributes — No Date Record (FN). | N/A | Alpha-numeric | 1 | 16 |
FN040 | District IRN | This field contains the district number. 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 | 17–22 |
FN050 | EMIS Student ID | This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the General Demographics page, Start Page > Student Selection > General Demographics and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number. | [Students]Student_Number | Alpha-numeric | 9 | 23–31 |
FN060 | Non-Attending Reason Obsolete as of FY15 – reports now as filler | This field contains the reason for counting an enrolled student who was absent from school for the entire week of the district’s count week. | [S_OH_STU_FN_X]Non_Attending_Reason | Alpha-numeric | 1 | 32 |
FN070 | Retained Status | This field contains the student’s retention status if applicable, else ‘*’. | [S_OH_STU_FN_X]Retained_Status (current year) or [S_OH_STU_FN_SNAP_C]Retained_Status (prior year) | Alpha-numeric | 1 | 33 |
FN080 | Grade Level, Next Year | This field contains the student’s grade level for the next school year. | [S_OH_STU_FN_X]Next_Year_Grade (current year) or [S_OH_STU_FN_SNAP_C.]Next_Year_Grade (prior year) | Alpha-numeric | 2 | 34–35 |
FN090 | Diploma Date | This field contains the date the student received a diploma, if applicable, else ‘00000000’ (Not Applicable). | [S_OH_STU_FN_X]Diploma_Date (current year) or [S_OH_STU_FN_SNAP_C]Diploma_Date (prior year) | Numeric | 8 | 36–43 |
FN100 | Diploma Type | This field contains the type of diploma the student received, if applicable, else ‘*’ (Not Applicable). | [S_OH_STU_FN_X]Diploma_Type (current year) or [S_OH_STU_FN_SNAP_C]Diploma_Type (prior year) | Alpha-numeric | 1 | 44 |
FN110 | Fiscal Year Student Began 9th Grade | This field contains the fiscal year that the student started 9th grade, if applicable, else ‘0000’ (Not Applicable). | [S_OH_STU_FN_X]Fiscal_9 (current year) or [S_OH_STU_FN_SNAP_C]Fiscal_9 (prior year) | Numeric | 4 | 45–48 |
FN120 | OGT Graduation Alternative | This field contains a ‘1’ if the student’s passage on one graduation test was met using the alternative criteria, else ‘0’ (Not Used). | [S_OH_STU_FN_X]Grad_Alt (current year) or [S_OH_STU_FN_SNAP_C]Grad_Alt (prior year) | Numeric | 1 | 49 |
FN130 | Graduation Credit Units - Obsolete | This field is calculated from the summed total of all the [StoredGrades]EarnedCRHrs field records for the current student and term that have a credit type that matches the credit type specified on the report user interface; the result is multiplied by 100. Use the following path to edit a student’s earned credit hours: Start Page > Student Selection > Historical Grades > Edit Stored Grade. | N/A | Numeric | 4 with 2 decimal places | 50–53 |
FN140 | Accountability IRN | This field contains the student’s accountability IRN if a student was enrolled simultaneously in two buildings, or participated in a program in another building, not the student’s home building, if applicable, else ‘******’ (Not Applicable). | [S_OH_STU_FN_X]Accountability_IRN (current year) or [S_OH_STU_FN_SNAP_C]Accountability_IRN (prior year) | Alpha-numeric | 6 | 54–59 |
N/A | Filler | Filler | N/A | Alpha-numeric | 7 | 60-66 |
FN210 | LEP Reclassification Date - obsolete as of end of FY17 | This field contains the year and month that the student is no longer considered an LEP student, if applicable, else ‘000000’ (Not Applicable). After FY17 this field is obsolete. | [S_OH_STU_FN_X]LEP_Reclassified_Date (current year) or [S_OH_STU_FN_SNAP_C]LEP_Reclassified_Date (prior year) | Alpha-numeric | 6 | 67–72 |
FN220 | Majority of Attendance IRN | This field contains the student’s majority of attendance IRN number. If the field is left blank on the FN tab, this field is calculated based on the student being continuously enrolled in the district between Friday of the first full week in October and the State designated end date:
| [S_OH_STU_FN_X]Majority_Att_IRN (current year) Calculated field, unless a value is hand entered. or [S_OH_STU_FN_SNAP_C]Majority_Att_IRN (prior year) Calculated and stored, unless a value was hand entered. | Alpha-numeric | 6 | 73–78 |
FN230 | Year End Reported State Student ID (SSID) Element | This field contains the student’s state ID number (SSID), if the SSID was different from the currently reported SSID. | [S_OH_STU_FN_X]Yearend_SSID (current year) or [S_OH_STU_FN_SNAP_C]Yearend_SSID (prior year) | Alpha-numeric | 9 | 79–87 |
FN240 | CORE Economics and Financial Literacy Requirement Met | This field contains ‘Y’ (Yes) to indicate the student has met the CORE Economics and Financial Literacy graduation requirement, else ‘N’ (Not yet determined). If the CORE Economics and Financial Literacy Requirement field is left blank on the FN tab, this field can be calculated based on the graduation set assigned on the FN report parameter page. | [S_OH_STU_FN_X]CORE_ Econ (current year) Calculated field, unless a value is hand entered. or [S_OH_STU_FN_SNAP_C]CORE_ Econ (prior year) Stored only if field is populated on the FN tab. | Alpha-numeric | 1 | 88 |
FN250 | CORE Fine Arts Requirement Met | This field contains ‘Y’ (Yes) to indicate the student has met the CORE Fine Arts graduation requirement, else ‘N’ (Not yet determined). If the CORE Fine Arts Requirement field is left blank on the FN tab, this field can be calculated based on the graduation set assigned on the FN report parameter page. | [S_OH_STU_FN_X]CORE_Arts (current year) Calculated field, unless a value is hand entered. or [S_OH_STU_FN_SNAP_C]CORE_Arts (prior year) Stored only if field is populated on the FN tab. | Alpha-numeric | 1 | 89 |
FN260 | Exempted from Physical Education Graduation Requirement | This field contains ‘Y’ (Yes) to indicate the student is exempt from the Physical Education graduation requirement, else ‘N’. | [STUDENTS.S_OH_STU_FN_X] Exempted_Physical (current year) or [S_OH_STU_FN_SNAP_C]Exempted_Physical (prior year) | Alpha-numeric | 1 | 90 |
FN270 | Updated October 31 IEP Outcome | This field contains the code identifying the Least Restrictive Environment (LRE) outcome as of October 31st else ‘****’ (No change). This value pertains to a student whose IEP currently on file with ODE does not reflect the current LRE for a student. | [S_OH_STU_FN_X]UpDated_IEP (current year) or [S_OH_STU_FN_SNAP_C]UpDated_IEP (prior year) | Alpha-numeric | 4 | 91–94 |
FN280 | Tech Prep Completer Element Obsolete - FY13N – reports now as filler | This field contains a value of Y if this student has completed a Tech Prep program. | [S_OH_STU_FN_X]Tech_Prep | Alpha-numeric | 1 | 95 |
FN290 | CTE Program of Concentration Element | This field contains the code that identifies the primary CTE Workforce Development Program for which a student has met the requirements of a concentrator, if applicable, else ‘**’. | [S_OH_STU_FN_X]CTE_Program (current year) or [S_OH_STU_FN_SNAP_C]CTE_Program (prior year) | Alpha-numeric | 2 | 96–97 |
FN300 | CORE Graduation Requirement Exemption Code | This field contains a code identifying the exemption status of a student, else ‘*’. | [S_OH_STU_FN_X]CORE_Grad_Req_Exemp (current year) or [S_OH_STU_FN_SNAP_C]CORE_Grad_Req_Exemp (prior year) | Alpha-numeric | 1 | 98 |
FN310 | Military Compact Graduation Alternative Count | This field contains a value indicating the number of assessments the student is not required to take, else ‘0’. | [S_OH_STU_FN_X]Military_CompGrad_Alt (current year) or [S_OH_STU_FN_SNAP_C]Military_CompGrad_Alt (prior year) | Numeric | 1 | 99 |
FN320 | CORE Graduation Requirement Exemption Date | The date the CORE Graduation Exemption requirement was determined, else ‘00000000’. This is only collected for the E and X datasets which are not required by the state of Ohio. | Currently Filler - this element is not collected for EMIS reporting. | Alpha-numeric | 8 | 100-107 |
FN330 | CORE Graduation Requirement Met Flag | This field contains a ‘Y’ (Yes) if a student’s CORE Graduation requirements were met, else ‘N’ (No). This is only collected for the E and X datasets which are not required by the state of Ohio. | Currently Filler - this element is not collected for EMIS reporting. | Alpha-numeric | 1 | 108 |
FN340 | Expected Graduation Date | The expected graduation date for the student, if applicable, else ‘00000000’. | [S_OH_STU_FN_X]Expected_Grad_Date or [S_OH_STU_FN_SNAP_C]Expected_Grad_Date | Alpha-numeric | 8 | 109-116 |
FN350 | Admission to Current High School Date | The date indicating the student’s first day of attendance at their high school, else ‘00000000’. This is only collected for the E and X datasets which are not required by the state of Ohio. | Currently Filler - this element is not collected for EMIS reporting. | 8 | 117-124 | |
FN360 | Math Diagnostic Result Code | Result of the student’s Math Diagnostic assessment, if applicable, else ‘**’ (Not Applicable). | [S_OH_STU_FN_X]Math_Diag_Result_code (current year) or [S_OH_STU_FN_SNAP_C]Math_Diag_Result_code (prior year) | Alpha-numeric | 2 | 125-126 |
FN370 | Reading Diagnostic Result Code | Result of the student’s Reading Diagnostic assessment, if applicable, else ‘**’ (Not Applicable). | [S_OH_STU_FN_X]Reading_Diag_Result_code (current year) or [S_OH_STU_FN_SNAP_C]Reading_Diag_Result_code (prior year) | Alpha-numeric | 2 | 127-128 |
FN380 | Writing Diagnostic Result Code | Result of the student’s Writing Diagnostic assessment, if applicable, else ‘**’ (Not Applicable). | [S_OH_STU_FN_X]Writing_Diag_Result_code (current year) or [S_OH_STU_FN_SNAP_C]Writing_Diag_Result_code (prior year) | Alpha-numeric | 2 | 129-130 |
FN390 | Attending Building IRN, Next Year | Indicates the building the student is expected to attend in the next school year, if student has not been withdrawn, else ‘******’ (Not Applicable) | [S_OH_STU_FN_X]Next_School (current year) or [S_OH_STU_FN_SNAP_C]Next_School (prior year) | Alpha-numeric | 6 | 131-136 |
FN400 | Previous Year District IRN (FLICS) | Indicates the IRN of the Ohio public or nonpublic school the student attended during the first full week of October for the prior school year, if applicable, else ‘******’ (Not Applicable). Only used for students who were not enrolled in an Ohio EMIS reporting entity the prior year or reporting a correction. | [S_OH_STU_FN_X]FLICS_IRN or [S_OH_STU_FN_SNAP_C]FLICS_IRN | Alpha-numeric | 6 | 137-142 |
FN410 | Courses Completed Date | The month and year in which the student completed the course requirements for a diploma. | [S_OH_STU_FN_X]Courses_completed_date or [S_OH_STU_FN_SNAP_C]Courses_completed_date | Date | 6 | 143-148 |
FN420 | Courses Completed IRN | The IRN of the district in which the student completed the course requirements for a diploma. | [S_OH_STU_FN_X]Courses_completed_IRN or [S_OH_STU_FN_SNAP_C]Courses_completed_IRN | Numeric | 6 | 149-154 |
FN430 | Military Student Identifier | Identifies a student with a parent or legal guardian who is an active member of the Armed Forces or National Guard, | [S_OH_STU_FN_X]Military_Student or [S_OH_STU_FN_SNAP_C]Military_Student | Alpha | 1 | 155 |