2015-2016 OCR DATA FILES

NOTE :: The page contains files that are either sent to the FEDs in preparation of the collection, or will be uploaded to the Federal Submission Portal.


This page will contain files created by the DPI on behalf of the LEAs and Charters.  The first set of files in the Advance Website (AWS) Files section was sent to the OCR in advance of the collection in order to prepare the Federal Submission Portal. The second set of files are files that contain data that cannot be reviewed within the PowerSchool CRDC Preview report.  These files will be uploaded to the Federal Submission Portal on behalf of the LEAs and Charter Schools and will be published on this site as they become available.  The files on this page are static and will not be changed.  If data contained in these files are not representative of what the LEA or Charter intends to report to the OCR, the data must be updated in the Federal Submission Portal after the NC DPI completes the upload process.


NOTE :: Various file formats are used on this page that may require download. If larger than 1mb, it will take longer to download. For instructions or more information, please visit our download page.

Advance Website (AWS) Files


2015-2016 Schools List
This file was provided to the OCR September 12, 2016. It contains all of the open schools in North Carolina that are required to participate in the data collection.  This data was exported from the EDDIE system.  If you find an error, please update EDDIE appropriately and contact the CRDC partner support at the Federal Level with your updated information.
NC CRDC SY 2015-2016 Schools List
(xlsx, 200kb)


2015-2016 CRDC LEA Contacts List
This file was provided to the OCR September 26, 2016 and contains OCR Coordinators contact information, Student Information Coordinators contact information and Superintendent contact information.  This data was exported from the EDDIE system.  If you find an error, please update EDDIE appropriately. Please be advised: The OCR will begin to create accounts to the Federal Submission Portal in late October.  Those staff that receive initial access to the Federal Submission Portal can then create accounts for other staff.
2015-2016 CRDC LEA Contacts List
(xlsx, 56kb)


Federal Submission Portal File


Expenditure and FTE File
This file was created by the NC DPI to upload non-PowerSchool data to the CRDC Federal Submission Portal. To understand the data requested or the format of the file, use the Federal CRDC documentation.

Part 1 Section IV: School Staff Data

  • Teachers – FTE Count and Certification, question 46
  • Teacher Years of Experience, question 47
  • Current Year and Previous Year Teachers, question 48
  • School Counselors, question 49
  • Security Staff, question 50
  • Support Services Staff, question 51

Part 2 Section XII: School Expenditures

  • Full-time Equivalency Count and Salary Amount for Teachers Funded with State and Local Funds, question 36
  • Full-time Equivalency Counts and Salary Amounts for Staff Funded with State and Local Funds, question 37
  • Salary Amount for Total Personnel Funded with State and Local Funds, question 38
  • Amount of Non-Personnel Expenditures Associated with Activities Funded with State and Local Funds, question 39
  • Salary Amount for Teachers Funded with Federal, State and Local Funds, question 40
  • Full-time Equivalency Counts and Salary Amounts for Staff funded with Federal, State and Local Funds, question 41
  • Salary Amount for Total Personnel Funded with Federal, State and Local Funds, question 42
  • Amount of Non-Personnel Expenditures Associated with Activities Funded with Federal, State and Local Funds, question 43

Expenditure FTE File
(xlsx, 599kb)



Supporting Information for non-PowerSchool Data Collected for the CRDC


Part 1 Section IV: School Staff Data
The data collected for School Staff Data section can be viewed on the Statistical Profile.

  • North Carolina Public School Personnel, Table 16: State Summary of Public School Full-Time Personnel
  • Table 16B: State Summary of Charter/Regional School Full-time Personnel

CRDC Expenditure Business Rules
This document identifies the business rules used by the NC DPI to extract expenditure data for the SY 15-16 CRDC from state systems. This document is only giving a general logic for NC DPI specific object and purpose codes based on NC Chart of Accounts available at:
http://www.ncpublicschools.org/fbs/finance/reporting/coa2015

(docx, 15kb)


Expenditures: State and Local Funds
This spreadsheet contains State and Local Expenditure data reported by LEA and School number as collected for the CRDC and prior to formatting the data for upload. Please refer to the CRDC Expenditure Business Rules and the Federal Documentation for a full understanding of the collection.
OCR-CRDC Expenditures FY2016, Spec. 1
(xlsx, 690kb)


Expenditures: Federal, State and Local Funds
This spreadsheet contains Federal State and Local Expenditure data reported by LEA and School as collected for the CRDC and prior to formatting the data for upload. Please refer to the CRDC Expenditure Business Rules and the Federal Documentation for a full understanding of the collection.
OCR-CRDC Expenditures FY2016, Spec. 2
(xlsx, 695kb)