LOBBYIST_EMPLOYER2_CD

Deprecated table for the disclosure of lobbyist relationships.

Fields

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


EMPLOYER_ID   Integer

Employer identification number


SESSION_ID   Integer

Legislative session identification number


EMPLOYER_NAME   String (up to 300)

Employer name


CURRENT_QTR_AMT   Floating point number

Current quarter amount


SESSION_TOTAL_AMT   Floating point number

Total amount for the session


CONTRIBUTOR_ID   Integer

Contributor identification number


INTEREST_CD   Integer

Interest Code

Code Definition
40301 AGRICULTURE
40302 EDUCATION
40303 ENTERTAINMENT/RECREATION
40304 FINANCE/INSURANCE
40305 GOVERNMENT
40306 HEALTH
40307 LABOR UNIONS
40308 LEGAL
40309 LODGING/RESTAURANTS
40310 MANUFACTURING/INDUSTRIAL
40311 MERCHANDISE/RETAIL
40312 MISCELLANEOUS
40313 OIL AND GAS
40314 POLITICAL ORGANIZATIONS
40315 PROFESSIONAL/TRADE
40316 PUBLIC EMPLOYEES
40317 REAL ESTATE
40318 TRANSPORTATION
40319 UTILITIES
Sources: Lookup-Codes-Cd (19)

INTEREST_NAME   String (up to 24)

Interest name


SESSION_YR_1   Integer

Total amount of year 1 of the session


SESSION_YR_2   Integer

Total amount of year 2 of the session


YR_1_YTD_AMT   Floating point number

Year 1 year-to-date-amount


YR_2_YTD_AMT   Floating point number

Year 2 year-to-date-amount


QTR_1   Floating point number

Quarter 1 total amount


QTR_2   Floating point number

Quarter 2 total amount


QTR_3   Floating point number

Quarter 3 total amount


QTR_4   Floating point number

Quarter 4 total amount


QTR_5   Floating point number

Quarter 5 total amount


QTR_6   Floating point number

Quarter 6 total amount


QTR_7   Floating point number

Quarter 7 total amount


QTR_8   Floating point number

Quarter 8 total amount


References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 11, 98-99)