Tool Search: NC PMR Extract
The PMR (Principal's Monthly Report) Detail contains enrollment, membership, and attendance information. 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
- Initial Enrollment
- Membership Last Day
PMR Detail Editor
Read - Access and generate the NC PMR Extract.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Report Logic
The PMR reports aggregated enrollment numbers for the calendars selected for each school month selected in the Report Editor. Data reports as of the LAST day of the PMR Reporting Period.
- Enrollment records with an Enrollment Start Status of R5: Re-Enroll - previous W1 or R6: Re-Enroll - previous W2 do not report.
- Enrollment records with an Admission Status of VED1: Visitor - Extended Day Program do not report.
Basic PMR Calculation
This report uses the following guidelines for most of the reported fields.
| When... | Then... |
|---|---|
| When Grade Level is STANDARD |
|
| When Grade Level is STANDARD TOTAL | All standard enrollments are summed. |
| When Grade Level begins with XG | The State Grade Level Code needs to be UG (Ungraded). |
| When Grade Level begins with XG Total | All XG enrollments are summed. |
| When Grade Level begins with Extended |
|
| When Grade Level begins with Extended Total | All extended enrollments are summed. |
| When Grade Level begins with School Total | The sum of Standard Total, XG Total, and Extended Total reports. |
| When Grade Level begins with PK |
|
Checklist for Generation
To ensure the PMR Summary report generates properly, verify the following selections:
- Enrollment State Start Statuses are aligned with Local Enrollment Start Statuses. (Enrollment Start Status Setup > State Start Status Code (Mapping)
- Enrollment State End Statuses are aligned with Local Enrollment End Statuses. (Enrollment End Status Setup > State End Status Code (Mapping)
- Students are assigned an Admission Status on their Enrollment records (Enrollments > State Reporting Fields > Admission Status)
- School Months are established following state guidelines. (School Month)
- Attendance Codes are aligned to an appropriate State Code. (Attendance Code Setup > Attendance Excuse Detail > State Code)
Report Editor
| Data Element | Description |
|---|---|
| Set Up | |
| Search Calendars | Search field to narrow the list of calendars to select. Use the Expand All/Collapse All. Place a checkbox next to the desired school and calendars. |
| Show Active Year Only |
When set to ON, only those calendars for the current school year are available for selection. When set to OFF, all calendars from all school years are available for selection. |
| Report Options | |
| Extract Type |
Determines which report PMR extract generates. |
| School Month Sequence |
Indicates which School Month is being reported. Select only one.
|
| Strip Apostrophes | When marked, apostrophes are removed from any field name that includes them. |
| Ad hoc Filter | Select which students to include in the extract by choosing a filter that was created in the Filter Designer. Only those students included in the filter are included in the report. |
| 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. Submit to Batch is useful when generating the report for several calendars or for larger amounts of data being reported. See the Batch Queue article for more information. |
| Format Type | Determines in which format the report generates - CSV or HTML. |
Generate the Report
- Select PMR Detail from the Extract Type field.
- Select the appropriate School Month from the dropdown list.
- Mark the Strip Apostrophes checkbox to remove all apostrophes from the report data.
- Choose an ad hoc filter to return only the course and staff information included in the selected filter.
- 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.
Report Layout
| Data Element
|
Description
|
Location
|
|---|---|---|
| PMR Month | Reports the numeric value of the selected School Month. | Scheduling & Courses > Calendar Setup > School Month |
| School Month Start Date
|
Reports the start date of the selected School Month.
|
Scheduling & Courses > Calendar Setup > School Month
|
| School Month End Date
|
Reports the end date of the selected School Month.
|
Scheduling & Courses > Calendar Setup > School Month
|
| School Name
|
Reports the name of the school.
|
School & District SEttings > Schools > School Information > Name
|
| School Number
|
Reports the state-assigned school number.
|
School & District SEttings > Schools > School Information > State School Number
|
| Student Race/Ethnicity
|
Reports the student's Race/Ethnicity/
|
Census >Demographics > Person Information > Race/Ethnicity
|
| Student Sex
|
Reports the student's designated Gender.
|
Census >Demographics > Person Information > Gender
|
| Student Last Name
|
Reports the student's Last Name.
|
Census >Demographics > Person Information > Last Name
|
| Student First Name
|
Reports the student's First Name.
|
Census >Demographics > Person Information > First Name
|
| Student State ID
|
Reports the student's state-assigned Identification number.
|
Census >Demographics > Person Identifiers > Student State ID
|
| Summary Group
|
Reports the student's State Grade Level group.
|
|
| State Grade | Reports the Grade Level State Code, split into five sections.
Reports one row per grade level in numeric order. |
Scheduling & Courses > Calendar Setup > Grade Level Setup |
| Admission Status
|
Reports the student's assigned Admission Status from their enrollment record.
|
Student Information > General > Enrollments > State Reporting Fields > Admiission Status
|
| Start Status
|
Reports the enrollment start status.
|
Student Information > General > Enrollments > General Enrollment Information > Local Start Status
|
| End Status
|
Reports the enrollment end status.
|
Student Information > General > Enrollments > General Enrollment Information > Local End Status
|
| Start Date
|
Reports the start date of the enrollment record.
|
Student Information > General > Enrollments > General Enrollment Information > Start Date
|
| End Date
|
Reports the end date of the enrollment record.
|
Student Information > General > Enrollments > General Enrollment Information > End Date
|
| E1 | Reports the aggregated number of enrollments where the Enrollment Start Status is E1: Initial Enrollment - This Year.
Numeric, 5 digits |
Student Information > General > Enrollments > State Start Status Code |
| E2 | Reports the aggregated number of enrollments where the Enrollment Start Status is E2: Initial Enrollment from non-NC Public School.
Numeric, 5 digits |
Student Information > General > Enrollments > State Start Status Code |
| R1 | Reports the aggregated number of enrollments where the Enrollment Status is R1: Re-Entry - previous in W1.
Numeric, 5 digits |
Student Information > General > Enrollments > State Start Status Code |
| R2 | Reports the aggregated number of enrollments where the Enrollment Start Status is R2: Transfer within the same LEA.
Numeric, 5 digits |
Student Information > General > Enrollments > State Start Status Code |
| R3 | Reports the aggregated number of enrollments where the Enrollment Start Status is R3: Transfer from another LEA.
Numeric, 5 digits |
Student Information > General > Enrollments > State Start Status Code |
| Start Status Total | Reports the aggregated sum of the values reported in the previous five fields.
Numeric, 5 digits |
Calculated value |
| W1 | Reports the aggregated number of enrollments where the Enrollment End Status is W1: Transfer Withdrawal.
Numeric, 5 digits |
Student Information > General > Enrollments > State End Status Code |
| W2 | Reports the aggregated number of enrollments where the Enrollment End Status is W2: Early Leaver Withdrawal.
Numeric, 5 digits |
Student Information > General > Enrollments > State End Status Code |
| W3 | Reports the aggregated number of enrollments where the Enrollment End Status is W3: Death.
Numeric, 5 digits |
Student Information > General > Enrollments > State End Status Code |
| W4 | Reports the aggregated number of enrollments where the Enrollment End Status is W4: Early Completer/Midyear Grad.
Numeric, 5 digits |
Student Information > General > Enrollments > State End Status Code |
| W2T | Reports the aggregated number of enrollments where the Enrollment End Status is W2T: Community College Adult High School (CCAHS).
Numeric, 5 digits |
Student Information > General > Enrollments > State End Status Code |
| End Status Total
|
Reports the aggregated sum of the values reported in the previous five fields.
Numeric, 5 digits |
Calculated value
|
| MEM Last Day NVIO | Reports the total of the values reported in the previous fields using the following calculation:
SUM (Field 3 through Field 7) minus (Field 9 through Field 13) Numeric, 5 digits |
Calculated value |
| MEM Last Day VIO | Reports the aggregated sum of all enrollments as of the last day for students who have 10 consecutive absences marked as unexcused AND are absent on the following 11th day for any reason.
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 who have 10 consecutive absences marked as unexcused AND are absent on the following 11th day for any reason.
Numeric, 5 digits |
Calculated value. |
| Instructional Days
|
Reports the total number of instructional days included in the school month.
|
Calculated value.
|
| Days Present | Reports the total membership days using the Basic PMR Calculation (see the Report Logic section for details).
Numeric, 5 digits |
Calculated value. |
| Days Absent NON-1H/1M/1S | Reports the total membership days absent using the Basic PMR Calculation (see the Report Logic section for details) AND the student's attendance event does not have a State Attendance Code is NOT 1H, 1M, or 1S.
Numeric, 5 digits |
Calculated value. |
| Days Absent 1H/1M/1S | Reports the total membership days absent using the Basic PMR Calculation (see the Report Logic section for details) AND the student's attendance event has a State Attendance Code is NOT 1H, 1M, or 1S.
Numeric, 5 digits |
Calculated value. |
| Days Absent 1R
|
The total membership days absent for all students using the Basic PMR Calculation (see the Report Logic section for details) AND the student's attendance event has a State Attendance Code of 1R.
Numeric, 5 digits |
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 whole number 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. Numeric, 5 digits |
Calculated value. |
| 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 whole number.
Numeric, 5 digits |
Calculated value. |
| Present On-Site | Reports the SUM of all present days where the Attendance State Code is NOT 1R: Present Off-Site.
Numeric, 5 digits |
Calculated value. |
| Present Off-Site | Reports the SUM of all present days where the Attendance State Code is 1R: Present Off-Site.
Numeric, 5 digits |
Calculated value. |
