PMR State Wide Rollup (North Carolina)

Tool Search: NC PMR Extract

The PMR State Wide Rollup Report is available for State Edition users in North Carolina and is a state-wide summary of all enrollment data collected as part of the PMR Summary Report generated by districts for every school month. 

Data reports only from the PMR Summary snapshot that is generated for each selected PMR Interval. 

This report is ONLY available for State Edition users.

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

Screenshot of the State Wide Rollup Report editor, located at Reporting, NC State Reporting. PMR State Wide Rollup

Report Editor

Data ElementDescription
Set Up
Search CalendarsUse the search field to narrow the list of districts and calendars to select. Use the Expand All/Collapse All option. Place a checkbox next to the desired district name and school name. 
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 State Wide Rollup.
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 ProcessingBecause of the large amount of data that is being summarized, the only report generation option is to Submit to Batch Queue. See the Batch Queue article for more information. Results are viewed at a later time once the report has completed.

Mark the Queue Options as needed - High Priority and Keep Unitl I Delete. High-priority submissions are generated as soon as they can be generated; submissions marked Keep Unitl I Delete remain in the Batch Queue Results list of generated reports until they are deleted. 
Format TypeDetermines in which format the report generates - CSV or HTML.


Districts follow this workflow when generating the PMR Extract. 
  1. Generate the PMR Summary. 
  2. Generate the Data Validation Reports.
  3. Regenerate the PMR Summary. 
  4. Review the PMR Summary. 
  5. Submit Verification the PMR Summary. 
  6. Generate the remaining PMR Extracts. 

Generate the PMR State Wide Rollup Report

  1. Select the appropriate District and School Calendar from the list of districts.
  2. Select State Wide Rollup from the Extract Type field. 
  3. Select the appropriate School Month from the dropdown list. 
  4. Select the Report Processing option of Submit to Batch Queue
  5. Select the desired Format Type
  6. Click Review. The report displays in the selected format.


Screenshot of the PMR State Wide Rollup Extract in HTML Format. PMR State Wide Rollup - HTML Format


Report Layout

Data ElementDescriptionLocation
Rollup TypeReports the name of the district and name of schools included in the report. 
PSUReports 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
District NameReports the name of the District selected in the report editor.

Alphanumeric, 50 characters
District Information > District Name

District.name
School NumberReports the unique state school number of the selected school.

Numeric, 6 digits
School Information > State School Number

School.number
School NameReports the name of the selected school from the editor.

Alphanumeric, 20 characters
School Information > School Name

School.name
End YearReports the last four digits of the school year selected.

Numeric, 4 digits 
Calendar Information  > End Date

Calendar.endDate
PMR MonthReports 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
SubmittedWhen 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
Verified TimeReports the time the user clicked Submit Verification.

Alphanumeric, 15 characters (MM/DD/YYYY, HH:MM AM/PM)
Calculated value
Generated ByReports the staff person's name of the last person who generated the report.

Alphanumeric, 30 characters
User Account > Name

UserAccount.name
Generated TimeReports the time the data was generated.

Alphanumeric, 15 characters (MM/DD/YYYY, HH:MM AM/PM)
Calculated value
Verified ByReports 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 TimeReports the time the user clicked Submit Verification.

Alphanumeric, 15 characters (MM/DD/YYYY, HH:MM AM/PM)
Calculated value
Summary GroupDisplays the grouping name being reported for that row - Standard and PK.

Alphanumeric, 8 characters
N/A
State GradeLists the words Group Total for each district and school selected, which is the sum of the values within the summary group for that district and school.

ADMReports 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
ADAReports 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.
  • State Grade Levels of PR are not reported in this calculation.
  • For PK grade levels, this ADA calculation displays as N/A.
Numeric, 5 digits
Calculated value
E1Reports 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
E2Reports 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
R1Reports 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
R2Reports 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
Start Status TotalReports the aggregated sum of the values reported in the previous five fields (start status E1 through R2) AND the student meets the requirements of the Basic PMR Calculation. 

Numeric, 5 digits
Calculated value
W1Reports 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
W2Reports 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
W3Reports 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
W4Reports 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
End Status TotalReports the aggregated sum of the values reported in the previous five fields (End Status W1 through W4) AND the student meets the requirements of the Basic PMR Calculation. 

Numeric, 5 digits
Calculated value
MEM Last Day NVIOReports 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 VIOReports the aggregated sum of all enrollments as of the last day for students considered In Violation.

Numeric, 5 digits
Calculated value
MEM Days NVIOReports 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 VIOReports 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 PresentReports 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-SiteReports 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-SiteReports 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 RemoteReports 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.