LOBBYIST_EMPLOYER_HISTORY_CD

Undocumented.

Fields

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


CONTRIBUTOR_ID   Integer

Contributor identification number.


CURRENT_QTR_AMT   Integer

Current Quarter Amount


EMPLOYER_ID   Integer

Employer identification number.


EMPLOYER_NAME   String (up to 300)

Employer Name


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 300)

Interest name.


QTR_1   Integer

Quarter 1 total amount.


QTR_2   Integer

Quarter 2 total amount.


QTR_3   Integer

Quarter 3 total amount.


QTR_4   Integer

Quarter 4 total amount.


QTR_5   Integer

Quarter 5 total amount.


QTR_6   Integer

Quarter 6 total amount.


QTR_7   Integer

Quarter 7 total amount.


QTR_8   Integer

Quarter 8 total amount.


SESSION_ID   Integer

Session identification number.


SESSION_TOTAL_AMT   Integer

Total amount for the session.


SESSION_YR_1   Integer

Total amount for year 1 of the session.


SESSION_YR_2   Integer

Total amount for year 2 of the session.


YR_1_YTD_AMT   Integer

Year 1 year to date amount.


YR_2_YTD_AMT   Integer

Year 2 year to date amount.


References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 11, 96-97)