Name: COC_Vehicles

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 694748f2bf324fbb9a129e999a2a59ea

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetID )
• CarmelID ( type: esriFieldTypeString, alias: CarmelID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CarmelID )
• UnitNumber ( type: esriFieldTypeString, alias: Unit Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UnitNumber )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Category )
• Subcategory ( type: esriFieldTypeString, alias: Subcategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Subcategory )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Make )
• ModelDescription ( type: esriFieldTypeString, alias: Model Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModelDescription )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Color , Coded Values: [Black: Black] , [Blue: Blue] , [Brown: Brown] , ...8 more... )
• CWEquipDesc ( type: esriFieldTypeString, alias: CW Equipment Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CWEquipDesc )
• CWEquipID ( type: esriFieldTypeString, alias: CW Equipment ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CWEquipID )
• Plate ( type: esriFieldTypeString, alias: Plate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Plate )
• VIN ( type: esriFieldTypeString, alias: VIN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VIN )
• FuelType ( type: esriFieldTypeString, alias: FuelType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FuelType , Coded Values: [Biodiesel: Biodiesel] , [Diesel: Diesel] , [Electric: Electric] , ...7 more... )
• SCFID ( type: esriFieldTypeString, alias: School Fuel ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SCFID )
• CKFID ( type: esriFieldTypeString, alias: Circle K Fuel ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CKFID )
• MFID ( type: esriFieldTypeString, alias: Meijer Fuel ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MFID )
• EMS ( type: esriFieldTypeString, alias: EMS Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EMS )
• ShellID ( type: esriFieldTypeString, alias: Shell Fuel ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ShellID )
• KNOX ( type: esriFieldTypeString, alias: Knox Key, editable: true, nullable: true, length: 255, defaultValue: null, modelName: KNOX )
• FEMACode ( type: esriFieldTypeString, alias: FEMA Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FEMACode )
• FEMARate ( type: esriFieldTypeDouble, alias: FEMA Rate, editable: true, nullable: true, defaultValue: null, modelName: FEMARate )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Department , Coded Values: [Engineering: Engineering] , [Street: Street] , [Utilities: Utilities] , ...8 more... )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Division , Coded Values: [Wastewater: Wastewater] , [Water: Water] , [Locators: Locators] , ...15 more... )
• MaintLocation ( type: esriFieldTypeString, alias: Maintenance Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintLocation , Coded Values: [Street Maintenance Shop: Street Maintenance Shop] , [Water Distribution: Water Distribution] , [WWTP: WWTP] , ...4 more... )
• RelatedStructure ( type: esriFieldTypeString, alias: Related Structure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RelatedStructure )
• PoolCar ( type: esriFieldTypeString, alias: Pool Car, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoolCar , Coded Values: [Y: Yes] , [N: No] )
• TakeHome ( type: esriFieldTypeString, alias: TakeHome, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TakeHome , Coded Values: [Y: Yes] , [N: No] )
• AssignedTo ( type: esriFieldTypeString, alias: AssignedTo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssignedTo )
• Operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operator )
• Filter ( type: esriFieldTypeString, alias: Filter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Filter )
• Fluid ( type: esriFieldTypeString, alias: Fluid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Fluid )
• PMSchedule ( type: esriFieldTypeString, alias: PM Schedule, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PMSchedule , Coded Values: [Engine Oil Life: Engine Oil Life] , [Mileage: Mileage] , [Hours: Hours] )
• PMLSD ( type: esriFieldTypeDate, alias: PM Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PMLSD )
• Mileage ( type: esriFieldTypeDouble, alias: Mileage, editable: true, nullable: true, defaultValue: null, modelName: Mileage )
• MIleageLS ( type: esriFieldTypeDouble, alias: Last Serviced MIleage, editable: true, nullable: true, defaultValue: null, modelName: MIleageLS )
• EngineHours ( type: esriFieldTypeDouble, alias: EngineHours, editable: true, nullable: true, defaultValue: null, modelName: EngineHours )
• EngineHoursLS ( type: esriFieldTypeDouble, alias: Last Serviced Engine Hours, editable: true, nullable: true, defaultValue: null, modelName: EngineHoursLS )
• AuxHours ( type: esriFieldTypeDouble, alias: Auxillary Hours, editable: true, nullable: true, defaultValue: null, modelName: AuxHours )
• AuxHoursLS ( type: esriFieldTypeDouble, alias: Last Serviced Aux Hours, editable: true, nullable: true, defaultValue: null, modelName: AuxHoursLS )
• EOL ( type: esriFieldTypeDouble, alias: Engine Oil Life, editable: true, nullable: true, defaultValue: null, modelName: EOL )
• OwnType ( type: esriFieldTypeString, alias: OwnType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnType , Coded Values: [Own: Own] , [Leased: Leased] )
• LLEndDate ( type: esriFieldTypeDate, alias: Lease_Loan End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LLEndDate )
• DOP ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DOP )
• PP ( type: esriFieldTypeDouble, alias: Purchase Price, editable: true, nullable: true, defaultValue: null, modelName: PP )
• RC ( type: esriFieldTypeDouble, alias: Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: RC )
• TargetRPLYear ( type: esriFieldTypeInteger, alias: Target Replacement Year, editable: true, nullable: true, defaultValue: null, modelName: TargetRPLYear )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• WarrantyMileage ( type: esriFieldTypeDouble, alias: Warranty Mileage, editable: true, nullable: true, defaultValue: null, modelName: WarrantyMileage )
• COF ( type: esriFieldTypeDouble, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: COF )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: POF )
• BRE ( type: esriFieldTypeDouble, alias: Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Inactive: Inactive] , [Planned: Planned] , ...5 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• WOID ( type: esriFieldTypeString, alias: WOID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WOID )
• WOStatus ( type: esriFieldTypeString, alias: WOStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WOStatus )
• PMInspectDate ( type: esriFieldTypeDate, alias: PM Inspect Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PMInspectDate )
• PMDueHrs ( type: esriFieldTypeDouble, alias: PM Next Due Hours, editable: true, nullable: true, defaultValue: null, modelName: PMDueHrs )
• PMDueMiles ( type: esriFieldTypeDouble, alias: PM Next Due Mileage, editable: true, nullable: true, defaultValue: null, modelName: PMDueMiles )

