EFS_FILING_LOG_CD

Logs from the Electronic Filing Subsystem, which accepts and validates electronic filings.

Fields

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


FILING_DATE   Date (without time) · Unique

Date of filing


FILINGSTATUS   Integer

Status of filing. This field is described in the docs as beingVARCHAR. However, its distinct values are 0, 1, 2 and 7.


VENDOR   String (up to 250) · Unique

Software vendor who submitted the electronic filing


FILER_ID   String (up to 250)

Filer's unique identification number


FORM_TYPE   String (up to 250)

Name of the source filing form or schedule

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 410: Statement of Organization (Recipient Committee)
Form 425: Semi-Annual Statement of No Activity (Recipient Committee)
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 496: Late Independent Expenditure Report
Form 497: Late Contribution Report
Form 498: Late Payment Report (Slate Mailer Organization)
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 606: Notice of Termination
Form 607: Notice of Withdrawal
Form 615: Lobbyist Report
Form 625: Report of Lobbying Firm
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
Form 645: Report of Person Spending $5,000 or More
BADFORMAT 253 Unknown
form Unknown
Sources: .CAL Format Overview (4-8)

ERROR_NO   String (up to 250)

Most records have a value of "ACCEPTED". Other records include "ERROR"or "BADFORMAT" and a three-digit number.


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 Format Overview (p. 1-2)

  • CAL-ACCESS Tables, Columns and Indexes (p. 49-50)