Name: AESI METER PROGRAM

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 137e8c31f9f94ad6a0de76812c70a964

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.4819138615699999E7
YMin: -3744928.7179999985
XMax: -82.02939999848604
YMax: 7572332.303300001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [194, 252, 181, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[26, 26, 26, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• f_address ( type: esriFieldTypeString, alias: Address, length: 500 )
• f_WO_number ( type: esriFieldTypeString, alias: Meter Exchange Work Order, length: 255 )
• f_relight_wo ( type: esriFieldTypeString, alias: Relight Work Order, length: 255 )
• f_radio_module_wo ( type: esriFieldTypeString, alias: Radio Module Activation Work Order, length: 255 )
• a_status ( type: esriFieldTypeString, alias: Status, length: 255 )
• f_street ( type: esriFieldTypeString, alias: Street, length: 255 )
• f_postal_code ( type: esriFieldTypeString, alias: Postal Code, length: 255 )
• f_unit ( type: esriFieldTypeString, alias: Unit, length: 255 )
• f_house_number ( type: esriFieldTypeString, alias: House Number, length: 255 )
• f_area_code ( type: esriFieldTypeString, alias: Area Code, length: 255 , Coded Values: [C: Delta, Surrey and White Rock (Delta and Tsawassen only)] , [D: Burnaby, New Westminster, Port Moody, Coquitlam, Port Coquitlam, Anmore & Belcarra] , [E: Richmond & Vancouver] , ...1 more... )
• o_city ( type: esriFieldTypeString, alias: City, length: 255 )
• o_work_order_desc ( type: esriFieldTypeString, alias: o_work_desc, length: 255 )
• f_WO_type ( type: esriFieldTypeString, alias: f_WO_type, length: 255 )
• f_transmit_date ( type: esriFieldTypeDate, alias: Transmit Date, length: 8 )
• f_completed_date ( type: esriFieldTypeDate, alias: Fortis Completion Date, length: 8 )
• c_rtu_meter ( type: esriFieldTypeString, alias: Uninstallable/ RTU Reason Code for Customer Meter, length: 255 , Coded Values: [a: No Access] , [b: Customer Refusal] , [c: Blackout Period] , ...3 more... )
• c_rtu_meter_comment ( type: esriFieldTypeString, alias: Uninstallable/ RTU Reason Code for Customer Meter Comment, length: 1000 )
• o_rtu_meter_status ( type: esriFieldTypeString, alias: Uninstallable/ RTU Reason Code for Customer Meter Status, length: 255 , Coded Values: [Pending: Pending FortisBC Approval] , [Accepted: Accepted - No Action Required] , [Rejected: Rejected - Action Required] , ...1 more... )
• c_customer_refusal ( type: esriFieldTypeString, alias: Name of Customer Refusing Exchange, length: 255 )
• c_meter_tampering ( type: esriFieldTypeString, alias: Instances of Meter Tampering/Interference or Gas Diversion Identified, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• o_meter_appointment_date ( type: esriFieldTypeDate, alias: Meter Exchange Appointment Date, length: 8 )
• o_relight_appointment_date ( type: esriFieldTypeDate, alias: Relight Appointment Date, length: 8 )
• c_size ( type: esriFieldTypeSmallInteger, alias: Size , Coded Values: [200: 200] , [400: 400] )
• c_radio_module ( type: esriFieldTypeString, alias: Active Radio Module Upon Arrival, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_bypass ( type: esriFieldTypeString, alias: Bypass Valve Present Upon Arrival, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_start_exchange ( type: esriFieldTypeDate, alias: Meter Exchange Start Time, length: 8 )
• c_end_exchange ( type: esriFieldTypeDate, alias: Meter Exchange End Time, length: 8 )
• a_duration_exchange ( type: esriFieldTypeInteger, alias: Meter Exchange Duration )
• a_meter_completed_by ( type: esriFieldTypeString, alias: Meter Exchange Completed By, length: 255 , Coded Values: [Manjot Singh: Manjot Singh] , [Bradley McCann: Bradley McCann] , [Jason Ouimet: Jason Ouimet] , ...150 more... )
• a_meter_company ( type: esriFieldTypeString, alias: Meter Exchange Company Completed By, length: 255 )
• c_relight_failure ( type: esriFieldTypeString, alias: Relight Service Failure, length: 255 , Coded Values: [Customer Refused: Customer Refused] , [Relight Crew Required: Relight Crew Required] , [Yes: Relight Failed] , ...2 more... )
• c_start_relight ( type: esriFieldTypeDate, alias: Relight Start Time, length: 8 )
• c_end_relight ( type: esriFieldTypeDate, alias: Relight End Time, length: 8 )
• a_duration_relight ( type: esriFieldTypeInteger, alias: Relight Duration )
• a_relight_completed_by ( type: esriFieldTypeString, alias: Relight Completed By, length: 255 , Coded Values: [Manjot Singh: Manjot Singh] , [Bradley McCann: Bradley McCann] , [Jason Ouimet: Jason Ouimet] , ...150 more... )
• c_relight_sl ( type: esriFieldTypeString, alias: Relight Service Level, length: 255 , Coded Values: [Overnight: 10:00 PM to 8:00 AM] , [Regular: 8:00 AM to 5:00 PM] , [Evening: 5:00 PM to 10:00 PM] , ...1 more... )
• a_late_relight ( type: esriFieldTypeString, alias: Late Relight, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• a_relight_company ( type: esriFieldTypeString, alias: Relight Company Completed By, length: 255 )
• c_start_com ( type: esriFieldTypeDate, alias: Commission Start Time, length: 8 )
• c_end_com ( type: esriFieldTypeDate, alias: Commission End Time, length: 8 )
• c_duration_com ( type: esriFieldTypeInteger, alias: Commission Duration )
• a_com_completed_by ( type: esriFieldTypeString, alias: Commission Completed By, length: 255 , Coded Values: [Manjot Singh: Manjot Singh] , [Bradley McCann: Bradley McCann] , [Jason Ouimet: Jason Ouimet] , ...150 more... )
• a_com_company ( type: esriFieldTypeString, alias: Commission Company Completed By, length: 255 )
• c_com_comment ( type: esriFieldTypeString, alias: Commission Commentary, length: 1000 )
• c_exchange_comment ( type: esriFieldTypeString, alias: Meter Exchange Commentary, length: 1000 )
• c_billing_1 ( type: esriFieldTypeString, alias: Billing 1, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_billing_1a ( type: esriFieldTypeString, alias: Meter Swivel Dimension Adjustment, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_billing_2 ( type: esriFieldTypeString, alias: Billing 2, length: 255 )
• c_billing_2a ( type: esriFieldTypeString, alias: Regulator and Bypass Valve Installation, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_billing_2b ( type: esriFieldTypeString, alias: Bypass Valve Only Installation, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_billing_2c ( type: esriFieldTypeString, alias: Meter Swivel Dimension Adjustment with Bypass Valve Installation, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_billing_3 ( type: esriFieldTypeString, alias: Radio Module Activation, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_fireplace ( type: esriFieldTypeSmallInteger, alias: Fireplace Replacement )
• a_delay ( type: esriFieldTypeString, alias: Delay, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• a_delay_reason ( type: esriFieldTypeString, alias: Delay Reason, length: 1000 )
• a_late_exchange ( type: esriFieldTypeString, alias: Late Meter Exchange, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• o_meter_reschedule_date ( type: esriFieldTypeDate, alias: o_meter_reschedule_date, length: 8 )
• c_rtu_bypass ( type: esriFieldTypeString, alias: Uninstallable/ RTU Reason Code for Bypass Valve, length: 255 , Coded Values: [a: No Access] , [c: Blackout Period] , [di: Unsafe Site Condition] , ...2 more... )
• o_relight_reschedule_date ( type: esriFieldTypeDate, alias: o_relight_reschedule_date, length: 8 )
• c_clo ( type: esriFieldTypeString, alias: CLO Blackout Period, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_rtu_meter_date ( type: esriFieldTypeDate, alias: Uninstallable/ RTU Reason Code for Customer Meter Date, length: 8 )
• f_vertical_sub ( type: esriFieldTypeString, alias: f_vertical_sub, length: 255 )
• f_indigenous ( type: esriFieldTypeString, alias: f_indigenous, length: 255 )
• f_ip_service ( type: esriFieldTypeString, alias: f_ip_service, length: 255 )
• f_industrial ( type: esriFieldTypeString, alias: f_industrial, length: 255 )
• f_ops_dtes ( type: esriFieldTypeString, alias: f_ops_dtes, length: 255 )
• f_ops_yvr ( type: esriFieldTypeString, alias: f_ops_yvr, length: 255 )
• f_ops_reserved ( type: esriFieldTypeString, alias: f_ops_reserved, length: 255 )
• f_equipment ( type: esriFieldTypeString, alias: f_equipment, length: 255 )
• f_material ( type: esriFieldTypeString, alias: f_material, length: 255 )
• f_material_desc ( type: esriFieldTypeString, alias: f_material_desc, length: 255 )
• f_serial_num ( type: esriFieldTypeString, alias: f_serial_num, length: 255 )
• f_pis ( type: esriFieldTypeString, alias: f_pis, length: 255 )
• f_dispatch_area ( type: esriFieldTypeString, alias: f_dispatch_area, length: 255 )
• f_mr_unit ( type: esriFieldTypeString, alias: f_mr_unit, length: 255 )
• f_portion ( type: esriFieldTypeString, alias: f_portion, length: 255 )
• f_device_location ( type: esriFieldTypeString, alias: f_device_location, length: 255 )
• f_next_replace ( type: esriFieldTypeString, alias: f_next_replace, length: 255 )
• f_riser_inlet_valve ( type: esriFieldTypeString, alias: f_riser_inlet_valve, length: 255 )
• f_meter_outlet_valve ( type: esriFieldTypeString, alias: f_meter_outlet_valve, length: 255 )
• f_main_reg_model ( type: esriFieldTypeString, alias: f_main_reg_model, length: 255 )
• f_regulator_installation_year ( type: esriFieldTypeString, alias: f_regulator_installation_year, length: 255 )
• f_delivery_pressure ( type: esriFieldTypeString, alias: f_delivery_pressure, length: 255 )
• f_billing_class ( type: esriFieldTypeString, alias: f_billing_class, length: 255 )
• f_order_group ( type: esriFieldTypeString, alias: f_order_group, length: 255 )
• o_meter_assigned_to ( type: esriFieldTypeString, alias: Meter Exchange Assigned To, length: 255 )
• o_relight_assigned_to ( type: esriFieldTypeString, alias: Relight Assigned To, length: 255 )
• c_relight_failure_comment ( type: esriFieldTypeString, alias: Relight Service and Tag Commentary, length: 1000 )
• c_unsafe_type ( type: esriFieldTypeString, alias: Unsafe Site Condition Type, length: 255 , Coded Values: [Damage: Damage] , [Leaking: Leaking] , [Other: Other] )
• c_rtu_bypass_comment ( type: esriFieldTypeString, alias: Uninstallable/ RTU Reason Code for Bypass Valve Comment, length: 1000 )
• c_thermocouple_other ( type: esriFieldTypeSmallInteger, alias: Other Thermocouples )
• f_size ( type: esriFieldTypeSmallInteger, alias: f_size , Coded Values: [200: 200] , [400: 400] )
• a_different_fsr ( type: esriFieldTypeString, alias: Different FSR, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• c_furnace ( type: esriFieldTypeSmallInteger, alias: Furnace Replacement , Coded Values: [1: Yes] , [0: No] )
• c_hot_water_tank ( type: esriFieldTypeSmallInteger, alias: Hot Water Tank Replacement , Coded Values: [1: Yes] , [0: No] )
• c_mazco_barcode ( type: esriFieldTypeString, alias: Mazco Tool Barcode, length: 255 )
• c_crystal_gauge_barcode ( type: esriFieldTypeString, alias: Crystal Gauge Barcode, length: 255 )
• c_mazco_bypass_barcode ( type: esriFieldTypeString, alias: Mazco Bypass Tool Barcode, length: 255 )
• c_meter_installed_type ( type: esriFieldTypeString, alias: Customer Meter Installed Type, length: 255 , Coded Values: [20LT: 20LT] , [30LT: 30LT] )
• f_meter_installed_barcode ( type: esriFieldTypeString, alias: f_meter_installed_barcode, length: 255 )
• f_meter_disposed_barcode ( type: esriFieldTypeString, alias: f_meter_disposed_barcode, length: 255 )
• f_regulator_model ( type: esriFieldTypeString, alias: f_regulator_model, length: 255 )
• f_regulator_tag ( type: esriFieldTypeString, alias: f_regulator_tag, length: 255 )
• f_inlet_bypass_model ( type: esriFieldTypeString, alias: f_inlet_bypass_model, length: 255 )
• f_inlet_bypass_id ( type: esriFieldTypeString, alias: f_inlet_bypass_id, length: 255 )
• f_outlet_bypass_model ( type: esriFieldTypeString, alias: f_outlet_bypass_model, length: 255 )
• f_outlet_bypass_id ( type: esriFieldTypeString, alias: f_outlet_bypass_id, length: 255 )
• f_sealant_model ( type: esriFieldTypeString, alias: f_sealant_model, length: 255 )
• f_sealant_id ( type: esriFieldTypeString, alias: f_sealant_id, length: 255 )
• f_bypass ( type: esriFieldTypeString, alias: f_bypass, length: 255 )
• f_visit_type ( type: esriFieldTypeString, alias: o_visit_type, length: 255 , Coded Values: [FALSE: Drop-In] , [TRUE: Appointment] )
• f_fortis_status ( type: esriFieldTypeString, alias: f_fortis_status, length: 255 )
• f_fortis_completion ( type: esriFieldTypeDate, alias: f_fortis_completion, length: 8 )
• a_total_therms ( type: esriFieldTypeSmallInteger, alias: a_total_therms )
• f_latitude ( type: esriFieldTypeDouble, alias: f_latitude )
• f_longitude ( type: esriFieldTypeDouble, alias: f_longitude )
• c_issue_resolved ( type: esriFieldTypeString, alias: Issue Resolved, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [No Issue: No Issue] )
• a_exchange_exported_by ( type: esriFieldTypeString, alias: Exchange Exported By, length: 255 )
• a_exchange_exported_date ( type: esriFieldTypeDate, alias: Exchange Exported Date, length: 8 )
• a_relight_exported_by ( type: esriFieldTypeString, alias: Relight Exported By, length: 255 )
• a_relight_exported_date ( type: esriFieldTypeDate, alias: Relight Exported Date, length: 8 )
• c_rtu_photo ( type: esriFieldTypeBlob, alias: c_rtu_photo )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• f_reg_change ( type: esriFieldTypeString, alias: Regulator Changed, length: 255 )
• f_reg_reason ( type: esriFieldTypeString, alias: Regulator Reason For Not Changing, length: 1000 )
• f_inlet_old ( type: esriFieldTypeString, alias: OLD Inlet Valve, length: 255 )
• f_inlet_bypass_qty ( type: esriFieldTypeSmallInteger, alias: Inlet Bypass Valve QTY )
• f_outlet_bypass_qty ( type: esriFieldTypeSmallInteger, alias: Outlet Bypass Valve QTY )
• f_swing_joint ( type: esriFieldTypeString, alias: Swing Joint Upgrade, length: 255 )
• f_vehicle_id ( type: esriFieldTypeString, alias: Vehicle Id, length: 255 )
• f_switched_meter ( type: esriFieldTypeString, alias: Switched Meter, length: 255 )
• f_switched_meter_notes ( type: esriFieldTypeString, alias: Switched Meter Notes, length: 1000 )
• f_outlet_old ( type: esriFieldTypeString, alias: Old Outlet Bypass Valve, length: 255 )
• f_transmit_rel_date ( type: esriFieldTypeDate, alias: Relight Creation Date, length: 8 )
• f_completion_rel_date ( type: esriFieldTypeDate, alias: Relight Completion Date, length: 8 )
• f_fortis_worker_ex ( type: esriFieldTypeString, alias: Fortis Exchange Worker, length: 255 )
• f_fortis_worker_rel ( type: esriFieldTypeString, alias: Fortis Relight Worker, length: 255 )
• f_wo_type_rel ( type: esriFieldTypeString, alias: Relight Work Order Type, length: 255 )
• f_onsight_ex_date ( type: esriFieldTypeDate, alias: Fortis Onsight Exchange Date, length: 8 )
• f_onsight_rel_date ( type: esriFieldTypeDate, alias: Fortis Onsight Relight Date, length: 8 )
• f_visit_rel_type ( type: esriFieldTypeString, alias: Fortis Relight Visit Type/Appointment, length: 255 )

Relationships:

• DBO.AMI_FORCE_ACCOUNT_RATES (1) -- Related To: FORCE ACCOUNT RATES (19)
• DBO.post_install (2) -- Related To: Post Install Audit Checklist (24)
• DBO.AMI_STANDBY (3) -- Related To: STANDBY (20)
• DBO.q_work_observation (0) -- Related To: Work Observation Checklist (25)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata