Decode the meaning of mystery form IDs

[gordonje]

About half of the tables in the CAL-ACCESS db have a column that denotes the Filing Form from which the given record was collected. Usually this is called FORM_TYPE or FORM_ID.

Some of the values in these columns do not match any of the forms found in the Fair Political Practices Commission's list of forms. These mystery values are outlined below.

F111

• 123 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD record with this form type is dated May 1990.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F410 AT and F410ATR

• Some sort of attachment to Form 410 (Statement of Organization Recipient Committee)?
  • Maybe Assistant Treasurer?
• 9,746 occurrences (for 'F410 AT') and 28 (for 'F410ATR') in the FORM_ID column on the FILER_FILINGS_CD table.
• In addition to occurrences in the FILER_FILINGS_CD and FILINGS_CD tables, each of these form types is associated with one filing ID that occurs in the TEXT_MEMO_CD table.
• Most recent FILER_FILINGS_CD records with these form types are dated March/April May 2016.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with either of these form ids.

F415

• According to this 1987 letter from the FPPC, this was a "Notice of Termination". Seems like a filing that is sent out from the FPPC.
• 51,047 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated January 2014.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F416

• 521 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated April 2008.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F419

This page on the Kings County Government website suggests that this might have been the "Ballot Measure Committee Campaign Statement-Long Form", and was replaced by Form 460.

• 2,293 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated May 2006.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F420

• This page on the Kings County Government website suggests that this might have been the "Recipient Committee Campaign Statement-Long Form", and was replaced by Form 460.
• Most recent FILER_FILINGS_CD records with these form types are dated February 2010.
• 70,704 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F421

• 1,832 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated October 1996.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F430

• 2,310 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated February 1988.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F440

• 145 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated January 1984.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F480

• 395 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD records with these form types are dated August 1982.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F490

• This page on the Kings County Government website suggests that this might have been the "Officeholder/Candidate Campaign Statement-Long Form", and was replaced by Form 460.
• 58,266 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• A filing ID -- 17 -- associated with form type F490 also occurs once in the following tables:
  • CVR_LOBBY_DISCLOSURE_CD
  • F690P2_CD
  • HDR_CD
  • LPAY_CD
  • RECEIVED_FILINGS_CD
  • SMRY_CD
• The form type associated with all of the records in the above tables is 'F635' (Report of Lobbyist Employer or Report of Lobbying Coalition).
• Seems like filing ID 17 maps to two distinct filings.
• Most recent FILER_FILINGS_CD record with this form type is dated August 2011.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F500

• 109 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD record with this form type is dated August 1980.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F555

• 397 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Most recent FILER_FILINGS_CD record with this form type is dated June 1999.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F666

• 4,211 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD record with this form type is dated March 2016.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F777

• 16,157 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD record with this form type is dated May 1994.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F888

• 2,936 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• In addition to occurrences in the FILER_FILINGS_CD and FILINGS_CD tables, filing IDs associated with this form type occur 37 times in the TEXT_MEMO_CD table.
  • The TEXT4000 values suggest these have something to do with terminated lobbyist status
• Most recent FILER_FILINGS_CD record with this form type is dated April 2016.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

F999

• 5,523 occurrences in the FORM_ID column on the FILER_FILINGS_CD table.
• Filing IDs with this form type only occur in FILER_FILINGS_CD and FILINGS_CD tables.
• Most recent FILER_FILINGS_CD record with this form type is dated April 2016.
• Getting "CGI Error" when I request any of the two dozen most recent filing ids with this form id.

[gordonje]

The advice consultants at FPPC responded with a few answers:

• Form 419 was previously title "Ballot Measure Committee Campaign Statement-Long Form" and was replaced by Form 460 (Recipient Committee Campaign Statement) about 15 years ago.
• Form 420 was previously title "Recipient Committee Campaign Statement-Long Form" and was also replaced by Form 460 about 15 years ago.
• Form 490 was previously title "Officeholder/Candidate Campaign Statement-Long Form" and was also replaced by Form 460.
• Forms 415 and 416 were eliminated about 15 years ago, and information previously reported on this form is now reported on Form 410 (Statement of Organization Recipient Committee).
• Form 430 was eliminated about 35 years ago, and they believe the information previously reported on this form is now reported on Form 460.
• They think 'F410 AT' and 'F410ATR' might refer to "amendments", but said we should check with the California Secretary of State.
• For answers regarding any of the other Forms, they recommended calling the SoS office.