Name: ELEC

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: [Transformer: Transformer] , [Unknown: Unknown] , [Time Clock: Time Clock] , ...10 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 )
• SIZE_ ( type: esriFieldTypeString, alias: Size, length: 50 )
• AMPERAGE ( type: esriFieldTypeString, alias: Amperage, length: 50 )
• BREAKER_TYPE ( type: esriFieldTypeString, alias: Breaker Type, length: 50 )
• BULB_TYPE ( type: esriFieldTypeString, alias: Bulb Type, length: 50 )
• COLOR ( type: esriFieldTypeString, alias: Color, length: 50 )
• LIFECYCLE_YRS ( type: esriFieldTypeString, alias: Lifecycle Yrs, length: 50 )
• VOLTAGE ( type: esriFieldTypeString, alias: Voltage, 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: Other
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited

---

ID: 10
Name: UPS
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Powerware: Powerware] , [Other: Other]
• MODEL:
  Coded Values: [9315: 9315] , [9390: 9390] , [Other: Other]
• TYPE:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 1
Name: Battery
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values:
• MODEL:
  Coded Values:
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Dry: Dry] , [Gel: Gel] , [Sealed: Sealed] , ...2 more...
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• 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: Electrical Panel
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cutler Hammer: Cutler Hammer] , [Eaton: Eaton] , [Federal Pacific: Federal Pacific] , ...6 more...
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 2
Name: Battery Charger
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [AED C-Charger: AED C-Charger] , [Cummins: Cummins] , [Dayton: Dayton] , ...4 more...
• MODEL:
  Coded Values:
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Generator: Generator] , [Portable: Portable] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 5
Name: Lighting
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cooper: Cooper] , [Cree: Cree] , [GE: GE] , ...3 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Indoor: Indoor] , [Outdoor: Outdoor] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values: [CLF: CLF] , [FloresCent: FloresCent] , [Halogen: Halogen] , ...4 more...
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 4
Name: GFCI
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cooper: Cooper] , [Hubble: Hubble] , [Leviton: Leviton] , ...2 more...
• SN:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values: [15: 15] , [20: 20]
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values: [Almond: Almond] , [Black: Black] , [Brown: Brown] , ...5 more...
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 7
Name: Motor
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [AOSmith: AOSmith] , [Baldor: Baldor] , [Dayton: Dayton] , ...5 more...
• TYPE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 6
Name: Motion Sensor
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cooper: Cooper] , [Hubble: Hubble] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Ceiling: Ceiling] , [Wall: Wall] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 9
Name: Transformer
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Dongan: Dongan] , [Eaton: Eaton] , [EGS: EGS] , ...5 more...
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

ID: 8
Name: Time Clock
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Intermatic: Intermatic] , [Tork: Tork] , [York: York] , ...1 more...
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• SIZE_:
  Coded Values:
• AMPERAGE:
  Coded Values:
• BREAKER_TYPE:
  Coded Values:
• BULB_TYPE:
  Coded Values:
• COLOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• VOLTAGE:
  Coded Values:
• WARRANTY_YRS:
  Coded Values:
• EXISTING:
  Inherited

---

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata