Name: PLUM

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: [Irrigation: Irrigation] , [Ice Maker: Ice Maker] , [Backflow: Backflow] , ...15 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 )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 50 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• CERTIFICATION_DATE ( type: esriFieldTypeDate, alias: Certification Date, length: 8 )
• SIZE_ ( type: esriFieldTypeString, alias: Size, length: 50 )
• APPLICATION ( type: esriFieldTypeString, alias: Application, length: 50 )
• GALLONS ( type: esriFieldTypeString, alias: Gallons, length: 50 )
• INTERIOR_EXTERIOR ( type: esriFieldTypeString, alias: Interior-Exterior, length: 50 )
• LIFECYCLE_YRS ( type: esriFieldTypeString, alias: Lifecycle Yrs, length: 50 )
• WARRANTY_YRS ( type: esriFieldTypeString, alias: Warranty Yrs, 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: Trap
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Josam: Josam] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 10
Name: Pump
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [B&G: B&G] , [Bell &Gosset: Bell &Gosset] , [Bryant: Bryant] , ...6 more...
• TYPE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• APPLICATION:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 13
Name: Walk-in Cooler
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Elkay: Elkay] , [GE: GE] , [Halsey Taylor: Halsey Taylor] , ...2 more...
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 12
Name: Valve
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Leonard: Leonard] , [Symmons: Symmons] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Manual: Manual] , [Sweat: Sweat] , [Thermostatic: Thermostatic] , ...2 more...
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 15
Name: Water Heater
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [AOSmith: AOSmith] , [Bradford: Bradford] , [Eemax: Eemax] , ...9 more...
• TYPE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 14
Name: Water Feature
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [MLK: MLK] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

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

---

ID: 16
Name: Well
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• TYPE:
  Coded Values: [Domestic Water Wells: Domestic Water Wells] , [Monitoring: Monitoring] , [Other: Other]
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 1
Name: Backflow
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Ames: Ames] , [Apollo: Apollo] , [Colt: Colt] , ...5 more...
• TYPE:
  Coded Values: [DC: DC] , [RPZ: RPZ] , [Other: Other]
• SIZE_:
  Coded Values: [1": 1"] , [1.5": 1.5"] , [2": 2"] , ...10 more...
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values: [Interior: Interior] , [Exterior: Exterior] , [Other: Other]
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

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

---

ID: 3
Name: Drain Pump
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Aurora: Aurora] , [B&G: B&G] , [Dayton: Dayton] , ...4 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 2
Name: Cistern
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Aboveground: Aboveground] , [Belowground: Belowground] , [Other: Other]
• SN:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 5
Name: Fountain
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Elkay: Elkay] , [GE: GE] , [Halsey Taylor: Halsey Taylor] , ...6 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Exterior: Exterior] , [Frost Free: Frost Free] , [Interior: Interior] , ...4 more...
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 4
Name: Eyewash Station
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Bradley: Bradley] , [Guardian: Guardian] , [Haws: Haws] , ...1 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Combo: Combo] , [Sink : Sink ] , [Wall: Wall] , ...1 more...
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 7
Name: Hose Bib
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Prier: Prier] , [Woodford: Woodford] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 6
Name: Grease Trap
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Josam: Josam] , [Smith: Smith] , [Zurn: Zurn] , ...1 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 9
Name: Irrigation
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Hunter: Hunter] , [Rain Bird: Rain Bird] , [Toro: Toro] , ...1 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Convention: Convention] , [Drip: Drip] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 8
Name: Ice Maker
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Ice-O-Matic: Ice-O-Matic] , [Manitowic: Manitowic] , [Other: Other]
• TYPE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• APPLICATION:
  Coded Values:
• GALLONS:
  Coded Values:
• INTERIOR_EXTERIOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata