Name: SCUDGIS.DBO.LeakMonitor

Display Field: MonitorDate

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LeakType ( type: esriFieldTypeString, alias: Leak Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeakType , Coded Values: [Above: Above Ground] , [Below: Below Ground] , [Broke: Broke Line] )
• ReportSource ( type: esriFieldTypeString, alias: Report Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReportSource , Coded Values: [Leak Survey: Leak Survey] , [Mobile FI: Mobile FI] , [Public: Public] , ...4 more... )
• LeakID ( type: esriFieldTypeString, alias: Leak ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeakID )
• StreetAddress ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetAddress )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City , Coded Values: [01: Sevierville] , [02: Pigeon Forge] , [03: Gatlinburg] , ...2 more... )
• GasFound ( type: esriFieldTypeString, alias: Gas Found?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GasFound , Coded Values: [Y: Yes] , [N: No] )
• ArrivedDate ( type: esriFieldTypeDate, alias: Arrived Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ArrivedDate )
• Technician ( type: esriFieldTypeString, alias: Technician, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Technician )
• InvestigationFoundLeak ( type: esriFieldTypeString, alias: Investigation Found Leak, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InvestigationFoundLeak , Coded Values: [YES: YES] , [NO: NO] )
• IfLeakFoundGrade ( type: esriFieldTypeString, alias: Grade, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfLeakFoundGrade , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location , Coded Values: [In Building: In Building] , [Near Building: Near Building] , [In Manhole: In Manhole] , ...3 more... )
• GasOdorDetected ( type: esriFieldTypeString, alias: Gas Odor Detected, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GasOdorDetected , Coded Values: [YES: YES] , [NO: NO] )
• Soap ( type: esriFieldTypeString, alias: Soap Test Performed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Soap , Coded Values: [YES: YES] , [NO: NO] )
• GasPercent ( type: esriFieldTypeDouble, alias: Gas Percent, editable: true, nullable: true, defaultValue: null, modelName: GasPercent )
• LELPercent ( type: esriFieldTypeDouble, alias: LEL Percent, editable: true, nullable: true, defaultValue: null, modelName: LELPercent )
• PPMPercent ( type: esriFieldTypeDouble, alias: PPM Percent, editable: true, nullable: true, defaultValue: null, modelName: PPMPercent )
• PressureSystem ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PressureSystem , Coded Values: [LOW: LOW: 0-59] , [MED: MEDIUM: 60-100] , [HIGH: HIGH: ABOVE 101] , ...1 more... )
• AreaLocation ( type: esriFieldTypeString, alias: Area Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AreaLocation , Coded Values: [School: School] , [Hospital: Hospital] , [Commercial: Commercial] , ...1 more... )
• ProbableSource ( type: esriFieldTypeString, alias: Probable Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProbableSource , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...5 more... )
• IfMeterLocationonMeter ( type: esriFieldTypeString, alias: Location on Meter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfMeterLocationonMeter , Coded Values: [Above: Above Grade] , [Below: Below Grade] , [Grease Plug: Grease Plug On Meter Stop] , ...19 more... )
• IfMeterBodyManufacturer ( type: esriFieldTypeString, alias: Meter Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfMeterBodyManufacturer )
• IfMeterSize ( type: esriFieldTypeString, alias: Meter Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfMeterSize )
• IfMainorServiceMaterial ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfMainorServiceMaterial , Coded Values: [PLASTIC: PLASTIC] , [BARE STEEL: BARE STEEL] , [COATED STEEL: COATED STEEL] , ...4 more... )
• IfMainorServiceSize ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfMainorServiceSize , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...12 more... )
• ProbableCause ( type: esriFieldTypeString, alias: Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProbableCause , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• IfExcavationDamageLocateCalled ( type: esriFieldTypeString, alias: Located Called In, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageLocateCalled , Coded Values: [YES: YES] , [NO: NO] )
• IfExcavationDamageLocateNumber ( type: esriFieldTypeString, alias: Locate Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageLocateNumber )
• IfExcavationDamageExcavatorName ( type: esriFieldTypeString, alias: Exavator Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageExavatorName )
• IfExcavationDamageExcavatorAddr ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageExcavatorAddr )
• IfExcavationDamageExcavatorCity ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageExcavatorCity )
• IfExcavationDamageExcavatorNumb ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IfExcavationDamageExcavatorNumber )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Remarks )
• MadeSafeDate ( type: esriFieldTypeDate, alias: Made Safe Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MadeSafeDate )
• LeakGUID ( type: esriFieldTypeGUID, alias: LeakGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LeakGUID )
• LeakMaintenanceType ( type: esriFieldTypeString, alias: Leak Maintenance Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeakMaintenanceType , Coded Values: [Monitor: Monitor] , [Repair: Repair] )
• FoundGrade ( type: esriFieldTypeString, alias: Grade as Found, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FoundGrade , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• FoundSource ( type: esriFieldTypeString, alias: Source as Determined During Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FoundSource , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...5 more... )
• FoundCause ( type: esriFieldTypeString, alias: Leak Cause as Determined During Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FoundCause , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• ExcavationType ( type: esriFieldTypeString, alias: Cause of Excavation Damage, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ExcavationType , Coded Values: [No Locates Requested: No Locates Requested] , [Mis-Marked Facilities: Mis-Marked Facilities] , [Facilities Not Marked: Facilities Not Marked] , ...3 more... )
• EquipmentFailureType ( type: esriFieldTypeString, alias: Equipment Failure Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EquipmentFailureType , Coded Values: [Valve: Valve] , [Service: Service] , [Meter Regulator: Meter Regulator] , ...4 more... )
• EquipementFailureCouplingType ( type: esriFieldTypeString, alias: Mechanical Coupling Failure Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EquipementFailureCouplingType )
• MWJType ( type: esriFieldTypeString, alias: Material, Weld, or Joint Failure Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MWJType , Coded Values: [Welds: Welds] , [Split Seams: Split Seams] , [Incomplete Fusion: Incomplete Fusion] , ...2 more... )
• MWJPipeComponent ( type: esriFieldTypeString, alias: What pipe component?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MWJPipeComponent )
• PipeCondition ( type: esriFieldTypeString, alias: Pipe Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeCondition , Coded Values: [Good: Good] , [Light Pitting: Light Pitting] , [Heavy Pitting: Heavy Pitting] )
• CoatingCondition ( type: esriFieldTypeString, alias: Coating Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CoatingCondition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• CoatingType ( type: esriFieldTypeString, alias: Coating Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CoatingType , Coded Values: [Xtrub: Xtrub] , [Coal Tar: Coal Tar] , [Epoxy: Epoxy] )
• CoatingRequiredRepair ( type: esriFieldTypeString, alias: Did the coating require repair?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CoatingRequiredRepair , Coded Values: [YES: YES] , [NO: NO] )
• DescribeCoatingRepair ( type: esriFieldTypeString, alias: Describe Coating Repair, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DescribeCoatingRepair )
• Repaired ( type: esriFieldTypeString, alias: Was the leak repair completed?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Repaired , Coded Values: [YES: YES] , [NO: NO] )
• DescribeLeakRepair ( type: esriFieldTypeString, alias: Describe Leak Repair, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DescribeLeakRepair )
• RepairedBy ( type: esriFieldTypeString, alias: Repaired By, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RepairedBy )
• RepairedDate ( type: esriFieldTypeDate, alias: Repaired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairedDate )
• MonitorGrade ( type: esriFieldTypeString, alias: Monitor Grade, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MonitorGrade , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• MonitorDescription ( type: esriFieldTypeString, alias: Monitor Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MonitorDescription )
• MonitorDate ( type: esriFieldTypeDate, alias: Monitor Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MonitorDate )
• MonitorBy ( type: esriFieldTypeString, alias: Monitored Performed By, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MonitorBy )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ReportedDate ( type: esriFieldTypeDate, alias: Reported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReportedDate )
• SqlAddDate ( type: esriFieldTypeDate, alias: AddDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AddDate )
• SqlStartDate ( type: esriFieldTypeDate, alias: StartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• SqlEndDate ( type: esriFieldTypeDate, alias: EndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EndDate )
• SqlStatus ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• SqlSystemLeakIsOn2 ( type: esriFieldTypeString, alias: SystemLeakIsOn2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SystemLeakIsOn2 )
• SqlDOTCauseOfLeak2 ( type: esriFieldTypeString, alias: DOTCauseOfLeak2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DOTCauseOfLeak2 )
• SqlRepairType2 ( type: esriFieldTypeString, alias: RepairType2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairType2 )
• RelatedGuid ( type: esriFieldTypeGUID, alias: RelatedGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelatedGuid )
• LeakStatus ( type: esriFieldTypeString, alias: LeakStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeakStatus , Coded Values: [Active: Active] , [Cleared: Cleared] , [Repaired: Repaired] , ...1 more... )
• MonitorGasPercent ( type: esriFieldTypeDouble, alias: MonitorGasPercent, editable: true, nullable: true, defaultValue: null, modelName: MonitorGasPercent )
• GasDetectionEquipment ( type: esriFieldTypeString, alias: Gas Detection Equipment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GasDetectionEquipment , Coded Values: [CGI: CGI] , [Flame Pack: Flame Pack] , [HLMD: Hawk Laser Methane Detector] , ...8 more... )
• OtherGasDetectionEquipment ( type: esriFieldTypeString, alias: Other Gas Detection Equipment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OtherGasDetectionEquipment )

Templates:

• Name: SCUDGIS.DBO.LeakMonitor
  Description:
  Prototype:
  MonitorGasPercent: null
  GasDetectionEquipment: null
  LeakType: null
  ReportSource: null
  LeakID: null
  StreetAddress: null
  City: null
  GasFound: null
  ArrivedDate: null
  Technician: null
  InvestigationFoundLeak: null
  IfLeakFoundGrade: null
  Location: null
  GasOdorDetected: null
  Soap: null
  GasPercent: null
  LELPercent: null
  PPMPercent: null
  PressureSystem: null
  AreaLocation: null
  ProbableSource: null
  IfMeterLocationonMeter: null
  IfMeterBodyManufacturer: null
  IfMeterSize: null
  IfMainorServiceMaterial: null
  IfMainorServiceSize: null
  ProbableCause: null
  IfExcavationDamageLocateCalled: null
  IfExcavationDamageLocateNumber: null
  IfExcavationDamageExcavatorName: null
  IfExcavationDamageExcavatorAddr: null
  IfExcavationDamageExcavatorCity: null
  IfExcavationDamageExcavatorNumb: null
  Remarks: null
  MadeSafeDate: null
  LeakGUID: null
  LeakMaintenanceType: null
  FoundGrade: null
  FoundSource: null
  FoundCause: null
  ExcavationType: null
  EquipmentFailureType: null
  EquipementFailureCouplingType: null
  MWJType: null
  MWJPipeComponent: null
  PipeCondition: null
  CoatingCondition: null
  CoatingType: null
  CoatingRequiredRepair: null
  DescribeCoatingRepair: null
  Repaired: null
  DescribeLeakRepair: null
  RepairedBy: null
  RepairedDate: null
  MonitorGrade: null
  MonitorDescription: null
  MonitorDate: null
  MonitorBy: null
  OtherGasDetectionEquipment: null
  LeakStatus: null
  RelatedGuid: null
  SqlRepairType2: null
  SqlDOTCauseOfLeak2: null
  ReportedDate: null
  SqlAddDate: null
  SqlStartDate: null
  SqlEndDate: null
  SqlStatus: null
  SqlSystemLeakIsOn2: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Leak (0) -- Related To: Leak All (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata