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.
NC PMR Extract - Best 1 of 2 EditorReport 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 Review. The report displays in the selected format.
PMR Best 1 of 2 - HTML FormatReport 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:
