Auto Territory Coverage
Policy
| Field | Table | Attribute | Definition |
|---|---|---|---|
| state code | state | code | State Abbreviation |
| state id | state | id | pk for state |
| coverage code | coverage | code | A code that identifies the exposure coverage associated with the manual class code. |
| coverage name | coverage | name | Human readable name of coverage |
| coverage note | coverage | note | a space for notes on coverage|
| policy id | policy | id | pk for policy |
| policy number | policy | number | policy number from source system |
| policy | f_line_of_business_id | fk for line_of_business | |
| policy | f_subline_code_id | fk for subline |
Line of Business
| Field | Table | Attribute | Definition |
|---|---|---|---|
| line of business name | line_of_business | name | human readable line of business |
| line of business id | line_of_business | id | pk for line_of_business |
| line of business code | line_of_business | code | short hand for LOB |
Transaction
| Field | Table | Attribute | Definition |
|---|---|---|---|
| deductible amount | transaction | deductible_amount | deductible amount that applies to the Physical Damage coverages |
| accounting year | transaction | accounting_year | Reflects reporting year |
| premium amount | premium_detail | amount | Actual premium amount in dollars and cents. |
| loss amount | claim_detail | loss_amount | Outstanding loss and outstanding allocated loss adjustment expense records should always have the amount reserved for the claim as of the end of the quarter. This amount must be reported each quarter it remains outstanding. If a partial payment is made on an outstanding loss, the new reserve amount must be reported if the claim is not closed by the end of the quarter. |
| exposuretransaction id | transaction | id | pk for transction |
| exposure_amount | transaction | exposure_amount | Enter the actual number of vehicles covered by the premium posted in the statistical record. Usually this will be one, although it is possible for the same coverage to be provided in the same policy on more than one vehicle, in which case the Exposure entry would be the number of vehicles covered under the coding entry. |
| transaction type | transaction | type | |
| deductible_amount | transaction | deductible_amount | deductible amoDunt that applies to the Physical Damage coverages |
| transaction | f_transactional_code_id | fk for tbl: transaction_code | |
| transaction | f_state_id | fk for tbl: state | |
| transaction | f_coverage_code_id | fk for tbl: coverage_code | |
| transaction | f_policy_id | fk for tbl: policy |
Claim Detail
| Field | Table | Attribute | Definition | |||
|---|---|---|---|---|---|---|
| clam detail id | claim_detail | id | pk for claim details | |||
| claim count | claim_detail | claim_count | Actual number of new claims reported in a given reporting period. The rules for negative counts are the same as those for the Exposure field. The claim count on a paid loss record should be 1 only when the first payment is made provided no reserve had been established in a previous quarter. | |||
| line of business | line_of_business | name | human readable line of business | |||
| line of business | line_of_business | id | pk for line_of_business | |||
| subline name | subline | name | Identifies the subline for humans | |||
| subline code | subline | code | short hand for subline name | |||
| subline id | subline | id | pk for unique identification of codes | |||
| transaction code | transaction_code | code | Identifies a loss transaction on limited coded records. The field will be populated on loss-related Transaction Codes if the record is not fully coded. | |||
| transaction name | transaction_code | name | human readable name for transaction code | |||
| transaction id | transaction_code | id | PK for transaction codes | |||
| accident date year | claim_detail | accident_date_year | The date on which the accident occurred (except for grouped claims) | |||
| claim id | claim_detail | id | PK for claim detailaccident date year | claim_detail | accident_date_year | The date on which the accident occurred (except for grouped claims) |
| loss amount | claim_detail | loss_amount | Outstanding loss and outstanding allocated loss adjustment expense records should always have the amount reserved for the claim as of the end of the quarter. This amount must be reported each quarter it remains outstanding. If a partial payment is made on an outstanding loss, the new reserve amount must be reported if the claim is not closed by the end of the quarter. | |||
| claim_detail | f_transaction_id | fk to relate to parent transaction |
Premium Detail
| Field | Table | Attribute | Definition |
|---|---|---|---|
| premium detail id | premium_detail | id | pk for premium details |
| premium amount | premium_detail | amount | amount paid |
| premium_detail | f_transaction_id | fk to parent transaction |
Coverage Code
| Field | Table | Attribute | Definition |
|---|---|---|---|
| coverage code | coverage_code | code | A code that identifies the exposure coverage associated with the manual class code. |
| coverage name | coverage_code | name | Human readable name of coverage |
| coverage note | coverage_code | note | a space for notes on coverage |
| coverage id | coverage_code | id | pk for coverage table |