(FS, FM) Student Standing/Detailed Attendance CSV Record – Zip File Output

Report Parameters

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 of 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 prior to running report.

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

Reporting Period*

Select the reporting period for which you are creating the extract – (S) Student.

Fiscal Year*

Enter the fiscal year for the report.

JVS/ESC

For JVS/ESC reporting entities the parameter radio button identifying that the report is being run for a JVS/ESC.

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.

FS010

Sort Type

The sort type equals FS for the Student Standing extract.

N/A

Alpha

2

FS020

Fiscal Year

The fiscal year is set by report input.

N/A

Numeric

4

FS030

Data Set

This is the reporting period set by report input.

N/A

Alpha

1

FS040

District IRN

This field contains the district number. This field value is extracted from the District Information preferences.

[Prefs]DistrictNumber; CST_SUBDISTRICTS.Subdistrict_number

Numeric

6

FS050

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 Student Profile > Demographics page, and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.

[Students]Student_Number; [Prefs]OH_EMIS_Prefix

Alpha-numeric

9

FS060

Effective Start Date

This field contains the first day, inclusive, that the set of all other values on this record are valid. For a student with a District Entry Date prior to the current year, the Effective Start Date defaults to July 1 of the current school year. If no history records are present for a student, the Effective Start Date is the student’s District Entry Date for the current enrollment (Student Profile > Modify Info).

[Students]OH_EffectiveStartDate; [S_OH_STU_FS_HISTORY_C]Effective_Start_Date

Numeric (date)

8

FS070

Admission Date

This field contains the date of the student’s first day of attendance for the most recent entry or re-entry into the school district.

[S_OH_STU_FS_X]admission_date; [S_OH_STU_FS_HISTORY_C]admission_date

Numeric (date)

8

FS080

Student Admission Reason

This field value is extracted from the FS admission reason field. If this field does not contain a value, a blank is extracted.

[S_OH_STU_FS_X]admission_reason; [S_OH_STU_FS_HISTORY_C]admission_reason

Alpha-numeric

1

FS090

Effective End Date

This field contains the last day, inclusive, that the set of all other values on this record are valid. If this is a Current enrollment the Effective End Date is calculated by subtracting 1 from the student’s exit date on the Transfer Info screen. If this record is a history record the value is taken from Effective_End_Date field

[S_OH_STU_FS_X]effective_end_date; [S_OH_STU_FS_HISTORY_C]effective_end_date

Numeric (date)

8

FS100

Withdrawal Reason

This field contains the reason for the most recent withdrawal from the school district. If this is a Current enrollment this field value is extracted from the current enrollment page. If this record is a history record the value is taken from the Reenrollments table.

[Students]OH_WithdrawalReason or [Students]ExitCode or [Reenrollments]ExitCode

Alpha-numeric

2

FS110

State Student ID (SSID)

This field contains the state student ID for this student. If this field is does not contain a value, a blank is extracted.

[Students]State_StudentNumber; [S_OH_STU_FS_HISTORY_C]State_student_id

Alpha-numeric

9

FS120

Student Percent of Time

This field contains the average percent of time, for the week, that the student participates in any instruction provided by a certified/licensed employee. If this field is left blank, 100% is reported.

[S_OH_STU_FS_X]Percent_Time; [S_OH_STU_FS_HISTORY_C]Percent_Time

Numeric

3

FS130

Tuition Type

This field contains the code identifying the method in which the student is paying tuition to the reporting district. If this field is does not contain a value, a blank is extracted.

[S_OH_STU_FS_X]Tuition_Type; [S_OH_STU_FS_HISTORY_C]Tuition_Type

Alpha-numeric

1

FS140

District Relationship

This field contains the code identifying the educational relationship between the student and the district. If this field does not contain a value, a blank is extracted.

[S_OH_STU_HISTORY_C]District_Relationship; [S_OH_STU_FS_HISTORY_C]District_Relationship

Numeric

1

FS150

Legal District of Residence

This field contains the six-digit IRN number of the city/municipal, local, or exempted village school district in which the parent is a resident, if residing in-state. If this field does not contain a value, a blank is extracted.

[Students]DistrictofResidence; [S_OH_STU_FS_HISTORY_C]Legal_District_Residence

Numeric

6

FS160

Attending Building IRN

This field contains the IRN of the building within the district that the student attends between the effective dates, inclusive, of the record being reported.

