Name: CAMPFIN_TRANSACTIONS

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)
• ENTITY_NAME (type: esriFieldTypeString, alias: ENTITY_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_TYPE (type: esriFieldTypeString, alias: ENTITY_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_TYPE_DETAIL (type: esriFieldTypeString, alias: ENTITY_TYPE_DETAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_LOCAL_FLAG (type: esriFieldTypeInteger, alias: ENTITY_LOCAL_FLAG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTITY_LOCAL_FLAG_DESC (type: esriFieldTypeString, alias: ENTITY_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)
• ENTITY_ID (type: esriFieldTypeInteger, alias: ENTITY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTITY_FILER_ID (type: esriFieldTypeInteger, alias: ENTITY_FILER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTITY_NAME_STD (type: esriFieldTypeString, alias: ENTITY_NAME_STD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_CITY (type: esriFieldTypeString, alias: ENTITY_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_STATE (type: esriFieldTypeString, alias: ENTITY_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_ZIP (type: esriFieldTypeString, alias: ENTITY_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_ZIP4 (type: esriFieldTypeString, alias: ENTITY_ZIP4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_RESIDENCY_FLAG (type: esriFieldTypeString, alias: ENTITY_RESIDENCY_FLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_NAICS (type: esriFieldTypeString, alias: ENTITY_NAICS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_OCCUPATION (type: esriFieldTypeString, alias: ENTITY_OCCUPATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_NAME (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_ADDRESS_1 (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_ADDRESS_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_ADDRESS_2 (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_ADDRESS_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_CITY (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_STATE (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_ZIP (type: esriFieldTypeString, alias: ENTITY_EMPLOYER_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_EMPLOYER_ZIP4 (type: esriFieldTypeString, alias: ENTITY_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: esriFieldTypeSmallInteger, alias: TERMINATION_REPORT, SQL Type: sqlTypeOther, 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)
• ENTITY_SOURCE_ADDRESS (type: esriFieldTypeString, alias: ENTITY_SOURCE_ADDRESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENTITY_STD_ADDRESS (type: esriFieldTypeString, alias: ENTITY_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)
• ENTITY_TYPE_REVIEW_STATUS (type: esriFieldTypeString, alias: ENTITY_TYPE_REVIEW_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CAMPFIN_TRANSACTIONS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/24/2023 12:40:49 AM

Schema Last Edit Date: 1/24/2023 12:40:49 AM

Data Last Edit Date: 1/24/2023 12:40:49 AM

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