In a memorandum dated September 22, 2022, the Department of Energy (DOE) Office of Project Management (PM) notified all stakeholders that support for the Microsoft Access Database (MDB) and Comma Separated Values (CSV) formats for uploading project cost and schedule data to the Project Assessment and Reporting System (PARS) would be discontinued at the end of calendar year 2025. I am pleased to report the successful completion of this critical transition to the JavaScript Object Notation (JSON) format.
The benefits of this modernization effort align directly with the Department's strategic priorities. The JSON format addresses critical cybersecurity vulnerabilities inherent in the legacy MDB format while ensuring compatibility across modern 64-bit operating systems. The transition has materially reduced contractor burden through direct export capabilities from major cost and schedule tools, eliminating cost and time spent on manual data extraction and file preparation each month. Data quality and integrity have improved significantly, with built-in validation and schema compliance ensuring consistency across the enterprise. The modern format has enhanced system reliability and positioned PARS to support emerging capabilities in data analytics and artificial intelligence, to include the Department’s Genesis Mission.
This achievement reflects the exceptional dedication, technical expertise, and collaborative spirit of the entire DOE project management community. I extend my sincere appreciation to the Federal Project Directors, Program Offices, Heads of Contracting Activity, and contractor personnel who invested effort to ensure a successful transition. The partnership between DOE PM, the Energy Facility Contractors Group (EFCOG), Office of Science Project Controls Working Group (SC PCWG) and major toolset vendors including Encore Analytics, Deltek, Oracle, DecisionEdge, forProject, and Midnite Dynamics exemplifies the collaborative approach.
Looking forward, PM will continue refining and expanding JSON capabilities to meet evolving enterprise needs. Remaining data sets include variance analysis, risk management, and other critical performance information; they will be evaluated no sooner than the beginning of calendar year 2027. This measured timeline provides adequate planning while PM works collaboratively with the DOE community on revisions to the JSON Data Item Description (DID) to incorporate lessons learned from the 2025 transition. This collaborative approach ensures that future 2 enhancements continue to serve the Department's mission while maintaining the data quality and operational efficiency achieved through this transition.
For additional information or assistance regarding JSON reporting requirements, please contact Amber Young, PARS Owner, at Amber.Young@hq.doe.gov, or Kevin Carney, Acting PM-30 Director, at Kevin.Carney@hq.doe.gov.