Name: Vehicle Adherence Report Inspections

Display Field: OSAR_SUPERVISOR

Type: Table

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_1

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OSAR_SUPERVISOR (type: esriFieldTypeString, alias: osar_supervisor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_INSPECTION_DATE (type: esriFieldTypeDate, alias: osar_inspection_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OSAR_DAY_WEEK (type: esriFieldTypeString, alias: osar_day_week, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_BLOCK_ID (type: esriFieldTypeString, alias: osar_block_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ROUTE_NUMBER (type: esriFieldTypeString, alias: osar_route_number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_STOP_ID (type: esriFieldTypeString, alias: osar_stop_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_LOCATION (type: esriFieldTypeString, alias: osar_location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ROUTE_DIRECTION (type: esriFieldTypeString, alias: osar_route_direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_RUN_NUMBER (type: esriFieldTypeString, alias: osar_run_number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_BUS_NUMBER (type: esriFieldTypeString, alias: osar_bus_number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_SCHEDULE_TIME (type: esriFieldTypeString, alias: osar_schedule_time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_SCHEDULE_TIME_MILITARY (type: esriFieldTypeString, alias: osar_schedule_time_military, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ACTUAL_ARRIVAL (type: esriFieldTypeString, alias: osar_actual_arrival, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ACTUAL_ARRIVAL_MILITARY (type: esriFieldTypeString, alias: osar_actual_arrival_military, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ACTUAL_DEPARTURE (type: esriFieldTypeString, alias: osar_actual_departure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_ACTUAL_DEPARTURE_MILITARY (type: esriFieldTypeString, alias: osar_actual_departure_military, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OSAR_TIME_DIFFERENCE (type: esriFieldTypeDouble, alias: osar_time_difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OSAR_COMMENTS (type: esriFieldTypeString, alias: osar_comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
• 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)
• GLOBALID_1 (type: esriFieldTypeGlobalID, alias: GLOBALID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Vehicle Adherence Report Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• fixed_routes_timetables (1) -- Related To: bct_fixed_routes_timetables (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2026 2:06:46 PM

Schema Last Edit Date: 9/8/2023 2:13:44 PM

Data Last Edit Date: 6/5/2026 2:06:46 PM

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