1. Life Insurance Management
  2. Data model
Reference

The tables behind Life Insurance Management

Life Insurance Management ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
15
Features
6
Change it
Add fields and tables in Proto

How the model is organised

Policyholders and teams

Organizations, Policyholders, team members and Users establish insurer scope, counterparty and owner.

Policies and issuance

Policies anchor policy coverages and policy endorsements.

Premium collection

Premium receipts point to the policy that received the provider event.

Claims and settlement

Claims point to Policies; claim decisions and claim payments keep the decision and payment trail.

Maturity reviews

Maturity reviews connect benefit review to a policy and organization.

Review and evidence

Review decisions, record attachments and operation receipts attach decisions and action history to Policies.

Every table, by feature

Policies and issuance

5 tablesAbout this feature
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders
  • Policy coverages

    Coverage lines attached to a policy.

    Linked to Policies
  • Policy endorsements

    Carrier-authorized policy endorsements.

    Linked to Policies
  • Review decisions

    Independent review decisions on submitted revisions.

    Linked to Policies, Team members
  • Operation receipts

    Idempotent operation receipts for guarded actions.

    Linked to Policies

Policyholders and teams

5 tablesAbout this feature
  • Organizations

    Insurer organizations and their operating scope.

  • Policyholders

    Policyholder entities and eligibility.

    Linked to Organizations
  • Team members

    Staff membership linked to platform identity.

    Linked to Organizations, Users
  • Users

    Users

    Linked to Users
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders

Premium collection

4 tablesAbout this feature
  • Premium receipts

    Verified premium receipts per policy.

    Linked to Policies
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders
  • Organizations

    Insurer organizations and their operating scope.

  • Policyholders

    Policyholder entities and eligibility.

    Linked to Organizations

Claims and settlement

6 tablesAbout this feature
  • Claims

    Claims reported against issued policies.

    Linked to Policies
  • Claim decisions

    Authorized claim decisions and approved benefits.

    Linked to Claims
  • Claim payments

    Verified provider payments against approved benefits.

    Linked to Claims, Claim decisions
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders
  • Policy coverages

    Coverage lines attached to a policy.

    Linked to Policies
  • Operation receipts

    Idempotent operation receipts for guarded actions.

    Linked to Policies

Maturity reviews

4 tablesAbout this feature
  • Maturity reviews

    Maturity benefit reviews for eligible policies.

    Linked to Policies, Organizations
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders
  • Organizations

    Insurer organizations and their operating scope.

  • Operation receipts

    Idempotent operation receipts for guarded actions.

    Linked to Policies

Review and evidence

5 tablesAbout this feature
  • Review decisions

    Independent review decisions on submitted revisions.

    Linked to Policies, Team members
  • Record attachments

    Evidence attachments retained against a policy.

    Linked to Policies, Team members
  • Operation receipts

    Idempotent operation receipts for guarded actions.

    Linked to Policies
  • Policies

    Life insurance policies and issuance state.

    Linked to Organizations, Team members, Policyholders
  • Team members

    Staff membership linked to platform identity.

    Linked to Organizations, Users

Keys and references

Policies use Organization, Owner and Counterparty references. Coverage lines, review decisions, attachments, maturity reviews and operation receipts use Parent to point back to a policy. Claims, premium receipts and endorsements use Policy. Claim payments reference both their Claim and Decision. Provider event ID distinguishes payment provider events. Operation key identifies a guarded action and expected revision records the version it expected.

Migration order

  1. Load Organizations, Users and team members, then verify each person’s insurer scope.
  2. Load Policyholders and resolve their organization references.
  3. Load Policies and their assigned owners and counterparties.
  4. Load policy coverages, policy endorsements and policy attachments.
  5. Load premium receipts, Claims and maturity reviews with their policy links.
  6. Load claim decisions, claim payments, review decisions and operation receipts after their parent records exist.

Set up Life Insurance Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started