Name: Vehicle Activity Table

Display Field: Name

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:

Name : OBJECTID

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)
• UnitID (type: esriFieldTypeString, alias: UnitID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BuildingName (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LicenseNumber (type: esriFieldTypeString, alias: LicenseNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ModelType (type: esriFieldTypeString, alias: ModelType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ServicedBy (type: esriFieldTypeString, alias: ServicedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TotalMileage (type: esriFieldTypeString, alias: TotalMileage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PurchaseDate (type: esriFieldTypeDate, alias: PurchaseDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PurchaseCost (type: esriFieldTypeString, alias: PurchaseCost, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExpectedLife (type: esriFieldTypeString, alias: ExpectedLife, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WarrantyExpiration (type: esriFieldTypeString, alias: WarrantyExpiration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DoorsAndLatches (type: esriFieldTypeSmallInteger, alias: DoorsAndLatches, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• WashVehicle (type: esriFieldTypeSmallInteger, alias: WashVehicle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• EmergencyBrake (type: esriFieldTypeSmallInteger, alias: EmergencyBrake, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• OilPressure (type: esriFieldTypeSmallInteger, alias: OilPressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• WasherFluid (type: esriFieldTypeSmallInteger, alias: WasherFluid, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• FanBelts (type: esriFieldTypeSmallInteger, alias: FanBelts, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• PowerSteeringFluid (type: esriFieldTypeSmallInteger, alias: PowerSteeringFluid, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• BrakeLights (type: esriFieldTypeSmallInteger, alias: BrakeLights, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• FireExtinguisher (type: esriFieldTypeSmallInteger, alias: FireExtinguisher, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• RadiatorCoolantLevel (type: esriFieldTypeSmallInteger, alias: RadiatorCoolantLevel, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• SeatBeltOperation (type: esriFieldTypeSmallInteger, alias: SeatBeltOperation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• FirstAidKit (type: esriFieldTypeSmallInteger, alias: FirstAidKit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• RecordMileage (type: esriFieldTypeSmallInteger, alias: RecordMileage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• BackupBell (type: esriFieldTypeSmallInteger, alias: BackupBell, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• Headlights (type: esriFieldTypeSmallInteger, alias: Headlights, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• RoadTest (type: esriFieldTypeSmallInteger, alias: RoadTest, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• Mirrors (type: esriFieldTypeSmallInteger, alias: Mirrors, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• HeaterACandDefroster (type: esriFieldTypeSmallInteger, alias: HeaterA/CandDefroster, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• OilLevel (type: esriFieldTypeSmallInteger, alias: OilLevel, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• AccidentForms (type: esriFieldTypeSmallInteger, alias: AccidentForms, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• HornOperation (type: esriFieldTypeSmallInteger, alias: HornOperation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• SpareTire (type: esriFieldTypeSmallInteger, alias: SpareTire, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• BatteryWater (type: esriFieldTypeSmallInteger, alias: BatteryWater, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• WiperOperation (type: esriFieldTypeSmallInteger, alias: WiperOperation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• TailLights (type: esriFieldTypeSmallInteger, alias: TailLights, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• TransmissionFluid (type: esriFieldTypeSmallInteger, alias: TransmissionFluid, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• TirePressure (type: esriFieldTypeSmallInteger, alias: TirePressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• BrakesDepressandHold (type: esriFieldTypeSmallInteger, alias: BrakesDepressandHold, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• 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: Vehicle Activity Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/10/2025 10:40:21 PM

Schema Last Edit Date: 10/5/2023 6:38:07 PM

Data Last Edit Date: 7/10/2025 10:40:21 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat