FILER_FILINGS_CD

An index that links filers to their filings.

Fields

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


FILER_ID   Integer · Unique

Filer's unique identification number


FILING_ID   Integer · Unique

Unique filing identification number


PERIOD_ID   Integer

Identifies the period when the filing was recieved.


FORM_ID   String (up to 7) · Unique

Form identification code

Code Definition
Form 400: Statement of Organization (Slate Mailer Organization)
Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
Form 402: Statement of Termination (Slate Mailer Organization)
Form 405: Amendment to Campaign Disclosure Statement
Form 410: Statement of Organization (Recipient Committee)
Form 415: Title Unknown
Form 416: Title Unknown
Form 419: Campaign Disclosure Statement, Long Form (Ballot Measure Committee)
Form 420: Campaign Disclosure Statement, Long Form (Recipient Committee)
Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
Form 430: Title Unknown
Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
Form 460: Campaign Disclosure Statement (Recipient Committee)
Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
Form 465: Supplemental Independent Expenditure Report
Form 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
Form 490: Campaign Disclosure Statement, Long Form (Officeholders and Candidates)
Form 495: Supplemental Pre-Election Campaign Statement (Recipient Committee)
Form 496: Late Independent Expenditure Report
Form 497: Late Contribution Report
Form 498: Late Payment Report (Slate Mailer Organization)
Form 501: Candidate Intention Statement
Form 502: Campaign Bank Account Statement
Form 511: Paid Spokesperson Report
Electronic Form 530: Electronic Issue Advocacy Report
Form 601: Lobbying Firm Registration Statement
Form 602: Lobbying Firm Activity Authorization
Form 603: Lobbyist Employer or Lobbying Coalition Registration Statement
Form 604: Lobbyist Certification Statement
Form 605: Amendment to Registration, Lobbying Firm, Lobbyist Employer, Lobbying Coalition
Form 606: Notice of Termination
Form 607: Notice of Withdrawal
Form 615: Lobbyist Report
Form 625: Report of Lobbying Firm
Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
Form 645: Report of Person Spending $5,000 or More
Form 690: Amendment to Lobbying Disclosure Report
Form 700: Statement of Economic Interest
Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
F111 Unknown
F410 AT Unknown
F410ATR Unknown
F421 Unknown
F440 Unknown
F470S Form 470: Campaign Disclosure Statement, Short Form (Officeholders and Candidates)
F480 Unknown
F500 Unknown
F501502 Forms 501 and/or 502 (Candidate Intention and/or Bank Account Statements)
F555 Unknown
F666 Unknown
F777 Unknown
F888 Unknown
F999 Unknown
Sources: CAL-ACCESS Tables, Columns and Indexes (65)

FILING_SEQUENCE   Integer · Unique

Amendment number where 0 is an original filing and 1 to 999 are amendments


FILING_DATE   Date (without time)

Date the filing entered into the system


STMNT_TYPE   Integer

Type of statement

Code Definition
0 N/A
10001 ORIGINAL/INITIAL
10002 AMENDMENT
10003 TERMINATION
10004 REDESIGNATE THE ACCOUNT FOR FUTURE ELECTION TO THE SAME OFFICE
10005 LOG
10006 LOG/AMENDMENT
10007 AS FILED BY COMMITTEE
Sources: Lookup-Codes-Cd (6)

STMNT_STATUS   Integer

The status of the statement. If the filing has been reviewed or not reviewed.

Code Definition
11001 COMPLETE
11002 INCOMPLETE
11003 NEEDS REVIEW
Sources: Lookup-Codes-Cd (6)

SESSION_ID   Integer

Legislative session identification number


USER_ID   String (up to 12)

User identifier of the PRD user who logged the filing


SPECIAL_AUDIT   Integer

Denotes whether the filing has been audited for money laundering or other special condition.


FINE_AUDIT   Integer

Indicates whether a filing has been audited for a fine


RPT_START   Date (without time)

Starting date for the period the filing represents


RPT_END   Date (without time)

Ending date for the period the filing represents


RPT_DATE   Date (without time)

Date filing received


FILING_TYPE   Integer

The type of filing

Code Definition
0 N/A
22001 Electronic
22006 Cal Online
Sources: FAQ (2)

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, 64-66)