Name: Vehicles_and_Last_Service_Status_Join_View

Display Field: vehicleid

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: true

Sources

Description: Vehicle Service Status

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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:

• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• vehicleid (type: esriFieldTypeString, alias: Vehicle ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• assignedoperation (type: esriFieldTypeString, alias: Assigned Operation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• vehiclename (type: esriFieldTypeString, alias: Vehicle Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehiclefleet (type: esriFieldTypeString, alias: Fleet or Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fleet: Fleet], [Contractor: Contractor])
• locationsource (type: esriFieldTypeString, alias: Location Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ArcGIS Only: ArcGIS Only], [Vendor AVL Only: Vendor AVL Only], [Vendor AVL Location and ArcGIS Field Operations: Vendor AVL Location and ArcGIS Field Operations])
• makemodel (type: esriFieldTypeString, alias: Make and Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehiclestatus (type: esriFieldTypeString, alias: Vehicle Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Operational: Operational], [Out for repair: Out for repair], [Retired: Retired])
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user_1706229219355 (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1706229219355 (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1706229219355 (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1706229219355 (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• assignedoperation_1706229219355 (type: esriFieldTypeString, alias: Assigned Operation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• vehicleid_1706229219355 (type: esriFieldTypeString, alias: Vehicle ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• servicestatus (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• aux1 (type: esriFieldTypeString, alias: Auxiliary 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• aux2 (type: esriFieldTypeString, alias: Auxiliary 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• aux3 (type: esriFieldTypeString, alias: Auxiliary 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• aux4 (type: esriFieldTypeDouble, alias: Auxiliary 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aux5 (type: esriFieldTypeDouble, alias: Auxiliary 5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aux6 (type: esriFieldTypeDouble, alias: Auxiliary 6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/30/2024 4:45:07 PM

Schema Last Edit Date: 6/12/2024 3:01:23 PM

Data Last Edit Date: 6/12/2024 3:01:23 PM

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