EXPN_CD

Itemized campaign expenditures.

Fields

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

AGENT_NAMF   String (up to 45)

Agent of Ind. Contractor's First name

AGENT_NAML   String (up to 200)

Agent of Ind. Contractor's Last name (Sched G)

AGENT_NAMS   String (up to 10)

Agent of Ind. Contractor's Suffix

AGENT_NAMT   String (up to 10)

Agent of Ind. Contractor's Prefix or Title

AMEND_ID   Integer · Unique

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

AMOUNT   Decimal number

Amount of Payment

BAKREF_TID   String (up to 20)

Back Reference to a Tran_ID of a 'parent' record

BAL_JURIS   String (up to 40)

Ballot measure's jurisdiction

BAL_NAME   String (up to 200)

Ballot Measure Name

BAL_NUM   String (up to 7)

Ballot Number or Letter

CAND_NAMF   String (up to 45)

Candidate's First name

CAND_NAML   String (up to 200)

Candidate's Last name

CAND_NAMS   String (up to 10)

Candidate's Suffix

CAND_NAMT   String (up to 10)

Candidate's Prefix or Title

CMTE_ID   String (up to 9)

Committee ID (If [COM|RCP] & no ID#, Treas info Req.)

CUM_OTH   Decimal number

Cumulative / 'Other' (No Cumulative on Sched E & G)

CUM_YTD   Decimal number

Cumulative / Year-to-date amount (No Cumulative on Sched E & G)

DIST_NO   String (up to 3)

Office District Number (Req. if Juris_Cd=[SEN|ASM|BOE]

ENTITY_CD   String (up to 3)

Entity Code describing payee

Code Definition
COM Committee
IND Individual
RCP Recipient committee
OTH Other
PTY Political Party
SCC Small Contributor Committee
BNM Ballot measure's name/title
CAO Candidate/officeholder
MBR Member of Associaton
OFF Officer
0 Unknown
PTH Unknown
RFD Unknown
Sources: .CAL Format Layout (Version 1.05.02) (8-9, 31), .CAL Format Layout (Version 2.01) (9-11, 42)
EXPN_CHKNO   String (up to 20)

Check Number (Optional)

EXPN_CODE   String (up to 4)

The type of expenditure

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)
ctb contribution (if nonmonetary, explain)*
ikd In-kind contribution (nonmonetary)
Mon monetary contribution
ofc office expenses
OFc office expenses
Ofc office expenses
Unknown
* Unknown
0 Unknown
001 Unknown
011 Unknown
200 Unknown
401 Unknown
ADV Unknown
ANN Unknown
APR Unknown
AUG Unknown
AUT Unknown
Ban Unknown
BAN Unknown
BOO Unknown
BOX Unknown
C Unknown
CAT Unknown
CC Unknown
CHE Unknown
CIV Unknown
CNT Unknown
CON Unknown
COP Unknown
CRE Unknown
CSN Unknown
CT Unknown
,CT Unknown
.CT Unknown
CTN Unknown
CVD Unknown
DAT Unknown
DEC Unknown
Dem Unknown
DIN Unknown
Don Unknown
DON Unknown
Ear Unknown
EIM Unknown
EMP Unknown
F Unknown
FAX Unknown
FDN Unknown
FED Unknown
FEE Unknown
FIN Unknown
Fun Unknown
FUN Unknown
G Unknown
GEN Unknown
GGG Unknown
GOT Unknown
IEs Unknown
IN- Unknown
Ina Unknown
INK Unknown
INS Unknown
ITE Unknown
JAN Unknown
JUL Unknown
JUN Unknown
KIC Unknown
L Unknown
LEV Unknown
Lit Unknown
LN# Unknown
LOG Unknown
M Unknown
MAI Unknown
Mar Unknown
MAR Unknown
MAY Unknown
MED Unknown
MEE Unknown
MGT Unknown
Mis Unknown
MRB Unknown
NGP Unknown
NON Unknown
NOT Unknown
NOV Unknown
O Unknown
OCT Unknown
.OF Unknown
OFF Unknown
OPE Unknown
OTH Unknown
P Unknown
Pac Unknown
PAI Unknown
PAR Unknown
PAY Unknown
PEN Unknown
PMT Unknown
.PO Unknown
Pos Unknown
PRE Unknown
PRI Unknown
PRP Unknown
R Unknown
.Re Unknown
.RE Unknown
REF Unknown
REI Unknown
RFP Unknown
S Unknown
S-A Unknown
SA Unknown
Sal Unknown
S C Unknown
S.C Unknown
SCU Unknown
SEE Unknown
SEN Unknown
SEP Unknown
S.M. Unknown
SOF Unknown
SWI Unknown
T Unknown
TAX Unknown
TB Unknown
TB, Unknown
TIC Unknown
Tor Unknown
TRA Unknown
TRF Unknown
TRV Unknown
UN Unknown
UTI Unknown
V Unknown
VEN Unknown
-VO Unknown
VOI Unknown
VOY Unknown
WI Unknown
x Unknown
X Unknown
S-6 Unknown
S.M Unknown
S-4 Unknown
SA: Unknown
100 Unknown
RFN Unknown
REN Unknown
003 Unknown
S-1 Unknown
08 Unknown
Sources: .CAL Format Layout (Version 1.05.02) (11), .CAL Format Layout (Version 2.01) (13-14)
EXPN_DATE   Date (without time)

Date of Expenditure (Note: Date not on Sched E & G)

EXPN_DSCR   String (up to 400)

Purpose of expense and/or description/explanation

FILING_ID   Integer · Unique

Unique filing identification number

FORM_TYPE   String (up to 6) · Unique

Name of the source filing form or schedule

Code Definition
F450P5 Form 450 (Campaign Disclosure Statement, Short Form (Recipient Committee)): Part 5, Payments Made
D Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees
E Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule E, Payments Made
G Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)
F461P5 Form 461 (Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)): Part 5, Contributions (Including Loans, Forgiveness of Loans, and LoanGuarantees) and Expenditures Made
F465P3 Form 465 (Supplemental Independent Expenditure Report): Part 3, Independent Expenditures Made
Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
Sources: .CAL Format Layout (Version 1.05.02) (31), .CAL Format Layout (Version 2.01) (42)
G_FROM_E_F   String (up to 1)

