CVR_F470_CD

The cover page for officeholder and candidate short and supplemental forms.

Fields

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


AMEND_ID   Integer · Unique

Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments.


CAND_ADR1   String (up to 55)

First line of the filer's street address.


CAND_ADR2   String (up to 55)

Second line of the filer's street address.


CAND_CITY   String (up to 30)

Candidate/Officeholder's City.


CAND_EMAIL   String (up to 60)

Candidate/Officeholder's EMail address. Not required by the form.


CAND_FAX   String (up to 20)

Candidate/Officeholder's FAX Phone Number. Not required by the form.


CAND_PHON   String (up to 20)

Candidate/Officeholder's phone number.


CAND_ST   String (up to 2)

Filer's State


CAND_ZIP4   String (up to 10)

Filer's zipcode


DATE_1000   Date (without time)

Date contributions totaling $1,000 or more. (For the 470-S)


DIST_NO   String (up to 3)

District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races.


ELECT_DATE   Date (without time)

Date of the general election. Required for filings in even years.


ENTITY_CD   String (up to 3)

The filer's entity code. The value of this column will always be Candidate/Office Holder (CAO) for this table.

Code Definition
CAO Candidate/officeholder
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (29)

FILER_ID   String (up to 9)

Filer's unique identification number.


FILER_NAMF   String (up to 45)

Filer's First Name(s) - required for individuals


FILER_NAML   String (up to 200)

Filer's Last Name/Committee name


FILER_NAMS   String (up to 10)

Filer's Name Suffix


FILER_NAMT   String (up to 10)

The filer's prefix or title that preceeds their name if they are an individual.


FILING_ID   Integer · Unique

Unique filing identification number.


FORM_TYPE   String (up to 4) · Unique

Type of Filing or Formset. The value of this column will always be equal to F470.

Code Definition
Form 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (29)

JURIS_CD   String (up to 3)

Office Jurisdiction Code

Code Definition
ASM Assembly District
BOE Board of Equalization District
CIT City
CTY County
LOC Local
OTH Other
SEN Senate District
STW Statewide
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (29)

JURIS_DSCR   String (up to 40)

Office jurisdiction description text reqired if the jurisdiction code (Juris_cd) is equal to CIT, CTY, LOC, or OTH.


OFF_S_H_CD   String (up to 1)

Office Sought/Held code. Legal values are "S" for sought and "H" for held.

Code Definition
H HELD
S SOUGHT
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (30)

OFFIC_DSCR   String (up to 40)

Office sought description used if the office code is other (OTH).


OFFICE_CD   String (up to 3)

Code that identifies the office being sought. See the CAL document for a list of valid codes.

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
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (29)

REC_TYPE   String (up to 3) · Unique

Type of CAL record. This column will always contain CVR.

Code Definition
CVR Cover Page
Sources: .CAL Format Layout (Version 1.05.02) (22), .CAL Format Layout (Version 2.01) (29)

REPORT_NUM   String (up to 3)

Report Number; 000 Original; 001-999 Amended as reported in the filing.


RPT_DATE   Date (without time)

Date this report is filed as reported by the filer.


Forms

The forms that the state uses to collect the information that populates this file.



References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 30-32)

  • Map from .CAL Format to Database Table and Fields (p. 15-16)

  • .CAL Format Layout (Version 1.05.02) (p. 22)

  • .CAL Format Layout (Version 2.01) (p. 29-30)