Aggregations

DimensionAggregation
Au-Coverage
RevenueWritten PremiumBase 1.0

Earned PremiumDerived 1.0Yes

Installment Charges


Finance & Serv Charges

ExposureWritten Exposure


Earned Exposure


Prop Amt of Ins


Total Ins Value (TIV)


PML

CountsVehicle Count


Vehicle Yearsderived 1.0Yes

Policy CountsBase 1.0

Policies in ForceDerived 2.0

New Business Pols


Renewal Pols


Cancel Pols


Non-Renewals Pols

ExpensesOIE


TL&F


Written Commission


Dividends

ClaimsClaim CountsBase 1.0

LAE


ALAEBase 1.0

ULAE


Incurred LossesDerived 1.0Yes

Outstanding Losses


Paid LossesBase 1.0

Incurred Count?Yes

Sort Filter Criteria

  • Most calls have multiple sort criteria
DimensionParameter
TimeAccident Yearbase 1.0

Accounting Periodbase 1.0

Calendar Yearbase 1.0

Pol Eff DateBase 2.0

Policy YearBase 2.0
LOB / CoverageAnn Stat LineBase 2.0

Stat Line/ Ext

LOBbase 1.0

Subline

Coveragebase 1.0

Class Codebase 1.0

Model Year

Policy Form

Protection Class

Limitbase 1.0

Deductiblebase 1.0

Policy Status

Vehicle

Program Code
LocationStatebase 1.0

Territory

County

Zip Codebase 1.0

Location

Windpool Zone

Brushfire Zone

Long/Lat
EntityCompanybase 1.0

Personal / Commercialbase 1.0

Policy Identifier

Claim Identifierbase 1.0

Business Unit
TransactionTransaction
CancellationCancel Reason

Cancel Source
  • No labels