PowerSchool SIS Ohio

(CM) Mapped Local Classroom Code Record

Introduction

Use this extract for Career Technical courses. Use the report option to generate the CM record, which consists of local classroom codes that are “mapped” to another local classroom code. The state uses this information to combine students between the two classroom codes.

You generate this report at the district level.

Prior to running this report, the Local Classroom Code Mappings must be defined (District Management > Compliance > (CM) Mapped Local Classroom Code).

Selection Criteria

Selection criteria determine which database records are used in the report. For the CM Extract, local classroom code records mapped on the Mapped Local Classroom Code Record page (District Management > Compliance > (CM) Mapped Local Classroom Code) are included on the report.

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 > (CM) Mapped Local Classroom Code. 

Field

Description

Reporting Period*

Select the reporting period for which you are creating the extract.

Fiscal Year*

Enter the fiscal year for the report.

Select District

Choose the district from the dropdown.

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.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

Begin/
End Position

N/A

Filler

Filler

N/A

Alpha-numeric

8

1-8

CM010

Sort Type

This field always contains “CM.”

N/A

Alpha-numeric

2

9-10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

CM020

Fiscal Year

The fiscal year is set by report input.

N/A

Numeric

4

12-15

CM030

Data Set

This field always contains "L."

N/A

Alpha-numeric

1

16

CM040

District IRN

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

[Prefs]districtnumber

Alpha-numeric

6

17-22

CM050

From Class Code

This field contains the code from which the students enrolled in this class will be moved (combined). This field value is entered on the Local Classroom Code Mappings page: District Management > (CM) Mapped Local Classroom Code.

[S_OH_COURSE_MAPPINGS_S]from_class_code (current year)

or

[S_OH_COURSE_MAPPINGS__SNAP_S]from_class_code (prior year)

Alpha-numeric

20

23-42

CM060

To Class Code

This field contains the code to which the students enrolled in this class will be moved (combined). This field value is entered on the Local Classroom Code Mappings page: District Management > (CM) Mapped Local Classroom Code.

[S_OH_COURSE_MAPPINGS_S]to_class_code (current year)

or

[S_OH_COURSE_MAPPINGS_SNAP_S]to_class_code (Prior year)

Alpha-numeric

20

43-62