Name: CAMPFIN_EXPENDITURES

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)
• transaction_id (type: esriFieldTypeInteger, alias: TRANSACTION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• transaction_date (type: esriFieldTypeDate, alias: TRANSACTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• transaction_type (type: esriFieldTypeString, alias: TRANSACTION_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• transaction_amount (type: esriFieldTypeDouble, alias: TRANSACTION_AMOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• transaction_description (type: esriFieldTypeString, alias: TRANSACTION_DESCRIPTION, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• description_type (type: esriFieldTypeString, alias: DESCRIPTION_TYPE, SQL Type: sqlTypeOther, length: 255, 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)
• pa_pac_registry_name (type: esriFieldTypeString, alias: PA_PAC_REGISTRY_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pa_pac_registry_type (type: esriFieldTypeString, alias: PA_PAC_REGISTRY_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• likely_unaffiliated (type: esriFieldTypeString, alias: LIKELY_UNAFFILIATED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_name (type: esriFieldTypeString, alias: PAYEE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_type (type: esriFieldTypeString, alias: PAYEE_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_type_detail (type: esriFieldTypeString, alias: PAYEE_TYPE_DETAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_local_flag (type: esriFieldTypeInteger, alias: PAYEE_LOCAL_FLAG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payee_local_flag_desc (type: esriFieldTypeString, alias: PAYEE_LOCAL_FLAG_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_year (type: esriFieldTypeInteger, alias: REPORT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_election_date (type: esriFieldTypeDate, alias: REPORT_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_city (type: esriFieldTypeString, alias: FILER_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filer_state (type: esriFieldTypeString, alias: FILER_STATE, 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)
• multiple_offices_flag (type: esriFieldTypeString, alias: MULTIPLE_OFFICES_FLAG, 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)
• payee_id (type: esriFieldTypeInteger, alias: PAYEE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payee_name_std (type: esriFieldTypeString, alias: PAYEE_NAME_STD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_filer_id (type: esriFieldTypeInteger, alias: PAYEE_FILER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payee_city (type: esriFieldTypeString, alias: PAYEE_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_state (type: esriFieldTypeString, alias: PAYEE_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_zip (type: esriFieldTypeString, alias: PAYEE_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_zip4 (type: esriFieldTypeString, alias: PAYEE_ZIP4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_residency_flag (type: esriFieldTypeString, alias: PAYEE_RESIDENCY_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_naics (type: esriFieldTypeString, alias: PAYEE_NAICS, 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_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)
• 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: esriFieldTypeString, alias: REPORT_TYPE, SQL Type: sqlTypeOther, length: 255, 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)
• termination_report (type: esriFieldTypeString, alias: TERMINATION_REPORT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• est_trans_count (type: esriFieldTypeDouble, alias: EST_TRANS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• transaction_supertype (type: esriFieldTypeString, alias: TRANSACTION_SUPERTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• label_total (type: esriFieldTypeString, alias: LABEL_TOTAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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_url (type: esriFieldTypeString, alias: REPORT_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_source_address (type: esriFieldTypeString, alias: PAYEE_SOURCE_ADDRESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• payee_std_address (type: esriFieldTypeString, alias: PAYEE_STD_ADDRESS, 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)
• payee_type_review_status (type: esriFieldTypeString, alias: PAYEE_TYPE_REVIEW_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CAMPFIN_EXPENDITURES
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/9/2025 10:04:39 AM

Schema Last Edit Date: 4/9/2025 10:04:39 AM

Data Last Edit Date: 4/9/2025 10:04:39 AM

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