...
| Field | Table | Attribute | Definition |
|---|---|---|---|
| transaction id | transaction | id | PK for transaction |
| deductible amount | transaction | deductible_amount | Deductible amount that applies to the Physical Damage coverages |
| accounting year | transaction | accounting_year | Reflects reporting year |
| exposure_amount | transaction | exposure_amount | 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 amount that applies to the Physical Damage coverages |
| zipcode | transaction | zipcode | policy zipcode |
| 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 |
...
| Field | Table | Attribute | Definition |
|---|---|---|---|
| subline id | subline | id | PK for subline |
| subline name | subline | name | Human readable name for subline |
| subline code | subline | code | Short hand for subline code |
Company
| Field | Table | Attribute | Definition |
|---|---|---|---|
| company id | company | id | PK for company |
| company name | company | name | name of company |
| company description | company | description | company description |
type_of_business
| Field | Table | Attribute | Definition |
|---|---|---|---|
| type_of_business id | type_of_business | id | PK for type_of_business |
| type_of_business name | type_of_business | name | name of type_of_business |
| type_of_business description | type_of_business | description | type_of_business description |
class_group
| Field | Table | Attribute | Definition |
|---|---|---|---|
| class_group id | class_group | id | PK for class_group |
| class_group name | class_group | name | name of class_group |
| class_group description | class_group | description | class_group description |
Model Acronyms/Definitions
| id | Acronym | Explanation |
|---|---|---|
| 1 | PK | primary key, the unique identifier for a row |
| 2 | FK | foreign key, a reference to a unique row that is defined in another table. |