Name: PW.WASHOE.ASSETS_ELEC_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_ELEC_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 )
• SERVICE_AREA ( type: esriFieldTypeString, alias: SERVICE_AREA, length: 20 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: ELEC_GlobalID, length: 38 )
• EDIT_FLAG ( type: esriFieldTypeString, alias: EDIT_FLAG, length: 20 , Coded Values: [!: !] , [-: .] )
• SECTION ( type: esriFieldTypeString, alias: SECTION, length: 50 )
• 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 )
• 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_ELEC_CAT ( type: esriFieldTypeSmallInteger, alias: AE_ELEC_CAT )
• AE_ELEC_TYPE ( type: esriFieldTypeString, alias: AE_ELEC_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 )
• AE_NAME ( type: esriFieldTypeString, alias: AE_NAME, length: 100 )
• AE_ID ( type: esriFieldTypeString, alias: AE_ID, length: 50 )

Types:

ID: 3
Name: Electric Motors
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [DOOR_ALARMS: DOOR ALARMS] , [EXIT_LIGHTS: EMERGENCY & EXIT LIGHTS] , [EXTERIOR_&_PARKING_LOT_LIGHTS: EXTERIOR & PARKING LOT LIGHTS] , ...7 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: Non-HVAC Electric Motors] , [2: Test]
• ASSET_COMP:
  Inherited

---

ID: 10
Name: Uninterrupted Power Supply
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [DOOR_ALARMS: DOOR ALARMS] , [EXIT_LIGHTS: EMERGENCY & EXIT LIGHTS] , [EXTERIOR_&_PARKING_LOT_LIGHTS: EXTERIOR & PARKING LOT LIGHTS] , ...7 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: Battery] , [2: Rotary]
• ASSET_COMP:
  Inherited

---

ID: 9
Name: Solar Photovoltaic Collector Panels
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [DOOR_ALARMS: DOOR ALARMS] , [EXIT_LIGHTS: EMERGENCY & EXIT LIGHTS] , [EXTERIOR_&_PARKING_LOT_LIGHTS: EXTERIOR & PARKING LOT LIGHTS] , ...7 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: All Solar Photovoltaic Collector Panels] , [2: SOLAR INVERTER]
• ASSET_COMP:
  Inherited

---

ID: 1
Name: Automatic Transfer Switch
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [DOOR_ALARMS: DOOR ALARMS] , [EXIT_LIGHTS: EMERGENCY & EXIT LIGHTS] , [EXTERIOR_&_PARKING_LOT_LIGHTS: EXTERIOR & PARKING LOT LIGHTS] , ...7 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: All Automatic Transfer Switch]
• ASSET_COMP:
  Inherited

---

ID: 7
Name: Motor Control Center
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• TYPE:
  Coded Values: [DOOR_ALARMS: DOOR ALARMS] , [EXIT_LIGHTS: EMERGENCY & EXIT LIGHTS] , [EXTERIOR_&_PARKING_LOT_LIGHTS: EXTERIOR & PARKING LOT LIGHTS] , ...7 more...
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: All Motor Control Center]
• ASSET_COMP:
  Inherited

---

ID: 5
Name: Generator
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: All Emergency Engine Generator Set]
• ASSET_COMP:
  Inherited

---

ID: 8
Name: Computer
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [1: All Computer]
• ASSET_COMP:
  Inherited

---

ID: 11
Name: Oil Storage Tank with Corrosion Protection
Domains:
• FLOOR:
  Inherited
• CLASS:
  Inherited
• EDIT_FLAG:
  Inherited
• CRITICALITY:
  Inherited
• CONDITION:
  Inherited
• AE_ELEC_TYPE:
  Coded Values: [Above Ground: Above Ground] , [Underground: Underground] , [Underground: FRP Coated Steel: Underground: FRP Coated Steel]
• ASSET_COMP:
  Inherited

---

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata