Name: FM_Asset_Object

Display Field: iMSName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ebae4623ee6146baae930d07be14fac5

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset Identifier, length: 50 )
• Display ( type: esriFieldTypeString, alias: Display Name, length: 255 )
• Location ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• MaintBy ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• PrimaryImage ( type: esriFieldTypeString, alias: Primary Image, length: 255 )
• CondInspScore ( type: esriFieldTypeSmallInteger, alias: Condition Score )
• CondInspDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• InstallCost ( type: esriFieldTypeDouble, alias: Install Cost )
• ExpReplaceDate ( type: esriFieldTypeDate, alias: Exp Replace Date, length: 8 )
• ExpReplaceCost ( type: esriFieldTypeDouble, alias: Exp Replace Cost )
• Age ( type: esriFieldTypeDouble, alias: Age )
• Criticality ( type: esriFieldTypeString, alias: Criticality, length: 25 )
• iPoF ( type: esriFieldTypeDouble, alias: Failure Probability )
• iCoF ( type: esriFieldTypeDouble, alias: Failure Consequence )
• iBRE ( type: esriFieldTypeDouble, alias: Business Risk )
• iMSPU ( type: esriFieldTypeDouble, alias: Maint Under Perform )
• iMSPO ( type: esriFieldTypeDouble, alias: Maint Over Perform )
• iMSR ( type: esriFieldTypeDouble, alias: Maint Score )
• iMCFY ( type: esriFieldTypeSmallInteger, alias: Maint Curve Fast Yr )
• iMCSY ( type: esriFieldTypeSmallInteger, alias: Maint Curve Slow Yr )
• iMCAY ( type: esriFieldTypeSmallInteger, alias: Maint Curve Avg Yr )
• iMSName ( type: esriFieldTypeString, alias: Maint Strategy Name, length: 255 )
• iCalcDate ( type: esriFieldTypeDate, alias: OpInsights Calc Date, length: 8 )
• IndFacID ( type: esriFieldTypeString, alias: Indoors Facility Identifier, length: 255 )
• IndLevID ( type: esriFieldTypeString, alias: Indoors Level Identifier, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• LastActivityDate ( type: esriFieldTypeDate, alias: Last Service Date, length: 8 )
• LastActivityID ( type: esriFieldTypeString, alias: Last Activity Id, length: 255 )
• LastActivityDesc ( type: esriFieldTypeString, alias: Last Activity Type, length: 255 )
• ExpirationDate ( type: esriFieldTypeDate, alias: Expiration Date, length: 8 )
• structure_boundary_globalid ( type: esriFieldTypeGUID, alias: structure_boundary_globalid, length: 38 )
• FM_Asset_Group ( type: esriFieldTypeSmallInteger, alias: FM_Asset_Group , Coded Values: [0: Unknown] , [2: HVAC] , [3: Irrigation] , ...37 more... )
• FM_Asset_Type ( type: esriFieldTypeSmallInteger, alias: FM_Asset_Type , Coded Values: [0: Unknown] , [3: Automatic Transfer Switch Generator] , [5: AC System] , ...91 more... )
• purchasedate ( type: esriFieldTypeDate, alias: purchasedate, length: 8 )
• departmentid ( type: esriFieldTypeSmallInteger, alias: departmentid , Coded Values: [0: Unknown] , [1: Water Distribution] , [2: Wastewater Treatment Plant] , ...2 more... )
• fldLocationID ( type: esriFieldTypeString, alias: fldLocationID, length: 255 )
• fldEquipDescription ( type: esriFieldTypeString, alias: fldEquipDescription, length: 255 )
• fldEqTypeID ( type: esriFieldTypeString, alias: fldEqTypeID, length: 255 )
• UNFCObject ( type: esriFieldTypeString, alias: UNFCObject, length: 255 )
• fldModelNo ( type: esriFieldTypeString, alias: fldModelNo, length: 255 )
• fldSerialNo ( type: esriFieldTypeString, alias: fldSerialNo, length: 255 )
• fldAssetNo ( type: esriFieldTypeString, alias: fldAssetNo, length: 255 )
• fldDatePurch ( type: esriFieldTypeString, alias: fldDatePurch, length: 255 )
• fldPurchPrice ( type: esriFieldTypeDouble, alias: fldPurchPrice )
• fldDateInService ( type: esriFieldTypeString, alias: fldDateInService, length: 255 )
• fldWarrantyDays ( type: esriFieldTypeSmallInteger, alias: fldWarrantyDays )
• fldLifeExpectancy ( type: esriFieldTypeSmallInteger, alias: fldLifeExpectancy )
• fldInServiceStatus ( type: esriFieldTypeString, alias: fldInServiceStatus, length: 255 )
• fldComments ( type: esriFieldTypeString, alias: fldComments, length: 255 )
• fldEqTypeCode ( type: esriFieldTypeString, alias: fldEqTypeCode, length: 255 )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: ASSETGROUP )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: ASSETTYPE )
• structure_junction_globalid ( type: esriFieldTypeGUID, alias: Structure Junction Object GlobalID, length: 38 )
• fm_building_globalid ( type: esriFieldTypeGUID, alias: fm_building_globalid, length: 38 )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more... )
• model ( type: esriFieldTypeString, alias: model, length: 64 )
• fldEquipID ( type: esriFieldTypeSmallInteger, alias: fldEquipID )
• wwtps_site_globalid ( type: esriFieldTypeGUID, alias: wwtps_site_globalid, length: 38 )
• fldDepartmentID ( type: esriFieldTypeString, alias: fldDepartmentID, length: 255 )
• fldVendorID ( type: esriFieldTypeSmallInteger, alias: fldVendorID )
• fldMfgID ( type: esriFieldTypeSmallInteger, alias: fldMfgID )
• migratetogis ( type: esriFieldTypeString, alias: migratetogis, length: 255 )
• designtype ( type: esriFieldTypeSmallInteger, alias: designtype )
• fldEqPriorityID ( type: esriFieldTypeSmallInteger, alias: fldEqPriorityID )

Types:

ID: 0
Name: Uknown
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• lifecyclestatus:
  Inherited

---

ID: 1
Name: Emergency Backup Power
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [11: Automatic Transfer Switch Generator] , [12: Stationary Generator] , ...4 more...
• lifecyclestatus:
  Inherited

---

ID: 2
Name: HVAC
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [21: AC System] , [22: Exhaust Fan] , ...5 more...
• lifecyclestatus:
  Inherited

---

ID: 3
Name: Irrigation
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [31: Landscape Irrigation]
• lifecyclestatus:
  Inherited

---

ID: 4
Name: Weather Instrument
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [41: Rain Gauge]
• lifecyclestatus:
  Inherited

---

ID: 5
Name: Lifting Device
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [51: Bridge Crane] , [52: Electric Hoist] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 6
Name: Gate
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [101: Gate] , [102: Stop Log] , ...2 more...
• lifecyclestatus:
  Inherited

---

ID: 7
Name: Conveyor
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [701: Plow Belt Conveyor] , [702: Portable Belt Conveyor] , ...2 more...
• lifecyclestatus:
  Inherited

---

ID: 8
Name: Motor
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [81: Electric Motor]
• lifecyclestatus:
  Inherited

---

ID: 9
Name: Plumbing
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [91: Air Valve Lines] , [92: Chlorine Valve LInes] , ...3 more...
• lifecyclestatus:
  Inherited

---

ID: 10
Name: Access Control
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1001: Fence] , [1002: Gate] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 11
Name: Communication
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1101: Communication Repeater] , [1102: Communication Tower] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 12
Name: Cabinet
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1201: Lock Out Tag Out Cabinet] , [1202: Power Correction Cabinet] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 13
Name: Pressure Washer
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1301: Portable Pressure Washer]
• lifecyclestatus:
  Inherited

