LEXP_CD

Lobbying activity expenditures.

Fields

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

AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.

AMOUNT   Decimal number

Amount of payment

BAKREF_TID   String (up to 20)

Backreference to the tranaction identifer of parent record

BENE_AMT   String (up to 12)

Amount benefiting benficiary

BENE_NAME   String (up to 90)

Name of the person beneifiting

BENE_POSIT   String (up to 90)

Official position of the person beneifiting

CREDCARDCO   String (up to 200)

Name of the credit card company, if paid using a card

ENTITY_CD   String (up to 3)

Entity Code of the Payee

Code Definition
IND Person (spending > $5000)
OTH Other
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (75)
EXPN_DATE   Date (without time)

Date of expenditure

EXPN_DSCR   String (up to 90)

Purpose of the expense and a description or explanation

FILING_ID   Integer · Unique

Unique filing identification number

FORM_TYPE   String (up to 7) · Unique

Name of the source filing form or schedule

Code Definition
F615P1 Form 615 (Lobbyist Report): Part 1, Activity Expenses Paid, Incurred, Arranged or Provided by the Lobbyist
F625P3A Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses
F635P3C Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses
F645P2A Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section A, Activity Expenses
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)
LINE_ITEM   Integer · Unique

Line item number of this record

MEMO_CODE   String (up to 1)

Memo amount flag

MEMO_REFNO   String (up to 20)

Reference to the text in a TEXT record

PAYEE_CITY   String (up to 30)

Payee city

PAYEE_NAMF   String (up to 45)

Payee first name

PAYEE_NAML   String (up to 200)

Payee last name or business name

PAYEE_NAMS   String (up to 10)

Payee suffix

PAYEE_NAMT   String (up to 10)

Payee title or prefix

PAYEE_ST   String (up to 2)

Payee state

PAYEE_ZIP4   String (up to 10)

Payee ZIP Code

REC_TYPE   String (up to 4) · Unique

Record Type Value: LEXP

Code Definition
LEXP LEXP
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)
RECSUBTYPE   String (up to 1)

Record Subtype

Code Definition
1 Main
2 Detail
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)
TRAN_ID   String (up to 20)

Permanent value unique to this item

Forms

The forms that the state uses to collect the information that populates this file.

Form 615: Lobbyist Report

Part 1, Activity Expenses Paid, Incurred, Arranged or Provided by the Lobbyist

Form 625: Report of Lobbying Firm

Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses

Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition

Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses

Form 645: Report of Person Spending $5,000 or More

Part 2, Payments Made this Period, Section A, Activity Expenses

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 86-87)

  • Map from .CAL Format to Database Table and Fields (p. 58-59)

  • .CAL Format Layout (Version 1.05.02) (p. 61)

  • .CAL Format Layout (Version 2.01) (p. 74-75)