Deep-dive guidewire claims data archive from ClaimCenter. Claims, exposures, reserves, indemnity, expense, recovery, SIU, litigation, multi-TB attachments. Per-jurisdiction state retention. HIPAA-compliant workers-comp. Examiner queries answered in hours, not weeks.
ClaimCenter holds the longest-retention, most-regulated, most-sensitive data in the insurance estate. Workers comp PHI, SIU dossiers, reinsurance long-tail, state-by-state retention — every dimension is harder than billing or policy data.
ClaimCenter is the operational system of record for every claim an insurer touches — first notice of loss (FNOL), adjuster assignment, exposure analysis, reserve setting (case + IBNR), payment processing (indemnity + expense + recovery), litigation tracking, SIU referral, subrogation pursuit and final closure. Every action is timestamped, user-attributed and rule-driven. The data model is rich — claims with multiple exposures (coverages affected), each exposure with its own reserve chain and payment chain, each payment with its own vendor and tax treatment, each artifact attached to the claim file (police reports, medical records, photographs, recorded statements, vendor invoices) preserved as substantiation.
The retention horizon is the longest in the insurance estate. State insurance commissioners require 5–10+ years post-claim-closure (longer in some states). Workers compensation can extend to lifetime-of-claimant for catastrophic injury (severe burns, paraplegia, brain injury) under state WC statutes. Reinsurance long-tail liability (asbestos, environmental, pharmaceutical) routinely runs 30+ years. SIU investigations carry separate 5–10+ year retention under state anti-fraud statutes. Litigation records carry retention based on case disposition. Multi-state insurers manage all of these retention clocks simultaneously, per jurisdiction, with periodic hold-and-release on examiner or litigation notice.
Keeping legacy ClaimCenter alive for retention purposes is the worst possible answer — it costs $200K–$900K/year in licence, infrastructure, DR, Gosu/Studio headcount, SOC2 attestation and HIPAA controls. The Syntra ETL guidewire claims data archive delivers the same regulator-query and examiner-response capability at $20K–$60K/year of archive operation. The data is preserved with full fidelity — every reserve change, every payment, every attachment, every SIU note. The legacy ClaimCenter footprint retires. The savings drop straight to the P&L.
Pre-built extraction and archive for every ClaimCenter data domain with per-jurisdiction retention.
Every claim with all exposures (coverages affected), full FNOL details, adjuster assignment history, status timeline, closure reason. Per-claim attribution with original timestamps and users preserved.
Every case-reserve change with timestamp, user, reason, dollar delta. IBNR allocations per period as actuarial evidence. Loss-development triangles rebuildable at any historical point from the archive.
Every indemnity payment (loss adjustment) and expense payment (LAE — defense, IME, vendor) with claimant supplier, tax-1099 classification, coverage allocation, payment date. Routed to Fusion AP and paid-loss GL.
Subrogation referrals, vendor assignments, pursuit timeline, demand letters, settlements, final recovery payments. Linked to original claim and routed to Fusion GL as recovery credits per coverage.
SIU referrals with full investigation timeline, vendor assignments (IFAs, surveillance, IME), NICB queries/responses, denial recommendations, prosecution outcomes. Access-restricted with full audit logging.
Police reports, medical records (HIPAA-controlled for WC), repair estimates, photographs, recorded-statement audio, SIU dossiers, litigation correspondence, vendor invoices — streamed in parallel, hash-signed, indexed.
A staged extraction and archive build that prioritizes the highest-retention data first. Typical timeline 10–16 weeks for the claims-archive slice.
State-by-state retention requirement inventory per LOB. WC HIPAA scope. Reinsurance long-tail liability exposure (asbestos, environmental, pharma). SIU retention obligations per state anti-fraud statute. Active litigation hold inventory. Output: per-jurisdiction retention map with hold inventory.
Claims, exposures, coverages-affected, FNOL details, adjuster assignments, claim status history. Extracted via CDA (GWCP) and/or JDBC (on-prem). Staged as Parquet with hash-signed manifests partitioned by state and LOB.
Every reserve change, IBNR allocation, indemnity payment, expense payment, recovery payment. Cross-references to claim, exposure and coverage preserved. Reserve-change history full-fidelity for actuarial loss-triangle rebuild.
Multi-TB claim attachments streamed in parallel via CDA (GWCP) or file-share extraction (on-prem). Hash-signed per artifact. Archived to cloud object storage with state-retention partitioning. Read-access logged for HIPAA and examiner audit.
SIU dossiers with full investigation timeline. Litigation records per case with disposition. Subrogation referrals and recovery activity. Access controls enforced (SIU restricted to authorized investigators with audit logging).
Per-jurisdiction retention policies activated. Active litigation and exam holds applied. Examiner query and SIU lookup interface enabled. Legacy ClaimCenter migration plan executed (read-only, then decommissioned per the broader project).
Six structural design choices that separate a P&C-specific archive from a generic compliance store.
Each state's retention clock runs independently per claim. NY 6yr, CA 5yr, TX 10yr, FL 5yr-post-close — applied automatically. Hold-and-release for litigation and examiner notice surgical to the jurisdiction.
Workers comp claims with PHI (medical records, treatment, prescription) get HIPAA-compliant access controls: role-based read, full access-log audit, encryption, minimum-necessary enforcement. Deployed under BAA at multiple insurers.
Every case-reserve change with timestamp/user/reason preserved per claim. Loss-development triangles rebuildable at any historical point for Schedule P statutory filing and reinsurance ceded calculations.
Subrogation pursuit and recovery activity preserved for years post-closure. Ceded recovery from reinsurance treaties cross-referenced to source claims for 30+ year reinsurance audit horizons.
SIU referrals, investigation timelines, NICB queries, prosecution outcomes preserved per state anti-fraud retention. Access restricted with full audit logging. Litigation records preserved alongside.
Police reports, medical records, repair estimates, photographs, recorded statements — multi-TB streamed in parallel, hash-signed, indexed for examiner and SIU lookup. Read-access logs for full audit chain of custody.
Guidewire claims data archive covers the full ClaimCenter data domain across the retention horizon — claims, exposures, reserves (case + IBNR), indemnity payments, expense payments, recovery payments (subrogation, salvage, ceded recovery), SIU referrals, litigation status, vendor assignments, claim notes, recorded statements, medical records (workers comp), police reports, repair estimates, photographs and every other artifact attached to the claim file. The archive is partitioned by state and line of business so per-jurisdiction retention rules (NY 6yr, CA 5yr, TX 10yr, FL 5yr post-close, workers-comp HIPAA, reinsurance long-tail 30+yr) can be enforced independently, with per-state holds for litigation and regulator exams.
Cost and risk. A mid-to-large legacy on-prem ClaimCenter instance costs $200K–$900K/year fully loaded — Oracle/SQL Server licence, WebLogic/Tomcat infrastructure, DR site, Gosu/Studio specialist headcount, SOC2 attestation, HIPAA controls for WC data. Keeping it alive purely for state-retention compliance is pure operating cost with zero business value. The Syntra ETL guidewire claims data archive delivers the same regulator-query response capability at $20K–$60K/year of archive operation. The risk dimension matters too — every year a legacy ClaimCenter stays alive is another year of cyber exposure, compliance drift and key-person-departure risk on Gosu/Studio knowledge.
Critical for Schedule P statutory filing and reinsurance ceded calculations. Every case-reserve change in ClaimCenter — initial reserve, every adjustment with timestamp/user/reason, every reopen, every closure — is captured in the archive with the full transactional grain. IBNR allocations per period are preserved as actuarial evidence. Reserve change types (re-evaluation, payment, recovery, closure) are tagged. Loss-development triangles can be rebuilt at any point in time from the archive without re-extracting from a decommissioned ClaimCenter. Actuaries can answer 'what did our reserves look like on December 31, 2019' as a query, not a six-month reconstruction project.
Subrogation pursuit can run for years post-loss-payment and recoveries can arrive 5+ years after closure. The archive preserves every subrogation referral, pursuit activity, vendor assignment, litigation status, demand letter, settlement and final recovery payment with full timestamp and dollar trail. Recoveries are linked back to the original claim, the original indemnity payment and the routing to Fusion GL as a recovery credit per coverage. Ceded recovery from reinsurance treaties is preserved with cross-references to source claims for the reinsurance-audit horizon (often 30+ years for long-tail liability and WC). Salvage recoveries are handled with the same rigor — recovery vendor, sale proceeds, allocation.
Workers comp claims contain protected health information (PHI) — injury descriptions, medical bills, treatment records, return-to-work documentation, prescription records. The archive enforces HIPAA-compliant access controls at the same grain as the live ClaimCenter: role-based read access, full access-log audit trail (who-read-what-when), encryption at rest and in transit, retention per state WC statute (typically lifetime-of-claimant for catastrophic injury), automated minimum-necessary controls. Syntra ETL's archive design has been deployed at insurers under HIPAA Business Associate Agreements without modification.
Yes — this is the largest data-volume challenge in P&C migrations. A mature ClaimCenter footprint can carry multi-TB to multi-PB of attachments across 20 years: police reports, medical records (workers comp), repair estimates, photographs, recorded-statement audio, SIU dossiers, litigation correspondence, vendor invoices. Syntra ETL streams attachments in parallel via Cloud Data Access (CDA) for GWCP or direct file-share extraction for on-prem, hash-signs each attachment, archives to cloud object storage with state-retention partitioning, and indexes for examiner and SIU lookup. Read-access is logged for HIPAA and state-commissioner audit compliance.
Examiner queries are answered from the archive in hours, not weeks. A typical state market-conduct exam involves random sampling of 50–200 closed claim files spanning 5–10 years. The archive's per-jurisdiction partitioning and indexing allows the file pull to complete in a single query: complete claim file, every reserve change, every payment, every attachment, every note, every adjuster action, every SIU flag, every litigation status — all with the original timestamps and users preserved. Examiners get the same evidence they would have gotten from a live ClaimCenter, faster, without the operating cost of keeping ClaimCenter alive purely for examiner queries.
SIU dossiers are among the most sensitive and longest-retention claim artifacts. State anti-fraud statutes typically require 5–10+ year retention of SIU referrals, investigation activity, NICB submissions and outcomes. The archive preserves every SIU referral with full investigation timeline, vendor assignments (IFAs, surveillance, IME), NICB queries and responses, denial recommendations and outcomes. SIU access is restricted to authorized investigators with full audit logging. Closed SIU cases that resulted in prosecution carry the litigation record alongside. This is data insurers absolutely cannot lose — and exactly what the Syntra ETL archive is designed to protect for the full retention horizon.
Book a 30-minute discovery call. We'll walk through your ClaimCenter footprint — state mix, WC exposure, reinsurance long-tail, SIU caseload, attachment volume — and give you a per-jurisdiction retention design, attachment-streaming plan and 16-week implementation timeline before the call ends.