Name: PW.WASHOE.ASSETS_FIRE_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_FIRE_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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: FIRE_GlobalID, length: 38 )
• EDIT_FLAG ( type: esriFieldTypeString, alias: EDIT_FLAG, length: 20 , Coded Values: [!: !] , [-: .] )
• 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 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 10 )
• AE_FIRE_CAT ( type: esriFieldTypeSmallInteger, alias: AE_FIRE_CAT )
• AE_FIRE_TYPE ( type: esriFieldTypeString, alias: AE_FIRE_TYPE, length: 50 )
• 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 )
• AE_NAME ( type: esriFieldTypeString, alias: AE_NAME, length: 100 )
• AE_ID ( type: esriFieldTypeString, alias: AE_ID, length: 50 )

Types:

ID: 2
Name: Fire Pumps
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: Electric Motor Driven] , [2: Engine Driven]
• ASSET_COMP:
  Inherited

---

ID: 3
Name: Sprinkler Systems
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: Heads] , [2: Piping Systems] , [3: Equipment and Devices (Flow Switch, Dry Pipe Valve, etc.)]
• ASSET_COMP:
  Inherited

---

ID: 4
Name: Security Systems
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: Activation Devices (Access Entry, Motion Sensor, etc.)] , [2: Notification Devices (Horn, Dialer)] , [3: Control Panels]
• ASSET_COMP:
  Inherited

---

ID: 5
Name: Closed Circuit TV System
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: Monitors] , [2: Pan and Tilt Motors] , [3: Cameras] , ...1 more...
• ASSET_COMP:
  Inherited

---

ID: 6
Name: Standby Power Supply: Battery
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: All Standby Power Supply: Battery]
• ASSET_COMP:
  Inherited

---

ID: 1
Name: Fire Alarm Systems
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [ALARM_PANEL: FIRE ALARM PANEL] , [ALARM_SYSTEM: FIRE ALARM SYSTEM] , [BREECHING_INLET: FIRE BREECHING INLET] , ...12 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_FIRE_TYPE:
  Coded Values: [1: Activation Devices (Pull Station, 10 Smoke Detector, et] , [2: Notification Devices (AV Horn/Strobe)] , [3: Control Panels] , ...1 more...
• ASSET_COMP:
  Inherited

---

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata