Skip to content

Instantly share code, notes, and snippets.

@jsfenfen
Created February 9, 2016 23:43
Show Gist options
  • Select an option

  • Save jsfenfen/f5c95896e37b2e916d0d to your computer and use it in GitHub Desktop.

Select an option

Save jsfenfen/f5c95896e37b2e916d0d to your computer and use it in GitHub Desktop.
missing key: F501_502.REC_TYPE
missing key: F501_502.FORM_TYPE
missing key: F501_502.FILER_ID
missing key: F501_502.COMMITTEE_ID
missing key: F501_502.ENTITY_CD
missing key: F501_502.FROM_DATE
missing key: F501_502.THRU_DATE
missing key: F501_502.ELECT_DATE
missing key: F501_502.CAND_NAML
missing key: F501_502.CAND_NAMF
missing key: F501_502.CAN_NAMM
missing key: F501_502.CAND_NAMT
missing key: F501_502.CAND_NAMS
missing key: F501_502.MONIKER_POS
missing key: F501_502.MONIKER
missing key: F501_502.CAND_CITY
missing key: F501_502.CAND_ST
missing key: F501_502.CAND_ZIP4
missing key: F501_502.CAND_PHON
missing key: F501_502.CAND_FAX
missing key: F501_502.CAND_EMAIL
missing key: F501_502.FIN_NAML
missing key: F501_502.FIN_NAMF
missing key: F501_502.FIN_NAMT
missing key: F501_502.FIN_NAMS
missing key: F501_502.FIN_CITY
missing key: F501_502.FIN_ST
missing key: F501_502.FIN_ZIP4
missing key: F501_502.FIN_PHON
missing key: F501_502.FIN_FAX
missing key: F501_502.FIN_EMAIL
missing key: F501_502.OFFIC_DSCR
missing key: F501_502.AGENCY_NAM
missing key: F501_502.JURIS_DSCR
missing key: F501_502.DIST_NO
missing key: F501_502.PARTY
missing key: F501_502.CAN_SIG
missing key: F501_502.ACCOUNT_NO
missing key: FILERNAME.XREF_FILER_ID
missing key: FILERNAME.FILER_TYPE
missing key: FILERNAME.STATUS
missing key: FILERNAME.NAML
missing key: FILERNAME.NAMF
missing key: FILERNAME.NAMT
missing key: FILERNAME.NAMS
missing key: FILERNAME.ADR1
missing key: FILERNAME.ADR2
missing key: FILERNAME.CITY
missing key: FILERNAME.ST
missing key: FILERNAME.ZIP4
missing key: FILERNAME.PHON
missing key: FILERNAME.FAX
missing key: FILERNAME.EMAIL
missing key: FILER_FILINGS.FORM_ID
missing key: FILER_FILINGS.USER_ID
missing key: CVR_E530.REC_TYPE
missing key: CVR_E530.FORM_TYPE
missing key: CVR_E530.ENTITY_CD
missing key: CVR_E530.FILER_NAML
missing key: CVR_E530.FILER_NAMF
missing key: CVR_E530.FILER_NAMT
missing key: CVR_E530.FILER_NAMS
missing key: CVR_E530.REPORT_NUM
missing key: CVR_E530.FILER_CITY
missing key: CVR_E530.FILER_ST
missing key: CVR_E530.FILER_ZIP4
missing key: CVR_E530.OCCUPATION
missing key: CVR_E530.EMPLOYER
missing key: CVR_E530.CAND_NAML
missing key: CVR_E530.CAND_NAMF
missing key: CVR_E530.CAND_NAMT
missing key: CVR_E530.CAND_NAMS
missing key: CVR_E530.OTHER_DESC
missing key: ACRONYMS.ACRONYM
missing key: ACRONYMS.STANDS_FOR
missing key: ACRONYMS.A_DESC
missing key: ADDRESS.CITY
missing key: ADDRESS.ST
missing key: ADDRESS.ZIP4
missing key: ADDRESS.PHON
missing key: ADDRESS.FAX
missing key: ADDRESS.EMAIL
missing key: BALLOT_MEASURES.MEASURE_NO
missing key: BALLOT_MEASURES.MEASURE_NAME
missing key: BALLOT_MEASURES.MEASURE_SHORT_NAME
missing key: BALLOT_MEASURES.JURISDICTION
missing key: EFS_FILING_LOG.VENDOR
missing key: EFS_FILING_LOG.FILER_ID
missing key: EFS_FILING_LOG.FORM_TYPE
missing key: EFS_FILING_LOG.ERROR_NO
missing key: FILER_ACRONYMS.ACRONYM
missing key: FILER_LINKS.ACTIVE_FLG
missing key: FILER_LINKS.LINK_DESC
missing key: FILER_LINKS.DOMINATE_FILER
missing key: FILER_STATUS_TYPES.STATUS_TYPE
missing key: FILER_STATUS_TYPES.STATUS_DESC
missing key: FILER_TO_FILER_TYPE.ACTIVE
missing key: FILER_TO_FILER_TYPE.SUB_CATEGORY_A
missing key: FILER_TYPES.DESCRIPTION
missing key: FILER_TYPES.CALC_USE
missing key: FILER_TYPES.GRACE_PERIOD
missing key: FILER_XREF.XREF_ID
missing key: FILER_XREF.MIGRATION_SOURCE
missing key: FILING_PERIOD.PERIOD_DESC
missing key: GROUP_TYPES.GRP_NAME
missing key: GROUP_TYPES.GRP_DESC
missing key: HEADER.FORM_ID
missing key: HEADER.REC_TYPE
missing key: HEADER.SECTION_LABEL
missing key: HEADER.COMMENTS1
missing key: HEADER.COMMENTS2
missing key: HEADER.LABEL
missing key: HDR.HDR_COMMENT
missing key: LOBBYING_CHG_LOG.CORRECTION_FLAG
missing key: LOBBYING_CHG_LOG.ACTION
missing key: LOBBYING_CHG_LOG.ATTRIBUTE_CHANGED
missing key: LOBBYING_CHG_LOG.INTERESTS
missing key: LOBBYING_CHG_LOG.FILER_FULL_NAME
missing key: LOBBYING_CHG_LOG.FILER_CITY
missing key: LOBBYING_CHG_LOG.FILER_ST
missing key: LOBBYING_CHG_LOG.FILER_PHONE
missing key: LOBBYING_CHG_LOG.ENTITY_NAME
missing key: LOBBYING_CHG_LOG.ENTITY_CITY
missing key: LOBBYING_CHG_LOG.ENTITY_ST
missing key: LOBBYING_CHG_LOG.ENTITY_ZIP
missing key: LOBBYING_CHG_LOG.ENTITY_PHONE
missing key: LOBBYING_CHG_LOG.RESPONSIBLE_OFFICER
missing key: LOBBYIST_CONTRIBUTIONS1.CONTRIBUTION_DT
missing key: LOBBYIST_CONTRIBUTIONS1.RECIPIENT_NAME
missing key: LOBBYIST_CONTRIBUTIONS2.CONTRIBUTION_DT
missing key: LOBBYIST_CONTRIBUTIONS2.RECIPIENT_NAME
missing key: LOBBYIST_CONTRIBUTIONS3.CONTRIBUTION_DT
missing key: LOBBYIST_CONTRIBUTIONS3.RECIPIENT_NAME
missing key: LOBBYIST_EMPLOYER1.EMPLOYER_NAME
missing key: LOBBYIST_EMPLOYER1.INTEREST_NAME
missing key: LOBBYIST_EMPLOYER2.EMPLOYER_NAME
missing key: LOBBYIST_EMPLOYER2.INTEREST_NAME
missing key: LOBBYIST_EMPLOYER3.EMPLOYER_NAME
missing key: LOBBYIST_EMPLOYER3.INTEREST_NAME
missing key: LOBBYIST_EMPLOYER_FIRMS1.FIRM_NAME
missing key: LOBBYIST_EMPLOYER_FIRMS1.TERMINATION_DT
missing key: LOBBYIST_EMPLOYER_FIRMS2.FIRM_NAME
missing key: LOBBYIST_EMPLOYER_FIRMS2.TERMINATION_DT
missing key: LOBBYIST_EMP_LOBBYIST1.LOBBYIST_LAST_NAME
missing key: LOBBYIST_EMP_LOBBYIST1.LOBBYIST_FIRST_NAME
missing key: LOBBYIST_EMP_LOBBYIST1.EMPLOYER_NAME
missing key: LOBBYIST_EMP_LOBBYIST2.LOBBYIST_LAST_NAME
missing key: LOBBYIST_EMP_LOBBYIST2.LOBBYIST_FIRST_NAME
missing key: LOBBYIST_EMP_LOBBYIST2.EMPLOYER_NAME
missing key: LOBBYIST_FIRM1.FIRM_NAME
missing key: LOBBYIST_FIRM2.FIRM_NAME
missing key: LOBBYIST_FIRM3.FIRM_NAME
missing key: LOBBYIST_FIRM_EMPLOYER1.FIRM_NAME
missing key: LOBBYIST_FIRM_EMPLOYER1.EMPLOYER_NAME
missing key: LOBBYIST_FIRM_EMPLOYER1.LBY_ACTVTY
missing key: LOBBYIST_FIRM_EMPLOYER1.EXT_LBY_ACTVTY
missing key: LOBBYIST_FIRM_EMPLOYER2.FIRM_NAME
missing key: LOBBYIST_FIRM_EMPLOYER2.EMPLOYER_NAME
missing key: LOBBYIST_FIRM_EMPLOYER2.LBY_ACTVTY
missing key: LOBBYIST_FIRM_EMPLOYER2.EXT_LBY_ACTVTY
missing key: LOBBYIST_FIRM_LOBBYIST1.LOBBYIST_LAST_NAME
missing key: LOBBYIST_FIRM_LOBBYIST1.LOBBYIST_FIRST_NAME
missing key: LOBBYIST_FIRM_LOBBYIST1.FIRM_NAME
missing key: LOBBYIST_FIRM_LOBBYIST2.LOBBYIST_LAST_NAME
missing key: LOBBYIST_FIRM_LOBBYIST2.LOBBYIST_FIRST_NAME
missing key: LOBBYIST_FIRM_LOBBYIST2.FIRM_NAME
missing key: LOOKUP_CODES.CODE_DESC
missing key: NAMES.NAML
missing key: NAMES.NAMF
missing key: NAMES.NAMT
missing key: NAMES.NAMS
missing key: NAMES.MONIKER
missing key: NAMES.MONIKER_POS
missing key: NAMES.NAMM
missing key: NAMES.FULLNAME
missing key: NAMES.NAML_SEARCH
missing key: RECEIVED_FILINGS.FILING_FILE_NAME
missing key: RECEIVED_FILINGS.FILING_DIRECTORY
missing key: RECEIVED_FILINGS.FORM_ID
missing key: RECEIVED_FILINGS.RECEIVE_COMMENT
missing key: REPORTS.RPT_NAME
missing key: REPORTS.RPT_DESC_FIELD
missing key: REPORTS.PATH
missing key: REPORTS.DATA_OBJECT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment