Name: Equipment

Display Field: ADDRESS

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a9155d8194914aba8c04735b0eced29f

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HasZ: false

HasM: false

Has Attachments: false

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: 20, defaultValue: null, modelName: ASSETID )
• FEMA_CODE ( type: esriFieldTypeString, alias: FEMA_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FEMA_CODE )
• ADDRESS ( type: esriFieldTypeString, alias: UNIT_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT_NO )
• REGISTRATION_MONTH ( type: esriFieldTypeSmallInteger, alias: REGISTRATION_MONTH, editable: true, nullable: true, defaultValue: null, modelName: REGISTRATION_MONTH )
• YEAR ( type: esriFieldTypeInteger, alias: YEAR, editable: true, nullable: true, defaultValue: null, modelName: YEAR )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: false, length: 30, defaultValue: null, modelName: MAKE )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• LOCATION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DESCRIPTION )
• COLOR ( type: esriFieldTypeString, alias: COLOR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COLOR )
• CLASS ( type: esriFieldTypeString, alias: CLASS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLASS )
• VIN_NUMBER ( type: esriFieldTypeString, alias: VIN_NUMBER, editable: true, nullable: true, length: 17, defaultValue: null, modelName: VIN_NUMBER )
• LICENSE_PLATE_NUMBER ( type: esriFieldTypeString, alias: LICENSE_PLATE_NUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LICENSE_PLATE_NUMBER )
• ENGINE_SERIAL_NUMBER ( type: esriFieldTypeString, alias: ENGINE_SERIAL_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ENGINE_SERIAL_NUMBER )
• ENGINE_SIZE ( type: esriFieldTypeString, alias: ENGINE_SIZE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ENGINE_SIZE )
• TRANSMISSION_SERIAL_NUMBER ( type: esriFieldTypeString, alias: TRANSMISSION_SERIAL_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TRANSMISSION_SERIAL_NUMBER )
• BED_MAKE ( type: esriFieldTypeString, alias: BED_MAKE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BED_MAKE )
• BED_MODEL ( type: esriFieldTypeString, alias: BED_MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BED_MODEL )
• BED_SERIAL_NUMBER ( type: esriFieldTypeString, alias: BED_SERIAL_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BED_SERIAL_NUMBER )
• DUMP_BED_CAPACITY ( type: esriFieldTypeString, alias: DUMP_BED_CAPACITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DUMP_BED_CAPACITY )
• GVWR ( type: esriFieldTypeString, alias: GVWR, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GVWR )
• FUEL_TYPE ( type: esriFieldTypeString, alias: FUEL_TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FUEL_TYPE )
• FUEL_CAPACITY ( type: esriFieldTypeString, alias: FUEL_CAPACITY, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FUEL_CAPACITY )
• FRONT_TIRE_SIZE ( type: esriFieldTypeString, alias: FRONT_TIRE_SIZE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FRONT_TIRE_SIZE )
• REAR_TIRE_SIZE ( type: esriFieldTypeString, alias: REAR_TIRE_SIZE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: REAR_TIRE_SIZE )
• FIRE_DEPT_JOB_NUMBER ( type: esriFieldTypeString, alias: FIRE_DEPT_JOB_NUMBER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FIRE_DEPT_JOB_NUMBER )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DEPARTMENT )
• IN_SERVICE_DATE ( type: esriFieldTypeDate, alias: IN_SERVICE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IN_SERVICE_DATE )
• VENDOR ( type: esriFieldTypeString, alias: VENDOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VENDOR )
• PURCHASE_ORDER_NUMBER ( type: esriFieldTypeString, alias: PURCHASE_ORDER_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PURCHASE_ORDER_NUMBER )
• ACQUISTION_DATE ( type: esriFieldTypeDate, alias: ACQUISTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACQUISTION_DATE )
• ACQUISTION_COST ( type: esriFieldTypeDouble, alias: ACQUISTION_COST, editable: true, nullable: true, defaultValue: null, modelName: ACQUISTION_COST )
• DISPOSAL_DATE ( type: esriFieldTypeDate, alias: DISPOSAL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DISPOSAL_DATE )
• DISPOSAL_COST ( type: esriFieldTypeDouble, alias: DISPOSAL_COST, editable: true, nullable: true, defaultValue: null, modelName: DISPOSAL_COST )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• EXP_AGE_RETIRE ( type: esriFieldTypeString, alias: EXP AGE RETIREMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: EXP_AGE_RETIRE )
• EXP_MILEAGE_RETIRE ( type: esriFieldTypeString, alias: EXP MILEAGE RETIREMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: EXP_MILEAGE_RETIRE )
• CAP_ASSET_NO ( type: esriFieldTypeString, alias: CAP_ASSET_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CAP_ASSET_NO )
• FI_UNIT_NO ( type: esriFieldTypeString, alias: FI_UNIT_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FI_UNIT_NO )
• LIFE_CYCLE ( type: esriFieldTypeString, alias: LIFE_CYCLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LIFE_CYCLE , Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED] , [NFM: NOT FLEET MAINTAINED] )
• SOLD_DATE ( type: esriFieldTypeString, alias: SOLD_DATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SOLD_DATE )
• FUEL_INTEGRATION ( type: esriFieldTypeString, alias: FUEL_INTEGRATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FUEL_INTEGRATION , Coded Values: [Yes: YES] , [No: NO] )
• EMAIL_NOTIFICATIONS ( type: esriFieldTypeString, alias: EMAIL_NOTIFICATIONS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: EMAIL_NOTIFICATIONS )
• PREVIOUS_UNIT_NUMBERS ( type: esriFieldTypeString, alias: PRIOR UNIT NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PREVIOUS_UNIT_NUMBERS )
• WEX_ACCOUNT ( type: esriFieldTypeString, alias: WEX ACCOUNT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WEX_ACCOUNT )
• IN_SHOP ( type: esriFieldTypeString, alias: IN SHOP, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SHOP , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OLD_DEPTARTMENT ( type: esriFieldTypeString, alias: OLD DEPARTMENT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OLD_DEPTARTMENT )
• MAINTENANCE_COST ( type: esriFieldTypeDouble, alias: MAINTENANCE COST, editable: true, nullable: true, defaultValue: null, modelName: MAINTENANCE_COST )
• CUR_MILEAGE ( type: esriFieldTypeInteger, alias: CUR MILEAGE, editable: true, nullable: true, defaultValue: null, modelName: CUR_MILEAGE )
• OUT_OF_SERVICE ( type: esriFieldTypeString, alias: OUT OF SERVICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OUT_OF_SERVICE , Coded Values: [Yes: Yes] , [No: No] )
• MUNIS_DEPARTMENT ( type: esriFieldTypeString, alias: MUNIS DEPARTMENT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MUNIS_DEPARTMENT )
• DSHB_REPORT ( type: esriFieldTypeString, alias: DSHB_REPORT, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DSHB_REPORT , Coded Values: [Yes: Yes] , [No: No] )
• METER_TYPE ( type: esriFieldTypeString, alias: METER_TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: METER_TYPE , Coded Values: [MILES: MILES] , [HOURS: HOURS] , [N/A: N/A] )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSET_TYPE , Coded Values: [NA: NA] , [LEASE: LEASE] , [PURCHASE: PURCHASE] )
• MAINTENANCE_TYPE ( type: esriFieldTypeString, alias: MAINTENANCE TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAINTENANCE_TYPE , Coded Values: [NA: NA] , [FULL MAINTENANCE: FULL MAINTENANCE] , [MANAGED MAINTENANCE: MANAGED MAINTENANCE] )
• LEASE_CONTRACT_DATE ( type: esriFieldTypeDate, alias: LEASE CONTRACT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LEASE_CONTRACT_DATE )
• LEASE_CONTRACT_MILES ( type: esriFieldTypeInteger, alias: LEASE CONTRACT MILES, editable: true, nullable: true, defaultValue: null, modelName: LEASE_CONTRACT_MILES )

