Name: COC_Equipment

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1e893fb3503945159249ca1a33dfb0d3

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

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

Relationships:

• COC_Equipment (0) -- Related To: COC_Maintenance_Shops (13)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata