Form460ScheduleFItemVersion

Every version of each accrued expense of a campaign filer.

Fields

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

amount_incurred Decimal number

Amount incurred this period (from DEBT_CD.AMT_INCUR)

amount_paid Decimal number

Amount paid this period (from DEBT_CD.AMT_PAID)

begin_balance Decimal number

Outstanding balance at the beginning of period covered by the filing (from DEBT_CD.BEG_BAL)

end_balance Decimal number

Outstanding balance at the end of period covered by the filing (from DEBT_CD.END_BAL)

filing_version Foreign Key (type determined by related field)

Foreign key referring to the version of the Form 460 that includes the Schedule F items

id Integer

line_item Integer

Line number of the filing form where the unpaid bill is itemized (from DEBT_CD.LINE_ITEM)

memo_code Boolean (Either True or False)

Memo amount flag (from DEBT_CD.MEMO_CODE)

memo_reference_number String (up to %(max_length)s)

A value assigned by the filer which refers to the item'sfootnote in the TEXT_MEMO_CD table (from DEBT_CD.MEMO_REFNO)

parent_transaction_id String (up to %(max_length)s)

Refers to a parent transaction itemized on the same Form 460 filing (from DEBT_CD.BAKREF_TID)

payee_city String (up to %(max_length)s)

City of the payee (from DEBT_CD.PAYEE_CITY)

payee_code String (up to %(max_length)s)

Code describing the payee (from DEBT_CD.ENTITY_CD)

Code	Definition
`BNM`	Ballot measure's name/title
`COM`	Committee
`IND`	Individual
`OTH`	Other
`PTY`	Political Party
`RCP`	Recipient committee
`SCC`	Small Contributor Committee
`???`	Unknown value

payee_committee_id String (up to %(max_length)s)

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

payee_firstname String (up to %(max_length)s)

First name of the payee (from DEBT_CD.PAYEE_NAMF)

payee_lastname String (up to %(max_length)s)

Last name of the payee or business name (from DEBT_CD.PAYEE_NAML)

payee_name_suffix String (up to %(max_length)s)

Name suffix of the payee (from DEBT_CD.PAYEE_NAMS)

payee_state String (up to %(max_length)s)

State of the payee (from DEBT_CD.PAYEE_ST)

payee_title String (up to %(max_length)s)

Name title of the payee (from DEBT_CD.PAYEE_NAMT)

payee_zip String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the payee (from DEBT_CD.PAYEE_ZIP4)

payment_code String (up to %(max_length)s)

Code describing the payment (from DEBT_CD.EXPN_CODE)

Code	Definition
`CMP`	Campaign paraphernalia/miscellaneous
`CNS`	Campaign consultants
`CTB`	Contribution (if nonmonetary, explain)*
`CVC`	Civic donations
`FIL`	Candidate filing/ballot feeds
`FND`	Fundraising events
`IKD`	In-kind contribution (nonmonetary)
`IND`	Independent expenditure supporting/opposing others (explain)*
`LEG`	Legal defense
`LIT`	Campaign literature and mailings
`LON`	Loan
`MBR`	Member communications
`MON`	Monetary contribution
`MTG`	Meetings and appearances
`OFC`	Office expenses
`PET`	Petition circulating
`PHO`	Phone banks
`POL`	Polling and survey research
`POS`	Postage, delivery and messenger services
`PRO`	Professional services (legal, accounting)
`PRT`	Print ads
`RAD`	Radio airtime and production costs
`RFD`	Returned contributions
`SAL`	Campaign workers salaries
`TEL`	T.V. or cable airtime and production costs
`TRC`	Candidate travel, lodging and meals (explain)
`TRS`	Staff/spouse travel, lodging and meals (explain)
`TSF`	Transfer between committees of the same candidate/sponsor
`VOT`	Voter registration
`WEB`	Information technology costs (internet, e-mail)
`???`	Unknown value

payment_description String (up to %(max_length)s)

Purpose of payment and/or description/explanation (from DEBT_CD.EXPN_DSCR)

transaction_id String (up to %(max_length)s)

Identifies a unique transaction across versions of the a given Form 460 filing (from DEBT_CD.TRAN_ID)

treasurer_city String (up to %(max_length)s)

City of the payee committee's treasurer (from DEBT_CD.TRES_CITY)

treasurer_firstname String (up to %(max_length)s)

First name of the payee committee's treasurer (from DEBT_CD.TRES_NAMF)

treasurer_lastname String (up to %(max_length)s)

Last name of the payee committee's treasurer (from DEBT_CD.TRES_NAML)

treasurer_name_suffix String (up to %(max_length)s)

Name suffix of the payee committee's treasurer (from DEBT_CD.TRES_NAMS)

treasurer_state String (up to %(max_length)s)

State of the payee committee's treasurer (from DEBT_CD.TRES_ST)

treasurer_title String (up to %(max_length)s)

Name title of the payee committee's treasurer (from DEBT_CD.TRES_NAMT)