Name: CAMPFIN_BALANCES

Display Field: FILER_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• filing_form_id (type: esriFieldTypeInteger, alias: FILING_FORM_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_id (type: esriFieldTypeInteger, alias: REPORT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_cycle_start_date (type: esriFieldTypeDate, alias: REPORT_CYCLE_START_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• report_cycle_end_date (type: esriFieldTypeDate, alias: REPORT_CYCLE_END_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• report_cycle_due_date (type: esriFieldTypeDate, alias: REPORT_CYCLE_DUE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• filer_name (type: esriFieldTypeString, alias: FILER_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_type (type: esriFieldTypeString, alias: FILER_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_local_flag (type: esriFieldTypeString, alias: FILER_LOCAL_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_local_flag_desc (type: esriFieldTypeString, alias: FILER_LOCAL_FLAG_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• beginning_cash_balance (type: esriFieldTypeDouble, alias: BEGINNING_CASH_BALANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ending_cash_balance (type: esriFieldTypeDouble, alias: ENDING_CASH_BALANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• utmz_monetary_contribution (type: esriFieldTypeDouble, alias: UTMZ_MONETARY_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• utmz_in_kind_contribution (type: esriFieldTypeDouble, alias: UTMZ_IN_KIND_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_contributions (type: esriFieldTypeDouble, alias: NUM_CONTRIBUTIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_expenditures (type: esriFieldTypeDouble, alias: NUM_EXPENDITURES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unpaid_debts (type: esriFieldTypeDouble, alias: UNPAID_DEBTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_paper_filings (type: esriFieldTypeInteger, alias: NUM_PAPER_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_year (type: esriFieldTypeDouble, alias: REPORT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• election_date (type: esriFieldTypeDate, alias: ELECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• election_type (type: esriFieldTypeString, alias: ELECTION_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_id (type: esriFieldTypeInteger, alias: FILER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• filer_state (type: esriFieldTypeString, alias: FILER_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_city (type: esriFieldTypeString, alias: FILER_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_zip (type: esriFieldTypeString, alias: FILER_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_actv_cand_flag (type: esriFieldTypeString, alias: FILER_ACTV_CAND_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_actv_city_cand_flag (type: esriFieldTypeString, alias: FILER_ACTV_CITY_CAND_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_actv_city_cand_desg_flag (type: esriFieldTypeString, alias: FILER_ACTV_CITY_CAND_DESG_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_candidate_name (type: esriFieldTypeString, alias: FILER_CANDIDATE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_office (type: esriFieldTypeString, alias: CANDIDATE_OFFICE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_level (type: esriFieldTypeString, alias: OFFICE_LEVEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_party (type: esriFieldTypeString, alias: CANDIDATE_PARTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_district_num (type: esriFieldTypeString, alias: CANDIDATE_DISTRICT_NUM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_district_name (type: esriFieldTypeString, alias: CANDIDATE_DISTRICT_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_incumbency (type: esriFieldTypeString, alias: CANDIDATE_INCUMBENCY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_election_outcome (type: esriFieldTypeString, alias: CANDIDATE_ELECTION_OUTCOME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate_endorsement (type: esriFieldTypeString, alias: CANDIDATE_ENDORSEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_cycle_code (type: esriFieldTypeString, alias: REPORT_CYCLE_CODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_cycle_name (type: esriFieldTypeString, alias: REPORT_CYCLE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_doc_type (type: esriFieldTypeString, alias: REPORT_DOC_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_doc_type_detail (type: esriFieldTypeString, alias: REPORT_DOC_TYPE_DETAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_type (type: esriFieldTypeInteger, alias: REPORT_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_certified_date (type: esriFieldTypeDate, alias: REPORT_CERTIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• report_filed_by (type: esriFieldTypeString, alias: REPORT_FILED_BY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_filing_office (type: esriFieldTypeString, alias: REPORT_FILING_OFFICE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_filing_status (type: esriFieldTypeString, alias: REPORT_FILING_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_url (type: esriFieldTypeString, alias: REPORT_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sum_itmz_monetary_contribution (type: esriFieldTypeDouble, alias: SUM_ITMZ_MONETARY_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sum_itmz_inkind_contribution (type: esriFieldTypeDouble, alias: SUM_ITMZ_INKIND_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_monetary_contribution (type: esriFieldTypeDouble, alias: TOTAL_MONETARY_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_in_kind_donations (type: esriFieldTypeDouble, alias: TOTAL_IN_KIND_DONATIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_contributions (type: esriFieldTypeDouble, alias: TOTAL_CONTRIBUTIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_expenditures (type: esriFieldTypeDouble, alias: TOTAL_EXPENDITURES, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CAMPFIN_BALANCES
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/24/2025 10:04:23 AM

Schema Last Edit Date: 7/24/2025 10:04:23 AM

Data Last Edit Date: 7/24/2025 10:04:23 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat