Tool Search: NC PMR Extract
The PMR Summary Report is part of a series of extracts that report enrollment, membership, and attendance information for the Principal's Monthly Report Extract. It is collected by NCDPI at the end of each school month for nine months and is used as the source data for calculating the following:
- Average Daily Membership
- Average Daily Attendance
- Enrollment
- Membership Last Day
- Violation Status
Students do not report when:
- Their enrollment record is marked as No Show or State Exclude.
- Their grade level of enrollment is marked as State Exclude.
- Their calendar of enrollment is marked as State Exclude.
See the NC Principals Monthly Report Extract article for information on required data setup, report logic, tool rights, and more.
PMR Summary ReportReport 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 Summary. 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 is being reported. Select one school month from the list. In Campus, PMR Intervals are called School Months. |
| Output Options | |
| Report Processing | To generate the report immediately, select Generate Now option. To choose when the report generates, use the Submit to Batch option. 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. 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. |
| 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 PMR Summary Report
Review the PMR Getting Started information for important setup, tool rights, report logic and workflow processes BEFORE generating the report.
- Select PMR Summary from the Extract Type field.
- Select the appropriate School Month from the dropdown list.
- Select the desired Report Processing option of Generate Now or Submit to Batch Queue.
- Select the desired Format Type.
- Click Generate. The report displays in the selected format.
The following State Attendance Codes are IGNORED when generating the PMR Summary:
- 1X: Nonobligatory (PK-Use Only)
- 1L: Excused Tardy
- 2L: Unexcused Tardy
PMR Summary Report - HTML FormatReview the Report
Follow the procedures above, selecting the same calendar and School Month. Instead of choosing Generate, choose Review. This pulls data from the snapshot previously created; if changes were made to enrollment records or attendance data between the snapshot's first creation and the date the data was reviewed, those changes are not reflected in the review results.
The Generate step creates a snapshot of data as it was on the day it was generated. This Review step uses that snapshot data.
Submit Verification
Additional tool rights are needed for this step. See the NC Principal's Monthly Report Extract information for details.
Once the data has been generated and reviewed, submit that data to the state. The same individual who generated the report must also be the same individual to submit this data.
When submitting the verification, text of the North Carolina General Statute Sections 115C- 276 (p); 115C--288 (b) and 115C-317 displays, requirement acknowledgement and certification of the data contained in the report. Once Submit is selected, data is sent to the State, and no further changes can be made.
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 (1R, 2R, etc.). Numeric, 1 digit | School Month > Name SchoolMonth.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 staff person's name of the last person who generated the report. Alphanumeric, 30 characters | User Account > Name UserAccount.name |
| Generated Time | Reports the time the data was generated. Alphanumeric, 15 characters (MM/DD/YYYY, HH:MM AM/PM) | Calculated value |
| Verified By | Reports the name of the staff person who clicked Submit Verification. Once submitted, additional generation of the same data does not occur. Alphanumeric, 30 characters | User Account > Name UserAccount.name |
| Verified Time | Reports the time the user clicked Submit Verification. Alphanumeric, 15 characters (MM/DD/YYYY, HH:MM AM/PM) | Calculated value |
| Summary Group | Displays the grouping name being reported for that row - Standard and PK. Alphanumeric, 8 characters | N/A |
| Grade | Reports the Grade Level State Code. Reports one row per grade level in numeric order. Reports a Group Total that reports the sum of the values within the summary group for that school. Alphanumeric, 2 characters | Grade Level Setup Enrollments > General Enrollment Information > Grade Enrollment.grade |
| ADA | Reports the Average Daily Attendance, based on the sum of the number of days in attendance for all students divided by the number of days in the school month, rounded to the nearest hundredth decimal place, using the Basic PMR Calculation.
| Calculated value |
| ADM | Reports the Average Daily Membership for all students using the Basic PMR Calculation. Student Membership Days NVIO is divided by the number of days in the school month and rounded to the nearest 100th decimal place for EACH GRADE LEVEL. Once the grade level ADM is calculated, all grade level ADMs are added together to determine the ADM for the school. Each school's ADM in the LEA is added together to determine the LEA's ADM using the Basic PMR Calculation. Numeric, 5 digits | Calculated value |
| E1 | Reports the aggregated number of enrollments where the Enrollment Start Status is E1: Initial Enrollment - This Year AND the student meets the requirements of the Basic PMR Calculation. End Status must not be one of the following: W1, W2, W3, W4, W6, W2T Numeric, 5 digits | Enrollments > General Enrollment Information > Local Start Status Enrollment.startStatus |
| E2 | Reports the aggregated number of enrollments where the Enrollment Start Status is E2: Initial Enrollment from non-NC Public School AND the student meets the requirements of the Basic PMR Calculation. End Status must not be one of the following: W1, W2, W3, W4, W6, W2T Numeric, 5 digits | Enrollments > General Enrollment Information > Local Start Status Enrollment.startStatus |
| R1 | Reports the aggregated number of enrollments where the Enrollment Status is R1: Re-Entry - previous in W1 AND the student meets the requirements of the Basic PMR Calculation. End Status must not be one of the following: W1, W2, W3, W4, W6, W2T Numeric, 5 digits | Enrollments > General Enrollment Information > Local Start Status Enrollment.startStatus |
| R2 | Reports the aggregated number of enrollments where the Enrollment Start Status is R2: Transfer within the same LEA AND the student meets the requirements of the Basic PMR Calculation. End Status must not be one of the following: W1, W2, W3, W4, W6, W2T Numeric, 5 digits | Enrollments > General Enrollment Information > Local Start Status Enrollment.startStatus |
| R3 | Reports the aggregated number of enrollments where the Enrollment Start Status is R3: Transfer from another LEA AND the student meets the requirements of the Basic PMR Calculation. End Status must not be one of the following: W1, W2, W3, W4, W6, W2T Numeric, 5 digits | Enrollments > General Enrollment Information > Local Start Status Enrollment.startStatus |
| Start Status Total | Reports the aggregated sum of the values reported in the previous five fields (start status E1 through R3) AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Calculated value |
| W1 | Reports the aggregated number of enrollments where the Enrollment End Status is W1: Transfer Withdrawal AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Enrollments > General Enrollment Information > Local End Status Enrollment.endStatus |
| W2 | Reports the aggregated number of enrollments where the Enrollment End Status is W2: Early Leaver Withdrawal AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Enrollments > General Enrollment Information > Local End Status Enrollment.endStatus |
| W3 | Reports the aggregated number of enrollments where the Enrollment End Status is W3: Death AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Enrollments > General Enrollment Information > Local End Status Enrollment.endStatus |
| W4 | Reports the aggregated number of enrollments where the Enrollment End Status is W4: Early Completer/Midyear Grad AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Enrollments > General Enrollment Information > Local End Status Enrollment.endStatus |
| W2T | Reports the aggregated number of enrollments where the Enrollment End Status is W2T: Community College Adult High School (CCAHS) AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Enrollments > General Enrollment Information > Local End Status Enrollment.endStatus |
| End Status Total | Reports the aggregated sum of the values reported in the previous five fields (End Status W1 through W2T) AND the student meets the requirements of the Basic PMR Calculation. Numeric, 5 digits | Calculated value |
| MEM Last Day NVIO | Reports the total of the values reported in the previous fields using the following calculation for students considered In Violation. This does NOT include students who ended their enrollment before the end of the school month. SUM (E1,E2,R1,R2,R3 minus W1,W2,W3,W4,W2T) Numeric, 5 digits | Calculated value |
| MEM Last Day VIO | Reports the aggregated sum of all enrollments as of the last day for students considered In Violation. Numeric, 5 digits | Calculated value |
| MEM Days NVIO | Reports the sum of the values reported for MEM Days VIO + Days Present + Days Absent Non-1H/1M/1S. Numeric, 5 digits | Calculated value |
| MEM Days VIO | Reports the total days of all reported enrollments for students considered In Violation. Numeric, 5 digits | Calculated value. |
| Days Present On Site | Reports the total membership days using the Basic PMR Calculation. Numeric, 5 digits | Calculated value. |
| Days Present Off Site (1H, 1M, 1Q, 1S) | Reports the total membership days absent using the Basic PMR Calculation AND the student's attendance event has a State Attendance Code of 1H, 1M, 1Q or 1S. Numeric, 5 digits | Calculated value. |
| Days Present Remote (1R) | Reports the total membership days using the Basic PMR Calculation AND the student was remotely attending classes. Numeric, 5 digits | Calculated value. |
| Total Days Present | Reports the total membership days the student was counted as present. Numeric, 5 digits | Calculated value |
| Days Absent | Reports the total membership days the student was marked absent. Numeric, 5 digits | Calculated value |
| Percent On-Site | Reports the percentage of all present days where the Attendance State Code is NOT 1R: Present Off-Site using the Basic PMR Calculation. Numeric, 5 digits | Calculated value. |
| Percent Off-Site | Reports the percentage of all present days where the Attendance State Code is 1R: Present Off-Site using the Basic PMR Calculation. Numeric, 5 digits | Calculated value. |
| Percent Remote | Reports the percentage of all present days where the Attendance State Code is 1R: Present Off-Site using the Basic PMR Calculation and the student is remotely attending classes. Numeric, 5 digits | Calculated value. |
Next Steps
Generate one of the other reports to review PMR information:
