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 |
|