1. Marine Insurance System
  2. Data model
Reference

The tables behind Marine Insurance System

Marine Insurance System ships with 16 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
16
Features
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Organization and people

Organizations, Policyholders, team members and Users define the insurer, assured, member and platform identity.

Policy book

Policies owns policy coverages, policy endorsements and premium receipts.

Loss and decision

Cargo surveys attaches to Policies; Claims attaches to Policies and owns claim decisions and claim payments.

Review and evidence

Review decisions, record attachments and operation receipts refer back to Policies.

Rates

Exchange rates keeps effective currency rates read-only for this app.

Every table, by feature

Policy book

4 tablesAbout this feature
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Organizations

    Insurer-side organizations owning marine policies and parties

  • Policyholders

    Assureds and counterparties covered by marine policies

    Linked to Organizations
  • Team members

    Internal team members with organization and platform identity

    Linked to Organizations, Users

Coverage and endorsements

4 tablesAbout this feature
  • Policy coverages

    Hull and cargo coverage lines on a policy

    Linked to Policies
  • Policy endorsements

    Endorsements preserving prior coverage revisions

    Linked to Policies
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Review decisions

    Independent reviewer decisions on policy revisions

    Linked to Policies, Team members

Policy review and issuance

5 tablesAbout this feature
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Policy coverages

    Hull and cargo coverage lines on a policy

    Linked to Policies
  • Review decisions

    Independent reviewer decisions on policy revisions

    Linked to Policies, Team members
  • Operation receipts

    Idempotent operation receipts for guarded actions

    Linked to Policies
  • Record attachments

    Evidence files attached to marine policies

    Linked to Policies, Team members

Cargo surveys

4 tablesAbout this feature
  • Cargo surveys

    Cargo damage surveys and assessed loss

    Linked to Policies, Organizations
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Organizations

    Insurer-side organizations owning marine policies and parties

  • Claims

    Hull and cargo damage claims

    Linked to Policies

Claims and decisions

5 tablesAbout this feature
  • Claims

    Hull and cargo damage claims

    Linked to Policies
  • Claim decisions

    Authorized insurer decisions and approved benefits

    Linked to Claims
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Cargo surveys

    Cargo damage surveys and assessed loss

    Linked to Policies, Organizations
  • Policy coverages

    Hull and cargo coverage lines on a policy

    Linked to Policies

Payments and receipts

6 tablesAbout this feature
  • Claim payments

    Verified claim payments against approved benefits

    Linked to Claims, Claim decisions
  • Claim decisions

    Authorized insurer decisions and approved benefits

    Linked to Claims
  • Claims

    Hull and cargo damage claims

    Linked to Policies
  • Premium receipts

    Verified premium receipts distinct from issuance

    Linked to Policies
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Exchange rates

    Read-only effective exchange rates for this app.

Activity and evidence

5 tablesAbout this feature
  • Operation receipts

    Idempotent operation receipts for guarded actions

    Linked to Policies
  • Review decisions

    Independent reviewer decisions on policy revisions

    Linked to Policies, Team members
  • Record attachments

    Evidence files attached to marine policies

    Linked to Policies, Team members
  • Policies

    Marine insurance policies and their lifecycle

    Linked to Organizations, Team members, Policyholders
  • Policy endorsements

    Endorsements preserving prior coverage revisions

    Linked to Policies

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

A policy is the central record for its assured, owner, coverage and later loss. A claim points to its policy. A claim payment points to both the claim and its decision so the paid benefit can be traced. A review decision names the policy revision considered. Operation receipts retain an operation key and expected revision for guarded actions. Provider event identifiers distinguish actual premium and payment events.

Migration order

  1. Import Organizations, Users, team members and Policyholders with stable identities.
  2. Import Policies, then their policy coverages and policy endorsements.
  3. Attach review decisions, record attachments, premium receipts and operation receipts to the correct policies.
  4. Import cargo surveys and Claims against their policies, then claim decisions and claim payments.
  5. Check exchange rates and reconcile references, status values and event identifiers before operating.

Set up Marine Insurance System your way.

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

How to get started