Skip to content

Latest commit

 

History

History
105 lines (75 loc) · 1.24 KB

Data.md

File metadata and controls

105 lines (75 loc) · 1.24 KB

Data

data-raw:

scripts for:

  • loss_data_all
  • loss_data
  • transactional_claims_data

Database Design

  • Users
  • Roles
  • Coverages
  • Policies
  • Retentions
  • ALAE Treatment
  • Occurrence Based vs Claims Based
  • Deductibles, Limits, Aggregates
  • Claimants
  • Claims
  • Occurrences
  • Locations
  • Status Codes
  • Evaluations
  • Transactions
  • Transaction Types
  • Changes

  • Account

  • Activity

  • Agreement

  • Claim

  • Communication

  • Coverage

  • Event

  • GeographicLocation

  • Money

  • Party

  • Policy

  • Policy Coverage Detail

  • Policy Deductible

  • Policy Limit

  • Product

  • Product Coverage

  • Reinsurance Agreements

  • Reinsurance Coverage

  • Occurrences:

    • occurrence_uid
    • occurrence_number
    • catastrophic_event_indicator
    • geographic_location_uid
    • date_of_occurrence
    • date_of_closure
    • occurrence_name
    • occurrence_description

Claims:

  • claim_uid
  • claim_number
  • occurrence_uid
  • claimant_uid
  • policy_uid
  • event_uid
  • claim_location_uid
  • claim_status_code
  • incurred_loss (splits)
  • paid_loss (splits)
  • claim_description
  • claim_report_date
  • claim_close_date
  • claim_reopen_date
  • claim_status_code
  • claim_claims_made_date
  • claim_submission_date

Backlinks:

list from [[Data]] AND -"Changelog"