Tool Search: NC PMR Extract

The PMR (Principal's Monthly Report) Best 1 of 2 report compares ADM calculations submitted in PMR Interval 1 with ADM calculations submitted in PMR Interval 2.The higher ADM for each grade level is then totaled by grade level across the PSU.

The PMR Best 1 of 2 Report can only be reviewed once the PMR Summary is verified for PMR 2 for the selected calendar, creating both snapshots for PMR 1 and 2. PMR 1 is referenced as 1R, which means that month 1 data was generated as of the month 2 collection window.

See the NC Principals Monthly Report Extract article for information on required data setup, tool rights, and more information on getting started.

Screenshot of the PMR Best 1 of 2 Extract Type for the PMR Summary, located at Reporting, NC State REporting, NC PMR Extract.

NC PMR Extract - Best 1 of 2 Editor

Report Editor

Data Element	Description
Set Up
Search Calendars	Use the search field to narrow the list of calendars to select. Use the Expand All/Collapse All option. Place a checkbox next to the desired school and calendars. As noted previously, all calendars are automatically selected because this is a school-wide report.
Show Active Year Only	When set to ON, only those calendars for the school year are available for selection. When set to OFF, all calendars from all school years are available for selection based on the user's tool rights.
Report Options
Extract Type	Determines which PMR report generates. For this instance, select PMR Best 1 of 2. The PMR Summary is the only report that includes the Generate and Submit Verification options for users assigned proper tool rights. All other reports include the Review option.
School Month Sequence	Indicates which School Month (e.g., PMR Interval) is being reported. Select one school month from the list. In Campus, PMR Intervals are called School Months.
Output Options
Report Processing	This is a complex report and requires several minutes to create the data snapshot. Because of this, it always needs to be generated using the Submit to Batch option. The Batch Queue processing can be used for both the report generation and the report review, allowing results to be reviewed at a later time. The Snapshot being compared is taken at the same time as the PMR summary and only students who report on the PMR summary are used in the counts. Submitting to Batch is useful when generating the report for several calendars or for more significant amounts of reported data. See the Batch Queue article for more information.
Format Type	Determines in which format the report generates - CSV or HTML.

Follow this workflow for generating the PMR Extract.

Generate the PMR Summary.
Generate the Data Validation Reports.
Regenerate the PMR Summary.
Review the PMR Summary.
Submit Verification the PMR Summary.
Generate the remaining PMR Extracts.

Generate the Report

Review the PMR Getting Started information for important setup, tool rights, report logic and workflow processes BEFORE generating the report.

Select PMR Best 1 of 2 from the Extract Type field. The School Month Sequence pre-populates with a value of 2 when the PMR Best 1 of 2 Extract Type is selected.
Select Submit to Batch Queue.
Select the desired Format Type.
Mark the desired Queue Options.
Click Generate. The report displays in the selected format.

Screenshot of the PMR Best 1 of 2 Report in HTML format.

PMR Best 1 of 2 - HTML Format

Report Layout

Data Element	Description	Location
PSU	Reports the first three digits of the school's Public School Unit number of the selected school. Numeric, 3 digits	District Information > State District Number District.number
School Number	Reports the unique state school number of the selected school. Numeric, 6 digits	School Information > State School Number School.number
School Name	Reports the name of the selected school from the editor. Alphanumeric, 20 characters	School Information > School Name School.name
End Year	Reports the last four digits of the school year selected. Numeric, 4 digits	Calendar Information > End Date Calendar.endDate
PMR Month	Reports the numeric value of the selected School Month from the report editor. When the PMR Interval is validated along with another PMR Interval, the school month plus the letter R (e.g., 1R). Numeric, 1 digit	School Month > Name School Month.name
Submitted	When the data for the report has been verified (submitted to the state), a value of 1 reports. Otherwise, this column is blank. Numeric, 1 digit	N/A
Generated By	Reports the name of the last user who generated the report. Alphanumeric, 20 characters	User Account > Name UserAccount.name
Generated Time	Reports the time the data was generated. Date and Time fields, 15 characters (XX/XX/YYYY, HH:MM AM/PM)	Calculated value
Verified By	Reports the name of the last user who clicked Submit Verification. Once submitted, additional generation of the same data does not occur. Alphanumeric, 20 characters	User Account > Name UserAccount.name
Verified Time	Reports the time the user clicked Submit Verification. Date and Time fields, 15 characters (XX/XX/YYYY, HH:MM AM/PM)	Calculated value
KG	Reports the larger value of School Month 1 and School Month 2 for students in state grade level Kindergarten. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
01	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 01: First. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
02	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 02: Second. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
03	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 03: Third. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
04	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 04: Four. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
05	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 05: Fifth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
06	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 06: Sixth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
07	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 07: Seventh. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
08	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 08: Eighth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
09	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 09: Ninth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
10	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 10: Tenth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
11	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 11: Eleventh. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
12	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 12: Twelfth. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
13	Reports the larger value of School Month 1 and School Month 2 for students in state grade level 13: Grade 13. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value
Standard Total	Reports the total sum of the values reported for each grade level. Numeric, 4 digits	Calculated value.
PK	Reports the larger value of School Month 1 and School Month 2 for students in state grade level PK: PreKindergarten. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value.
PR	Reports the larger value of School Month 1 and School Month 2 for students in state grade level PR: Preschool. When this grade level is not in the selected calendar, reports a value of 0 (zero). Numeric, 4 digits	Calculated value.
PK Total	Reports the total sum of the values reported for state grade levels PK and PR. Numeric, 4 digits	Calculated value.

Next Steps

Generate one of the other reports to review PMR information:

PMR Best 1 of 2 (North Carolina)

Report Editor

Generate the Report

Report Layout

Next Steps

Related Articles