Back Reference from Sched G to Sched 'E' or 'F'?

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
Cit City
sen Senate District
Sen Senate District
stw Statewide
APP Statewide
ASR County
ATT Statewide
GOV Statewide
LTG Statewide
SOS Statewide
SUP Statewide
TRE Statewide
BSU County
CSU County
ES City
SM City
BED Other
CCB Other
CCM Other
PDR Other
12 Senate District
4 Statewide
8 Statewide
27 Statewide
93 Statewide
98 Statewide
CLB Unknown
PER Unknown
Boa Board of Equalization District
Sta Unknown
STA Unknown
CA Unknown
SAN Unknown
ES Unknown
CON Unknown
LA Unknown
LBC Unknown
OR Unknown
SB Unknown
WES Unknown
BM Unknown
(Lo Unknown
(Ci Unknown
vty Unknown
OC Unknown
SM Unknown
ASS Unknown
JR Unknown
O Unknown
ADM Unknown
SAC Unknown
US Unknown
J Unknown
LOS Unknown
IRV Unknown
CO Unknown
JRS Unknown
NEV Unknown
IB Unknown
A Unknown
Ass Unknown
SD Unknown
D Unknown
SEC Unknown
SC Unknown
RB Unknown
GEN Unknown
CC Unknown
FED Unknown
FM Unknown
R Unknown
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)
JURIS_DSCR   String (up to 40)

Office Jurisdiction Description (Req. if Juris_Cd=[CIT|CTY|LOC|OTH]

LINE_ITEM   Integer · Unique

Line item number of this record

MEMO_CODE   String (up to 1)

Memo Amount? (Date/Amount are informational only). For Form 460 filings, this indicates the record is a sub-item and its amount is included in another item reported on the filing.

MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record.

OFF_S_H_CD   String (up to 1)

Office is sought or held code

Code Definition
H HELD
S SOUGHT
s SOUGHT
h HELD
A UNKNOWN
a UNKNOWN
8 UNKNOWN
O UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)
OFFIC_DSCR   String (up to 40)

Office Sought Description (Req. if Office_Cd=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
Cou County Counsel
sen State Senator
AtT Attorney General
May Mayor
Sen State Senator
asm State Assembly Person
gov Governor
Gov Governor
LA Unknown
HOU Unknown
LAD Unknown
11A Unknown
001 Unknown
BM Unknown
AS1 Unknown
ASS Unknown
73 Unknown
CIT Unknown
HSE Unknown
LT Unknown
CTY Unknown
STA Unknown
GO Unknown
CO Unknown
A Unknown
PAC Unknown
REP Unknown
OFF Unknown
SE Unknown
031 Unknown
COM Unknown
ASB Unknown
OT Unknown
NAT Unknown
CC Unknown
SWE Unknown
FED Unknown
STE Unknown
H Unknown
DA Unknown
S Unknown
AS Unknown
OF Unknown
LEG Unknown
STW Unknown
ST Unknown
PRE Unknown
/S Unknown
U S Unknown
O Unknown
8 Unknown
C:S Unknown
Sources: .CAL Version 2.01 Errata (2), .CAL Format Layout (Version 1.05.02) (10), .CAL Format Layout (Version 2.01) (12)
PAYEE_CITY   String (up to 30)

Payee City

PAYEE_NAMF   String (up to 45)

Payee's First name

PAYEE_NAML   String (up to 200)

Payee's Last name

PAYEE_NAMS   String (up to 10)

Payee's Suffix

PAYEE_NAMT   String (up to 10)

Payee's Prefix or Title

PAYEE_ST   String (up to 2)

State code

PAYEE_ZIP4   String (up to 10)

Zip+4

REC_TYPE   String (up to 4) · Unique

Record Type Value: EXPN

Code Definition
EXPN Expense
Sources: .CAL Format Layout (Version 1.05.02) (31), .CAL Format Layout (Version 2.01) (42)
SUP_OPP_CD   String (up to 1)

Support or opposition code

Code Definition
O OPPOSITION
S SUPPORT
s SUPPORT
o OPPOSITION
H UNKNOWN
N UNKNOWN
X UNKNOWN
Y UNKNOWN
Sources: .CAL Format Layout (Version 1.05.02) (32), .CAL Format Layout (Version 2.01) (44)
TRAN_ID   String (up to 20)

Permanent value unique to this item

TRES_CITY   String (up to 30)

Treasurer City

TRES_NAMF   String (up to 45)

Treasurer's First name (Req if [COM|RCP] & no ID#)

TRES_NAML   String (up to 200)

Treasurer's Last name (Req if [COM|RCP] & no ID#)

TRES_NAMS   String (up to 10)

Treasurer's Suffix

TRES_NAMT   String (up to 10)

Treasurer's Prefix or Title

TRES_ST   String (up to 2)

Treasurer State

TRES_ZIP4   String (up to 10)

Treasurer ZIP+4

XREF_MATCH   String (up to 1)

X = Related item on other Sched has same Tran_ID

XREF_SCHNM   String (up to 2)

Related item is included on Sched 'C' or 'H2'

Forms

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

Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)

Part 5, Payments Made

Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees

Schedule E, Payments Made

Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)

Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)

Part 5, Contributions (Including Loans, Forgiveness of Loans, and LoanGuarantees) and Expenditures Made

Form 465: Supplemental Independent Expenditure Report

Part 3, Independent Expenditures Made

Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 53-56)

  • .CAL Format Layout (Version 1.05.02) (p. 31-32)

  • .CAL Format Layout (Version 2.01) (p. 42-44)

  • Map from .CAL Format to Database Table and Fields (p. 45-48)