Deltek Costpoint Data Archival — Every Pool Calc, Every Rate Cert, DCAA-Defensible

Deltek costpoint data archival is the discipline of moving aged transactional history out of the live Costpoint environment (or capturing it after migration to Fusion) into a long-term, immutable, query-ready repository purpose-built for DCAA, DFARS and CAS audit lookback. It matters for three reasons specific to federal contractors. First, DCAA audits routinely look back 7+ years (and incurred-cost-submission audits can stretch further) for indirect-rate certifications, executive comp cap tests, floor-check evidence and ICE submission packages — keeping it in live Costpoint is expensive and exposes the production environment to audit-only queries. Second, after migration to Oracle Fusion, the Costpoint environment becomes a six-figure annual carrying cost with no operational use. Third, archival is the only way to keep historical pool calculation workpapers, approved forward-pricing rate certs and Cobra EVMS series accessible without paying the running Costpoint licence and infrastructure.

A backup is a binary blob of the Costpoint Oracle/SQL Server database, restorable only by spinning up a Costpoint application server stack with matching version, matching customizations, matching integrations and matching application credentials — a multi-week, six-figure recovery exercise that everyone hopes they'll never need. Deltek costpoint data archival is the opposite: a query-ready repository where the controller, the DCAA liaison, contract administrators and auditors search by project, CLIN, pool, fiscal period, vendor or PLC and get answers in seconds, without a Costpoint instance running anywhere. Backups satisfy IT continuity. Archival satisfies DCAA audit defense, the actual day-to-day historical lookups federal contractors face, and the contracting officer's evidence request that arrives years post-cutover.

Every entity that matters to a future DCAA audit, contract closeout, customer dispute or operational lookback. Projects: project master, CLIN/SLIN structure, funding modifications, PLC labor categories, budgets, EAC/ETC, allowable cost detail. Accounting: GL accounts, journal entries, fiscal-period closes, multi-state allocations. Indirect Cost Pools: every pool calculation workpaper, allocation base detail, approved provisional and forward-pricing rate cert, executive comp cap test. AP: vendor master, voucher history, 1099 history, vendor labor, P-card history. AR: customer master, project invoices, WAWF iRAPT submission history. Billing: per-CLIN billed-to-date, T&M rates by PLC, retainage tracking. T&E: per-employee per-day per-PLC labor distribution, expense reports, floor check records. Cobra (CER): earned-value records, CPR/IPMR data, control account budgets. Plus every attached document and approved rate cert PDF.

Indirect-rate pool calculation workpapers are the most audit-sensitive thing the archive carries. Every pool calculation run from Costpoint — typically across 7+ fiscal years — is captured with the full supporting detail: allocation base, cost objects accumulating into the pool, intermediate pool basis, final allocation result, approved provisional rate at time of calculation, approved forward-pricing rate cert. The workpaper is stored as immutable Parquet partitioned per pool per fiscal period, with the approved rate cert PDF stored alongside under object-lock retention. When the DCAA contracting officer requests rate reconciliation for FY2019, the original Costpoint pool calculation, the supporting cost data and the approved rate cert all surface in seconds — no reconstruction, no fishing through backup tapes.

Yes — the multi-dimensional govt-contracting context is the single most important thing deltek costpoint data archival has to preserve. Every archived transaction carries its Project, CLIN/SLIN, PLC, Charge Code, Org Hierarchy, Pool assignment and any custom Costpoint fields as first-class columns in the archive Parquet, not as opaque text strings. Project master, CLIN funding hierarchy and PLC rate cards are captured at every point-in-time so a 2018-as-of contract billing lookback for IDIQ Task Order 0012 uses 2018 funding modifications and 2018 PLC rates, not today's. Pool definitions are snapshotted similarly, so an FY2020 indirect-rate certification lookback reflects the pool design that was in production during FY2020.

Depends on contractor scale and contract complexity. Typical mid-size federal contractor archives 200 GB – 5 TB of structured data (compressed Parquet typically 5–10x smaller than raw Costpoint Oracle/SQL Server), plus 100 GB – 5+ TB of attached documents (vendor invoices on vouchers, signed timesheet backups, contract modification PDFs, approved rate cert PDFs). Large primes with multi-billion-dollar IDIQ portfolios run multi-TB on both axes. Cloud object storage costs cents per GB-month, so even a 10 TB archive runs well under $5K/year in raw storage — versus the six-figure Costpoint licence plus infrastructure. The payback math against keeping Costpoint alive read-only is straightforward.

Tightly. The standard pattern for federal contractors: pre-migration, run a bulk deltek costpoint data archival pass to capture everything currently in Costpoint including 7+ years of indirect-rate pool calculations and DCAA evidence; during the parallel-run window, run scheduled nightly Web Services delta extracts so the archive stays current right up to cutover; at cutover, run a final reconciled delta to capture the last 24 hours and the final indirect-rate certification; post-cutover, Costpoint goes read-only and the archive becomes the authoritative source for historical queries while Fusion handles all new transactions. The whole sequence is choreographed around the federal fiscal calendar to give controller, DCAA liaison and contracting officers zero evidence-chain gaps.

Yes — many federal contractors do this purely to escape Costpoint's licence + infrastructure burden for a subsidiary or wound-down contract portfolio. The pattern: run a one-shot full archival of every entity, every indirect-rate pool calculation workpaper, every approved rate cert, every attached document; run weekly deltas until the contract closeout date or the licence renewal; at the renewal date, cancel the Costpoint licence and let the archive become the source of truth for DCAA audit lookback. This is especially common for primes that won a single LPTA contract on a wholly-owned subsidiary entity — Costpoint stood up for that contract, contract closed, but the 7-year DCAA evidence obligation remains.