Form497FilingVersion
Every version of each Schedule 497 filing by a campaign filer.
Fields
Information about the 8 fields and the definitions of any abbreviated values.
amend_id
Integer
Identifies the version of the Schedule 497 filing, with 0 representing the initial filing (from CVR_CAMPAIGN_DISCLOSURE_CD.AMEND_ID)
date_filed
Date (without time)
Date this report was filed, according to the filer (from CVR_CAMPAIGN_DISCLOSURE.RPT_DATE)
election_date
Date (without time)
Date of the election in which the filer is participating (from CVR_CAMPAIGN_DISCLOSURE.ELECT_DATE)
filer_firstname
String (up to %(max_length)s)
First name of the filer (from CVR_CAMPAIGN_DISCLOSURE.FILER_NAMF)
filer_id
Integer
Numeric filer identification number (from FILER_XREF.FILER_ID)
filer_lastname
String (up to %(max_length)s)
Last name of filer (from CVR_CAMPAIGN_DISCLOSURE.FILER_NAML)
filing
Foreign Key (type determined by related field)
Unique identification number for the Schedule 497 filing (from S497_CD.FILING_ID)
id
Integer