If the Attending Building IRN field is blank on the FS, the Building IRN entered on the Home tab is extracted.

If the Attending Building on the Home tab is also blank, the school number is extracted.

[S_OH_STU_FS_X]Attending_Building_IRN; [S_OH_STU_FS_HISTORY_C]Attending_Building_IRN; [S_OH_STU.COMMON_X]Building_IRN; [Schools]School_Number

Numeric

6

FS170

Assigned Building IRN

This field contains the IRN of the building the student would normally attend according to the standard district attendance policy. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]Assigned_Building_IRN; [S_OH_STU_FS_HISTORY_C]Assigned_Building_IRN

Alpha-numeric

6

FS180

How Received

This field contains the code identifying how student arrived at the district.

[S_OH_STU_FS_X]How_Received; [S_OH_STU_FS_HISTORY_C]How_Received

Alpha-numeric

1

FS190

How Received IRN

This field contains the district from which a student is received. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]How_Received_IRN; [S_OH_STU_FS_HISTORY_C]How_Received_IRN

Alpha-numeric

6

FS200

Sent Reason 1

This field contains the reason a student is sent to another district.

[S_OH_STU_FS_X]Sent_Reason1; [S_OH_STU_FS_HISTORY_C]Sent_Reason1

Alpha-numeric

2

FS210

Sent to IRN 1

This field contains the district to which a student is sent. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]Sent_To_IRN1; [S_OH_STU_FS_HISTORY_C]Sent_To_IRN1

Alpha-numeric

6

FS220

Sent To Percent of Time 1

This field contains the average percent of time, for the week, that the student participates in any instruction provided by an employee at a non-EMIS reporting entity. If this field is blank, three zeroes (000) are extracted.

[S_OH_STU_FS_X]Sent_To_Percent_Time1; [S_OH_STU_FS_HISTORY_C]Sent_To_Percent_Time1

Numeric

3

FS230

Sent Reason 2

This field contains the reason a student is sent to another district, if the student is sent to a second district.

[S_OH_STU_FS_X]Sent_Reason2; [S_OH_STU_FS_HISTORY_C]Sent_Reason2

Alpha-numeric

2

FS240

Sent To IRN 2

This field contains the district to which a student is sent, if the student is simultaneously being sent to a second district. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]Sent_To_IRN2; [S_OH_STU_FS_HISTORY_C]Sent_To_IRN2

Alpha-numeric

6

FS250

Sent To Percent of Time 2

This field contains the average percent of time, for the week, that the student participates in any instruction provided by an employee at a non-EMIS reporting entity. If this field is blank, three zeroes (000) are extracted.

[S_OH_STU_FS_X]Sent_To_Percent_Time2; [S_OH_STU_FS_HISTORY_C]Sent_To_Percent_Time2

Numeric

3

FS350

Admitted From IRN

This field contains the IRN of the district which the student is coming from. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]Admitted_From_IRN; [S_OH_STU_FS_HISTORY_C]Admitted_From_IRN

Alpha-numeric

6

FS360

Withdrawn To IRN

This field contains the IRN of the district which the student is being withdrawn to. If this field is blank, six asterisks (******) are extracted.

[S_OH_STU_FS_X]Withdrawn_To_IRN; [S_OH_STU_FS_HISTORY_C]Withdrawn_To_IRN

Alpha-numeric

6

FS370

County of Residence

This field contains the county of residence. If this field is blank, the report extracts as blank.

[S_OH_STU_FS_X]County; [S_OH_STU_FS_HISTORY_C]County

Numeric

2

FS380

Updated Exit Status

This field contains the county of residence. If this field is blank, the report extracts as blank.

[S_OH_STU_FS_X]exit_status; [S_OH_STU_FS_HISTORY_C]exit_status

Numeric

2

FM010

Sort Type

The sort type equals FM for the Student Detailed Attendance extract. Always "FM".

N/A

Alpha

2

FM020

Fiscal Year

The fiscal year is set by report input.

N/A

Numeric

4

FM030

Data Set

This is the reporting period set by report input.

N/A

Alpha-numeric

1

FM040

District IRN

This field contains the district number. This field value is extracted from the District Information preferences.

[Prefs]DistrictNumber; CST_SUBDISTRICTS.Subdistrict_number

Numeric

6

FM050

EMIS Student ID Number

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 Student Profile > Demographics page, and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.

[Students]Student_Number; [Prefs]OH_EMIS_Prefix

