Name: HVAC

Display Field: ASSET_TYPE

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: Asset_Type_Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSET_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type Subtype )
• ASSET_TYPE ( type: esriFieldTypeString, alias: Asset Type, length: 50 , Coded Values: [Air Compressor: Air Compressor] , [Air Handler: Air Handler] , [Boiler: Boiler] , ...16 more... )
• ASSET_TAG ( type: esriFieldTypeString, alias: Asset Tag, length: 20 )
• SITE ( type: esriFieldTypeString, alias: Site, length: 50 , Coded Values: [301 Building: 301 Building] , [310 W. Martin: 310 W. Martin] , [Alexander: Alexander] , ...261 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 50 )
• LEGACYID ( type: esriFieldTypeString, alias: Address, length: 50 )
• FLOOR ( type: esriFieldTypeString, alias: Floor, length: 20 , Coded Values: [Basement: Basement] , [1st Floor: 1st Floor] , [2nd Floor: 2nd Floor] , ...12 more... )
• ROOM_TYPE ( type: esriFieldTypeString, alias: Room Type, length: 50 , Coded Values: [Attic: Attic] , [Break Room: Break Room] , [Classroom: Classroom] , ...43 more... )
• ROOM_ID ( type: esriFieldTypeString, alias: Room ID, length: 20 )
• MAKE ( type: esriFieldTypeString, alias: Make, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• SN ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• LIFECYCLE_YRS ( type: esriFieldTypeString, alias: Lifecycle Yrs, length: 50 )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 50 )
• BUILD_NUMBER ( type: esriFieldTypeString, alias: Build Number, length: 50 )
• NUMBER_OF_FILTERS ( type: esriFieldTypeString, alias: Number of Filters, length: 50 )
• FUEL_TYPE ( type: esriFieldTypeString, alias: Fuel Type, length: 50 )
• SIZE_ ( type: esriFieldTypeString, alias: Size, length: 50 )
• FILTER_SIZE ( type: esriFieldTypeString, alias: Filter Size, length: 50 )
• FILTER_TYPE ( type: esriFieldTypeString, alias: Filter Type, length: 50 )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• EXISTING ( type: esriFieldTypeString, alias: Existing, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 250 )
• 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 )
• FO_ASSET_ID ( type: esriFieldTypeString, alias: FO_ASSET_ID, length: 20 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Types:

ID: 11
Name: Furnace
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Aaon: Aaon] , [Bryant: Bryant] , [Carrier: Carrier] , ...7 more...
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 10
Name: Exhaust Fan
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• INSTALL_DATE:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 13
Name: Variable Air Volume Box
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Carrier: Carrier] , [Kruger: Kruger] , [Prolan: Prolan] , ...2 more...
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 12
Name: Humidifier
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• INSTALL_DATE:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values: [Atomizer: Atomizer] , [Steam: Steam] , [Other: Other]
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 15
Name: Other
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited

---

ID: 14
Name: Variable Fan Drive
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [ABB: ABB] , [Danfoss: Danfoss] , [Other: Other]
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 1
Name: Air Compressor
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Devilbliss: Devilbliss] , [Ingrosol-Rand: Ingrosol-Rand] , [Quincy: Quincy] , ...3 more...
• INSTALL_DATE:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values: [Fixed: Fixed] , [Portable: Portable] , [Other: Other]
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 0
Name: Unknown
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited

---

ID: 3
Name: Boiler
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Locnivar: Locnivar] , [Peerless: Peerless] , [Raypak: Raypak] , ...2 more...
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 2
Name: Air Handler
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Aaon: Aaon] , [Amana: Amana] , [American Standard: American Standard] , ...14 more...
• INSTALL_DATE:
  Coded Values:
• TYPE:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_TYPE:
  Coded Values: [Bag: Bag] , [High Ffficiency: High Efficiency] , [Pleated: Pleated] , ...1 more...
• EXISTING:
  Inherited

---

ID: 5
Name: Coil
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• SN:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 4
Name: Chiller
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Carrier: Carrier] , [Trane: Trane] , [Other: Other]
• TYPE:
  Coded Values: [Mini Split: Mini Split] , [Other: Other]
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 7
Name: Cooling Tower
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [1st Company: 1st Company] , [Carrier: Carrier] , [Trane: Trane] , ...1 more...
• TYPE:
  Coded Values: [Closed Loop: Closed Loop] , [Other: Other]
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 6
Name: Condenser
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 9
Name: Energy Recovery Unit
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 8
Name: Damper
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• SN:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 17
Name: Gas Pack
Domains:
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [American Standard: American Standard] , [Bryant: Bryant] , [Carrier: Carrier] , ...9 more...
• TYPE:
  Coded Values:
• FUEL_TYPE:
  Coded Values: [American Standard: American Standard] , [Bryant: Bryant] , [Carrier: Carrier] , ...9 more...
• SIZE_:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 16
Name: Rooftop Unit
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [American Standard: American Standard] , [Bryant: Bryant] , [Carrier: Carrier] , ...9 more...
• TYPE:
  Coded Values:
• FUEL_TYPE:
  Coded Values: [Electric: Electric] , [Natural Gas: Natural Gas] , [Propane: Propane] , ...1 more...
• SIZE_:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 18
Name: Dehumidifier
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• LIFECYCLE_YRS:
  Coded Values:
• TYPE:
  Coded Values:
• BUILD_NUMBER:
  Coded Values:
• NUMBER_OF_FILTERS:
  Coded Values:
• FUEL_TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• FILTER_SIZE:
  Coded Values:
• FILTER_TYPE:
  Coded Values:
• EXISTING:
  Inherited

---

Relationships:

• FACILITY_AND_OPERATIONS_ASSETS (3) -- Related To: FACILITY AND OPERATIONS ASSETS (1)

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

  Iteminfo   Thumbnail   Metadata