Name: CAMPFIN_SUMMARY

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)
• filer_id (type: esriFieldTypeInteger, alias: FILER_ID, SQL Type: sqlTypeOther, 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)
• report_year (type: esriFieldTypeDouble, alias: REPORT_YEAR, 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)
• filer_type_review_status (type: esriFieldTypeString, alias: FILER_TYPE_REVIEW_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• first_report_id (type: esriFieldTypeInteger, alias: FIRST_REPORT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• first_report_date (type: esriFieldTypeDate, alias: FIRST_REPORT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• beginning_cash_balance (type: esriFieldTypeDouble, alias: BEGINNING_CASH_BALANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• last_report_id (type: esriFieldTypeInteger, alias: LAST_REPORT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• last_report_date (type: esriFieldTypeDate, alias: LAST_REPORT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ending_cash_balance (type: esriFieldTypeDouble, alias: ENDING_CASH_BALANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ending_unpaid_debts (type: esriFieldTypeDouble, alias: ENDING_UNPAID_DEBTS, SQL Type: sqlTypeOther, 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)
• sum_utmz_monetary_contribution (type: esriFieldTypeDouble, alias: SUM_UTMZ_MONETARY_CONTRIBUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sum_utmz_inkind_contribution (type: esriFieldTypeDouble, alias: SUM_UTMZ_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)
• num_contributions (type: esriFieldTypeInteger, alias: NUM_CONTRIBUTIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_expenditures (type: esriFieldTypeInteger, alias: NUM_EXPENDITURES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_digital_filings (type: esriFieldTypeInteger, alias: NUM_DIGITAL_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_paper_filings (type: esriFieldTypeInteger, alias: NUM_PAPER_FILINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_terminated_year (type: esriFieldTypeString, alias: IS_TERMINATED_YEAR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CAMPFIN_SUMMARY
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/30/2025 10:25:53 AM

Schema Last Edit Date: 7/30/2025 10:25:53 AM

Data Last Edit Date: 7/30/2025 10:25:53 AM

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