LOBBYING_CHG_LOG_CD

Log of lobbyist filings compiled for display on the state website.

Fields

Information about the 25 fields and the definitions of any abbreviated values.

FILER_ID   Integer · Unique

Filer's unique identification number

CHANGE_NO   Integer · Unique

Number of changes this session

SESSION_ID   Integer

Legislative session identification number

LOG_DT   Date (without time)

This field is undocumented

FILER_TYPE   Integer

Foreign key referencing FilerTypesCd.filer_type

CORRECTION_FLG   String (up to 200)

This field is undocumented

ACTION   String (up to 200)

This field is undocumented

ATTRIBUTE_CHANGED   String (up to 200)

This field is undocumented

ETHICS_DT   Date (without time)

This field is undocumented

INTERESTS   String (up to 200)

This field is undocumented

FILER_FULL_NAME   String (up to 200)

Full name of filer

FILER_CITY   String (up to 200)

City address of filer

FILER_ST   String (up to 200)

State address of filer

FILER_ZIP   Integer

ZIP Code of filer

FILER_PHONE   String (up to 12)

Phone number of filer

ENTITY_TYPE   Integer

This field is undocumented. The values might refer to either FILER_TYPES_CD.FILER_TYPE or GROUP_TYPES_CD.GRP_ID, but that's just a guess.

Code Definition
0 n/a
1 Client
2 Employer
3 Firm
4 Lobbyist
10 Major Donor
16 Recipient Committee
20 Treasurer/Responsible Officer
ENTITY_NAME   String (up to 500)

This field is undocumented

ENTITY_CITY   String (up to 500)

This field is undocumented

ENTITY_ST   String (up to 500)

This field is undocumented

ENTITY_ZIP   String (up to 10)

This field is undocumented

ENTITY_PHONE   String (up to 12)

Entity phone number

ENTITY_ID   Integer

Entity identification number

RESPONSIBLE_OFFICER   String (up to 500)

This field is undocumented

EFFECT_DT   Date (without time)

This field is undocumented

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 91-92)