Page History

...

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.

Space shortcuts