jdutton Loss Run Parser
Normalize a carrier loss run into one row per claim with paid, reserve, and incurred figures.
Column mapping
Carrier column names vary. See the column-mapping reference for the alias table covering the major carriers.
Steps
- Detect the header row and map carrier columns to the canonical schema.
- Emit one normalized row per claim.
- Report rows where paid + reserve does not tie to incurred.