PowerSchool SIS Ohio
PowerSchool SIS Ohio
Breadcrumbs

(DL) Grade Schedule - Record

Introduction

The (DL) Grade Schedule Record report includes a record for each grade/attendance pattern combination at the district/ building level for any EMIS reporting entity.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects which district/school records to use based on the following criteria:

  • All records located in the Ohio General Grade Schedule table will be extracted.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

The report input is done in Data and Reporting > Reports > Compliance Reports > (DL) Grade Schedule - Record.

Field

Description

Schools for which to run?*

Choose one of the following from the pop-up menu:

  • Select Multiple Schools – Includes all student records associated with the school(s) that meet the selection criteria.

  • District Wide (default) – Includes all student records on the PowerSchool server that meet the selection criteria.

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.

  • 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.

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

DL010

Sort Type

The sort type equals DL.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

DL020

Fiscal Year

The fiscal year defaults to the current school year.

N/A

Numeric

4

12–15

DL030

Reporting Period

This is the reporting period selected on the Grade Schedule Record page: Data and Reporting > Reports > Compliance Reports > (DL) Grade Schedule Record

N/A

Alpha-numeric

1

16

DL040

District IRN

This field contains the district number.

[S_OH_GRADE_SCH_S]district_irn

Numeric

6

17–22

DL050

Building IRN

The state assigned six-digit information retrieval number (IRN) of the building.

[S_OH_GRADE_SCH_S]building_irn

Numeric

6

23-28

DL060

Grade Code

This field contains the grade for which this schedule record is being reported.

[S_OH_GRADE_SCH_S]grade_code

Alpha-numeric

2

29-30

DL070

Attendance Pattern

This field contains the arrangement of days in which a student is in this building on a weekly basis.

[S_OH_GRADE_SCH_S]attendance_pattern_code

Alpha-numeric

2

31-32

DL080

First Day of School

This field indicates the first day of instruction for students in this grade/ attendance pattern combination. The format is YYYYMMDD

[S_OH_GRADE_SCH_S]first_day_school

Numeric

8

33-40

DL090

Last Day of School

This field indicates the last day of instruction for students in this grade/ attendance pattern combination. The format is YYYYMMDD

[S_OH_GRADE_SCH_S]last_day_school

Numeric

8

41-48

DL100

Hours Per Day

This field contains the actual number of hours per day in which scheduled classes, supervised activities, or approved educational options were provided to students in this grade. Entry is in Ohio required decimal format with equivalent hours and minutes displayed upon entry.

[S_OH_GRADE_SCH_S]hours_per_day

Numeric

1 and 2 decimal places

49-51

N/A

Filler

Filler

N/A

Alpha-numeric

9

52-60

N/A

Filler

Filler

 

N/A

Numeric

8

61-68