Name: CFD_Equipment_Vw

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: false

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: UnitNumber, length: 255 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Make ( type: esriFieldTypeString, alias: Make, length: 255 )
• ModelDescription ( type: esriFieldTypeString, alias: ModelDescription, length: 255 )
• ModelNumber ( type: esriFieldTypeString, alias: ModelNumber, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 255 )
• CWEquipDesc ( type: esriFieldTypeString, alias: CWEquipDesc, length: 255 )
• CWEquipID ( type: esriFieldTypeString, alias: CWEquipID, 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 )
• SCFID ( type: esriFieldTypeString, alias: SCFID, length: 255 )
• FEMACode ( type: esriFieldTypeString, alias: FEMACode, length: 255 )
• FEMARate ( type: esriFieldTypeDouble, alias: FEMARate )
• Department ( type: esriFieldTypeString, alias: Department, length: 255 )
• Division ( type: esriFieldTypeString, alias: Division, length: 255 )
• MaintLocation ( type: esriFieldTypeString, alias: MaintLocation, length: 255 )
• RelatedStructure ( type: esriFieldTypeString, alias: RelatedStructure, 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: PMSchedule, length: 255 )
• PMLSD ( type: esriFieldTypeDate, alias: PMLSD, length: 8, precision: 1 )
• Mileage ( type: esriFieldTypeDouble, alias: Mileage )
• MIleageLS ( type: esriFieldTypeDouble, alias: MIleageLS )
• EngineHours ( type: esriFieldTypeDouble, alias: EngineHours )
• EngineHoursLS ( type: esriFieldTypeDouble, alias: EngineHoursLS )
• AuxHours ( type: esriFieldTypeDouble, alias: AuxHours )
• AuxHoursLS ( type: esriFieldTypeDouble, alias: AuxHoursLS )
• EOL ( type: esriFieldTypeDouble, alias: EOL )
• OwnType ( type: esriFieldTypeString, alias: OwnType, length: 255 )
• LLEndDate ( type: esriFieldTypeDate, alias: LLEndDate, length: 8, precision: 1 )
• DOP ( type: esriFieldTypeDate, alias: DOP, length: 8, precision: 1 )
• PP ( type: esriFieldTypeDouble, alias: PP )
• RC ( type: esriFieldTypeDouble, alias: RC )
• TargetRPLYear ( type: esriFieldTypeInteger, alias: TargetRPLYear )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8, precision: 1 )
• WarrantyMileage ( type: esriFieldTypeDouble, alias: WarrantyMileage )
• COF ( type: esriFieldTypeDouble, alias: COF )
• POF ( type: esriFieldTypeDouble, alias: POF )
• BRE ( type: esriFieldTypeDouble, alias: BRE )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8, precision: 1 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8, precision: 1 )
• GlobalID_1 ( type: esriFieldTypeGUID, alias: GlobalID_1, length: 38 )
• WOID ( type: esriFieldTypeString, alias: WOID, length: 255 )
• WOStatus ( type: esriFieldTypeString, alias: WOStatus, length: 255 )
• PMInspectDate ( type: esriFieldTypeDate, alias: PMInspectDate, length: 8, precision: 1 )
• PMDueHrs ( type: esriFieldTypeDouble, alias: PMDueHrs )
• PMDueMiles ( type: esriFieldTypeDouble, alias: PMDueMiles )

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

  Iteminfo   Thumbnail   Metadata