D:\DB2012.mdb Monday, May 14, 2012

Table: Acronyms Page: 1

Properties

DateCreated: 5/14/2012 3:46:59 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:46:59 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 301

Updatable: True

Columns

Name Type Size

Acronym Text 12

Description Text 64

D:\DB2012.mdb Monday, May 14, 2012

Table: Agendas Page: 2

Properties

DateCreated: 5/14/2012 3:46:59 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:46:59 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 275

Updatable: True

Columns

Name Type Size

CommHouse Text 4

Date Text 255

Time Text 255

Type Text 100

Location Text 120

Comments Text 255

RevDate Date/Time 8

Status Text 100

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 4

Fields:

CommHouse Ascending

Date Ascending

Time Ascending

Type Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: BAgenda Page: 3

Properties

DateCreated: 5/14/2012 3:46:59 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:46:59 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 667

Updatable: True

Columns

Name Type Size

CommHouse Text 4

Date Text 255

Time Text 255

Type Text 100

BillType Text 3

BillNumber Integer 2

Category Text 100

RevDate Date/Time 8

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 6

Fields:

CommHouse Ascending

Date Ascending

Time Ascending

Type Ascending

BillType Ascending

BillNumber Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: BillHist Page: 4

Properties

DateCreated: 5/14/2012 3:46:59 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:00 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 5905

Updatable: True

Columns

Name Type Size

BillType Text 3

BillNumber Integer 2

Sequence Integer 2

DateAction Date/Time 8

Action Text 16

Comment Text 35

House Text 1

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 3

Fields:

BillType Ascending

BillNumber Ascending

Sequence Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: BillSpon Page: 5

Properties

DateCreated: 5/14/2012 3:47:00 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:00 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 12519

Updatable: True

Columns

Name Type Size

BillType Text 3

BillNumber Long Integer 4

Sequence Integer 2

Sponsor Text 255

Type Text 1

Status Text 1

SponDate Date/Time 8

WithDate Date/Time 8

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 5

Fields:

BillType Ascending

BillNumber Ascending

Sequence Ascending

Sponsor Ascending

Type Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: BillSubj Page: 6

Properties

DateCreated: 5/14/2012 3:47:00 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:00 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 9518

Updatable: True

Columns

Name Type Size

BillType Text 3

BillNumber Integer 2

SubjectKey Text 12

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 3

Fields:

BillType Ascending

BillNumber Ascending

SubjectKey Ascending

SubjectKey 1

Fields:

SubjectKey Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: BillWP Page: 7

Properties

DateCreated: 5/14/2012 3:47:00 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 5717

Updatable: True

Columns

Name Type Size

BillType Text 3

BillNumber Long Integer 4

Document Text 60

DocType Text 3

ReprintNum Integer 2

Pages Integer 2

Comment Text 50

ModDate Date/Time 8

Table Indexes

Name Number of Fields

PrimaryKey 4

Fields:

BillType Ascending

BillNumber Ascending

Document Ascending

DocType Ascending

ReprintNum 1

Fields:

ReprintNum Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: COMember Page: 8

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 279

Updatable: True

Columns

Name Type Size

Code Text 4

Member Text 255

Position_on_Committee Text 1

Assignment_to_Committee Text 1

ModDate Date/Time 8

Table Indexes

Name Number of Fields

Code 1

Fields:

Code Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: Committee Page: 9

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 43

Updatable: True

Columns

Name Type Size

Code Text 4

Description Text 60

House Text 1

Group Text 1

Type Text 25

Aide Text 255

Phone Text 255

ModDate Date/Time 8

Table Indexes

Name Number of Fields

Code 1

Fields:

Code Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: LegBio Page: 10

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 121

Updatable: True

Columns

Name Type Size

Roster Key Integer 2

Last_Name Text 17

First_Name Text 12

Middle_Name Text 12

Suffix Text 4

Legislator Text 255

DOB Text 100

Education Memo -

PublicService Memo -

LegService Memo -

Occupation Text 255

MilitaryService Text 255

URLPicture Text 255

PictureText Text 255

Table Indexes

Name Number of Fields

Roster Key 1

Fields:

Roster Key Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: MainBill Page: 11

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 5238

Updatable: True

Columns

Name Type Size

BillType Text 3

BillNumber Integer 2

CurrentStatus Text 4

LDOA Date/Time 8

IntroDate Date/Time 8

ActualBillNumber Text 100

BillParty1 Text 1

BillParty2 Text 1

BillParty3 Text 1

GovernorAction Text 4

GovernorDateOfAction Date/Time 8

PamphletLaw Integer 2

ChapterLaw Integer 2

EffectOnStatutes Text 1

EffectiveDate Date/Time 8

Codification Text 50

FirstPrime Text 40

SecondPrime Text 40

ThirdPrime Text 40

Synopsis Text 255

EfDateNote Text 100

IdenticalBillNumber Text 50

LastSessionFullBillNumber Text 50

OldBillNumber Text 50

ProposedDate Date/Time 8

Abstract Text 80

ModDate Date/Time 8

Table Indexes

Name Number of Fields

IdenticalBillNumber 1

Fields:

IdenticalBillNumber Ascending

PrimaryKey 2

Fields:

BillType Ascending

BillNumber Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: NAgenda Page: 12

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 250

Updatable: True

Columns

Name Type Size

CommHouse Text 4

Date Text 255

Time Text 255

Type Text 100

Action Text 100

LastName Text 17

FirstName Text 12

MiddleName Text 12

Position Text 180

Term Text 180

Resides_At Text 40

ModDate Date/Time 8

D:\DB2012.mdb Monday, May 14, 2012

Table: Roster Page: 13

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 121

Updatable: True

Columns

Name Type Size

District Integer 2

House Text 1

LastName Text 17

Firstname Text 12

MidName Text 12

Suffix Text 4

Sex Text 1

Title Text 20

LegPos Text 30

LegStatus Text 100

Party Text 1

Race Text 25

Address Text 255

City Text 40

State Text 20

Zipcode Text 10

Phone Text 20

Email Text 100

Roster Key Integer 2

Table Indexes

Name Number of Fields

Roster Key 1

Fields:

Roster Key Ascending

Zipcode 1

Fields:

Zipcode Ascending

D:\DB2012.mdb Monday, May 14, 2012

Table: SubjHeadings Page: 14

Properties

DateCreated: 5/14/2012 3:47:01 PM DefaultView: Datasheet

LastUpdated: 5/14/2012 3:47:01 PM OrderByOn: False

Orientation: Left-to-Right RecordCount: 195

Updatable: True

Columns

Name Type Size

SubjAbbrev Text 12

SubOrTopic Text 1

Description Text 60

Parent Text 12

ModDate Date/Time 8