Page History

...

Field	Table	Attribute	Definition
line of business nameid	line_of_business	nameid	human readable pk for line_of_business
line of business idcode	line_of_business	idcode	pk for line_of_businessshort hand for LOB
line of business codename	line_of_business	code	name	human readable line of businessshort hand for LOB

Transaction

Field	Table	Attribute	Definition
transaction id	transaction	id	pk for transction
deductible amount	transaction	deductible_amount	deductible amount that applies to the Physical Damage coverages
accounting year	transaction	accounting_year	Reflects reporting year	transaction 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

...

Field	Table	Attribute	Definition
coverage id	coverage_code	id	pk for coverage table
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

State

Field	Table	Attribute	Definition
state id	state	id	pk for state
state name	state	name	human readable name
state code	state	code	State Abbreviation

Transaction Code

Field	Table	Attribute	Definition
transaction id	transaction_code	id	PK for transaction 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

Subline

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 codepk for coverage table

Space shortcuts