Pre-built majesco / sapiens data retention for P&C and L&A insurance archive — per-state, per-LOB retention clocks, NAIC Model #797, HIPAA for workers comp and L&A medical, reinsurance ceded 30+ year horizons. Signed attestation for state-commissioner exam response.
Every US state has its own rule, NAIC model regulations layer on top, HIPAA applies to workers comp + L&A medical, and reinsurance treaties stretch retention 30+ years for long-tail liability. Multi-rule overlap is the norm, not the exception.
Most ERP retention requirements are 7 years for finance records and done. Insurance retention requirements are 7-30+ years depending on state of admission, line of business, record category and reinsurance treaty obligations. New York requires 6 years post-policy-end for P&C (NY Insurance Law Reg 152) and indefinite for life insurance policy records. California requires 5 years for P&C (CCR Title 10 §2695.4). Texas requires 10 years for policy and claim files (28 TAC §21.203). Florida requires 5 years post-claim-closure (FL Statute 626.748). Massachusetts requires 7 years. Illinois requires 7 years. Each state has its own retention-clock-start basis (policy end, claim closure, policy issue) and its own exception list.
NAIC Model #797 adds replacement-records retention for L&A (typically 7-10 years post-replacement per state adoption). HIPAA applies to workers comp medical records and L&A medical exam records (typically 6 years from creation or last access). Reinsurance ceded layers stretch retention 30+ years for long-tail liability (workers comp, professional liability, environmental, asbestos). Insurance carriers writing in multiple states across multiple LOBs face an N×M retention matrix that legacy on-prem Majesco/Sapiens systems were never designed to enforce per-record.
The Syntra ETL archive applies per-state, per-LOB, per-record retention with overlapping policies handled correctly — longest applicable rule wins. Every record is tagged with state of admission, LOB, retention-clock-start date and applicable rule. When a state-commissioner exam team arrives, the response is a query producing a signed attestation — not a six-week consultant reconstruction.
Every record extracted from Majesco/Sapiens is tagged on all six dimensions so the longest applicable retention rule wins.
State of risk for P&C (where the policy covers the risk), state of issue for L&A (where the policy was issued). Drives per-state retention clock.
P&C: auto, property, GL, workers comp, professional liability, etc. L&A: life, annuity, health. Retention rules vary by LOB within state.
Policy end date, claim closure date, policy issue date, last-access date — basis varies per state per LOB per rule. Applied per-record.
State commissioner rule + NAIC model (#797 for L&A replacement) + HIPAA (workers comp + L&A medical) + reinsurance treaty obligation. Longest rule wins.
Retention rules update over time. Per-record rule version applied (the rule in force at the relevant time) so exam attestation cites correct rule version.
GDPR / CCPA right-to-erasure for specific PII fields when erasure request applies and retention exemption does not. Field-level erasure with audit log.
Automated tagging at extract time, per-state clock enforcement, signed attestation at exam time.
Every record extracted from Majesco P&C/L&A Core Suite or Sapiens IDITSuite/CoreSuite/ALIS tagged with state of admission, LOB, retention-clock-start date, applicable rule and rule version.
Archive partitioned by state of admission, LOB and fiscal year so per-state retention clocks run independently. Multi-rule overlap handled at query time — longest rule wins.
Per-state, per-LOB clock running independently per record. When clock reaches expiry, record marked eligible for deletion per configured retention policy.
Record eligible for deletion. Final attestation snapshot captured before deletion: record content hash, retention rule applied, retention horizon, deletion timestamp.
GDPR / CCPA right-to-erasure for specific PII fields handled per field. Erasure event audit-logged indefinitely. Retention-exempt fields (policy/claim record body) preserved per state rule.
State-commissioner market-conduct exam request produces signed attestation in minutes: which records retained, retention rule applied, chain-of-custody, deletion attestation for expired records.
A sample of the per-state, per-LOB rules enforced in the archive. The full matrix covers all 50 states + DC + territories.
P&C: 6 years post-policy-end (Reg 152). L&A: indefinite for life insurance policy records. NAIC #797 applies for L&A replacement.
P&C: 5 years (CCR Title 10 §2695.4). L&A: 7 years from policy termination. NAIC #797 applies.
P&C and L&A: 10 years for policy and claim files (28 TAC §21.203). NAIC #797 applies for L&A.
P&C: 5 years post-claim-closure (FL Statute 626.748). L&A: 5 years from policy termination. NAIC #797 applies.
P&C: 7 years. L&A: indefinite for life. NAIC #797 applies. Workers comp adds HIPAA layer.
P&C: 7 years. L&A: 7 years post-policy-termination. NAIC #797 applies. Workers comp adds HIPAA layer.
Every US state has its own retention rule for P&C and L&A insurance records, plus NAIC model regulations, plus HIPAA for workers comp medical and L&A medical records, plus reinsurance treaty obligations stretching 30+ years for long-tail liability. Examples: New York 6 years post-policy-end for P&C (NY Insurance Law Reg 152) and indefinite for life insurance policy records; California 5 years for P&C (CCR Title 10 §2695.4); Texas 10 years for policy and claim files (28 TAC §21.203); Florida 5 years post-claim-closure (FL Statute 626.748); Massachusetts 7 years; Illinois 7 years. NAIC Model #797 adds replacement-records retention for L&A. Workers comp adds HIPAA. Reinsurance ceded layers can stretch retention 30+ years.
Per-state, per-LOB, per-record retention clock enforcement. Every record extracted from Majesco P&C/L&A Core Suite or Sapiens IDITSuite/CoreSuite/ALIS is tagged with state of admission (state of risk for P&C, state of issue for L&A), line of business, retention-clock-start date (policy end date, claim closure date, or policy issue date depending on the rule) and applicable retention rule (state rule, NAIC model, HIPAA, reinsurance). The archive is partitioned by state and LOB so each retention clock runs independently. When a record reaches its retention horizon, it is marked eligible for deletion per the configured retention policy — typically with a final attestation snapshot for audit closure.
L&A retention is more complex than P&C in three ways. (1) NAIC Model #797 (Life Insurance and Annuities Replacement) requires replacement-record retention per state — typically 7-10 years post-policy-replacement. (2) Life insurance policy records often have indefinite retention (New York, Massachusetts) because the policy may outlive the insurance company by decades through cash value, paid-up additions and dividend accumulation. (3) Annuity records have 1099-R distribution-reporting alignment that requires per-year tax-record retention beyond the standard insurance rule. Syntra ETL's archive applies all three L&A layers: NAIC #797 replacement records partitioned per state, indefinite retention for life policy records where applicable, and 1099-R distribution records preserved per tax year.
Reinsurance ceded layers can stretch retention 30+ years for long-tail liability — workers comp, professional liability, environmental liability, asbestos and other long-tail lines. The reinsurance treaty itself often specifies retention obligations on the ceding insurer (e.g., a treaty requires policy and claim records be available for reinsurer audit for the life of the cession plus 7 years). The Syntra ETL archive applies reinsurance retention on top of standard state and NAIC retention so the longest applicable rule wins. For workers comp specifically, retention horizons routinely exceed 30 years because the underlying injury claim may remain open for the worker's life plus dependent benefits.
Per-state retention attestation. When a New York DFS, California DOI, Texas DOI or state insurance commissioner market-conduct exam team requests proof of retention for a specific record set (e.g., all personal auto policies issued in New York 2018-2022), the response is a query against the archive producing a signed attestation: which records are retained, when each record's retention clock started, when each record's retention clock ends, what attestation snapshot exists for any record that has been deleted post-retention, and the chain-of-custody log proving the record's integrity throughout the retention period. Response time is minutes, not weeks.
Yes — and this is half the value of the archive. Actuarial teams query the archive for loss-development triangle reconstruction across 10-30 year horizons. Claims teams query for SIU investigations on historical claim patterns. Underwriting teams query for prior-claims history on new applications. Finance teams query for premium ledger reconstruction during statutory or GAAP audit. Reinsurance teams query for treaty cession trail during reinsurer audits. L&A teams query for cash value history, dividend distribution history, surrender history and NAIC #797 replacement records. The archive UI supports both ad-hoc queries by business users and programmatic queries via SQL/REST for downstream analytics.
Insurance records are generally exempt from GDPR right-to-erasure and CCPA right-to-delete for the duration of the applicable state-commissioner retention rule (the legitimate interest / legal obligation exemption). However, the exemption is per-record-type and per-jurisdiction — some PII embedded in insurance records (e.g., banking info, secondary contact info, marketing-consent data) may be subject to erasure even when the policy/claim record itself must be retained. The Syntra ETL archive supports field-level retention and erasure: the policy/claim record is retained per state rule; specific PII fields can be erased per GDPR/CCPA request with audit-logged erasure events preserved indefinitely as proof of compliance with both retention and erasure obligations.
Retention rules are version-controlled in the archive. When a state insurance commissioner updates a retention rule (e.g., extends or shortens a horizon, adds a new record category, changes the retention-clock-start basis), the new rule is applied prospectively from the effective date with the prior rule still applicable to records under its retention window. The archive supports overlapping retention policies per state per LOB per record category so the transition is handled correctly. Audit response queries produce attestations that cite the specific retention rule version applied to each record, so a state-commissioner exam team can verify compliance against the rule version that was in force at the relevant time.
Book a 30-minute discovery call. We'll walk through your Majesco/Sapiens footprint, your state-of-admission spread across P&C and L&A, your reinsurance treaty obligations, your workers comp + L&A medical record volumes and your GDPR/CCPA exposure — and propose a concrete retention strategy with per-state clock design.