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)