Layers:

Tables:

CAMPFIN_CONTRIBUTIONS (1)


Name: CAMPFIN_CONTRIBUTIONS

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: esriFieldTypeInteger, 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)
• donor_name (type: esriFieldTypeString, alias: DONOR_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_type (type: esriFieldTypeString, alias: DONOR_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_type_detail (type: esriFieldTypeString, alias: DONOR_TYPE_DETAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_local_flag (type: esriFieldTypeInteger, alias: DONOR_LOCAL_FLAG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• donor_local_flag_desc (type: esriFieldTypeString, alias: DONOR_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)
• donor_id (type: esriFieldTypeInteger, alias: DONOR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• donor_name_std (type: esriFieldTypeString, alias: DONOR_NAME_STD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_filer_id (type: esriFieldTypeInteger, alias: DONOR_FILER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• donor_city (type: esriFieldTypeString, alias: DONOR_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_state (type: esriFieldTypeString, alias: DONOR_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_zip (type: esriFieldTypeString, alias: DONOR_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_zip4 (type: esriFieldTypeString, alias: DONOR_ZIP4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_residency_flag (type: esriFieldTypeString, alias: DONOR_RESIDENCY_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_naics (type: esriFieldTypeString, alias: DONOR_NAICS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_occupation (type: esriFieldTypeString, alias: DONOR_OCCUPATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_name (type: esriFieldTypeString, alias: DONOR_EMPLOYER_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_address_1 (type: esriFieldTypeString, alias: DONOR_EMPLOYER_ADDRESS_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_address_2 (type: esriFieldTypeString, alias: DONOR_EMPLOYER_ADDRESS_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_city (type: esriFieldTypeString, alias: DONOR_EMPLOYER_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_state (type: esriFieldTypeString, alias: DONOR_EMPLOYER_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_zip (type: esriFieldTypeString, alias: DONOR_EMPLOYER_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_employer_zip4 (type: esriFieldTypeString, alias: DONOR_EMPLOYER_ZIP4, 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: esriFieldTypeInteger, 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)
• donor_source_address (type: esriFieldTypeString, alias: DONOR_SOURCE_ADDRESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donor_std_address (type: esriFieldTypeString, alias: DONOR_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)
• donor_type_review_status (type: esriFieldTypeString, alias: DONOR_TYPE_REVIEW_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CAMPFIN_CONTRIBUTIONS
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:38:02 AM

Schema Last Edit Date: 4/9/2025 10:38:02 AM

Data Last Edit Date: 4/9/2025 10:38:02 AM