Name: Vacuum Pump Activity Table
Display Field: OBJECTID
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)
- GPS_Recorded_At (type: esriFieldTypeDate, alias: GPS Recorded At, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Assigned_By (type: esriFieldTypeString, alias: Assigned By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Assigned_To (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Created_At (type: esriFieldTypeDate, alias: Created At, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Last_Saved_Date (type: esriFieldTypeDate, alias: Last Saved Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Record_Date (type: esriFieldTypeDate, alias: Record Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Task (type: esriFieldTypeString, alias: Task, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Air_Vac_ID (type: esriFieldTypeString, alias: Air Vac ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Diameter (type: esriFieldTypeSmallInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Exercise_Iso_Valve (type: esriFieldTypeSmallInteger, alias: Exercise Iso Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Flush_Air_Vac (type: esriFieldTypeSmallInteger, alias: Flush Air Vac, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Exercise_Shut_off_Valve (type: esriFieldTypeSmallInteger, alias: Exercise Shut off Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Rebuild_Air_Vac (type: esriFieldTypeSmallInteger, alias: Rebuild Air Vac, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Exercise_Drainage_Valve (type: esriFieldTypeSmallInteger, alias: Exercise Drainage Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
- Grease (type: esriFieldTypeString, alias: Grease, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 1 more ...)
- Debris (type: esriFieldTypeString, alias: Debris, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 1 more ...)
- Exercise_Date (type: esriFieldTypeDate, alias: Exercise Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Flush_Date (type: esriFieldTypeDate, alias: Flush Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Repair_Date (type: esriFieldTypeDate, alias: Repair Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Location_Details (type: esriFieldTypeString, alias: Location Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- 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: Vacuum 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: 6/25/2025 3:31:49 PM
Schema Last Edit Date: 6/25/2025 3:31:49 PM
Data Last Edit Date: 6/25/2025 3:31:49 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat