Name: PW.WASHOE.ASSETS_PLUM_EQUIPMENT

Display Field: AE_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: 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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: AE_PLUM_CAT

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BUILDING ( type: esriFieldTypeString, alias: BUILDING, length: 100 )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, length: 2 , Coded Values: [B: Basement] , [R: Roof] , [1: Ground Floor] , ...11 more... )
• ROOM ( type: esriFieldTypeString, alias: ROOM, length: 20 )
• SPECIFIC_LOCATION ( type: esriFieldTypeString, alias: SPECIFIC_LOCATION, length: 50 )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 12 , Coded Values: [PLUM: PLUMBING] , [HVAC: HVAC] , [FIRE: FIRE] , ...3 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 50 )
• FD_ID ( type: esriFieldTypeString, alias: FD_ID, length: 255 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 40 )
• MODEL_NUM ( type: esriFieldTypeString, alias: MODEL_NUM, length: 50 )
• SERIAL_NUM ( type: esriFieldTypeString, alias: SERIAL_NUM, length: 50 )
• COST_ORIGINAL ( type: esriFieldTypeDouble, alias: COST_ORIGINAL )
• DATE_INSTALLED ( type: esriFieldTypeDate, alias: DATE_INSTALLED, length: 8 )
• EQUIPMENT_NOTES ( type: esriFieldTypeString, alias: EQUIPMENT_NOTES, length: 255 )
• EQP_GIS_ID ( type: esriFieldTypeString, alias: EQP_GIS_ID, length: 10 )
• MANUFACTURE_DATE ( type: esriFieldTypeDate, alias: MANUFACTURE_DATE, length: 8 )
• CRITICALITY ( type: esriFieldTypeSmallInteger, alias: CRITICALITY , Coded Values: [0: MOST CRITICAL, $50k+ impact] , [25: ESSENTIAL, $25k impact] , [50: IMPORTANT, $10k impact] , ...2 more... )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION , Coded Values: [0: F – Need replaced to 20% useful life remaining] , [25: D - 20% to 40% useful life remaining] , [50: C - 40% to 60% useful life remaining] , ...2 more... )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST_EDIT_DATE, length: 8 )
• BLDG_GIS_ID ( type: esriFieldTypeGUID, alias: BLDG_GIS_ID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: PLUM_GlobalID, length: 38 )
• HP ( type: esriFieldTypeSingle, alias: HP )
• AMP ( type: esriFieldTypeSingle, alias: AMP )
• VOLT ( type: esriFieldTypeSmallInteger, alias: VOLT )
• PHASE ( type: esriFieldTypeSmallInteger, alias: PHASE )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 10 )
• AE_PLUM_CAT ( type: esriFieldTypeSmallInteger, alias: AE_PLUM_CAT )
• AE_PLUM_TYPE ( type: esriFieldTypeString, alias: AE_PLUM_TYPE, length: 150 )
• ASSET_COMP ( type: esriFieldTypeString, alias: ASSET_COMP, length: 3 , Coded Values: [COM: COMPONENT] , [ASS: PARENT ASSET] )
• PARENT ( type: esriFieldTypeString, alias: PARENT, length: 50 )
• EUL ( type: esriFieldTypeSmallInteger, alias: EUL )
• EDIT_FLAG ( type: esriFieldTypeString, alias: EDIT_FLAG, length: 3 , Coded Values: [!: !] , [-: .] )
• AE_NAME ( type: esriFieldTypeString, alias: AE_NAME, length: 100 )
• AE_ID ( type: esriFieldTypeString, alias: AE_ID, length: 50 )

Types:

ID: 4
Name: Backflow Prevention
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [BACKFLOW_PREVENTOR: BACKFLOW PREVENTOR] , [DRINKING_FOUNTAIN: DRINKING FOUNTAIN] , [WASTE_FLOOR_WASTE: FLOOR SINK] , ...18 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: Light Duty] , [2: Heavy Duty (Main Service)]
• ASSET_COMP:
  Inherited

---

ID: 5
Name: Water Softeners
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [BACKFLOW_PREVENTOR: BACKFLOW PREVENTOR] , [DRINKING_FOUNTAIN: DRINKING FOUNTAIN] , [WASTE_FLOOR_WASTE: FLOOR SINK] , ...18 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: All Water Softeners]
• ASSET_COMP:
  Inherited

---

ID: 7
Name: Snowmelt System
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: All Snowmelt Assets]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 1
Name: Water Heater
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [BACKFLOW_PREVENTOR: BACKFLOW PREVENTOR] , [DRINKING_FOUNTAIN: DRINKING FOUNTAIN] , [WASTE_FLOOR_WASTE: FLOOR SINK] , ...18 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: Electric, Normal Use] , [4: Gas Fired, Normal Use] , [5: Gas Fired, Heavy Use or Tankless] , ...2 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 3
Name: Pump
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [BACKFLOW_PREVENTOR: BACKFLOW PREVENTOR] , [DRINKING_FOUNTAIN: DRINKING FOUNTAIN] , [WASTE_FLOOR_WASTE: FLOOR SINK] , ...18 more...
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: Base Mounted] , [2: In-line] , [3: Sewage Ejector] , ...2 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 8
Name: AIr Compressors
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [All Reciprocating Air Compressors: All Reciprocating Air Compressors]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 9
Name: MISC
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [1: SAND OIL SEPARATOR] , [2: TANKS (STORAGE)] , [3: HVACR] , ...10 more...
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

ID: 10
Name: ELECTRIC MOTOR
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_PLUM_TYPE:
  Coded Values: [Without Soft Start: Without Soft Start] , [With Soft Start: With Soft Start]
• ASSET_COMP:
  Inherited
• EDIT_FLAG:
  Inherited

---

Relationships:

• BUILDING (2) -- Related To: PW.WASHOE.ASSETS_LOCATIONS (0)

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

  Iteminfo   Thumbnail   Metadata