---

ID: 14
Name: Control Panel
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1401: Blower Control Panel] , [1402: Control Panel] , ...8 more...
• lifecyclestatus:
  Inherited

---

ID: 15
Name: Controller
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1501: Actuator] , [1502: Chlorine Regulator] , ...6 more...
• lifecyclestatus:
  Inherited

---

ID: 16
Name: UV System
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1601: UV Acid Bath] , [1602: UV Bank] , ...3 more...
• lifecyclestatus:
  Inherited

---

ID: 17
Name: SCADA
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1701: SCADA Computer System] , [1702: SCADA Field Interface Unit]
• lifecyclestatus:
  Inherited

---

ID: 19
Name: Gear
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1901: Gear Box] , [1902: Speed Reducer]
• lifecyclestatus:
  Inherited

---

ID: 20
Name: Mixer
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [201: PAX Mixer] , [202: Post Aeration MIxer] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 21
Name: NA
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• lifecyclestatus:
  Inherited

---

ID: 22
Name: N/A
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• lifecyclestatus:
  Inherited

---

ID: 23
Name: Auger
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Uknown] , [2301: Lime Auger] , [2302: Lime Feed Auger] , ...3 more...
• lifecyclestatus:
  Inherited

---

ID: 24
Name: Storage
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2401: Lime Silo] , [2402: Sludge Dumpster]
• lifecyclestatus:
  Inherited

---

ID: 25
Name: Blower
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2501: Aeration Blower] , [2502: Belt Press Lime Blower]
• lifecyclestatus:
  Inherited

---

ID: 26
Name: Cathodic Protection
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2601: Cathodic Protection]
• lifecyclestatus:
  Inherited

---

ID: 27
Name: Biofilter
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2701: Biofilter Irrigation] , [2702: Biofilters] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 28
Name: Final Clarifier
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2801: Algae Sweep] , [2802: Center Ring]
• lifecyclestatus:
  Inherited

---

ID: 29
Name: Lighting
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [2901: Aviation Light] , [2902: Yard Lighting]
• lifecyclestatus:
  Inherited

---

ID: 30
Name: Odor Control
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [301: Odor Control System]
• lifecyclestatus:
  Inherited

---

ID: 31
Name: Dumpster Veyor
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3101: Dumpster Veyor] , [3102: Dumpster Veyor Tracks]
• lifecyclestatus:
  Inherited

---

ID: 32
Name: Screen
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3201: Debris Screeen] , [3202: Filter Screen] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 33
Name: Plow
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3301: Plow]
• lifecyclestatus:
  Inherited

---

ID: 34
Name: Room
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3401: Belt Press Office] , [3402: PTA Grit Snail Room] , ...7 more...
• lifecyclestatus:
  Inherited

---

ID: 36
Name: Sequencing Batch Reactor
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3601: Scum Collector]
• lifecyclestatus:
  Inherited

---

ID: 37
Name: Bin Activator
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• lifecyclestatus:
  Inherited

---

ID: 38
Name: Biosolids Storage Area Belt Press
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3801: Sludge Staging Area] , [3802: Y Strainer Cleanout] , ...1 more...
• lifecyclestatus:
  Inherited

---

ID: 39
Name: Grinder
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3901: Channel Grinder]
• lifecyclestatus:
  Inherited

---

ID: 35
Name: Grit
Domains:
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• FM_Asset_Group:
  Inherited
• FM_Asset_Type:
  Inherited
• departmentid:
  Inherited
• ASSETTYPE:
  Coded Values: [0: Unknown] , [3501: Grit Chamber] , [3502: Grit Slurry Cup] , ...1 more...
• lifecyclestatus:
  Inherited

---

Relationships:

• StructureJunctionObject (11) -- Related To: Structure Junction Object (11)
• FM_Building (9) -- Related To: FM Building (1)
• StructureBoundary (5) -- Related To: Structure Boundary (5)

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

  Iteminfo   Thumbnail   Metadata