Skip to content

Instantly share code, notes, and snippets.

@jsfenfen

jsfenfen/calaccess_field_names.csv

Last active February 9, 2016 23:01
Show Gist options
  • Save jsfenfen/93afa9997f178ec6b0f2 to your computer and use it in GitHub Desktop.
Save jsfenfen/93afa9997f178ec6b0f2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
calaccess_field_names.csv
model._meta.db_table str(field).split('.')[2].upper() field.maxlength
CVR_SO_CD ID None
CVR_SO_CD ACCT_OPENDT None
CVR_SO_CD ACTVTY_LVL 2
CVR_SO_CD AMEND_ID None
CVR_SO_CD BANK_ADR1 55
CVR_SO_CD BANK_ADR2 55
CVR_SO_CD BANK_CITY 30
CVR_SO_CD BANK_NAM 200
CVR_SO_CD BANK_PHON 20
CVR_SO_CD BANK_ST 2
CVR_SO_CD BANK_ZIP4 10
CVR_SO_CD BRDBASE_CB 1
CVR_SO_CD CITY 30
CVR_SO_CD CMTE_EMAIL 60
CVR_SO_CD CMTE_FAX 20
CVR_SO_CD COM82013ID 9
CVR_SO_CD COM82013NM 200
CVR_SO_CD COM82013YN 1
CVR_SO_CD CONTROL_CB 1
CVR_SO_CD COUNTY_ACT 20
CVR_SO_CD COUNTY_RES 20
CVR_SO_CD ENTITY_CD 3
CVR_SO_CD FILER_ID 9
CVR_SO_CD FILER_NAMF 45
CVR_SO_CD FILER_NAML 200
CVR_SO_CD FILER_NAMS 10
CVR_SO_CD FILER_NAMT 10
CVR_SO_CD FILING_ID None
CVR_SO_CD FORM_TYPE 4
CVR_SO_CD GENPURP_CB 1
CVR_SO_CD GPC_DESCR 300
CVR_SO_CD MAIL_CITY 30
CVR_SO_CD MAIL_ST 2
CVR_SO_CD MAIL_ZIP4 10
CVR_SO_CD PHONE 20
CVR_SO_CD PRIMFC_CB 1
CVR_SO_CD QUALFY_DT None
CVR_SO_CD QUAL_CB 1
CVR_SO_CD REC_TYPE 4
CVR_SO_CD REPORT_NUM 3
CVR_SO_CD RPT_DATE None
CVR_SO_CD SMCONT_QUALDT None
CVR_SO_CD SPONSOR_CB 1
CVR_SO_CD ST 2
CVR_SO_CD SURPLUSDSP 90
CVR_SO_CD TERM_DATE None
CVR_SO_CD TRES_CITY 30
CVR_SO_CD TRES_NAMF 45
CVR_SO_CD TRES_NAML 200
CVR_SO_CD TRES_NAMS 10
CVR_SO_CD TRES_NAMT 10
CVR_SO_CD TRES_PHON 20
CVR_SO_CD TRES_ST 2
CVR_SO_CD TRES_ZIP4 10
CVR_SO_CD ZIP4 10
CVR2_SO_CD ID None
CVR2_SO_CD FILING_ID None
CVR2_SO_CD AMEND_ID None
CVR2_SO_CD LINE_ITEM None
CVR2_SO_CD REC_TYPE 4
CVR2_SO_CD FORM_TYPE 4
CVR2_SO_CD TRAN_ID 20
CVR2_SO_CD ENTITY_CD 3
CVR2_SO_CD ENTY_NAML 194
CVR2_SO_CD ENTY_NAMF 34
CVR2_SO_CD ENTY_NAMT 9
CVR2_SO_CD ENTY_NAMS 10
CVR2_SO_CD ITEM_CD 4
CVR2_SO_CD MAIL_CITY 25
CVR2_SO_CD MAIL_ST 4
CVR2_SO_CD MAIL_ZIP4 10
CVR2_SO_CD DAY_PHONE 20
CVR2_SO_CD FAX_PHONE 20
CVR2_SO_CD EMAIL_ADR 40
CVR2_SO_CD CMTE_ID None
CVR2_SO_CD IND_GROUP 87
CVR2_SO_CD OFFICE_CD 3
CVR2_SO_CD OFFIC_DSCR 40
CVR2_SO_CD JURIS_CD 4
CVR2_SO_CD JURIS_DSCR 40
CVR2_SO_CD DIST_NO 4
CVR2_SO_CD OFF_S_H_CD 1
CVR2_SO_CD NON_PTY_CB 4
CVR2_SO_CD PARTY_NAME 63
CVR2_SO_CD BAL_NUM 7
CVR2_SO_CD BAL_JURIS 40
CVR2_SO_CD SUP_OPP_CD 1
CVR2_SO_CD YEAR_ELECT 4
CVR2_SO_CD POF_TITLE 44
CVR_CAMPAIGN_DISCLOSURE_CD ID None
CVR_CAMPAIGN_DISCLOSURE_CD AMEND_ID None
CVR_CAMPAIGN_DISCLOSURE_CD AMENDEXP_1 100
CVR_CAMPAIGN_DISCLOSURE_CD AMENDEXP_2 100
CVR_CAMPAIGN_DISCLOSURE_CD AMENDEXP_3 100
CVR_CAMPAIGN_DISCLOSURE_CD ASSOC_CB 4
CVR_CAMPAIGN_DISCLOSURE_CD ASSOC_INT 90
CVR_CAMPAIGN_DISCLOSURE_CD BAL_ID 9
CVR_CAMPAIGN_DISCLOSURE_CD BAL_JURIS 40
CVR_CAMPAIGN_DISCLOSURE_CD BAL_NAME 200
CVR_CAMPAIGN_DISCLOSURE_CD BAL_NUM 4
CVR_CAMPAIGN_DISCLOSURE_CD BRDBASE_YN 1
CVR_CAMPAIGN_DISCLOSURE_CD BUS_CITY 30
CVR_CAMPAIGN_DISCLOSURE_CD BUS_INTER 40
CVR_CAMPAIGN_DISCLOSURE_CD BUS_NAME 200
CVR_CAMPAIGN_DISCLOSURE_CD BUS_ST 2
CVR_CAMPAIGN_DISCLOSURE_CD BUS_ZIP4 10
CVR_CAMPAIGN_DISCLOSURE_CD BUSACT_CB 10
CVR_CAMPAIGN_DISCLOSURE_CD BUSACTVITY 90
CVR_CAMPAIGN_DISCLOSURE_CD CAND_CITY 30
CVR_CAMPAIGN_DISCLOSURE_CD CAND_EMAIL 60
CVR_CAMPAIGN_DISCLOSURE_CD CAND_FAX 20
CVR_CAMPAIGN_DISCLOSURE_CD CAND_ID 9
CVR_CAMPAIGN_DISCLOSURE_CD CAND_NAMF 45
CVR_CAMPAIGN_DISCLOSURE_CD CAND_NAML 200
CVR_CAMPAIGN_DISCLOSURE_CD CAND_NAMS 10
CVR_CAMPAIGN_DISCLOSURE_CD CAND_NAMT 10
CVR_CAMPAIGN_DISCLOSURE_CD CAND_PHON 20
CVR_CAMPAIGN_DISCLOSURE_CD CAND_ST 4
CVR_CAMPAIGN_DISCLOSURE_CD CAND_ZIP4 10
CVR_CAMPAIGN_DISCLOSURE_CD CMTTE_ID 9
CVR_CAMPAIGN_DISCLOSURE_CD CMTTE_TYPE 1
CVR_CAMPAIGN_DISCLOSURE_CD CONTROL_YN None
CVR_CAMPAIGN_DISCLOSURE_CD DIST_NO 4
CVR_CAMPAIGN_DISCLOSURE_CD ELECT_DATE None
CVR_CAMPAIGN_DISCLOSURE_CD EMPLBUS_CB 4
CVR_CAMPAIGN_DISCLOSURE_CD EMPLOYER 200
CVR_CAMPAIGN_DISCLOSURE_CD ENTITY_CD 4
CVR_CAMPAIGN_DISCLOSURE_CD FILE_EMAIL 60
CVR_CAMPAIGN_DISCLOSURE_CD FILER_CITY 30
CVR_CAMPAIGN_DISCLOSURE_CD FILER_FAX 20
CVR_CAMPAIGN_DISCLOSURE_CD FILER_ID 15
CVR_CAMPAIGN_DISCLOSURE_CD FILER_NAMF 45
CVR_CAMPAIGN_DISCLOSURE_CD FILER_NAML 200
CVR_CAMPAIGN_DISCLOSURE_CD FILER_NAMS 10
CVR_CAMPAIGN_DISCLOSURE_CD FILER_NAMT 10
CVR_CAMPAIGN_DISCLOSURE_CD FILER_PHON 20
CVR_CAMPAIGN_DISCLOSURE_CD FILER_ST 4
CVR_CAMPAIGN_DISCLOSURE_CD FILER_ZIP4 10
CVR_CAMPAIGN_DISCLOSURE_CD FILING_ID None
CVR_CAMPAIGN_DISCLOSURE_CD FORM_TYPE 4
CVR_CAMPAIGN_DISCLOSURE_CD FROM_DATE None
CVR_CAMPAIGN_DISCLOSURE_CD JURIS_CD 3
CVR_CAMPAIGN_DISCLOSURE_CD JURIS_DSCR 40
CVR_CAMPAIGN_DISCLOSURE_CD LATE_RPTNO 30
CVR_CAMPAIGN_DISCLOSURE_CD MAIL_CITY 30
CVR_CAMPAIGN_DISCLOSURE_CD MAIL_ST 4
CVR_CAMPAIGN_DISCLOSURE_CD MAIL_ZIP4 10
CVR_CAMPAIGN_DISCLOSURE_CD OCCUPATION 60
CVR_CAMPAIGN_DISCLOSURE_CD OFF_S_H_CD 1
CVR_CAMPAIGN_DISCLOSURE_CD OFFIC_DSCR 40
CVR_CAMPAIGN_DISCLOSURE_CD OFFICE_CD 3
CVR_CAMPAIGN_DISCLOSURE_CD OTHER_CB 1
CVR_CAMPAIGN_DISCLOSURE_CD OTHER_INT 90
CVR_CAMPAIGN_DISCLOSURE_CD PRIMFRM_YN 1
CVR_CAMPAIGN_DISCLOSURE_CD REC_TYPE 4
CVR_CAMPAIGN_DISCLOSURE_CD REPORT_NUM 3
CVR_CAMPAIGN_DISCLOSURE_CD REPORTNAME 3
CVR_CAMPAIGN_DISCLOSURE_CD RPT_ATT_CB 4
CVR_CAMPAIGN_DISCLOSURE_CD RPT_DATE None
CVR_CAMPAIGN_DISCLOSURE_CD RPTFROMDT None
CVR_CAMPAIGN_DISCLOSURE_CD RPTTHRUDT None
CVR_CAMPAIGN_DISCLOSURE_CD SELFEMP_CB 1
CVR_CAMPAIGN_DISCLOSURE_CD SPONSOR_YN None
CVR_CAMPAIGN_DISCLOSURE_CD STMT_TYPE 2
CVR_CAMPAIGN_DISCLOSURE_CD SUP_OPP_CD 1
CVR_CAMPAIGN_DISCLOSURE_CD THRU_DATE None
CVR_CAMPAIGN_DISCLOSURE_CD TRES_CITY 30
CVR_CAMPAIGN_DISCLOSURE_CD TRES_EMAIL 60
CVR_CAMPAIGN_DISCLOSURE_CD TRES_FAX 20
CVR_CAMPAIGN_DISCLOSURE_CD TRES_NAMF 45
CVR_CAMPAIGN_DISCLOSURE_CD TRES_NAML 200
CVR_CAMPAIGN_DISCLOSURE_CD TRES_NAMS 10
CVR_CAMPAIGN_DISCLOSURE_CD TRES_NAMT 10
CVR_CAMPAIGN_DISCLOSURE_CD TRES_PHON 20
CVR_CAMPAIGN_DISCLOSURE_CD TRES_ST 2
CVR_CAMPAIGN_DISCLOSURE_CD TRES_ZIP4 10
CVR2_CAMPAIGN_DISCLOSURE_CD ID None
CVR2_CAMPAIGN_DISCLOSURE_CD AMEND_ID None
CVR2_CAMPAIGN_DISCLOSURE_CD BAL_JURIS 40
CVR2_CAMPAIGN_DISCLOSURE_CD BAL_NAME 200
CVR2_CAMPAIGN_DISCLOSURE_CD BAL_NUM 7
CVR2_CAMPAIGN_DISCLOSURE_CD CMTE_ID 9
CVR2_CAMPAIGN_DISCLOSURE_CD CONTROL_YN None
CVR2_CAMPAIGN_DISCLOSURE_CD DIST_NO 3
CVR2_CAMPAIGN_DISCLOSURE_CD ENTITY_CD 3
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_CITY 30
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_EMAIL 60
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_FAX 20
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_NAMF 45
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_NAML 200
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_NAMS 10
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_NAMT 10
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_PHON 20
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_ST 2
CVR2_CAMPAIGN_DISCLOSURE_CD ENTY_ZIP4 10
CVR2_CAMPAIGN_DISCLOSURE_CD F460_PART 2
CVR2_CAMPAIGN_DISCLOSURE_CD FILING_ID None
CVR2_CAMPAIGN_DISCLOSURE_CD FORM_TYPE 4
CVR2_CAMPAIGN_DISCLOSURE_CD JURIS_CD 3
CVR2_CAMPAIGN_DISCLOSURE_CD JURIS_DSCR 40
CVR2_CAMPAIGN_DISCLOSURE_CD LINE_ITEM None
CVR2_CAMPAIGN_DISCLOSURE_CD MAIL_CITY 30
CVR2_CAMPAIGN_DISCLOSURE_CD MAIL_ST 2
CVR2_CAMPAIGN_DISCLOSURE_CD MAIL_ZIP4 10
CVR2_CAMPAIGN_DISCLOSURE_CD OFF_S_H_CD 1
CVR2_CAMPAIGN_DISCLOSURE_CD OFFIC_DSCR 40
CVR2_CAMPAIGN_DISCLOSURE_CD OFFICE_CD 3
CVR2_CAMPAIGN_DISCLOSURE_CD REC_TYPE 4
CVR2_CAMPAIGN_DISCLOSURE_CD SUP_OPP_CD 1
CVR2_CAMPAIGN_DISCLOSURE_CD TITLE 90
CVR2_CAMPAIGN_DISCLOSURE_CD TRAN_ID 20
CVR2_CAMPAIGN_DISCLOSURE_CD TRES_NAMF 45
CVR2_CAMPAIGN_DISCLOSURE_CD TRES_NAML 200
CVR2_CAMPAIGN_DISCLOSURE_CD TRES_NAMS 10
CVR2_CAMPAIGN_DISCLOSURE_CD TRES_NAMT 10
RCPT_CD ID None
RCPT_CD AMEND_ID None
RCPT_CD AMOUNT None
RCPT_CD BAKREF_TID 20
RCPT_CD BAL_JURIS 40
RCPT_CD BAL_NAME 200
RCPT_CD BAL_NUM 7
RCPT_CD CAND_NAMF 45
RCPT_CD CAND_NAML 200
RCPT_CD CAND_NAMS 10
RCPT_CD CAND_NAMT 10
RCPT_CD CMTE_ID 9
RCPT_CD CTRIB_CITY 30
RCPT_CD CTRIB_DSCR 90
RCPT_CD CTRIB_EMP 200
RCPT_CD CTRIB_NAMF 45
RCPT_CD CTRIB_NAML 200
RCPT_CD CTRIB_NAMS 10
RCPT_CD CTRIB_NAMT 10
RCPT_CD CTRIB_OCC 60
RCPT_CD CTRIB_SELF 1
RCPT_CD CTRIB_ST 2
RCPT_CD CTRIB_ZIP4 10
RCPT_CD CUM_OTH None
RCPT_CD CUM_YTD None
RCPT_CD DATE_THRU None
RCPT_CD DIST_NO 3
RCPT_CD ENTITY_CD 3
RCPT_CD FILING_ID None
RCPT_CD FORM_TYPE 9
RCPT_CD INT_RATE 9
RCPT_CD INTR_CITY 30
RCPT_CD INTR_CMTEID 9
RCPT_CD INTR_EMP 200
RCPT_CD INTR_NAMF 45
RCPT_CD INTR_NAML 200
RCPT_CD INTR_NAMS 10
RCPT_CD INTR_NAMT 10
RCPT_CD INTR_OCC 60
RCPT_CD INTR_SELF 1
RCPT_CD INTR_ST 2
RCPT_CD INTR_ZIP4 10
RCPT_CD JURIS_CD 3
RCPT_CD JURIS_DSCR 40
RCPT_CD LINE_ITEM None
RCPT_CD MEMO_CODE 1
RCPT_CD MEMO_REFNO 20
RCPT_CD OFF_S_H_CD 1
RCPT_CD OFFIC_DSCR 40
RCPT_CD OFFICE_CD 3
RCPT_CD RCPT_DATE None
RCPT_CD REC_TYPE 4
RCPT_CD SUP_OPP_CD 1
RCPT_CD TRAN_ID 20
RCPT_CD TRAN_TYPE 1
RCPT_CD TRES_CITY 30
RCPT_CD TRES_NAMF 45
RCPT_CD TRES_NAML 200
RCPT_CD TRES_NAMS 10
RCPT_CD TRES_NAMT 10
RCPT_CD TRES_ST 2
RCPT_CD TRES_ZIP4 10
RCPT_CD XREF_MATCH 1
RCPT_CD XREF_SCHNM 2
CVR3_VERIFICATION_INFO_CD ID None
CVR3_VERIFICATION_INFO_CD FILING_ID None
CVR3_VERIFICATION_INFO_CD AMEND_ID None
CVR3_VERIFICATION_INFO_CD LINE_ITEM None
CVR3_VERIFICATION_INFO_CD REC_TYPE 4
CVR3_VERIFICATION_INFO_CD FORM_TYPE 4
CVR3_VERIFICATION_INFO_CD TRAN_ID 20
CVR3_VERIFICATION_INFO_CD ENTITY_CD 3
CVR3_VERIFICATION_INFO_CD SIG_DATE None
CVR3_VERIFICATION_INFO_CD SIG_LOC 39
CVR3_VERIFICATION_INFO_CD SIG_NAML 56
CVR3_VERIFICATION_INFO_CD SIG_NAMF 45
CVR3_VERIFICATION_INFO_CD SIG_NAMT 10
CVR3_VERIFICATION_INFO_CD SIG_NAMS 8
LOAN_CD ID None
LOAN_CD AMEND_ID None
LOAN_CD BAKREF_TID 20
LOAN_CD CMTE_ID 9
LOAN_CD ENTITY_CD 3
LOAN_CD FILING_ID None
LOAN_CD FORM_TYPE 2
LOAN_CD INTR_CITY 30
LOAN_CD INTR_NAMF 45
LOAN_CD INTR_NAML 200
LOAN_CD INTR_NAMS 10
LOAN_CD INTR_NAMT 10
LOAN_CD INTR_ST 2
LOAN_CD INTR_ZIP4 10
LOAN_CD LINE_ITEM None
LOAN_CD LNDR_NAMF 45
LOAN_CD LNDR_NAML 200
LOAN_CD LNDR_NAMS 10
LOAN_CD LNDR_NAMT 10
LOAN_CD LOAN_AMT1 None
LOAN_CD LOAN_AMT2 None
LOAN_CD LOAN_AMT3 None
LOAN_CD LOAN_AMT4 None
LOAN_CD LOAN_AMT5 None
LOAN_CD LOAN_AMT6 None
LOAN_CD LOAN_AMT7 None
LOAN_CD LOAN_AMT8 None
LOAN_CD LOAN_CITY 30
LOAN_CD LOAN_DATE1 None
LOAN_CD LOAN_DATE2 None
LOAN_CD LOAN_EMP 200
LOAN_CD LOAN_OCC 60
LOAN_CD LOAN_RATE 30
LOAN_CD LOAN_SELF 1
LOAN_CD LOAN_ST 2
LOAN_CD LOAN_TYPE 3
LOAN_CD LOAN_ZIP4 10
LOAN_CD MEMO_CODE 1
LOAN_CD MEMO_REFNO 20
LOAN_CD REC_TYPE 4
LOAN_CD TRAN_ID 20
LOAN_CD TRES_CITY 30
LOAN_CD TRES_NAMF 45
LOAN_CD TRES_NAML 200
LOAN_CD TRES_NAMS 10
LOAN_CD TRES_NAMT 10
LOAN_CD TRES_ST 2
LOAN_CD TRES_ZIP4 10
LOAN_CD XREF_MATCH 1
LOAN_CD XREF_SCHNM 2
S401_CD ID None
S401_CD FILING_ID None
S401_CD AMEND_ID None
S401_CD LINE_ITEM None
S401_CD REC_TYPE 4
S401_CD FORM_TYPE 7
S401_CD TRAN_ID 20
S401_CD AGENT_NAML 200
S401_CD AGENT_NAMF 45
S401_CD AGENT_NAMT 200
S401_CD AGENT_NAMS 10
S401_CD PAYEE_NAML 200
S401_CD PAYEE_NAMF 45
S401_CD PAYEE_NAMT 10
S401_CD PAYEE_NAMS 10
S401_CD PAYEE_CITY 30
S401_CD PAYEE_ST 2
S401_CD PAYEE_ZIP4 10
S401_CD AMOUNT None
S401_CD AGGREGATE None
S401_CD EXPN_DSCR 90
S401_CD CAND_NAML 200
S401_CD CAND_NAMF 45
S401_CD CAND_NAMT 10
S401_CD CAND_NAMS 10
S401_CD OFFICE_CD 3
S401_CD OFFIC_DSCR 40
S401_CD JURIS_CD 3
S401_CD JURIS_DSCR 40
S401_CD DIST_NO 3
S401_CD OFF_S_H_CD 1
S401_CD BAL_NAME 200
S401_CD BAL_NUM 7
S401_CD BAL_JURIS 40
S401_CD SUP_OPP_CD 1
S401_CD MEMO_CODE 1
S401_CD MEMO_REFNO 20
S401_CD BAKREF_TID 20
EXPN_CD ID None
EXPN_CD AGENT_NAMF 45
EXPN_CD AGENT_NAML 200
EXPN_CD AGENT_NAMS 10
EXPN_CD AGENT_NAMT 10
EXPN_CD AMEND_ID None
EXPN_CD AMOUNT None
EXPN_CD BAKREF_TID 20
EXPN_CD BAL_JURIS 40
EXPN_CD BAL_NAME 200
EXPN_CD BAL_NUM 7
EXPN_CD CAND_NAMF 45
EXPN_CD CAND_NAML 200
EXPN_CD CAND_NAMS 10
EXPN_CD CAND_NAMT 10
EXPN_CD CMTE_ID 9
EXPN_CD CUM_OTH None
EXPN_CD CUM_YTD None
EXPN_CD DIST_NO 3
EXPN_CD ENTITY_CD 3
EXPN_CD EXPN_CHKNO 20
EXPN_CD EXPN_CODE 3
EXPN_CD EXPN_DATE None
EXPN_CD EXPN_DSCR 400
EXPN_CD FILING_ID None
EXPN_CD FORM_TYPE 6
EXPN_CD G_FROM_E_F 1
EXPN_CD JURIS_CD 3
EXPN_CD JURIS_DSCR 40
EXPN_CD LINE_ITEM None
EXPN_CD MEMO_CODE 1
EXPN_CD MEMO_REFNO 20
EXPN_CD OFF_S_H_CD 1
EXPN_CD OFFIC_DSCR 40
EXPN_CD OFFICE_CD 3
EXPN_CD PAYEE_CITY 30
EXPN_CD PAYEE_NAMF 45
EXPN_CD PAYEE_NAML 200
EXPN_CD PAYEE_NAMS 10
EXPN_CD PAYEE_NAMT 10
EXPN_CD PAYEE_ST 2
EXPN_CD PAYEE_ZIP4 10
EXPN_CD REC_TYPE 4
EXPN_CD SUP_OPP_CD 1
EXPN_CD TRAN_ID 20
EXPN_CD TRES_CITY 30
EXPN_CD TRES_NAMF 45
EXPN_CD TRES_NAML 200
EXPN_CD TRES_NAMS 10
EXPN_CD TRES_NAMT 10
EXPN_CD TRES_ST 2
EXPN_CD TRES_ZIP4 10
EXPN_CD XREF_MATCH 1
EXPN_CD XREF_SCHNM 2
F495P2_CD ID None
F495P2_CD FILING_ID None
F495P2_CD AMEND_ID None
F495P2_CD LINE_ITEM None
F495P2_CD REC_TYPE 4
F495P2_CD FORM_TYPE 4
F495P2_CD ELECT_DATE None
F495P2_CD ELECTJURIS 40
F495P2_CD CONTRIBAMT None
DEBT_CD ID None
DEBT_CD AMEND_ID None
DEBT_CD AMT_INCUR None
DEBT_CD AMT_PAID None
DEBT_CD BAKREF_TID 20
DEBT_CD BEG_BAL None
DEBT_CD CMTE_ID 9
DEBT_CD END_BAL None
DEBT_CD ENTITY_CD 3
DEBT_CD EXPN_CODE 3
DEBT_CD EXPN_DSCR 400
DEBT_CD FILING_ID None
DEBT_CD FORM_TYPE 1
DEBT_CD LINE_ITEM None
DEBT_CD MEMO_CODE 1
DEBT_CD MEMO_REFNO 20
DEBT_CD PAYEE_CITY 30
DEBT_CD PAYEE_NAMF 45
DEBT_CD PAYEE_NAML 200
DEBT_CD PAYEE_NAMS 10
DEBT_CD PAYEE_NAMT 100
DEBT_CD PAYEE_ST 2
DEBT_CD PAYEE_ZIP4 10
DEBT_CD REC_TYPE 4
DEBT_CD TRAN_ID 20
DEBT_CD TRES_CITY 30
DEBT_CD TRES_NAMF 45
DEBT_CD TRES_NAML 200
DEBT_CD TRES_NAMS 10
DEBT_CD TRES_NAMT 100
DEBT_CD TRES_ST 2
DEBT_CD TRES_ZIP4 10
DEBT_CD XREF_MATCH 1
DEBT_CD XREF_SCHNM 2
S496_CD ID None
S496_CD FILING_ID None
S496_CD AMEND_ID None
S496_CD LINE_ITEM None
S496_CD REC_TYPE 4
S496_CD FORM_TYPE 4
S496_CD TRAN_ID 20
S496_CD AMOUNT None
S496_CD EXP_DATE None
S496_CD EXPN_DSCR 90
S496_CD MEMO_CODE 1
S496_CD MEMO_REFNO 20
S496_CD DATE_THRU None
SPLT_CD ID None
SPLT_CD AMEND_ID None
SPLT_CD ELEC_AMOUNT None
SPLT_CD ELEC_CODE 2
SPLT_CD ELEC_DATE None
SPLT_CD FILING_ID None
SPLT_CD LINE_ITEM None
SPLT_CD PFORM_TYPE 7
SPLT_CD PTRAN_ID 32
S497_CD ID None
S497_CD FILING_ID None
S497_CD AMEND_ID None
S497_CD LINE_ITEM None
S497_CD REC_TYPE 4
S497_CD FORM_TYPE 6
S497_CD TRAN_ID 20
S497_CD ENTITY_CD 3
S497_CD ENTY_NAML 200
S497_CD ENTY_NAMF 45
S497_CD ENTY_NAMT 10
S497_CD ENTY_NAMS 10
S497_CD ENTY_CITY 30
S497_CD ENTY_ST 2
S497_CD ENTY_ZIP4 10
S497_CD CTRIB_EMP 200
S497_CD CTRIB_OCC 60
S497_CD CTRIB_SELF 1
S497_CD ELEC_DATE None
S497_CD CTRIB_DATE None
S497_CD DATE_THRU None
S497_CD AMOUNT None
S497_CD CMTE_ID 9
S497_CD CAND_NAML 200
S497_CD CAND_NAMF 45
S497_CD CAND_NAMT 10
S497_CD CAND_NAMS 10
S497_CD OFFICE_CD 3
S497_CD OFFIC_DSCR 40
S497_CD JURIS_CD 3
S497_CD JURIS_DSCR 40
S497_CD DIST_NO 3
S497_CD OFF_S_H_CD 1
S497_CD BAL_NAME 200
S497_CD BAL_NUM 7
S497_CD BAL_JURIS 40
S497_CD MEMO_CODE 1
S497_CD MEMO_REFNO 20
S497_CD BAL_ID 9
S497_CD CAND_ID 9
S497_CD SUP_OFF_CD 1
S497_CD SUP_OPP_CD 1
F501_502_CD ID None
F501_502_CD FILING_ID None
F501_502_CD AMEND_ID None
F501_502_CD REC_TYPE 4
F501_502_CD FORM_TYPE 4
F501_502_CD FILER_ID 9
F501_502_CD COMMITTEE_ID 8
F501_502_CD ENTITY_CD 3
F501_502_CD REPORT_NUM None
F501_502_CD RPT_DATE None
F501_502_CD STMT_TYPE None
F501_502_CD FROM_DATE 32
F501_502_CD THRU_DATE 32
F501_502_CD ELECT_DATE 32
F501_502_CD CAND_NAML 81
F501_502_CD CAND_NAMF 25
F501_502_CD CAN_NAMM 10
F501_502_CD CAND_NAMT 7
F501_502_CD CAND_NAMS 7
F501_502_CD MONIKER_POS 32
F501_502_CD MONIKER 4
F501_502_CD CAND_CITY 22
F501_502_CD CAND_ST 4
F501_502_CD CAND_ZIP4 10
F501_502_CD CAND_PHON 14
F501_502_CD CAND_FAX 14
F501_502_CD CAND_EMAIL 37
F501_502_CD FIN_NAML 53
F501_502_CD FIN_NAMF 32
F501_502_CD FIN_NAMT 32
F501_502_CD FIN_NAMS 32
F501_502_CD FIN_CITY 20
F501_502_CD FIN_ST 4
F501_502_CD FIN_ZIP4 9
F501_502_CD FIN_PHON 14
F501_502_CD FIN_FAX 10
F501_502_CD FIN_EMAIL 15
F501_502_CD OFFICE_CD None
F501_502_CD OFFIC_DSCR 50
F501_502_CD AGENCY_NAM 63
F501_502_CD JURIS_CD None
F501_502_CD JURIS_DSCR 14
F501_502_CD DIST_NO 4
F501_502_CD PARTY 20
F501_502_CD YR_OF_ELEC None
F501_502_CD ELEC_TYPE None
F501_502_CD EXECUTE_DT None
F501_502_CD CAN_SIG 13
F501_502_CD ACCOUNT_NO 22
F501_502_CD ACCT_OP_DT None
F501_502_CD PARTY_CD None
F501_502_CD DISTRICT_CD None
F501_502_CD ACCEPT_LIMIT_YN None
F501_502_CD DID_EXCEED_DT None
F501_502_CD CNTRB_PRSNL_FNDS_DT None
S498_CD ID None
S498_CD FILING_ID None
S498_CD AMEND_ID None
S498_CD LINE_ITEM None
S498_CD REC_TYPE 4
S498_CD FORM_TYPE 9
S498_CD TRAN_ID 20
S498_CD ENTITY_CD 3
S498_CD CMTE_ID 9
S498_CD PAYOR_NAML 200
S498_CD PAYOR_NAMF 45
S498_CD PAYOR_NAMT 10
S498_CD PAYOR_NAMS 10
S498_CD PAYOR_CITY 30
S498_CD PAYOR_ST 2
S498_CD PAYOR_ZIP4 10
S498_CD DATE_RCVD None
S498_CD AMT_RCVD None
S498_CD CAND_NAML 200
S498_CD CAND_NAMF 45
S498_CD CAND_NAMT 10
S498_CD CAND_NAMS 10
S498_CD OFFICE_CD 4
S498_CD OFFIC_DSCR 40
S498_CD JURIS_CD 3
S498_CD JURIS_DSCR 40
S498_CD DIST_NO 3
S498_CD OFF_S_H_CD 1
S498_CD BAL_NAME 200
S498_CD BAL_NUM 7
S498_CD BAL_JURIS 40
S498_CD SUP_OPP_CD 1
S498_CD AMT_ATTRIB None
S498_CD MEMO_CODE 1
S498_CD MEMO_REFNO 20
S498_CD EMPLOYER 200
S498_CD OCCUPATION 60
S498_CD SELFEMP_CB 1
CVR_REGISTRATION_CD ID None
CVR_REGISTRATION_CD A_B_CITY 30
CVR_REGISTRATION_CD A_B_NAME 200
CVR_REGISTRATION_CD A_B_ST 2
CVR_REGISTRATION_CD A_B_ZIP4 10
CVR_REGISTRATION_CD AMEND_ID None
CVR_REGISTRATION_CD AUTH_CITY 30
CVR_REGISTRATION_CD AUTH_NAME 200
CVR_REGISTRATION_CD AUTH_ST 2
CVR_REGISTRATION_CD AUTH_ZIP4 10
CVR_REGISTRATION_CD BUS_CB 1
CVR_REGISTRATION_CD BUS_CITY 30
CVR_REGISTRATION_CD BUS_CLASS 3
CVR_REGISTRATION_CD BUS_DESCR 100
CVR_REGISTRATION_CD BUS_EMAIL 60
CVR_REGISTRATION_CD BUS_FAX 20
CVR_REGISTRATION_CD BUS_PHON 20
CVR_REGISTRATION_CD BUS_ST 2
CVR_REGISTRATION_CD BUS_ZIP4 10
CVR_REGISTRATION_CD C_LESS50 1
CVR_REGISTRATION_CD C_MORE50 1
CVR_REGISTRATION_CD COMPLET_DT None
CVR_REGISTRATION_CD DESCRIP_1 300
CVR_REGISTRATION_CD DESCRIP_2 300
CVR_REGISTRATION_CD EFF_DATE None
CVR_REGISTRATION_CD ENTITY_CD 3
CVR_REGISTRATION_CD FILER_ID 8
CVR_REGISTRATION_CD FILER_NAMF 45
CVR_REGISTRATION_CD FILER_NAML 200
CVR_REGISTRATION_CD FILER_NAMS 10
CVR_REGISTRATION_CD FILER_NAMT 10
CVR_REGISTRATION_CD FILING_ID None
CVR_REGISTRATION_CD FIRM_NAME 200
CVR_REGISTRATION_CD FORM_TYPE 4
CVR_REGISTRATION_CD IND_CB 1
CVR_REGISTRATION_CD IND_CLASS 3
CVR_REGISTRATION_CD IND_DESCR 100
CVR_REGISTRATION_CD INFLUEN_YN 1
CVR_REGISTRATION_CD L_FIRM_CB 1
CVR_REGISTRATION_CD LBY_604_CB 1
CVR_REGISTRATION_CD LBY_REG_CB 1
CVR_REGISTRATION_CD LOBBY_CB 1
CVR_REGISTRATION_CD LOBBY_INT 300
CVR_REGISTRATION_CD LS_BEG_YR 5
CVR_REGISTRATION_CD LS_END_YR 5
CVR_REGISTRATION_CD MAIL_CITY 30
CVR_REGISTRATION_CD MAIL_PHON 20
CVR_REGISTRATION_CD MAIL_ST 2
CVR_REGISTRATION_CD MAIL_ZIP4 10
CVR_REGISTRATION_CD NEWCERT_CB 1
CVR_REGISTRATION_CD OTH_CB 1
CVR_REGISTRATION_CD PRN_NAMF 45
CVR_REGISTRATION_CD PRN_NAML 200
CVR_REGISTRATION_CD PRN_NAMS 10
CVR_REGISTRATION_CD PRN_NAMT 10
CVR_REGISTRATION_CD QUAL_DATE None
CVR_REGISTRATION_CD REC_TYPE 4
CVR_REGISTRATION_CD RENCERT_CB 1
CVR_REGISTRATION_CD REPORT_NUM 3
CVR_REGISTRATION_CD RPT_DATE None
CVR_REGISTRATION_CD SENDER_ID 9
CVR_REGISTRATION_CD SIG_DATE None
CVR_REGISTRATION_CD SIG_LOC 45
CVR_REGISTRATION_CD SIG_NAMF 45
CVR_REGISTRATION_CD SIG_NAML 200
CVR_REGISTRATION_CD SIG_NAMS 10
CVR_REGISTRATION_CD SIG_NAMT 10
CVR_REGISTRATION_CD SIG_TITLE 45
CVR_REGISTRATION_CD ST_AGENCY 100
CVR_REGISTRATION_CD ST_LEG_YN 1
CVR_REGISTRATION_CD STMT_FIRM 90
CVR_REGISTRATION_CD TRADE_CB 1
CVR2_REGISTRATION_CD ID None
CVR2_REGISTRATION_CD FILING_ID None
CVR2_REGISTRATION_CD AMEND_ID None
CVR2_REGISTRATION_CD LINE_ITEM None
CVR2_REGISTRATION_CD REC_TYPE 4
CVR2_REGISTRATION_CD FORM_TYPE 10
CVR2_REGISTRATION_CD TRAN_ID 20
CVR2_REGISTRATION_CD ENTITY_CD 3
CVR2_REGISTRATION_CD ENTITY_ID 9
CVR2_REGISTRATION_CD ENTY_NAML 200
CVR2_REGISTRATION_CD ENTY_NAMF 45
CVR2_REGISTRATION_CD ENTY_NAMT 10
CVR2_REGISTRATION_CD ENTY_NAMS 10
CVR_LOBBY_DISCLOSURE_CD ID None
CVR_LOBBY_DISCLOSURE_CD AMEND_ID None
CVR_LOBBY_DISCLOSURE_CD CTRIB_N_CB 1
CVR_LOBBY_DISCLOSURE_CD CTRIB_Y_CB 1
CVR_LOBBY_DISCLOSURE_CD CUM_BEG_DT None
CVR_LOBBY_DISCLOSURE_CD ENTITY_CD 3
CVR_LOBBY_DISCLOSURE_CD FILER_ID 8
CVR_LOBBY_DISCLOSURE_CD FILER_NAMF 45
CVR_LOBBY_DISCLOSURE_CD FILER_NAML 200
CVR_LOBBY_DISCLOSURE_CD FILER_NAMS 10
CVR_LOBBY_DISCLOSURE_CD FILER_NAMT 10
CVR_LOBBY_DISCLOSURE_CD FILING_ID None
CVR_LOBBY_DISCLOSURE_CD FIRM_CITY 30
CVR_LOBBY_DISCLOSURE_CD FIRM_ID 9
CVR_LOBBY_DISCLOSURE_CD FIRM_NAME 200
CVR_LOBBY_DISCLOSURE_CD FIRM_PHON 20
CVR_LOBBY_DISCLOSURE_CD FIRM_ST 2
CVR_LOBBY_DISCLOSURE_CD FIRM_ZIP4 10
CVR_LOBBY_DISCLOSURE_CD FORM_TYPE 4
CVR_LOBBY_DISCLOSURE_CD FROM_DATE None
CVR_LOBBY_DISCLOSURE_CD LBY_ACTVTY 400
CVR_LOBBY_DISCLOSURE_CD LOBBY_N_CB 1
CVR_LOBBY_DISCLOSURE_CD LOBBY_Y_CB 1
CVR_LOBBY_DISCLOSURE_CD MAIL_CITY 30
CVR_LOBBY_DISCLOSURE_CD MAIL_PHON 20
CVR_LOBBY_DISCLOSURE_CD MAIL_ST 2
CVR_LOBBY_DISCLOSURE_CD MAIL_ZIP4 10
CVR_LOBBY_DISCLOSURE_CD MAJOR_NAMF 45
CVR_LOBBY_DISCLOSURE_CD MAJOR_NAML 200
CVR_LOBBY_DISCLOSURE_CD MAJOR_NAMS 10
CVR_LOBBY_DISCLOSURE_CD MAJOR_NAMT 10
CVR_LOBBY_DISCLOSURE_CD NOPART1_CB 1
CVR_LOBBY_DISCLOSURE_CD NOPART2_CB 1
CVR_LOBBY_DISCLOSURE_CD PART1_1_CB 1
CVR_LOBBY_DISCLOSURE_CD PART1_2_CB 1
CVR_LOBBY_DISCLOSURE_CD PRN_NAMF 45
CVR_LOBBY_DISCLOSURE_CD PRN_NAML 200
CVR_LOBBY_DISCLOSURE_CD PRN_NAMS 10
CVR_LOBBY_DISCLOSURE_CD PRN_NAMT 10
CVR_LOBBY_DISCLOSURE_CD RCPCMTE_ID 9
CVR_LOBBY_DISCLOSURE_CD RCPCMTE_NM 200
CVR_LOBBY_DISCLOSURE_CD REC_TYPE 4
CVR_LOBBY_DISCLOSURE_CD REPORT_NUM 3
CVR_LOBBY_DISCLOSURE_CD RPT_DATE None
CVR_LOBBY_DISCLOSURE_CD SENDER_ID 9
CVR_LOBBY_DISCLOSURE_CD SIG_DATE None
CVR_LOBBY_DISCLOSURE_CD SIG_LOC 45
CVR_LOBBY_DISCLOSURE_CD SIG_NAMF 45
CVR_LOBBY_DISCLOSURE_CD SIG_NAML 200
CVR_LOBBY_DISCLOSURE_CD SIG_NAMS 10
CVR_LOBBY_DISCLOSURE_CD SIG_NAMT 10
CVR_LOBBY_DISCLOSURE_CD SIG_TITLE 45
CVR_LOBBY_DISCLOSURE_CD THRU_DATE None
CVR2_LOBBY_DISCLOSURE_CD ID None
CVR2_LOBBY_DISCLOSURE_CD AMEND_ID None
CVR2_LOBBY_DISCLOSURE_CD ENTITY_CD 3
CVR2_LOBBY_DISCLOSURE_CD ENTITY_ID 9
CVR2_LOBBY_DISCLOSURE_CD ENTY_NAMF 45
CVR2_LOBBY_DISCLOSURE_CD ENTY_NAML 200
CVR2_LOBBY_DISCLOSURE_CD ENTY_NAMS 10
CVR2_LOBBY_DISCLOSURE_CD ENTY_NAMT 10
CVR2_LOBBY_DISCLOSURE_CD ENTY_TITLE 45
CVR2_LOBBY_DISCLOSURE_CD FILING_ID None
CVR2_LOBBY_DISCLOSURE_CD FORM_TYPE 4
CVR2_LOBBY_DISCLOSURE_CD LINE_ITEM None
CVR2_LOBBY_DISCLOSURE_CD REC_TYPE 4
CVR2_LOBBY_DISCLOSURE_CD TRAN_ID 20
LOBBY_AMENDMENTS_CD ID None
LOBBY_AMENDMENTS_CD FILING_ID None
LOBBY_AMENDMENTS_CD AMEND_ID None
LOBBY_AMENDMENTS_CD REC_TYPE 4
LOBBY_AMENDMENTS_CD FORM_TYPE 9
LOBBY_AMENDMENTS_CD EXEC_DATE 22
LOBBY_AMENDMENTS_CD FROM_DATE 22
LOBBY_AMENDMENTS_CD THRU_DATE 22
LOBBY_AMENDMENTS_CD ADD_L_CB 1
LOBBY_AMENDMENTS_CD ADD_L_EFF None
LOBBY_AMENDMENTS_CD A_L_NAML 200
LOBBY_AMENDMENTS_CD A_L_NAMF 45
LOBBY_AMENDMENTS_CD A_L_NAMT 10
LOBBY_AMENDMENTS_CD A_L_NAMS 10
LOBBY_AMENDMENTS_CD DEL_L_CB 8
LOBBY_AMENDMENTS_CD DEL_L_EFF 22
LOBBY_AMENDMENTS_CD D_L_NAML 56
LOBBY_AMENDMENTS_CD D_L_NAMF 35
LOBBY_AMENDMENTS_CD D_L_NAMT 10
LOBBY_AMENDMENTS_CD D_L_NAMS 8
LOBBY_AMENDMENTS_CD ADD_LE_CB 1
LOBBY_AMENDMENTS_CD ADD_LE_EFF None
LOBBY_AMENDMENTS_CD A_LE_NAML 200
LOBBY_AMENDMENTS_CD A_LE_NAMF 45
LOBBY_AMENDMENTS_CD A_LE_NAMT 10
LOBBY_AMENDMENTS_CD A_LE_NAMS 10
LOBBY_AMENDMENTS_CD DEL_LE_CB 9
LOBBY_AMENDMENTS_CD DEL_LE_EFF 22
LOBBY_AMENDMENTS_CD D_LE_NAML 160
LOBBY_AMENDMENTS_CD D_LE_NAMF 45
LOBBY_AMENDMENTS_CD D_LE_NAMT 12
LOBBY_AMENDMENTS_CD D_LE_NAMS 9
LOBBY_AMENDMENTS_CD ADD_LF_CB 1
LOBBY_AMENDMENTS_CD ADD_LF_EFF None
LOBBY_AMENDMENTS_CD A_LF_NAME 200
LOBBY_AMENDMENTS_CD DEL_LF_CB 1
LOBBY_AMENDMENTS_CD DEL_LF_EFF None
LOBBY_AMENDMENTS_CD D_LF_NAME 200
LOBBY_AMENDMENTS_CD OTHER_CB 1
LOBBY_AMENDMENTS_CD OTHER_EFF None
LOBBY_AMENDMENTS_CD OTHER_DESC 100
LOBBY_AMENDMENTS_CD F606_YES 1
LOBBY_AMENDMENTS_CD F606_NO 1
F690P2_CD ID None
F690P2_CD FILING_ID None
F690P2_CD AMEND_ID None
F690P2_CD LINE_ITEM None
F690P2_CD REC_TYPE 4
F690P2_CD FORM_TYPE 4
F690P2_CD EXEC_DATE None
F690P2_CD FROM_DATE None
F690P2_CD THRU_DATE None
F690P2_CD CHG_PARTS 100
F690P2_CD CHG_SECTS 100
F690P2_CD AMEND_TXT1 330
LATT_CD ID None
LATT_CD AMEND_ID None
LATT_CD AMOUNT None
LATT_CD CUM_AMT None
LATT_CD CUMBEG_DT None
LATT_CD ENTITY_CD 3
LATT_CD FILING_ID None
LATT_CD FORM_TYPE 6
LATT_CD LINE_ITEM None
LATT_CD MEMO_CODE 1
LATT_CD MEMO_REFNO 20
LATT_CD PMT_DATE None
LATT_CD REC_TYPE 4
LATT_CD RECIP_CITY 30
LATT_CD RECIP_NAMF 45
LATT_CD RECIP_NAML 200
LATT_CD RECIP_NAMS 10
LATT_CD RECIP_NAMT 10
LATT_CD RECIP_ST 2
LATT_CD RECIP_ZIP4 10
LATT_CD TRAN_ID 20
LEXP_CD ID None
LEXP_CD AMEND_ID None
LEXP_CD AMOUNT None
LEXP_CD BAKREF_TID 20
LEXP_CD BENE_AMT 12
LEXP_CD BENE_NAME 90
LEXP_CD BENE_POSIT 90
LEXP_CD CREDCARDCO 200
LEXP_CD ENTITY_CD 3
LEXP_CD EXPN_DATE None
LEXP_CD EXPN_DSCR 90
LEXP_CD FILING_ID None
LEXP_CD FORM_TYPE 7
LEXP_CD LINE_ITEM None
LEXP_CD MEMO_CODE 1
LEXP_CD MEMO_REFNO 20
LEXP_CD PAYEE_CITY 30
LEXP_CD PAYEE_NAMF 45
LEXP_CD PAYEE_NAML 200
LEXP_CD PAYEE_NAMS 10
LEXP_CD PAYEE_NAMT 10
LEXP_CD PAYEE_ST 2
LEXP_CD PAYEE_ZIP4 10
LEXP_CD REC_TYPE 4
LEXP_CD RECSUBTYPE 1
LEXP_CD TRAN_ID 20
LCCM_CD ID None
LCCM_CD AMEND_ID None
LCCM_CD AMOUNT None
LCCM_CD BAKREF_TID 20
LCCM_CD CTRIB_DATE None
LCCM_CD CTRIB_NAMF 45
LCCM_CD CTRIB_NAML 120
LCCM_CD CTRIB_NAMS 10
LCCM_CD CTRIB_NAMT 10
LCCM_CD ENTITY_CD 3
LCCM_CD FILING_ID None
LCCM_CD FORM_TYPE 7
LCCM_CD LINE_ITEM None
LCCM_CD MEMO_CODE 1
LCCM_CD MEMO_REFNO 20
LCCM_CD REC_TYPE 4
LCCM_CD RECIP_CITY 30
LCCM_CD RECIP_ID 9
LCCM_CD RECIP_NAMF 45
LCCM_CD RECIP_NAML 200
LCCM_CD RECIP_NAMS 10
LCCM_CD RECIP_NAMT 10
LCCM_CD RECIP_ST 2
LCCM_CD RECIP_ZIP4 10
LCCM_CD TRAN_ID 20
LOTH_CD ID None
LOTH_CD AMEND_ID None
LOTH_CD AMOUNT None
LOTH_CD CUM_AMT None
LOTH_CD FILING_ID None
LOTH_CD FIRM_CITY 30
LOTH_CD FIRM_NAME 200
LOTH_CD FIRM_PHON 20
LOTH_CD FIRM_ST 2
LOTH_CD FIRM_ZIP4 10
LOTH_CD FORM_TYPE 7
LOTH_CD LINE_ITEM None
LOTH_CD MEMO_CODE 1
LOTH_CD MEMO_REFNO 20
LOTH_CD PMT_DATE None
LOTH_CD REC_TYPE 4
LOTH_CD SUBJ_NAMF 45
LOTH_CD SUBJ_NAML 200
LOTH_CD SUBJ_NAMS 45
LOTH_CD SUBJ_NAMT 45
LOTH_CD TRAN_ID 20
LEMP_CD ID None
LEMP_CD AGENCYLIST 200
LEMP_CD AMEND_ID None
LEMP_CD CLI_CITY 30
LEMP_CD CLI_NAMF 45
LEMP_CD CLI_NAML 200
LEMP_CD CLI_NAMS 10
LEMP_CD CLI_NAMT 10
LEMP_CD CLI_PHON 20
LEMP_CD CLI_ST 2
LEMP_CD CLI_ZIP4 10
LEMP_CD CLIENT_ID 9
LEMP_CD CON_PERIOD 30
LEMP_CD DESCRIP 100
LEMP_CD EFF_DATE None
LEMP_CD FILING_ID None
LEMP_CD FORM_TYPE 7
LEMP_CD LINE_ITEM None
LEMP_CD REC_TYPE 4
LEMP_CD SUB_CITY 30
LEMP_CD SUB_NAME 200
LEMP_CD SUB_PHON 20
LEMP_CD SUB_ST 2
LEMP_CD SUB_ZIP4 10
LEMP_CD SUBFIRM_ID 9
LPAY_CD ID None
LPAY_CD ADVAN_AMT None
LPAY_CD ADVAN_DSCR 100
LPAY_CD AMEND_ID None
LPAY_CD BAKREF_TID 20
LPAY_CD CUM_TOTAL None
LPAY_CD EMPLR_CITY 30
LPAY_CD EMPLR_ID 9
LPAY_CD EMPLR_NAMF 45
LPAY_CD EMPLR_NAML 200
LPAY_CD EMPLR_NAMS 10
LPAY_CD EMPLR_NAMT 10
LPAY_CD EMPLR_PHON 20
LPAY_CD EMPLR_ST 2
LPAY_CD EMPLR_ZIP4 10
LPAY_CD ENTITY_CD 3
LPAY_CD FEES_AMT None
LPAY_CD FILING_ID None
LPAY_CD FORM_TYPE 7
LPAY_CD LBY_ACTVTY 200
LPAY_CD LINE_ITEM None
LPAY_CD MEMO_CODE 1
LPAY_CD MEMO_REFNO 20
LPAY_CD PER_TOTAL None
LPAY_CD REC_TYPE 4
LPAY_CD REIMB_AMT None
LPAY_CD TRAN_ID 20
FILERNAME_CD ID None
FILERNAME_CD XREF_FILER_ID 15
FILERNAME_CD FILER_ID None
FILERNAME_CD FILER_TYPE 45
FILERNAME_CD STATUS 10
FILERNAME_CD EFFECT_DT None
FILERNAME_CD NAML 200
FILERNAME_CD NAMF 55
FILERNAME_CD NAMT 70
FILERNAME_CD NAMS 32
FILERNAME_CD ADR1 200
FILERNAME_CD ADR2 200
FILERNAME_CD CITY 55
FILERNAME_CD ST 4
FILERNAME_CD ZIP4 10
FILERNAME_CD PHON 60
FILERNAME_CD FAX 60
FILERNAME_CD EMAIL 60
FILER_FILINGS_CD ID None
FILER_FILINGS_CD FILER_ID None
FILER_FILINGS_CD FILING_ID None
FILER_FILINGS_CD PERIOD_ID None
FILER_FILINGS_CD FORM_ID 7
FILER_FILINGS_CD FILING_SEQUENCE None
FILER_FILINGS_CD FILING_DATE None
FILER_FILINGS_CD STMNT_TYPE None
FILER_FILINGS_CD STMNT_STATUS None
FILER_FILINGS_CD SESSION_ID None
FILER_FILINGS_CD USER_ID 12
FILER_FILINGS_CD SPECIAL_AUDIT None
FILER_FILINGS_CD FINE_AUDIT None
FILER_FILINGS_CD RPT_START None
FILER_FILINGS_CD RPT_END None
FILER_FILINGS_CD RPT_DATE None
FILER_FILINGS_CD FILING_TYPE None
FILINGS_CD ID None
FILINGS_CD FILING_ID None
FILINGS_CD FILING_TYPE None
SMRY_CD ID None
SMRY_CD FILING_ID None
SMRY_CD AMEND_ID None
SMRY_CD LINE_ITEM 8
SMRY_CD REC_TYPE 4
SMRY_CD FORM_TYPE 8
SMRY_CD AMOUNT_A None
SMRY_CD AMOUNT_B None
SMRY_CD AMOUNT_C None
SMRY_CD ELEC_DT None
CVR_E530_CD ID None
CVR_E530_CD FILING_ID None
CVR_E530_CD AMEND_ID None
CVR_E530_CD REC_TYPE 4
CVR_E530_CD FORM_TYPE 4
CVR_E530_CD ENTITY_CD 32
CVR_E530_CD FILER_NAML 200
CVR_E530_CD FILER_NAMF 4
CVR_E530_CD FILER_NAMT 32
CVR_E530_CD FILER_NAMS 32
CVR_E530_CD REPORT_NUM 32
CVR_E530_CD RPT_DATE None
CVR_E530_CD FILER_CITY 16
CVR_E530_CD FILER_ST 4
CVR_E530_CD FILER_ZIP4 10
CVR_E530_CD OCCUPATION 15
CVR_E530_CD EMPLOYER 13
CVR_E530_CD CAND_NAML 46
CVR_E530_CD CAND_NAMF 21
CVR_E530_CD CAND_NAMT 32
CVR_E530_CD CAND_NAMS 32
CVR_E530_CD DISTRICT_CD None
CVR_E530_CD OFFICE_CD None
CVR_E530_CD PMNT_DT None
CVR_E530_CD PMNT_AMOUNT None
CVR_E530_CD TYPE_LITERATURE None
CVR_E530_CD TYPE_PRINTADS None
CVR_E530_CD TYPE_RADIO None
CVR_E530_CD TYPE_TV None
CVR_E530_CD TYPE_IT None
CVR_E530_CD TYPE_BILLBOARDS None
CVR_E530_CD TYPE_OTHER None
CVR_E530_CD OTHER_DESC 49
TEXT_MEMO_CD ID None
TEXT_MEMO_CD FILING_ID None
TEXT_MEMO_CD AMEND_ID None
TEXT_MEMO_CD LINE_ITEM None
TEXT_MEMO_CD REC_TYPE 4
TEXT_MEMO_CD FORM_TYPE 8
TEXT_MEMO_CD REF_NO 20
TEXT_MEMO_CD TEXT4000 4000
ACRONYMS_CD ID None
ACRONYMS_CD ACRONYM 40
ACRONYMS_CD STANDS_FOR 4
ACRONYMS_CD EFFECT_DT None
ACRONYMS_CD A_DESC 50
ADDRESS_CD ID None
ADDRESS_CD ADRID None
ADDRESS_CD CITY 500
ADDRESS_CD ST 500
ADDRESS_CD ZIP4 10
ADDRESS_CD PHON 20
ADDRESS_CD FAX 20
ADDRESS_CD EMAIL 500
BALLOT_MEASURES_CD ID None
BALLOT_MEASURES_CD ELECTION_DATE None
BALLOT_MEASURES_CD FILER_ID None
BALLOT_MEASURES_CD MEASURE_NO 2
BALLOT_MEASURES_CD MEASURE_NAME 163
BALLOT_MEASURES_CD MEASURE_SHORT_NAME 50
BALLOT_MEASURES_CD JURISDICTION 9
EFS_FILING_LOG_CD ID None
EFS_FILING_LOG_CD FILING_DATE None
EFS_FILING_LOG_CD FILINGSTATUS None
EFS_FILING_LOG_CD VENDOR 250
EFS_FILING_LOG_CD FILER_ID 250
EFS_FILING_LOG_CD FORM_TYPE 250
EFS_FILING_LOG_CD ERROR_NO 250
FILERS_CD ID None
FILERS_CD FILER_ID None
FILER_ACRONYMS_CD ID None
FILER_ACRONYMS_CD ACRONYM 32
FILER_ACRONYMS_CD FILER_ID None
FILER_ADDRESS_CD ID None
FILER_ADDRESS_CD FILER_ID None
FILER_ADDRESS_CD ADRID None
FILER_ADDRESS_CD EFFECT_DT None
FILER_ADDRESS_CD ADD_TYPE None
FILER_ADDRESS_CD SESSION_ID None
FILER_ETHICS_CLASS_CD ID None
FILER_ETHICS_CLASS_CD FILER_ID None
FILER_ETHICS_CLASS_CD SESSION_ID None
FILER_ETHICS_CLASS_CD ETHICS_DATE None
FILER_INTERESTS_CD ID None
FILER_INTERESTS_CD FILER_ID None
FILER_INTERESTS_CD SESSION_ID None
FILER_INTERESTS_CD INTEREST_CD None
FILER_INTERESTS_CD EFFECT_DATE None
FILER_LINKS_CD ID None
FILER_LINKS_CD FILER_ID_A None
FILER_LINKS_CD FILER_ID_B None
FILER_LINKS_CD ACTIVE_FLG 1
FILER_LINKS_CD SESSION_ID None
FILER_LINKS_CD LINK_TYPE None
FILER_LINKS_CD LINK_DESC 255
FILER_LINKS_CD EFFECT_DT None
FILER_LINKS_CD DOMINATE_FILER 1
FILER_LINKS_CD TERMINATION_DT None
FILER_STATUS_TYPES_CD ID None
FILER_STATUS_TYPES_CD STATUS_TYPE 11
FILER_STATUS_TYPES_CD STATUS_DESC 11
FILER_TO_FILER_TYPE_CD ID None
FILER_TO_FILER_TYPE_CD FILER_ID None
FILER_TO_FILER_TYPE_CD FILER_TYPE None
FILER_TO_FILER_TYPE_CD ACTIVE 1
FILER_TO_FILER_TYPE_CD RACE None
FILER_TO_FILER_TYPE_CD SESSION_ID None
FILER_TO_FILER_TYPE_CD CATEGORY None
FILER_TO_FILER_TYPE_CD CATEGORY_TYPE None
FILER_TO_FILER_TYPE_CD SUB_CATEGORY None
FILER_TO_FILER_TYPE_CD EFFECT_DT None
FILER_TO_FILER_TYPE_CD SUB_CATEGORY_TYPE None
FILER_TO_FILER_TYPE_CD ELECTION_TYPE None
FILER_TO_FILER_TYPE_CD SUB_CATEGORY_A 1
FILER_TO_FILER_TYPE_CD NYQ_DT None
FILER_TO_FILER_TYPE_CD PARTY_CD None
FILER_TO_FILER_TYPE_CD COUNTY_CD None
FILER_TO_FILER_TYPE_CD DISTRICT_CD None
FILER_TYPES_CD ID None
FILER_TYPES_CD FILER_TYPE None
FILER_TYPES_CD DESCRIPTION 255
FILER_TYPES_CD GRP_TYPE None
FILER_TYPES_CD CALC_USE 1
FILER_TYPES_CD GRACE_PERIOD 12
FILER_XREF_CD ID None
FILER_XREF_CD FILER_ID None
FILER_XREF_CD XREF_ID 32
FILER_XREF_CD EFFECT_DT None
FILER_XREF_CD MIGRATION_SOURCE 50
FILING_PERIOD_CD ID None
FILING_PERIOD_CD PERIOD_ID None
FILING_PERIOD_CD START_DATE None
FILING_PERIOD_CD END_DATE None
FILING_PERIOD_CD PERIOD_TYPE None
FILING_PERIOD_CD PER_GRP_TYPE None
FILING_PERIOD_CD PERIOD_DESC 255
FILING_PERIOD_CD DEADLINE None
GROUP_TYPES_CD ID None
GROUP_TYPES_CD GRP_ID None
GROUP_TYPES_CD GRP_NAME 28
GROUP_TYPES_CD GRP_DESC 32
HEADER_CD ID None
HEADER_CD LINE_NUMBER None
HEADER_CD FORM_ID 5
HEADER_CD REC_TYPE 11
HEADER_CD SECTION_LABEL 58
HEADER_CD COMMENTS1 48
HEADER_CD COMMENTS2 48
HEADER_CD LABEL 98
HEADER_CD COLUMN_A None
HEADER_CD COLUMN_B None
HEADER_CD COLUMN_C None
HEADER_CD SHOW_C None
HEADER_CD SHOW_B None
HDR_CD ID None
HDR_CD AMEND_ID None
HDR_CD CAL_VER 4
HDR_CD EF_TYPE 3
HDR_CD FILING_ID None
HDR_CD HDR_COMMENT 200
HDR_CD REC_TYPE 4
HDR_CD SOFT_NAME 90
HDR_CD SOFT_VER 16
HDR_CD STATE_CD 2
IMAGE_LINKS_CD ID None
IMAGE_LINKS_CD IMG_LINK_ID None
IMAGE_LINKS_CD IMG_LINK_TYPE None
IMAGE_LINKS_CD IMG_ID None
IMAGE_LINKS_CD IMG_TYPE None
IMAGE_LINKS_CD IMG_DT None
LEGISLATIVE_SESSIONS_CD ID None
LEGISLATIVE_SESSIONS_CD SESSION_ID None
LEGISLATIVE_SESSIONS_CD BEGIN_DATE None
LEGISLATIVE_SESSIONS_CD END_DATE None
LOBBYING_CHG_LOG_CD ID None
LOBBYING_CHG_LOG_CD FILER_ID None
LOBBYING_CHG_LOG_CD CHANGE_NO None
LOBBYING_CHG_LOG_CD SESSION_ID None
LOBBYING_CHG_LOG_CD LOG_DT None
LOBBYING_CHG_LOG_CD FILER_TYPE None
LOBBYING_CHG_LOG_CD CORRECTION_FLAG 200
LOBBYING_CHG_LOG_CD ACTION 200
LOBBYING_CHG_LOG_CD ATTRIBUTE_CHANGED 200
LOBBYING_CHG_LOG_CD ETHICS_DT None
LOBBYING_CHG_LOG_CD INTERESTS 200
LOBBYING_CHG_LOG_CD FILER_FULL_NAME 200
LOBBYING_CHG_LOG_CD FILER_CITY 200
LOBBYING_CHG_LOG_CD FILER_ST 200
LOBBYING_CHG_LOG_CD FILER_ZIP None
LOBBYING_CHG_LOG_CD FILER_PHONE 12
LOBBYING_CHG_LOG_CD ENTITY_TYPE None
LOBBYING_CHG_LOG_CD ENTITY_NAME 500
LOBBYING_CHG_LOG_CD ENTITY_CITY 500
LOBBYING_CHG_LOG_CD ENTITY_ST 500
LOBBYING_CHG_LOG_CD ENTITY_ZIP 10
LOBBYING_CHG_LOG_CD ENTITY_PHONE 12
LOBBYING_CHG_LOG_CD ENTITY_ID None
LOBBYING_CHG_LOG_CD RESPONSIBLE_OFFICER 500
LOBBYING_CHG_LOG_CD EFFECT_DT None
LOBBYIST_CONTRIBUTIONS1_CD ID None
LOBBYIST_CONTRIBUTIONS1_CD FILER_ID None
LOBBYIST_CONTRIBUTIONS1_CD FILING_PERIOD_START_DT None
LOBBYIST_CONTRIBUTIONS1_CD FILING_PERIOD_END_DT None
LOBBYIST_CONTRIBUTIONS1_CD CONTRIBUTION_DT 32
LOBBYIST_CONTRIBUTIONS1_CD RECIPIENT_NAME 106
LOBBYIST_CONTRIBUTIONS1_CD RECIPIENT_ID None
LOBBYIST_CONTRIBUTIONS1_CD AMOUNT None
LOBBYIST_CONTRIBUTIONS2_CD ID None
LOBBYIST_CONTRIBUTIONS2_CD FILER_ID None
LOBBYIST_CONTRIBUTIONS2_CD FILING_PERIOD_START_DT None
LOBBYIST_CONTRIBUTIONS2_CD FILING_PERIOD_END_DT None
LOBBYIST_CONTRIBUTIONS2_CD CONTRIBUTION_DT 32
LOBBYIST_CONTRIBUTIONS2_CD RECIPIENT_NAME 106
LOBBYIST_CONTRIBUTIONS2_CD RECIPIENT_ID None
LOBBYIST_CONTRIBUTIONS2_CD AMOUNT None
LOBBYIST_CONTRIBUTIONS3_CD ID None
LOBBYIST_CONTRIBUTIONS3_CD FILER_ID None
LOBBYIST_CONTRIBUTIONS3_CD FILING_PERIOD_START_DT None
LOBBYIST_CONTRIBUTIONS3_CD FILING_PERIOD_END_DT None
LOBBYIST_CONTRIBUTIONS3_CD CONTRIBUTION_DT 32
LOBBYIST_CONTRIBUTIONS3_CD RECIPIENT_NAME 106
LOBBYIST_CONTRIBUTIONS3_CD RECIPIENT_ID None
LOBBYIST_CONTRIBUTIONS3_CD AMOUNT None
LOBBYIST_EMPLOYER1_CD ID None
LOBBYIST_EMPLOYER1_CD EMPLOYER_ID None
LOBBYIST_EMPLOYER1_CD SESSION_ID None
LOBBYIST_EMPLOYER1_CD EMPLOYER_NAME 300
LOBBYIST_EMPLOYER1_CD CURRENT_QTR_AMT None
LOBBYIST_EMPLOYER1_CD SESSION_TOTAL_AMT None
LOBBYIST_EMPLOYER1_CD CONTRIBUTOR_ID None
LOBBYIST_EMPLOYER1_CD INTEREST_CD None
LOBBYIST_EMPLOYER1_CD INTEREST_NAME 24
LOBBYIST_EMPLOYER1_CD SESSION_YR_1 None
LOBBYIST_EMPLOYER1_CD SESSION_YR_2 None
LOBBYIST_EMPLOYER1_CD YR_1_YTD_AMT None
LOBBYIST_EMPLOYER1_CD YR_2_YTD_AMT None
LOBBYIST_EMPLOYER1_CD QTR_1 None
LOBBYIST_EMPLOYER1_CD QTR_2 None
LOBBYIST_EMPLOYER1_CD QTR_3 None
LOBBYIST_EMPLOYER1_CD QTR_4 None
LOBBYIST_EMPLOYER1_CD QTR_5 None
LOBBYIST_EMPLOYER1_CD QTR_6 None
LOBBYIST_EMPLOYER1_CD QTR_7 None
LOBBYIST_EMPLOYER1_CD QTR_8 None
LOBBYIST_EMPLOYER2_CD ID None
LOBBYIST_EMPLOYER2_CD EMPLOYER_ID None
LOBBYIST_EMPLOYER2_CD SESSION_ID None
LOBBYIST_EMPLOYER2_CD EMPLOYER_NAME 300
LOBBYIST_EMPLOYER2_CD CURRENT_QTR_AMT None
LOBBYIST_EMPLOYER2_CD SESSION_TOTAL_AMT None
LOBBYIST_EMPLOYER2_CD CONTRIBUTOR_ID None
LOBBYIST_EMPLOYER2_CD INTEREST_CD None
LOBBYIST_EMPLOYER2_CD INTEREST_NAME 24
LOBBYIST_EMPLOYER2_CD SESSION_YR_1 None
LOBBYIST_EMPLOYER2_CD SESSION_YR_2 None
LOBBYIST_EMPLOYER2_CD YR_1_YTD_AMT None
LOBBYIST_EMPLOYER2_CD YR_2_YTD_AMT None
LOBBYIST_EMPLOYER2_CD QTR_1 None
LOBBYIST_EMPLOYER2_CD QTR_2 None
LOBBYIST_EMPLOYER2_CD QTR_3 None
LOBBYIST_EMPLOYER2_CD QTR_4 None
LOBBYIST_EMPLOYER2_CD QTR_5 None
LOBBYIST_EMPLOYER2_CD QTR_6 None
LOBBYIST_EMPLOYER2_CD QTR_7 None
LOBBYIST_EMPLOYER2_CD QTR_8 None
LOBBYIST_EMPLOYER3_CD ID None
LOBBYIST_EMPLOYER3_CD EMPLOYER_ID None
LOBBYIST_EMPLOYER3_CD SESSION_ID None
LOBBYIST_EMPLOYER3_CD EMPLOYER_NAME 300
LOBBYIST_EMPLOYER3_CD CURRENT_QTR_AMT None
LOBBYIST_EMPLOYER3_CD SESSION_TOTAL_AMT None
LOBBYIST_EMPLOYER3_CD CONTRIBUTOR_ID None
LOBBYIST_EMPLOYER3_CD INTEREST_CD None
LOBBYIST_EMPLOYER3_CD INTEREST_NAME 24
LOBBYIST_EMPLOYER3_CD SESSION_YR_1 None
LOBBYIST_EMPLOYER3_CD SESSION_YR_2 None
LOBBYIST_EMPLOYER3_CD YR_1_YTD_AMT None
LOBBYIST_EMPLOYER3_CD YR_2_YTD_AMT None
LOBBYIST_EMPLOYER3_CD QTR_1 None
LOBBYIST_EMPLOYER3_CD QTR_2 None
LOBBYIST_EMPLOYER3_CD QTR_3 None
LOBBYIST_EMPLOYER3_CD QTR_4 None
LOBBYIST_EMPLOYER3_CD QTR_5 None
LOBBYIST_EMPLOYER3_CD QTR_6 None
LOBBYIST_EMPLOYER3_CD QTR_7 None
LOBBYIST_EMPLOYER3_CD QTR_8 None
LOBBYIST_EMPLOYER_FIRMS1_CD ID None
LOBBYIST_EMPLOYER_FIRMS1_CD EMPLOYER_ID None
LOBBYIST_EMPLOYER_FIRMS1_CD FIRM_ID None
LOBBYIST_EMPLOYER_FIRMS1_CD FIRM_NAME 400
LOBBYIST_EMPLOYER_FIRMS1_CD SESSION_ID None
LOBBYIST_EMPLOYER_FIRMS1_CD TERMINATION_DT 32
LOBBYIST_EMPLOYER_FIRMS2_CD ID None
LOBBYIST_EMPLOYER_FIRMS2_CD EMPLOYER_ID None
LOBBYIST_EMPLOYER_FIRMS2_CD FIRM_ID None
LOBBYIST_EMPLOYER_FIRMS2_CD FIRM_NAME 400
LOBBYIST_EMPLOYER_FIRMS2_CD SESSION_ID None
LOBBYIST_EMPLOYER_FIRMS2_CD TERMINATION_DT 32
LOBBYIST_EMP_LOBBYIST1_CD ID None
LOBBYIST_EMP_LOBBYIST1_CD LOBBYIST_ID None
LOBBYIST_EMP_LOBBYIST1_CD EMPLOYER_ID None
LOBBYIST_EMP_LOBBYIST1_CD LOBBYIST_LAST_NAME 17
LOBBYIST_EMP_LOBBYIST1_CD LOBBYIST_FIRST_NAME 17
LOBBYIST_EMP_LOBBYIST1_CD EMPLOYER_NAME 300
LOBBYIST_EMP_LOBBYIST1_CD SESSION_ID None
LOBBYIST_EMP_LOBBYIST2_CD ID None
LOBBYIST_EMP_LOBBYIST2_CD LOBBYIST_ID None
LOBBYIST_EMP_LOBBYIST2_CD EMPLOYER_ID None
LOBBYIST_EMP_LOBBYIST2_CD LOBBYIST_LAST_NAME 17
LOBBYIST_EMP_LOBBYIST2_CD LOBBYIST_FIRST_NAME 17
LOBBYIST_EMP_LOBBYIST2_CD EMPLOYER_NAME 300
LOBBYIST_EMP_LOBBYIST2_CD SESSION_ID None
LOBBYIST_FIRM1_CD ID None
LOBBYIST_FIRM1_CD FIRM_ID None
LOBBYIST_FIRM1_CD SESSION_ID None
LOBBYIST_FIRM1_CD FIRM_NAME 400
LOBBYIST_FIRM1_CD CURRENT_QTR_AMT None
LOBBYIST_FIRM1_CD SESSION_TOTAL_AMT None
LOBBYIST_FIRM1_CD CONTRIBUTOR_ID None
LOBBYIST_FIRM1_CD SESSION_YR_1 None
LOBBYIST_FIRM1_CD SESSION_YR_2 None
LOBBYIST_FIRM1_CD YR_1_YTD_AMT None
LOBBYIST_FIRM1_CD YR_2_YTD_AMT None
LOBBYIST_FIRM1_CD QTR_1 None
LOBBYIST_FIRM1_CD QTR_2 None
LOBBYIST_FIRM1_CD QTR_3 None
LOBBYIST_FIRM1_CD QTR_4 None
LOBBYIST_FIRM1_CD QTR_5 None
LOBBYIST_FIRM1_CD QTR_6 None
LOBBYIST_FIRM1_CD QTR_7 None
LOBBYIST_FIRM1_CD QTR_8 None
LOBBYIST_FIRM2_CD ID None
LOBBYIST_FIRM2_CD FIRM_ID None
LOBBYIST_FIRM2_CD SESSION_ID None
LOBBYIST_FIRM2_CD FIRM_NAME 400
LOBBYIST_FIRM2_CD CURRENT_QTR_AMT None
LOBBYIST_FIRM2_CD SESSION_TOTAL_AMT None
LOBBYIST_FIRM2_CD CONTRIBUTOR_ID None
LOBBYIST_FIRM2_CD SESSION_YR_1 None
LOBBYIST_FIRM2_CD SESSION_YR_2 None
LOBBYIST_FIRM2_CD YR_1_YTD_AMT None
LOBBYIST_FIRM2_CD YR_2_YTD_AMT None
LOBBYIST_FIRM2_CD QTR_1 None
LOBBYIST_FIRM2_CD QTR_2 None
LOBBYIST_FIRM2_CD QTR_3 None
LOBBYIST_FIRM2_CD QTR_4 None
LOBBYIST_FIRM2_CD QTR_5 None
LOBBYIST_FIRM2_CD QTR_6 None
LOBBYIST_FIRM2_CD QTR_7 None
LOBBYIST_FIRM2_CD QTR_8 None
LOBBYIST_FIRM3_CD ID None
LOBBYIST_FIRM3_CD FIRM_ID None
LOBBYIST_FIRM3_CD SESSION_ID None
LOBBYIST_FIRM3_CD FIRM_NAME 400
LOBBYIST_FIRM3_CD CURRENT_QTR_AMT None
LOBBYIST_FIRM3_CD SESSION_TOTAL_AMT None
LOBBYIST_FIRM3_CD CONTRIBUTOR_ID None
LOBBYIST_FIRM3_CD SESSION_YR_1 None
LOBBYIST_FIRM3_CD SESSION_YR_2 None
LOBBYIST_FIRM3_CD YR_1_YTD_AMT None
LOBBYIST_FIRM3_CD YR_2_YTD_AMT None
LOBBYIST_FIRM3_CD QTR_1 None
LOBBYIST_FIRM3_CD QTR_2 None
LOBBYIST_FIRM3_CD QTR_3 None
LOBBYIST_FIRM3_CD QTR_4 None
LOBBYIST_FIRM3_CD QTR_5 None
LOBBYIST_FIRM3_CD QTR_6 None
LOBBYIST_FIRM3_CD QTR_7 None
LOBBYIST_FIRM3_CD QTR_8 None
LOBBYIST_FIRM_EMPLOYER1_CD ID None
LOBBYIST_FIRM_EMPLOYER1_CD FIRM_ID None
LOBBYIST_FIRM_EMPLOYER1_CD FILING_ID None
LOBBYIST_FIRM_EMPLOYER1_CD FILING_SEQUENCE None
LOBBYIST_FIRM_EMPLOYER1_CD FIRM_NAME 400
LOBBYIST_FIRM_EMPLOYER1_CD EMPLOYER_NAME 300
LOBBYIST_FIRM_EMPLOYER1_CD RPT_START None
LOBBYIST_FIRM_EMPLOYER1_CD RPT_END None
LOBBYIST_FIRM_EMPLOYER1_CD PER_TOTAL None
LOBBYIST_FIRM_EMPLOYER1_CD CUM_TOTAL None
LOBBYIST_FIRM_EMPLOYER1_CD LBY_ACTVTY 182
LOBBYIST_FIRM_EMPLOYER1_CD EXT_LBY_ACTVTY 32
LOBBYIST_FIRM_EMPLOYER2_CD ID None
LOBBYIST_FIRM_EMPLOYER2_CD FIRM_ID None
LOBBYIST_FIRM_EMPLOYER2_CD FILING_ID None
LOBBYIST_FIRM_EMPLOYER2_CD FILING_SEQUENCE None
LOBBYIST_FIRM_EMPLOYER2_CD FIRM_NAME 400
LOBBYIST_FIRM_EMPLOYER2_CD EMPLOYER_NAME 300
LOBBYIST_FIRM_EMPLOYER2_CD RPT_START None
LOBBYIST_FIRM_EMPLOYER2_CD RPT_END None
LOBBYIST_FIRM_EMPLOYER2_CD PER_TOTAL None
LOBBYIST_FIRM_EMPLOYER2_CD CUM_TOTAL None
LOBBYIST_FIRM_EMPLOYER2_CD LBY_ACTVTY 182
LOBBYIST_FIRM_EMPLOYER2_CD EXT_LBY_ACTVTY 32
LOBBYIST_FIRM_LOBBYIST1_CD ID None
LOBBYIST_FIRM_LOBBYIST1_CD LOBBYIST_ID None
LOBBYIST_FIRM_LOBBYIST1_CD FIRM_ID None
LOBBYIST_FIRM_LOBBYIST1_CD LOBBYIST_LAST_NAME 15
LOBBYIST_FIRM_LOBBYIST1_CD LOBBYIST_FIRST_NAME 17
LOBBYIST_FIRM_LOBBYIST1_CD FIRM_NAME 400
LOBBYIST_FIRM_LOBBYIST1_CD SESSION_ID None
LOBBYIST_FIRM_LOBBYIST2_CD ID None
LOBBYIST_FIRM_LOBBYIST2_CD LOBBYIST_ID None
LOBBYIST_FIRM_LOBBYIST2_CD FIRM_ID None
LOBBYIST_FIRM_LOBBYIST2_CD LOBBYIST_LAST_NAME 15
LOBBYIST_FIRM_LOBBYIST2_CD LOBBYIST_FIRST_NAME 17
LOBBYIST_FIRM_LOBBYIST2_CD FIRM_NAME 400
LOBBYIST_FIRM_LOBBYIST2_CD SESSION_ID None
LOOKUP_CODES_CD ID None
LOOKUP_CODES_CD CODE_TYPE None
LOOKUP_CODES_CD CODE_ID None
LOOKUP_CODES_CD CODE_DESC 100
NAMES_CD ID None
NAMES_CD NAMID None
NAMES_CD NAML 200
NAMES_CD NAMF 50
NAMES_CD NAMT 100
NAMES_CD NAMS 30
NAMES_CD MONIKER 30
NAMES_CD MONIKER_POS 9
NAMES_CD NAMM 20
NAMES_CD FULLNAME 200
NAMES_CD NAML_SEARCH 200
RECEIVED_FILINGS_CD ID None
RECEIVED_FILINGS_CD FILER_ID None
RECEIVED_FILINGS_CD FILING_FILE_NAME 14
RECEIVED_FILINGS_CD RECEIVED_DATE None
RECEIVED_FILINGS_CD FILING_DIRECTORY 45
RECEIVED_FILINGS_CD FILING_ID None
RECEIVED_FILINGS_CD FORM_ID 4
RECEIVED_FILINGS_CD RECEIVE_COMMENT 51
REPORTS_CD ID None
REPORTS_CD RPT_ID None
REPORTS_CD RPT_NAME 74
REPORTS_CD RPT_DESC_FIELD 32
REPORTS_CD PATH 32
REPORTS_CD DATA_OBJECT 38
REPORTS_CD PARMS_FLG_Y_N None
REPORTS_CD RPT_TYPE None
REPORTS_CD PARM_DEFINITION None
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment