Skip to content

insurance

sqllocks_spindle.domains.insurance

Insurance domain — policies, claims, premiums, and subrogation.

Classes

InsuranceDomain

Bases: Domain

Insurance domain with policies, claims, and underwriting.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - agent: Insurance agents with licensing info (fixed: 100) - policyholder: Insurance customers with demographics (anchor: 1000 small) - policy_type: Policy categories and base premiums (fixed: 30) - policy: Insurance policies with coverage details - coverage: Coverage line items per policy - claim: Claims filed against policies - claim_payment: Payouts on claims - premium_payment: Premium payments by policyholders - underwriting: Risk assessment records per policy

Methods:
star_schema_map()

Return the star schema mapping for the Insurance domain.

Produces
  • dim_policyholder (from policyholder)
  • dim_agent (from agent)
  • dim_policy_type (from policy_type)
  • dim_policy (from policy)
  • fact_claim (from claim)
  • fact_claim_payment (from claim_payment + claim)
  • fact_premium (from premium_payment)
cdm_map()

Return the CDM entity map for the Insurance domain.

Maps source table names to Microsoft Common Data Model entity names.