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 Incident Management with the codes and subcodes used in IM. 

Field

Description

Processing Options

Choose a time to run the report from the pop-up menu:

  • In Background Now (Recommended) – Execute the report immediately in the background.

  • ASAP – Execute the report in the order it is received in the Report Queue.

  • At Night – Execute the report during the next evening.

  • On Weekend – Execute the report during the next weekend.

  • On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy, or use the date picker, icon in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10:05 AM.

Fiscal Year

Enter the fiscal year for the report.

Reporting Period

Select the reporting period for which you are creating the extract – (C) Calendar

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

Alpha-numeric

4

12–15

DL030

Reporting Period

This is the reporting period selected on the Grade Schedule Record page: Start Page > Reports > Run Reports > Grade Schedule (DL)

N/A

Alpha-numeric

1

16

DL040

District IRN

This field contains the district number.

[S_OH_Grade_Sch_S]district_irn

Alpha-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

Alpha-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]attendance_pattern_code

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.

 

[S_OH_Grade_Sch_S]first_day_school

Numeric

1 and 2 decimal places

49-51

N/A

Filler

Filler

N/A

Alpha-numeric

4

52-55

N/A

Filler

Filler

N/A

Alpha-numeric

4

56-60

N/A

Filler

Filler

 

N/A

Numeric

8

61-68