Name: BeaconMeterUsageData

Display Field: Account_First_Name

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 3000

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)
• Account_Billing_Cycle (type: esriFieldTypeString, alias: Account_Billing_Cycle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Email (type: esriFieldTypeString, alias: Account_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_First_Name (type: esriFieldTypeString, alias: Account_First_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Full_Name (type: esriFieldTypeString, alias: Account_Full_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_ID (type: esriFieldTypeString, alias: Account_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Last_Name (type: esriFieldTypeString, alias: Account_Last_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Phone (type: esriFieldTypeString, alias: Account_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Portal_Status (type: esriFieldTypeString, alias: Account_Portal_Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account_Status (type: esriFieldTypeString, alias: Account_Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Alert_Code (type: esriFieldTypeInteger, alias: Alert_Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Backflow_Gallons (type: esriFieldTypeString, alias: Backflow_Gallons, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Battery_Level (type: esriFieldTypeString, alias: Battery_Level, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_Address_Line1 (type: esriFieldTypeString, alias: Billing_Address_Line1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_Address_Line2 (type: esriFieldTypeString, alias: Billing_Address_Line2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_Address_Line3 (type: esriFieldTypeString, alias: Billing_Address_Line3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_City (type: esriFieldTypeString, alias: Billing_City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_Country (type: esriFieldTypeString, alias: Billing_Country, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_State (type: esriFieldTypeString, alias: Billing_State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Billing_ZIP (type: esriFieldTypeString, alias: Billing_ZIP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Connector_Type (type: esriFieldTypeString, alias: Connector_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Leak_Rate (type: esriFieldTypeString, alias: Current_Leak_Rate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Leak_Start_Date (type: esriFieldTypeString, alias: Current_Leak_Start_Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Demand_Zone_ID (type: esriFieldTypeString, alias: Demand_Zone_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Dials (type: esriFieldTypeInteger, alias: Dials, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Endpoint_Install_Date (type: esriFieldTypeDate, alias: Endpoint_Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Endpoint_SN (type: esriFieldTypeInteger, alias: Endpoint_SN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Endpoint_Status (type: esriFieldTypeString, alias: Endpoint_Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Endpoint_Type (type: esriFieldTypeString, alias: Endpoint_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Estimated_Flag (type: esriFieldTypeInteger, alias: Estimated_Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow (type: esriFieldTypeDouble, alias: Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow_Time (type: esriFieldTypeDate, alias: Flow_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Flow_Unit (type: esriFieldTypeString, alias: Flow_Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• High_Read_Limit (type: esriFieldTypeString, alias: High_Read_Limit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Last_Comm_Time (type: esriFieldTypeDate, alias: Last_Comm_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Location_Address_Line1 (type: esriFieldTypeString, alias: Location_Address_Line1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line2 (type: esriFieldTypeString, alias: Location_Address_Line2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line3 (type: esriFieldTypeString, alias: Location_Address_Line3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Parity (type: esriFieldTypeString, alias: Location_Address_Parity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Area (type: esriFieldTypeString, alias: Location_Area, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Bathrooms (type: esriFieldTypeString, alias: Location_Bathrooms, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Building_Number (type: esriFieldTypeString, alias: Location_Building_Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Building_Type (type: esriFieldTypeString, alias: Location_Building_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_City (type: esriFieldTypeString, alias: Location_City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Continuous_Flow (type: esriFieldTypeString, alias: Location_Continuous_Flow, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Country (type: esriFieldTypeString, alias: Location_Country, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_County_Name (type: esriFieldTypeString, alias: Location_County_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_DHS_Code (type: esriFieldTypeString, alias: Location_DHS_Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_District (type: esriFieldTypeString, alias: Location_District, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Funding (type: esriFieldTypeString, alias: Location_Funding, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_ID (type: esriFieldTypeString, alias: Location_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Irrigated_Area (type: esriFieldTypeString, alias: Location_Irrigated_Area, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Irrigation (type: esriFieldTypeString, alias: Location_Irrigation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Latitude (type: esriFieldTypeDouble, alias: Location_Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Location_Longitude (type: esriFieldTypeDouble, alias: Location_Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Location_Main_Use (type: esriFieldTypeString, alias: Location_Main_Use, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Name (type: esriFieldTypeString, alias: Location_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Pool (type: esriFieldTypeString, alias: Location_Pool, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Population (type: esriFieldTypeString, alias: Location_Population, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Site (type: esriFieldTypeString, alias: Location_Site, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_State (type: esriFieldTypeString, alias: Location_State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Water_Type (type: esriFieldTypeString, alias: Location_Water_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Year_Built (type: esriFieldTypeString, alias: Location_Year_Built, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_ZIP (type: esriFieldTypeInteger, alias: Location_ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Low_Read_Limit (type: esriFieldTypeString, alias: Low_Read_Limit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_Continuous_Flow (type: esriFieldTypeString, alias: Meter_Continuous_Flow, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_ID (type: esriFieldTypeInteger, alias: Meter_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Meter_Install_Date (type: esriFieldTypeDate, alias: Meter_Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Meter_Manufacturer (type: esriFieldTypeString, alias: Meter_Manufacturer, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_Model (type: esriFieldTypeString, alias: Meter_Model, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_Note (type: esriFieldTypeString, alias: Meter_Note, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_Size (type: esriFieldTypeDouble, alias: Meter_Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Meter_Size_Desc (type: esriFieldTypeString, alias: Meter_Size_Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_Size_Unit (type: esriFieldTypeString, alias: Meter_Size_Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Meter_SN (type: esriFieldTypeString, alias: Meter_SN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Person_ID (type: esriFieldTypeString, alias: Person_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Portal_ID (type: esriFieldTypeString, alias: Portal_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Raw_Read (type: esriFieldTypeInteger, alias: Raw_Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Read_ (type: esriFieldTypeDouble, alias: Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Read_Code_1 (type: esriFieldTypeString, alias: Read_Code_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Read_Code_2 (type: esriFieldTypeString, alias: Read_Code_2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Read_Code_3 (type: esriFieldTypeString, alias: Read_Code_3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Read_Method (type: esriFieldTypeString, alias: Read_Method, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Read_Note (type: esriFieldTypeString, alias: Read_Note, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Read_Sequence (type: esriFieldTypeInteger, alias: Read_Sequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Read_Time (type: esriFieldTypeDate, alias: Read_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Read_Unit (type: esriFieldTypeString, alias: Read_Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Reader_Initials (type: esriFieldTypeString, alias: Reader_Initials, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Register_Note (type: esriFieldTypeString, alias: Register_Note, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Register_Number (type: esriFieldTypeString, alias: Register_Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Register_Resolution (type: esriFieldTypeDouble, alias: Register_Resolution, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Register_Unit_Of_Measure (type: esriFieldTypeString, alias: Register_Unit_Of_Measure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SA_Start_Date (type: esriFieldTypeDate, alias: SA_Start_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Service_Point_Class_Code (type: esriFieldTypeString, alias: Service_Point_Class_Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Service_Point_Class_Code_Normal (type: esriFieldTypeString, alias: Service_Point_Class_Code_Normalized, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Service_Point_Cycle (type: esriFieldTypeString, alias: Service_Point_Cycle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Service_Point_ID (type: esriFieldTypeInteger, alias: Service_Point_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Service_Point_Latitude (type: esriFieldTypeDouble, alias: Service_Point_Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Service_Point_Longitude (type: esriFieldTypeDouble, alias: Service_Point_Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Service_Point_Route (type: esriFieldTypeString, alias: Service_Point_Route, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Service_Point_Timezone (type: esriFieldTypeString, alias: Service_Point_Timezone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Service_Point_Type (type: esriFieldTypeString, alias: Service_Point_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Signal_Strength (type: esriFieldTypeString, alias: Signal_Strength, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Supply_Zone_ID (type: esriFieldTypeString, alias: Supply_Zone_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Trouble_Code (type: esriFieldTypeString, alias: Trouble_Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Utility_Use_1 (type: esriFieldTypeString, alias: Utility_Use_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Utility_Use_2 (type: esriFieldTypeString, alias: Utility_Use_2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Flow_Gallon (type: esriFieldTypeDouble, alias: Flow_Gallon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Read_Gallon (type: esriFieldTypeDouble, alias: Read_Gallon, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: BeaconMeterUsageData
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Usage (0) -- Related To: AnalysisFeature2 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/3/2022 7:15:17 AM

Schema Last Edit Date: 11/3/2022 7:15:17 AM

Data Last Edit Date: 11/3/2022 7:15:17 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat