Form460ScheduleESubItemVersion

Every version of each sub-item of a payment by a campaign filer.

Fields

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

amount Decimal number

Amount paid to the payee in the period covered by the filing (from EXPN_CD.AMOUNT)

ballot_measure_jurisdiction String (up to %(max_length)s)

If the payment went toward supporting/opposing a ballot measure, the jurisdiction subject to the ballot measure (from EXPN_CD.BAL_JURIS)

ballot_measure_name String (up to %(max_length)s)

If the payment went toward supporting/opposing a ballot measure, name of the ballot measure (from EXPN_CD.BAL_NAME or EXPN_CD.CAND_NAML)

ballot_measure_num String (up to %(max_length)s)

If the payment went toward supporting/opposing a ballot measure, ballot number or letter (from EXPN_CD.BAL_NUM)

candidate_district String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate,for state senate, assembly or local board of education, thedistrict of the office (from EXPN_CD.DIST_NO)

candidate_firstname String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate, first name of the candidate (from EXPN_CD.CAND_NAMF)

candidate_jurisdiction_code String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate,code indicating the jurisdiction of the office (from EXPN_CD.JURIS_CD)

Code	Definition
`ASM`	Assembly District
`BOE`	Board of Equalization District
`CIT`	City
`CTY`	County
`LOC`	Local
`OTH`	Other
`SEN`	Senate District
`STW`	Statewide
`???`	Statewide

candidate_jurisdiction_description String (up to %(max_length)s)

If the payment went toward supporting/opposing a county, city or local candidate, full description of the office (from EXPN_CD.JURIS_DSCR)

candidate_lastname String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate, last name of the candidate or business name (from EXPN_CD.CAND_NAML)

candidate_name_suffix String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate, name suffix of the candidate (from EXPN_CD.CAND_NAMS)

candidate_title String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate, name title of the candidate (from EXPN_CD.CAND_NAMT)

check_number String (up to %(max_length)s)

Optional check number for the payment made by the campaign filer (from EXPN_CD.EXPN_CHKNO)

cumulative_ytd_amount Decimal number

Cumulative year-to-date amount given or spent by the filer in support or opposition of the candidate or ballot measure as of the Form 460's filing date (from EXPN_CD.CUM_YTD)

expense_date Date (without time)

Date or expense (from EXPN_CD.EXPN_DATE)

filing_version Foreign Key (type determined by related field)

Foreign key referring to the version of the Form 460 that includes the payment made

id Integer

line_item Integer

Line number of the filing form where the payment is itemized (from EXPN_CD.LINE_ITEM)

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 EXPN_CD.MEMO_REFNO)

office_code String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate,code describing the office (from EXPN_CD.OFFICE_CD)

Code	Definition
`APP`	State Appellate Court Justice
`ASM`	State Assembly Person
`ASR`	Assessor
`ATT`	Attorney General
`BED`	Board of Education
`BOE`	Board of Equalization Member
`BSU`	Board of Supervisors
`CAT`	City Attorney
`CCB`	Community College Board
`CCM`	City Council Member
`CON`	State Controller
`COU`	County Counsel
`CSU`	County Supervisor
`CTR`	Local Controller
`DAT`	District Attorney
`GOV`	Governor
`INS`	Insurance Commissioner
`LTG`	Lieutenant Governor
`MAY`	Mayor
`OTH`	Other
`PDR`	Public Defender
`PER`	Public Employees Retirement System
`PLN`	Planning Commissioner
`SCJ`	Superior Court Judge
`SEN`	State Senator
`SHC`	Sheriff-Coroner
`SOS`	Secretary of State
`SPM`	Supreme Court Justice
`SUP`	Superintendent of Public Instruction
`TRE`	State Treasurer
`TRS`	Local Treasurer
`???`	Unknown value

office_description String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate,description of the office (from EXPN_CD.OFFIC_DSCR)

office_sought_held String (up to %(max_length)s)

If the payment went toward supporting/opposing a candidate,code indicating if the candidate is seeking or currently holds the office (from EXPN_CD.OFF_S_H_CD)

Code	Definition
`S`	SOUGHT
`H`	HELD

parent_transaction_id String (up to %(max_length)s)

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

payee_city String (up to %(max_length)s)

City of the payee (from EXPN_CD.PAYEE_CITY)

payee_code String (up to %(max_length)s)

Code describing the payee (from EXPN_CD.ENTITY_CD)

Code	Definition
`BNM`	Ballot measure's name/title
`CAO`	Candidate/officeholder
`COM`	Committee
`IND`	Individual
`MBR`	Member of Associaton
`OFF`	Officer
`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 EXPN_CD.CMTE_ID)

payee_firstname String (up to %(max_length)s)

First name of the payee (from EXPN_CD.PAYEE_NAMF)

payee_lastname String (up to %(max_length)s)

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

payee_name_suffix String (up to %(max_length)s)

Name suffix of the payee (from EXPN_CD.PAYEE_NAMS)

payee_state String (up to %(max_length)s)

State of the payee (from EXPN_CD.PAYEE_ST)

payee_title String (up to %(max_length)s)

Name title of the payee (from EXPN_CD.PAYEE_NAMT)

payee_zip String (up to %(max_length)s)

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

payment_code String (up to %(max_length)s)

Code describing the payment (from EXPN_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 EXPN_CD.EXPN_DSCR)

support_oppose_code String (up to %(max_length)s)

If applicable, code indicating whether the payment went toward supporting or opposing a candidate/ballot measure (from EXPN_CD.SUP_OPP_CD)

Code	Definition
`S`	Support
`O`	Oppose
`?`	Unknown value

transaction_id String (up to %(max_length)s)

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

treasurer_city String (up to %(max_length)s)

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

treasurer_firstname String (up to %(max_length)s)

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

treasurer_lastname String (up to %(max_length)s)

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

treasurer_name_suffix String (up to %(max_length)s)

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

treasurer_state String (up to %(max_length)s)

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

treasurer_title String (up to %(max_length)s)

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

treasurer_zip String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the payee committee's treasurer (from EXPN_CD.TRES_ZIP4)