Templates:

• Name: Equipment
  Description:
  Prototype:
  LEASE_CONTRACT_DATE: null
  MAINTENANCE_TYPE: null
  ASSETID: null
  FEMA_CODE: null
  ADDRESS: null
  REGISTRATION_MONTH: null
  YEAR: null
  MAKE:
  MODEL: null
  LOCATION: null
  COLOR: null
  CLASS: null
  VIN_NUMBER: null
  LICENSE_PLATE_NUMBER: null
  ENGINE_SERIAL_NUMBER: null
  ENGINE_SIZE: null
  TRANSMISSION_SERIAL_NUMBER: null
  BED_MAKE: null
  BED_MODEL: null
  BED_SERIAL_NUMBER: null
  DUMP_BED_CAPACITY: null
  GVWR: null
  FUEL_TYPE: null
  FUEL_CAPACITY: null
  FRONT_TIRE_SIZE: null
  REAR_TIRE_SIZE: null
  FIRE_DEPT_JOB_NUMBER: null
  DEPARTMENT: null
  IN_SERVICE_DATE: null
  VENDOR: null
  PURCHASE_ORDER_NUMBER: null
  ACQUISTION_DATE: null
  ACQUISTION_COST: null
  DISPOSAL_DATE: null
  DISPOSAL_COST: null
  COMMENTS: null
  EXP_AGE_RETIRE: null
  EXP_MILEAGE_RETIRE: null
  CAP_ASSET_NO: null
  FI_UNIT_NO: null
  LIFE_CYCLE: null
  SOLD_DATE: null
  FUEL_INTEGRATION: null
  EMAIL_NOTIFICATIONS: null
  PREVIOUS_UNIT_NUMBERS: null
  WEX_ACCOUNT: null
  IN_SHOP: null
  ASSET_TYPE: null
  METER_TYPE: null
  DSHB_REPORT: null
  MUNIS_DEPARTMENT: null
  LEASE_CONTRACT_MILES: null
  OLD_DEPTARTMENT: null
  MAINTENANCE_COST: null
  CUR_MILEAGE: null
  OUT_OF_SERVICE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Department (0) -- Related To: Fleet Departments (0)

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

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