Form460ScheduleDItem

Payments in support or opposition of other candidates and ballot measures.

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_election_amount   Decimal number

If the candidate is subject to contribution limits, the cumulative amount given by the filer during the election cycle as of the Form 460's filing date (from EXPN_CD.CUM_OTH)


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   Foreign Key (type determined by related field)

Foreign key referring to the Form 460 on which the payment was reported (from EXPN_CD.FILING_ID)


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

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)