Form497Part1ItemVersion

Every version of each late contribution received by a campaign filer.

Fields

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

amount_received   Decimal number

Dollar amount received (from S497_CD.AMOUNT)

contributor_city   String (up to %(max_length)s)

City of the contributor (from S497_CD.ENTY_CITY)

contributor_code   String (up to %(max_length)s)

Code describing the contributor (from S497_CD.ENTITY_CD)

Code Definition
BNM Ballot measure name/title
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
IND Individual
OFF Officer
OTH Other
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
contributor_committee_id   String (up to %(max_length)s)

Contributor's filer identification number, if it is a committee (from RCPT_CD.CMTE_ID)

contributor_employer   String (up to %(max_length)s)

Employer of the contributor (from S497_CD.CTRIB_EMP)

contributor_firstname   String (up to %(max_length)s)

First name of the contributor (from S497_CD.ENTY_NAMF)

contributor_is_self_employed   Boolean (Either True or False)

Indicates whether or not the contributor is self-employed(from S497_CD.CTRIB_SELF)

contributor_lastname   String (up to %(max_length)s)

Last name of the contributor (from S497_CD.ENTY_NAML)

contributor_name_suffix   String (up to %(max_length)s)

Name suffix of the contributor (from S497_CD.ENTY_NAMS)

contributor_occupation   String (up to %(max_length)s)

Occupation of the contributor (from S497_CD.CTRIB_OCC)

contributor_state   String (up to %(max_length)s)

State of the contributor (from S497_CD.ENTY_ST)

contributor_title   String (up to %(max_length)s)

Name title of the contributor (from S497_CD.ENTY_NAMT)

contributor_zip   String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the contributor (from S497_CD.ENTY_ZIP4)

date_received   Date (without time)

Date the late contribution was received (from S497_CD.CTRIB_DATE, unless NULL then from S497_CD.DATE_THRU)

date_received_thru   Date (without time)

End date for late contributions received over a range of days(from S497_CD.DATE_THRU)

filing_version   Foreign Key (type determined by related field)

Foreign key referring to the version of the Schedule 497 that includes the received contribution

id   Integer

line_item   Integer

Line number of the filing form where the transaction is itemized (from S497_CD.LINE_ITEM)

memo_reference_number   String (up to %(max_length)s)

Reference number for the memo attached to the transaction (from S497_CD.MEMO_REFNO)

transaction_id   String (up to %(max_length)s)

Identifies a unique transaction across versions of the a given Schedule 497 filing (from S497_CD.TRAN_ID)