{
 "currentVersion": 10.91,
 "id": 1,
 "name": "Equipment",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ADDRESS",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "ASSETID",
   "length": 20,
   "domain": null
  },
  {
   "name": "FEMA_CODE",
   "type": "esriFieldTypeString",
   "alias": "FEMA_CODE",
   "length": 10,
   "domain": null
  },
  {
   "name": "ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "UNIT_NO",
   "length": 20,
   "domain": null
  },
  {
   "name": "REGISTRATION_MONTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "REGISTRATION_MONTH",
   "domain": null
  },
  {
   "name": "YEAR",
   "type": "esriFieldTypeInteger",
   "alias": "YEAR",
   "domain": null
  },
  {
   "name": "MAKE",
   "type": "esriFieldTypeString",
   "alias": "MAKE",
   "length": 30,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "MODEL",
   "length": 50,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "DESCRIPTION",
   "length": 60,
   "domain": null
  },
  {
   "name": "COLOR",
   "type": "esriFieldTypeString",
   "alias": "COLOR",
   "length": 20,
   "domain": null
  },
  {
   "name": "CLASS",
   "type": "esriFieldTypeString",
   "alias": "CLASS",
   "length": 20,
   "domain": null
  },
  {
   "name": "VIN_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "VIN_NUMBER",
   "length": 17,
   "domain": null
  },
  {
   "name": "LICENSE_PLATE_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "LICENSE_PLATE_NUMBER",
   "length": 10,
   "domain": null
  },
  {
   "name": "ENGINE_SERIAL_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "ENGINE_SERIAL_NUMBER",
   "length": 30,
   "domain": null
  },
  {
   "name": "ENGINE_SIZE",
   "type": "esriFieldTypeString",
   "alias": "ENGINE_SIZE",
   "length": 30,
   "domain": null
  },
  {
   "name": "TRANSMISSION_SERIAL_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "TRANSMISSION_SERIAL_NUMBER",
   "length": 30,
   "domain": null
  },
  {
   "name": "BED_MAKE",
   "type": "esriFieldTypeString",
   "alias": "BED_MAKE",
   "length": 25,
   "domain": null
  },
  {
   "name": "BED_MODEL",
   "type": "esriFieldTypeString",
   "alias": "BED_MODEL",
   "length": 50,
   "domain": null
  },
  {
   "name": "BED_SERIAL_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "BED_SERIAL_NUMBER",
   "length": 30,
   "domain": null
  },
  {
   "name": "DUMP_BED_CAPACITY",
   "type": "esriFieldTypeString",
   "alias": "DUMP_BED_CAPACITY",
   "length": 30,
   "domain": null
  },
  {
   "name": "GVWR",
   "type": "esriFieldTypeString",
   "alias": "GVWR",
   "length": 15,
   "domain": null
  },
  {
   "name": "FUEL_TYPE",
   "type": "esriFieldTypeString",
   "alias": "FUEL_TYPE",
   "length": 10,
   "domain": null
  },
  {
   "name": "FUEL_CAPACITY",
   "type": "esriFieldTypeString",
   "alias": "FUEL_CAPACITY",
   "length": 15,
   "domain": null
  },
  {
   "name": "FRONT_TIRE_SIZE",
   "type": "esriFieldTypeString",
   "alias": "FRONT_TIRE_SIZE",
   "length": 25,
   "domain": null
  },
  {
   "name": "REAR_TIRE_SIZE",
   "type": "esriFieldTypeString",
   "alias": "REAR_TIRE_SIZE",
   "length": 25,
   "domain": null
  },
  {
   "name": "FIRE_DEPT_JOB_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "FIRE_DEPT_JOB_NUMBER",
   "length": 25,
   "domain": null
  },
  {
   "name": "DEPARTMENT",
   "type": "esriFieldTypeString",
   "alias": "DEPARTMENT",
   "length": 30,
   "domain": null
  },
  {
   "name": "IN_SERVICE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "IN_SERVICE_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "VENDOR",
   "type": "esriFieldTypeString",
   "alias": "VENDOR",
   "length": 50,
   "domain": null
  },
  {
   "name": "PURCHASE_ORDER_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "PURCHASE_ORDER_NUMBER",
   "length": 20,
   "domain": null
  },
  {
   "name": "ACQUISTION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "ACQUISTION_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACQUISTION_COST",
   "type": "esriFieldTypeDouble",
   "alias": "ACQUISTION_COST",
   "domain": null
  },
  {
   "name": "DISPOSAL_DATE",
   "type": "esriFieldTypeDate",
   "alias": "DISPOSAL_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DISPOSAL_COST",
   "type": "esriFieldTypeDouble",
   "alias": "DISPOSAL_COST",
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 250,
   "domain": null
  },
  {
   "name": "EXP_AGE_RETIRE",
   "type": "esriFieldTypeString",
   "alias": "EXP AGE RETIREMENT",
   "length": 15,
   "domain": null
  },
  {
   "name": "EXP_MILEAGE_RETIRE",
   "type": "esriFieldTypeString",
   "alias": "EXP MILEAGE RETIREMENT",
   "length": 15,
   "domain": null
  },
  {
   "name": "CAP_ASSET_NO",
   "type": "esriFieldTypeString",
   "alias": "CAP_ASSET_NO",
   "length": 20,
   "domain": null
  },
  {
   "name": "FI_UNIT_NO",
   "type": "esriFieldTypeString",
   "alias": "FI_UNIT_NO",
   "length": 20,
   "domain": null
  },
  {
   "name": "LIFE_CYCLE",
   "type": "esriFieldTypeString",
   "alias": "LIFE_CYCLE",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "CW_Equipment_LifeCycle",
    "description": "Life Cycle of Fleet Vehicles",
    "codedValues": [
     {
      "name": "ACTIVE",
      "code": "ACTIVE"
     },
     {
      "name": "RETIRED",
      "code": "RETIRED"
     },
     {
      "name": "NOT FLEET MAINTAINED",
      "code": "NFM"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SOLD_DATE",
   "type": "esriFieldTypeString",
   "alias": "SOLD_DATE",
   "length": 10,
   "domain": null
  },
  {
   "name": "FUEL_INTEGRATION",
   "type": "esriFieldTypeString",
   "alias": "FUEL_INTEGRATION",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo_1",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "YES",
      "code": "Yes"
     },
     {
      "name": "NO",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "EMAIL_NOTIFICATIONS",
   "type": "esriFieldTypeString",
   "alias": "EMAIL_NOTIFICATIONS",
   "length": 250,
   "domain": null
  },
  {
   "name": "PREVIOUS_UNIT_NUMBERS",
   "type": "esriFieldTypeString",
   "alias": "PRIOR UNIT NO",
   "length": 30,
   "domain": null
  },
  {
   "name": "WEX_ACCOUNT",
   "type": "esriFieldTypeString",
   "alias": "WEX ACCOUNT",
   "length": 20,
   "domain": null
  },
  {
   "name": "IN_SHOP",
   "type": "esriFieldTypeString",
   "alias": "IN SHOP",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoOnly",
    "description": "Yes or No Only",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "OLD_DEPTARTMENT",
   "type": "esriFieldTypeString",
   "alias": "OLD DEPARTMENT",
   "length": 30,
   "domain": null
  },
  {
   "name": "MAINTENANCE_COST",
   "type": "esriFieldTypeDouble",
   "alias": "MAINTENANCE COST",
   "domain": null
  },
  {
   "name": "CUR_MILEAGE",
   "type": "esriFieldTypeInteger",
   "alias": "CUR MILEAGE",
   "domain": null
  },
  {
   "name": "OUT_OF_SERVICE",
   "type": "esriFieldTypeString",
   "alias": "OUT OF SERVICE",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoOnly",
    "description": "Yes or No Only",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "MUNIS_DEPARTMENT",
   "type": "esriFieldTypeString",
   "alias": "MUNIS DEPARTMENT",
   "length": 5,
   "domain": null
  },
  {
   "name": "DSHB_REPORT",
   "type": "esriFieldTypeString",
   "alias": "DSHB_REPORT",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoOnly",
    "description": "Yes or No Only",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "METER_TYPE",
   "type": "esriFieldTypeString",
   "alias": "METER_TYPE",
   "length": 8,
   "domain": {
    "type": "codedValue",
    "name": "CE_Meter_Type",
    "description": "Citywworks Equipment Meter Types",
    "codedValues": [
     {
      "name": "MILES",
      "code": "MILES"
     },
     {
      "name": "HOURS",
      "code": "HOURS"
     },
     {
      "name": "N/A",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ASSET_TYPE",
   "type": "esriFieldTypeString",
   "alias": "ASSET TYPE",
   "length": 8,
   "domain": {
    "type": "codedValue",
    "name": "CE_Asset_Type",
    "description": "Cityworks Equipment Asset Types",
    "codedValues": [
     {
      "name": "NA",
      "code": "NA"
     },
     {
      "name": "LEASE",
      "code": "LEASE"
     },
     {
      "name": "PURCHASE",
      "code": "PURCHASE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MAINTENANCE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "MAINTENANCE TYPE",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "CE_Maint_Type",
    "description": "Cityworks Equipment Maintenance Types",
    "codedValues": [
     {
      "name": "NA",
      "code": "NA"
     },
     {
      "name": "FULL MAINTENANCE",
      "code": "FULL MAINTENANCE"
     },
     {
      "name": "MANAGED MAINTENANCE",
      "code": "MANAGED MAINTENANCE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LEASE_CONTRACT_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LEASE CONTRACT DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "LEASE_CONTRACT_MILES",
   "type": "esriFieldTypeInteger",
   "alias": "LEASE CONTRACT MILES",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R1892_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_1892",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G5998DEPARTMENT",
   "fields": "DEPARTMENT",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_1892",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "Department",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "DEPARTMENT",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null,
 "serviceItemId": "0f86b2922f3e4d5eb43bf80f2b03a63e"
}