Alpha-numeric

9

FM060

Effective Start Date

This field contains the first day, inclusive, that the set of all other values on this record are valid. For a student with a District Entry Date prior to the current year, the Effective Start Date defaults to July 1 of the current school year. If no history records are present for a student, the Effective Start Date is the student’s District Entry Date for the current enrollment.

[Students]OH_EffectiveStartDate; [S_OH_STU_FS_HISTORY_C]Effective_Start_Date

Numeric (date)

8

FM070

Attendance Type

Indicates what type of attendance is reflected by the hours on this record. Valid Options: AT – In attendance; EX – Excused absence; UN – Unexcused absence. This value is not stored directly in a PowerSchool field but is calculated based on the student's attendance records. The system evaluates each attendance record's attendance code category to classify hours into the appropriate category. To properly calculate attendance, the student's [S_OH_STU_FD_X]local_attend_pattern must align with a corresponding Grade Schedule record [S_OH_Grade_Sch_S]. If there is not a corresponding record, attendance cannot be calculated. If override values are entered in the FS hour fields ([S_OH_STU_FS_X]Hrs_Present, Hrs_Excused, Hrs_Unexcused or [S_OH_STU_FS_HISTORY_C]Hrs_Present, Hrs_Excused, Hrs_Unexcused), those FS override values take precedence over the calculated FM attendance values and no standard attendance-code-based calculations are included for FM070/FM080/FM100.

Calculated; derived from [Attendance_Code.S_OH_ATC_TRUANCY_X]considered_present, [Code_Entity]att_category_code, [Attendance_Code]presence_status_CD, [S_OH_STU_FD_X]local_attend_pattern and [S_OH_Grade_Sch_S] alignment. Override: [S_OH_STU_FS_X]Hrs_Present, Hrs_Excused, Hrs_Unexcused; [S_OH_STU_FS_HISTORY_C]Hrs_Present, Hrs_Excused, Hrs_Unexcused

Alpha-numeric

2

FM080

Attendance Detail

Provides additional context to further define the Attendance Type for this record. This value is not stored directly in a PowerSchool field but is derived from the Attendance Type (FM070). Valid Options: AT – In attendance; AB – Absent. Mapping: When Attendance Type is AT (In attendance), the Attendance Detail is AT. When Attendance Type is EX (Excused absence) or UN (Unexcused absence), the Attendance Detail is AB (Absent). The presence status of each attendance code determines whether hours are categorized as present, excused absent, or unexcused absent.

Calculated; derived from FM070 Attendance Type classification

Alpha-numeric

2

FM090

Effective End Date

This field contains the last day, inclusive, that the set of all other values on this record are valid. If this is a Current enrollment and the school year has not ended, the Effective End Date is populated with the date the file is run. If this is a current record and the school year has ended, this value is calculated by subtracting 1 from the student’s exit date on the Transfer Info screen. If this record is a history record the value is taken from Effective_End_Date field.

[S_OH_STU_FS_X]effective_end_date; [S_OH_STU_FS_HISTORY_C]effective_end_date

Numeric (date)

8

FM100

Attendance Hours

The actual number of hours a student was in attendance or absent for the combination of Attendance Type (FM070) and Attendance Detail (FM080) between the effective dates on this record, inclusive. Valid range: 0000.00–1800.00. Only time when the student is required to be in attendance is included. Hours are calculated using the same attendance calculation logic described in FM070. Additionally, the Percent of Time that a student participates in district instruction is used as a multiplier when calculating attendance hours. If FS hour override values are entered, those override values take precedence over the calculated FM attendance hours.

Calculated; derived from [Attendance_Code.S_OH_ATC_TRUANCY_X]considered_present, [Code_Entity]att_category_code, [Attendance_Code]presence_status_CD, requires [S_OH_STU_FD_X]local_attend_pattern and [S_OH_Grade_Sch_S] alignment. Multiplied by [S_OH_STU_FS_X]Percent_Time; [S_OH_STU_FS_HISTORY_C]Percent_Time. Override: [S_OH_STU_FS_X]Hrs_Present, Hrs_Excused, Hrs_Unexcused; [S_OH_STU_FS_HISTORY_C]Hrs_Present, Hrs_Excused, Hrs_Unexcused

Numeric

PIC 9(4)V99

AT – In attendance

AT – In attendance

EX – Excused absence

AB – Absent

UN – Unexcused absence

AB – Absent