CVR_CAMPAIGN_DISCLOSURE_CD

The cover page of campaign-disclosure forms.

Fields

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

AMEND_ID Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.

AMENDEXP_1 String (up to 100)

Amendment explanation line 1

AMENDEXP_2 String (up to 100)

Amendment explanation line 2

AMENDEXP_3 String (up to 100)

Amendment explanation line 3

ASSOC_CB String (up to 4)

Association Interests info included check-box. Legal values are 'X' and null.

ASSOC_INT String (up to 90)

Description of association interests

BAL_ID String (up to 9)

.CAL format to db tables doc says: "Not Used-AMS KDE"

BAL_JURIS String (up to 40)

Ballot measure jurisdiction

BAL_NAME String (up to 200)

Ballot measure name

BAL_NUM String (up to 4)

Ballot measure number or letter

BRDBASE_YN String (up to 1)

Broad Base Committee (yes/no) check box. Legal values are 'Y' or 'N'.

BUS_CITY String (up to 30)

Employer/business address city

BUS_INTER String (up to 40)

Employer/business interest description

BUS_NAME String (up to 200)

Name of employer/business. Applies to the form 461.

BUS_ST String (up to 2)

Employer/business address state

BUS_ZIP4 String (up to 10)

Employer/business address ZIP Code

BUSACT_CB String (up to 10)

Business activity info included check-box. Valid values are 'X' and null

BUSACTVITY String (up to 90)

Business activity description

CAND_CITY String (up to 30)

Candidate/officeholder city

CAND_EMAIL String (up to 60)

Candidate/officeholder email. This field is not contained on the forms.

CAND_FAX String (up to 20)

Candidate/officeholder fax. This field is not contained on the forms.

CAND_ID String (up to 9)

.CAL format to db tables doc says: "Not Used-AMS KDE"

CAND_NAMF String (up to 45)

Candidate/officeholder first name

CAND_NAML String (up to 200)

Candidate/officeholder's last name. Applies to forms 460, 465, and 496.

CAND_NAMS String (up to 10)

Candidate/officeholder's name suffix

CAND_NAMT String (up to 10)

Candidate/officeholder's prefix or title

CAND_PHON String (up to 20)

Candidate/officeholder phone

CAND_ST String (up to 4)

Candidate/officeholder's state

CAND_ZIP4 String (up to 10)

Candidate/officeholder's ZIP Code

CMTTE_ID String (up to 9)

Committee ID (Filer_id) of recipient Committee who's campaign statement is attached. This field applies to the form 401.

CMTTE_TYPE String (up to 1)

Type of Recipient Committee. Applies to the 450/460.

Code	Definition
`C`	Candidate or officeholder controlled committee
`P`	Candidate or officeholder primarily formed committee
`B`	Ballot-measure committee
`G`	General-purpose committee
Sources: Map from .CAL Format to Database Table and Fields (10), .CAL Format Layout (Version 1.05.02) (19), .CAL Format Layout (Version 2.01) (24)

CONTROL_YN Integer

Controlled Committee (yes/no) check box. Legal values are 'Y' or 'N'.

DIST_NO String (up to 4)

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

EMPLBUS_CB String (up to 4)

Employer/Business Info included check-box. Legal values are 'X' or null. Applies to the Form 461.

EMPLOYER String (up to 200)

Employer. This field is most likely unused.

ENTITY_CD String (up to 4)

The entity type of the filer. These codes vary by form type.

Code	Definition
`BMC`	Ballot measure committee
`CAO`	Candidate/officeholder
`COM`	Committee
`CTL`	Controlled committee
`IND`	Individual
`MDI`	Major Donor/Ind Expenditure
`OTH`	Other
`PTY`	Political Party
`RCP`	Recipient committee
`SCC`	Small Contributor Committee
`SMO`	Slate-mailer organization
Sources: Map from .CAL Format to Database Table and Fields (6), .CAL Format Layout (Version 1.05.02) (8-9, 18), .CAL Format Layout (Version 2.01) (9-11, 22)

FILE_EMAIL String (up to 60)

Filer's email address

FILER_CITY String (up to 30)

Filer's city

FILER_FAX String (up to 20)

Filer's fax

FILER_ID String (up to 15)

Filer's unique identification number

FILER_NAMF String (up to 45)

Filer's first name, if an individual

FILER_NAML String (up to 200)

The committee's or organization's name or if an individual the filer's last name.

FILER_NAMS String (up to 10)

Filer's suffix, if an individual

FILER_NAMT String (up to 10)

Filer's title or prefix, if an individual

FILER_PHON String (up to 20)

Filer phone number

FILER_ST String (up to 4)

Filer state

FILER_ZIP4 String (up to 10)

Filer ZIP Code

FILING_ID Integer · Unique

Unique filing identification number

FORM_TYPE String (up to 4)

Name of the source filing form or schedule

Code	Definition
`F401`	Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
`F425`	Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
`F450`	Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
`F460`	Form 460: Campaign Disclosure Statement (Recipient Committee)
`F461`	Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
`F465`	Form 465: Supplemental Independent Expenditure Report
`F496`	Form 496: Late Independent Expenditure Report
`F497`	Form 497: Late Contribution Report
`F498`	Form 498: Late Payment Report (Slate Mailer Organization)
`F511`	Form 511: Paid Spokesperson Report
`F900`	Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
Sources: .CAL Format Layout (Version 1.05.02) (18), .CAL Format Layout (Version 2.01) (22)

FROM_DATE Date (without time)

