Page History

...

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
class_group type	class_group	class_group_type	voluntary risk, assigned risk, miscellaneous personal vehicles

class_group_type

Field	Table	Attribute	Definition
class_group_type id	class_group_type	id	PK for class_group_type
class_group_type name	class_group_type	name	name of class_group_type
class_group_type description	class_group_type	description	class_group description

Section II: Data

class_group_type

id	name	description
1	Voluntary Risk
2	Assigned Risk	Utilize state assigned risk classification plans.
3	Miscellaneous Personal Vehicles	includes motorcycles

class_group

id	name	description	type
1	1	No Male driver under 25; non-business use	1
2	1F	No male driver under 25; Farm use	1
3	1A	No male driver under 25; non-business use, non farm, no driving to work	1
4	1B	No male driver under 25; non-business use; drives to work - limited number of miles each day	1
5	1C	No male driver under 25; non-business use; drives to work - over a limit of miles each way	1
6	1D	No male driver under 25; non-business use, drives to work - no distance restriction	1
7	3	No male driver under 25; business use	1
8	2	Driver under 25; business and non business use	1
9	2A	Male driver under 25; business and non business use; married or single male not owner or principal driver	1
10	2B	Married male driver under 25; business and non-business use	1
11	2C	Unmarried male driver under 25; business and non-business; owner or principal driver	1
12	2D	Female driver under 25	1
13	2E	Single male operator age 25-29 inclusive; owner or principal operator	1
14	Sr. Citizen	Operator age 65 and over	1
15	All Other PPNF	No class plan or other class plan used; military post coverage, all other private passener cars	1

type_of_business

id	name	description
1	Voluntary
2	Residual

state

Section III: 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