Templates:

• Name: COC_Vehicles
  Description:
  Prototype:
  PMDueHrs: null
  PMInspectDate: null
  AssetID: null
  CarmelID: null
  UnitNumber: null
  Category: null
  Subcategory: null
  Year: null
  Make: null
  ModelDescription: null
  Color: null
  CWEquipDesc: null
  CWEquipID: null
  Plate: null
  VIN: null
  FuelType: null
  SCFID: null
  CKFID: null
  MFID: null
  EMS: null
  ShellID: null
  KNOX: null
  FEMACode: null
  FEMARate: null
  Department: null
  Division: null
  MaintLocation: null
  RelatedStructure: null
  PoolCar: null
  TakeHome: null
  AssignedTo: null
  Operator: null
  Filter: null
  Fluid: null
  PMSchedule: null
  PMLSD: null
  Mileage: null
  MIleageLS: null
  EngineHours: null
  EngineHoursLS: null
  AuxHours: null
  AuxHoursLS: null
  EOL: null
  OwnType: null
  LLEndDate: null
  DOP: null
  PP: null
  RC: null
  TargetRPLYear: null
  WarrantyDate: null
  WarrantyMileage: null
  COF: null
  POF: null
  BRE: null
  Comments: null
  Status: null
  WOStatus: null
  WOID: null
  PMDueMiles: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• COC_Vehicles (1) -- Related To: COC_Maintenance_Shops (13)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata