FILERNAME_CD

A combination of CAL-ACCESS tables created by the state to consolidate filer information.

Fields

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

XREF_FILER_ID   String (up to 15)

Alternative filer ID found on many forms

FILER_ID   Integer · Unique

Filer's unique identification number

FILER_TYPE   String (up to 45)

The type of filer. These values are found FILER_TYPES_CD.DESCRIPTION

Code Definition
NOT DEFINED Undefined
ALL FILERS All filers
CANDIDATE/OFFICEHOLDER Candidate/officeholder
CLIENT Client
EMPLOYER Employer
FIRM Firm
INDIVIDUAL Individual
INITIATIVE Initiative
LOBBYIST Lobbyist
MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE Major donor or indenpendent expenditure committee
PAYMENT TO INFLUENCE Payment to influence
PREPAID ACCOUNT Prepaid account
PROPONENT Proponent
PROPOSITION Proposition
RECIPIENT COMMITTEE Recipient committee
SLATE MAILER ORGANIZATIONS Slate mailer organization
TREASURER/RESPONSIBLE OFFICER Treasurer/responsible officer
Sources: Filer-Types-Cd (1)
STATUS   String (up to 10)

The status of the filer. Includes a mixture of values found in the STATUS_TYPE and STATUS_DESC columns on FILER_STATUS_TYPES_CD

Code Definition
Undefined
A ACTIVE
P PENDING
R REVOKED
S SUSPENDED
W WITHDRAWN
Y ACTIVE
N INACTIVE
T TERMINATED
ACTIVE ACTIVE
INACTIVE INACTIVE
TERMINATED TERMINATED
Sources: Filer-Status-Types-Cd (1)
EFFECT_DT   Date (without time)

Effective date for status

NAML   String (up to 200)

Last name, sometimes full name in the case of PACs, firms and employers. Major donors can be split between first and last name fields, but usually are contained in the last name field only. Individual names of lobbyists, politicans and officers tend to use both the first and last name.

NAMF   String (up to 55)

First name

NAMT   String (up to 70)

Name prefix or title

NAMS   String (up to 32)

Name suffix

ADR1   String (up to 200)

First line of street address

ADR2   String (up to 200)

Second line of street address

CITY   String (up to 55)

City address

ST   String (up to 4)

State

ZIP4   String (up to 10)

ZIP Code

PHON   String (up to 60)

Phone number

FAX   String (up to 60)

Fax number

EMAIL   String (up to 60)

Email address

References

The documents that provided the information on this page.

  • FAQ (p. 2)