Name: Pump Activity Table
Display Field: PumpName
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ActivityID (type: esriFieldTypeString, alias: ActivityID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GPSRecordedAt (type: esriFieldTypeDate, alias: GPSRecordedAt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AssignedBy (type: esriFieldTypeString, alias: AssignedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AssignedTo (type: esriFieldTypeString, alias: AssignedTo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CreatedAt (type: esriFieldTypeDate, alias: CreatedAt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LastSavedDate (type: esriFieldTypeDate, alias: LastSavedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RecordDate (type: esriFieldTypeDate, alias: RecordDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Task (type: esriFieldTypeString, alias: Task, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PumpName (type: esriFieldTypeString, alias: PumpName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pump1Hours (type: esriFieldTypeDouble, alias: Pump1Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Pump2Hours (type: esriFieldTypeDouble, alias: Pump2Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Pump3Hours (type: esriFieldTypeDouble, alias: Pump3Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Pump4Hours (type: esriFieldTypeDouble, alias: Pump4Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MechanicalSeals (type: esriFieldTypeSmallInteger, alias: MechanicalSeals, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- OverheadCrane (type: esriFieldTypeSmallInteger, alias: OverheadCrane, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- StationLights (type: esriFieldTypeSmallInteger, alias: StationLights, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- StationLocks (type: esriFieldTypeSmallInteger, alias: StationLocks, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- BubblerSystem (type: esriFieldTypeSmallInteger, alias: BubblerSystem, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- BlowdownBubblerSystem (type: esriFieldTypeSmallInteger, alias: BlowdownBubblerSystem, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- VentilationSystem (type: esriFieldTypeSmallInteger, alias: VentilationSystem, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CleanBathroom (type: esriFieldTypeSmallInteger, alias: CleanBathroom, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- MopDrywell (type: esriFieldTypeSmallInteger, alias: MopDrywell, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CleanMCCRoom (type: esriFieldTypeSmallInteger, alias: CleanMCCRoom, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- SumpPumpOperation (type: esriFieldTypeSmallInteger, alias: SumpPumpOperation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectWetwell (type: esriFieldTypeSmallInteger, alias: InspectWetwell, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- BlowDownSurgeTank (type: esriFieldTypeSmallInteger, alias: BlowDownSurgeTank, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceControlBulbs (type: esriFieldTypeSmallInteger, alias: ReplaceControlBulbs, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- BarScreen (type: esriFieldTypeSmallInteger, alias: BarScreen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- SurgeTank (type: esriFieldTypeSmallInteger, alias: SurgeTank, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- FMIsolationValve (type: esriFieldTypeSmallInteger, alias: FMIsolationValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CompressorReliefValve (type: esriFieldTypeSmallInteger, alias: CompressorReliefValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- HighDryWellLevelAlarm (type: esriFieldTypeSmallInteger, alias: HighDryWellLevelAlarm, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- HighWetwellLevelAlarm (type: esriFieldTypeSmallInteger, alias: HighWetwellLevelAlarm, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ConfirmAlarmSetPoints (type: esriFieldTypeSmallInteger, alias: ConfirmAlarmSetPoints, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex1SuctionValve (type: esriFieldTypeSmallInteger, alias: Ex1SuctionValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex1DischargeValve (type: esriFieldTypeSmallInteger, alias: Ex1DischargeValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Cycle1CheckValve (type: esriFieldTypeSmallInteger, alias: Cycle1CheckValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex2SuctionValve (type: esriFieldTypeSmallInteger, alias: Ex2SuctionValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex2DischargeValve (type: esriFieldTypeSmallInteger, alias: Ex2DischargeValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Cycle2CheckValve (type: esriFieldTypeSmallInteger, alias: Cycle2CheckValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex3SuctionValve (type: esriFieldTypeSmallInteger, alias: Ex3SuctionValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex3DischargeValve (type: esriFieldTypeSmallInteger, alias: Ex3DischargeValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Cycle3CheckValve (type: esriFieldTypeSmallInteger, alias: Cycle3CheckValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex4SuctionValve (type: esriFieldTypeSmallInteger, alias: Ex4SuctionValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Ex4DischargeValve (type: esriFieldTypeSmallInteger, alias: Ex4DischargeValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Cycle4CheckValve (type: esriFieldTypeSmallInteger, alias: Cycle4CheckValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- A_CService (type: esriFieldTypeSmallInteger, alias: A/CService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- GeneratorService (type: esriFieldTypeSmallInteger, alias: GeneratorService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- AmpDraw (type: esriFieldTypeSmallInteger, alias: AmpDraw, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- RakeBarScreen (type: esriFieldTypeSmallInteger, alias: RakeBarScreen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- GreaseService (type: esriFieldTypeSmallInteger, alias: GreaseService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CarbonSample (type: esriFieldTypeSmallInteger, alias: CarbonSample, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ChangeCompressorOil (type: esriFieldTypeSmallInteger, alias: ChangeCompressorOil, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ChangeOil (type: esriFieldTypeSmallInteger, alias: ChangeOil, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CheckFanBelts (type: esriFieldTypeSmallInteger, alias: CheckFanBelts, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- OperationalCheckPump (type: esriFieldTypeSmallInteger, alias: OperationalCheckPump, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CleanWetWell (type: esriFieldTypeSmallInteger, alias: CleanWetWell, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- CycleValve (type: esriFieldTypeSmallInteger, alias: CycleValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ExBy_PassValve (type: esriFieldTypeSmallInteger, alias: ExBy-PassValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ElectricHeatSurvey (type: esriFieldTypeSmallInteger, alias: ElectricHeatSurvey, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectCompressor (type: esriFieldTypeSmallInteger, alias: InspectCompressor, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectLadder (type: esriFieldTypeSmallInteger, alias: InspectLadder, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Landscaping (type: esriFieldTypeSmallInteger, alias: Landscaping, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- LubricateBearing (type: esriFieldTypeSmallInteger, alias: LubricateBearing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- LubricateMotorBearing (type: esriFieldTypeSmallInteger, alias: LubricateMotorBearing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- LubricatePumpBearing (type: esriFieldTypeSmallInteger, alias: LubricatePumpBearing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- LubricatePumpShaft (type: esriFieldTypeSmallInteger, alias: LubricatePumpShaft, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- MotorMegged (type: esriFieldTypeSmallInteger, alias: MotorMegged, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectForLeaks (type: esriFieldTypeSmallInteger, alias: InspectForLeaks, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- TakePressureReadings (type: esriFieldTypeSmallInteger, alias: TakePressureReadings, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectCoupling (type: esriFieldTypeSmallInteger, alias: InspectCoupling, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- RenewFuelPermit (type: esriFieldTypeSmallInteger, alias: RenewFuelPermit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceCarbonFilter (type: esriFieldTypeSmallInteger, alias: ReplaceCarbonFilter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceFilter (type: esriFieldTypeSmallInteger, alias: ReplaceFilter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceOilinPump (type: esriFieldTypeSmallInteger, alias: ReplaceOilinPump, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplacePumpPacking (type: esriFieldTypeSmallInteger, alias: ReplacePumpPacking, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ServiceTransferSwitch (type: esriFieldTypeSmallInteger, alias: ServiceTransferSwitch, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceUPSBatteries (type: esriFieldTypeSmallInteger, alias: ReplaceUPSBatteries, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- VibrationalAnalysis (type: esriFieldTypeSmallInteger, alias: VibrationalAnalysis, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- BackflowService (type: esriFieldTypeSmallInteger, alias: BackflowService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- WetWellWasher (type: esriFieldTypeSmallInteger, alias: WetWellWasher, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ChannelMonster (type: esriFieldTypeSmallInteger, alias: ChannelMonster, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectVapex (type: esriFieldTypeSmallInteger, alias: InspectVapex, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- InspectScrubber (type: esriFieldTypeSmallInteger, alias: InspectScrubber, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- OverflowWetWell (type: esriFieldTypeSmallInteger, alias: OverflowWetWell, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- PolishDieselFuel (type: esriFieldTypeSmallInteger, alias: PolishDieselFuel, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- PortablePumpService (type: esriFieldTypeSmallInteger, alias: PortablePumpService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- RepairBy_PassConnection (type: esriFieldTypeSmallInteger, alias: RepairBy-PassConnection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceBattery (type: esriFieldTypeSmallInteger, alias: ReplaceBattery, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceBearing (type: esriFieldTypeSmallInteger, alias: ReplaceBearing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceFanBelt (type: esriFieldTypeSmallInteger, alias: ReplaceFanBelt, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceCheckValve (type: esriFieldTypeSmallInteger, alias: ReplaceCheckValve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceDehumidifier (type: esriFieldTypeSmallInteger, alias: ReplaceDehumidifier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceImpeller (type: esriFieldTypeSmallInteger, alias: ReplaceImpeller, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceMotorBearings (type: esriFieldTypeSmallInteger, alias: ReplaceMotorBearings, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplacePumpBearings (type: esriFieldTypeSmallInteger, alias: ReplacePumpBearings, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceRadiator (type: esriFieldTypeSmallInteger, alias: ReplaceRadiator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceSumpPump (type: esriFieldTypeSmallInteger, alias: ReplaceSumpPump, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- ReplaceSeal (type: esriFieldTypeSmallInteger, alias: ReplaceSeal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ManHours (type: esriFieldTypeDouble, alias: ManHours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CrewNumber (type: esriFieldTypeSmallInteger, alias: CrewNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TotalHours (type: esriFieldTypeDouble, alias: TotalHours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Pump Activity Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/10/2025 11:16:43 PM
Schema Last Edit Date: 7/10/2025 11:16:43 PM
Data Last Edit Date: 7/10/2025 11:16:43 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat