Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Attributes are to be added to up for discussion section.

...


Data NeedsResultPassthrough or Derivedrequired fieldsPriorityDateNAIC Data Fields
1Accident Year2018PassAccounting Year, Year of Lossmin
Accounting Year /  Year of Loss
2Accounting Year
Pass
min
Accounting Year
3Basic Limit Level
Pass
min

4Car Years477DerivedVehicle ID, Coverage ID, Cov Eff Date, Cov Exp Datemin
Exposure: Vehicle ID / Coverage ID / Cov Eff Date /  Cov Exp Date
5Coll Deductible$500Derived
min
Coll Deductible
6Comp Deductible$250Derived
min
Comp Deductible
7CoverageBodily InjuryPass
min
Coverage ID
8Cov Eff Date
Pass
min
Cov Eff Date
9Cov Exp Date
Pass
min
Cov Exp Date
10Coverage GroupLiabilityDerived
min
Coverage ID
11Coverage ID
Pass
min
Coverage ID
12Development Factor
Pass
min
Development Factor
13Developed Incurred Losses at Basic Limits64,999DerivedDevelopment Factor, Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, PAID LAE, Outstanding LAEmin
Development Factor / Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
14Developed Incurred Losses at Excess Limit0DerivedDevelopment Factor, Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, PAID LAE, Outstanding LAEmin
Development Factor / Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
15Earned Premium73,533Derived
min
Premium Amount
16Incurred Claim Count0DerivedNumber of Outstanding, Number of Paid Claimsmin
Number of Outstanding / Number of Paid Claims
17Incurred Loss at Basic Limits51,100DerivedBasic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAEmin
Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
18Incurred Loss at Excess Limits0DerivedBasic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAEmin
Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
19Incurred Losses51,100DerivedTransaction Type, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAEmin
Transaction Type /  Paid Losses / Outstanding Losses /  Paid LAE / Outstanding LAE
20Liability Limits Amount
Pass
min

21Line of BusinessAutomobilePass
min
Line of Business
22Number of Outstanding
Pass
min
Number of Outstanding
23Number of Paid Claims
Pass
min
Number of Paid Claims
24Outstanding LAE
Pass
min

25Outstanding Losses
Pass
min

26Paid LAE
Pass
min

27Paid Losses
Pass
min

28Premium Amount
Pass
min
Premium Amount
29StateArkansasPass
min
State
30Territory24DerivedPass
reviewmin
Territory
31Transaction Type
Pass
min
Transaction Type
32Type of BusinessVoluntaryPass
min
Type of Business
33Vehicle ID
Pass
min
Vehicle ID
34Vehicle type mentioned in NAIC HandbookPrivate PassengerPass
min
Vehicle Type ??
35Year of Loss
Pass
min
Year of Loss
36Zip Code71602Pass
min
Zip Code

...

Rules


Data Needs
Result
Passthrough
Passthrough or Derived
Rules
rules
Definitionrequired fieldsNAIC Data Fields
4Car Years
477Derived
Derivedfor car/policy pair: Eff cov-Exp cov


For a vehicle coverage pair, the difference between effective date and expiration date.Vehicle ID, Coverage ID, Cov Eff Date, Cov Exp DateExposure: Vehicle ID / Coverage ID / Cov Eff Date /  Cov Exp Date
5Coll Deductible
$500Derived
DerivedPresent in Stat planthe amount you have to pay first before the car insurance company steps in to cover the cost
Coll Deductible
6Comp Deductible
$250Derived
DerivedPresent in stat plan the amount that you have to pay out-of-pocket when filing a comprehensive insurance claim.
Comp Deductible
10Coverage Group
Liability
Derived


Coverage ID
13Developed Incurred Losses at Basic Limits
64,999
Derived

Development Factor, Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, PAID LAE, Outstanding LAEDevelopment Factor / Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
14Developed Incurred Losses at Excess Limit
0
Derived

Development Factor, Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, PAID LAE, Outstanding LAEDevelopment Factor / Basic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
15Earned Premium
73,533DerivedDerived
Derived(earned exposures/written exposures)*written premiumthat portion of a policy's premium that applies to the expired portion of the policy.
Premium Amount
16Incurred Claim Count
0
DerivedOutstanding + paid claimsThis means the total number of claims reported during the experience period (whether paid or in the process of payment) plus any incurred but not reported at the end of the experience period less the number of claims incurred but not reported at the beginning of the experience period.Number of Outstanding, Number of Paid ClaimsNumber of Outstanding / Number of Paid Claims
17Incurred Loss at Basic Limits
51,100DerivedDerived
Derived

sum(casewhen (coalesce(q.paid_losses, 0) + coalesce(q.outstanding_losses, 0)) > 25000then25000else (coalesce(q.paid_losses, 0) + coalesce(q.outstanding_losses, 0)) end)


Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAEBasic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
18Incurred Loss at Excess Limits
0Derived
Derived

sum(casewhen (coalesce(q.paid_losses, 0) + coalesce(q.outstanding_losses, 0)) <= 25000then0else (coalesce(q.paid_losses, 0) + coalesce(q.outstanding_losses, 0)) - 25000end)


Basic Limit Level, Liability Limits Amount, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAEBasic Limit Level / Liability Limits Amount / Paid Losses / Outstanding Losses / Paid LAE / Outstanding LAE
19Incurred Losses
51,100
Derived

sum(coalesce(q.paid_losses, 0) + coalesce(q.outstanding_losses, 0))

the total amount of paid claims and loss reserves associated with a particular time period,Transaction Type, Paid Losses, Outstanding Losses, Paid LAE, Outstanding LAETransaction Type /  Paid Losses / Outstanding Losses /  Paid LAE / Outstanding LAE
30Territory24DerivedTerritory