Reporting period from date

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
`sen`	Senate District
`Gov`	Statewide
`ATT`	Statewide
`CON`	Statewide
`GOV`	Statewide
`SOS`	Statewide
`SPM`	Statewide
`46`	Assembly District
`55`	Assembly District
`BSU`	County
`CSU`	County
`DAT`	County
`SHC`	County
`MAY`	City
`CCM`	City
`APP`	Other
`BED`	Other
`SCJ`	Other
`SD`	Other
`OC`	County
`AD`	Assembly District
`CA`	Unknown
`F`	Unknown
Sources: Map from .CAL Format to Database Table and Fields (13), .CAL Format Layout (Version 1.05.02) (21-22), .CAL Format Layout (Version 2.01) (28-29)

JURIS_DSCR String (up to 40)

Office Jurisdiction description if the field JURIS_CD is set to city (CIT), county (CTY), local (LOC), or other (OTH).

LATE_RPTNO String (up to 30)

Identifying Report Number used to distinguish multiple reports filed during the same filing period. For example, this field allows for multiple form 497s to be filed on the same day.

MAIL_CITY String (up to 30)

Filer mailing address city

MAIL_ST String (up to 4)

Filer mailing address state

MAIL_ZIP4 String (up to 10)

Filer mailing address ZIP Code

OCCUPATION String (up to 60)

Occupation. This field is most likely unused.

OFF_S_H_CD String (up to 1)

Office is sought or held code

Code	Definition
`S`	SOUGHT
`H`	HELD
`s`	SOUGHT
`h`	HELD
`F`	UNKNOWN
`O`	UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (21), .CAL Format Layout (Version 2.01) (28)

OFFIC_DSCR String (up to 40)

Office sought description if the field OFFICE_CD is set to other (OTH)

OFFICE_CD String (up to 3)

Identifies the office being sought

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
`Gov`	Governor
`Sen`	State Senator
`LOC`	Community College Board
`LEG`	State Senator
`REP`	State Assembly Person
`Mem`	Other
`CIT`	State Assembly Person
`PAC`	Unknown
`F`	Unknown
`COM`	Unknown
Sources: .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12)

OTHER_CB String (up to 1)

Other entity interests info included check-box. Legal values are 'X' and null.

OTHER_INT String (up to 90)

Other entity interests description

PRIMFRM_YN String (up to 1)

Primarily Formed Committee (yes/no) checkbox. Legal values are 'Y' or 'N'.

REC_TYPE String (up to 4)

Record Type Value: CVR

Code	Definition
`CVR`	Cover Page
Sources: Map from .CAL Format to Database Table and Fields (6), .CAL Format Layout (Version 1.05.02) (18), .CAL Format Layout (Version 2.01) (22), CAL-ACCESS Tables, Columns and Indexes (25)

REPORT_NUM String (up to 3)

Amendment number, as reported by the filer Report Number 000 represents an original filing. 001-999 are amendments.

REPORTNAME String (up to 3)

Attached campaign disclosure statement type. Legal values are 450, 460, and 461.

Code	Definition
`450`	Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
`460`	Form 460: Campaign Disclosure Statement (Recipient Committee)
`461`	Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
Sources: .CAL Format Layout (Version 1.05.02) (15, 20), .CAL Format Layout (Version 2.01) (19, 26)

RPT_ATT_CB String (up to 4)

Committee Report Attached check-box. Legal values are 'X' or null. This field applies to the form 401.

RPT_DATE Date (without time)

Date this report was filed, according to the filer

RPTFROMDT Date (without time)

Attached campaign disclosure statement - Period from date.

RPTTHRUDT Date (without time)

Attached campaign disclosure statement - Period through date.

SELFEMP_CB String (up to 1)

Self employed check-box. CAL format to db tables doc says: "Not Used-AMS KDE"

SPONSOR_YN Integer

Sponsored Committee (yes/no) checkbox. Legal values are 'Y' or 'N'.

STMT_TYPE String (up to 2)

Type of statement

Code	Definition
`PE`	Pre-Election (F450, F460)
`QT`	Quarterly Stmt (F450,F460)
`SA`	Semi-annual (F450, F460)
`SE`	Supplemental Pre-elect (F450, F460, F495)
`SY`	Special Odd-Yr. Campaign (F450, F460)
`S1`	Semi-Annual (Jan1-Jun30) (F425)
`S2`	Semi-Annual (Jul1-Dec31) (F425)
`TS`	Termination Statement (F450, F460)
`pe`	Pre-Election (F450, F460)
`qt`	Quarterly Stmt (F450,F460)
`sa`	Semi-annual (F450, F460)
`se`	Supplemental Pre-elect (F450, F460, F495)
`sy`	Special Odd-Yr. Campaign (F450, F460)
`ts`	Termination Statement (F450, F460)
`**`	Amendment
`1`	Unknown
`2`	Unknown
`CA`	Unknown
`MD`	Unknown
`NA`	Unknown
`PR`	Unknown
`QS`	Unknown
`S`	Unknown
`x`	Unknown
`YE`	Unknown
Sources: Map from .CAL Format to Database Table and Fields (7), .CAL Format Layout (Version 1.05.02) (18), .CAL Format Layout (Version 2.01) (23)

SUP_OPP_CD String (up to 1)

Support or opposition code

Code	Definition
`S`	SUPPORT
`O`	OPPOSITION
`s`	SUPPORT
`o`	OPPOSITION
Sources: Map from .CAL Format to Database Table and Fields (14), .CAL Format Layout (Version 1.05.02) (21), CAL-ACCESS Tables, Columns and Indexes (28), .CAL Format Layout (Version 2.01) (28)