Data Deliverables
Aggregations
Dimension | Aggregation | Au-Coverage | |
Revenue | Written Premium | Base 1.0 | |
Earned Premium | Derived 1.0 | Yes | |
Installment Charges | |||
Finance & Serv Charges | |||
Exposure | Written Exposure | ||
Earned Exposure | |||
Prop Amt of Ins | |||
Total Ins Value (TIV) | |||
PML | |||
Counts | Vehicle Count | ||
Vehicle Years | derived 1.0 | Yes | |
Policy Counts | Base 1.0 | ||
Policies in Force | Derived 2.0 | ||
New Business Pols | |||
Renewal Pols | |||
Cancel Pols | |||
Non-Renewals Pols | |||
Expenses | OIE | ||
TL&F | |||
Written Commission | |||
Dividends | |||
Claims | Claim Counts | Base 1.0 | |
LAE | |||
ALAE | Base 1.0 | ||
ULAE | |||
Incurred Losses | Derived 1.0 | Yes | |
Outstanding Losses | |||
Paid Losses | Base 1.0 | ||
Incurred Count | ? | Yes |
Sort Filter Criteria
Most calls have multiple sort criteria
Dimension | Parameter | |
Time | Accident Year | base 1.0 |
Accounting Period | base 1.0 | |
Calendar Year | base 1.0 | |
Pol Eff Date | Base 2.0 | |
Policy Year | Base 2.0 | |
LOB / Coverage | Ann Stat Line | Base 2.0 |
Stat Line/ Ext | ||
LOB | base 1.0 | |
Subline | ||
Coverage | base 1.0 | |
Class Code | base 1.0 | |
Model Year | ||
Policy Form | ||
Protection Class | ||
Limit | base 1.0 | |
Deductible | base 1.0 | |
Policy Status | ||
Vehicle | ||
Program Code | ||
Location | State | base 1.0 |
Territory | ||
County | ||
Zip Code | base 1.0 | |
Location | ||
Windpool Zone | ||
Brushfire Zone | ||
Long/Lat | ||
Entity | Company | base 1.0 |
Personal / Commercial | base 1.0 | |
Policy Identifier | ||
Claim Identifier | base 1.0 | |
Business Unit | ||
Transaction | Transaction | |
Cancellation | Cancel Reason | |
Cancel Source |