Name: HVACComponent

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• AssetID ( type: esriFieldTypeString , alias: Asset ID (Tag) , length: 50 )
• AssetName ( type: esriFieldTypeString , alias: Asset Name , length: 100 )
• FacilitySiteName ( type: esriFieldTypeString , alias: Facility Site Name , length: 100 , Coded Values: [Main Facility: SLCWRRF - Main Facility] , [Influent Pump Station: SLCWRRF - Influent Pump Station] )
• ParentID ( type: esriFieldTypeString , alias: Parent ID , length: 50 )
• OrigEquipNumber ( type: esriFieldTypeString , alias: Original Equipment Number , length: 30 )
• Type ( type: esriFieldTypeString , alias: Type , length: 30 , Coded Values: [Fan: Fan] , [Heater: Heater] , [Louvers: Louvers] , ...4 more... )
• Criticality ( type: esriFieldTypeInteger , alias: Criticality , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• CriticalityComments ( type: esriFieldTypeString , alias: Criticality Comments , length: 255 )
• Condition ( type: esriFieldTypeInteger , alias: Condition , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ConditionComments ( type: esriFieldTypeString , alias: Condition Comments , length: 256 )
• StartUpDate ( type: esriFieldTypeDate , alias: Start Up Date , length: 8 )
• Location ( type: esriFieldTypeString , alias: Location , length: 200 )
• SerialNumber ( type: esriFieldTypeString , alias: Serial Number , length: 50 )
• ModelNumber ( type: esriFieldTypeString , alias: Model Number , length: 50 )
• Description ( type: esriFieldTypeString , alias: Description , length: 255 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , length: 50 )
• Vendor ( type: esriFieldTypeString , alias: Vendor , length: 50 )
• WarrantyDate ( type: esriFieldTypeDate , alias: Warranty Date , length: 8 )
• OriginalCost ( type: esriFieldTypeDouble , alias: Original Cost )
• ReplacementCost ( type: esriFieldTypeDouble , alias: Replacement Cost )
• EstimatedLife ( type: esriFieldTypeSmallInteger , alias: Estimated Life )
• Process ( type: esriFieldTypeString , alias: Process , length: 50 , Coded Values: [Influent Screening: Influent Screening] , [Primary Settling: Primary Settling] , [Secondary Settling: Secondary Settling] , ...16 more... )
• O_MLink ( type: esriFieldTypeString , alias: O&M Link , length: 255 )
• CIPName ( type: esriFieldTypeString , alias: CIP Name , length: 100 )
• CIPNumber ( type: esriFieldTypeString , alias: CIP Number , length: 20 )
• PurchaseDate ( type: esriFieldTypeDate , alias: Purchase Date , length: 8 )
• Classification ( type: esriFieldTypeString , alias: Classification , length: 50 , Coded Values: [Unclassified: Unclassified] , [Class 1 - Division 1: Class 1 - Division 1] , [Class 1 - Division 2: Class 1 - Division 2] )
• LifecycleStatus ( type: esriFieldTypeString , alias: Lifecycle Status , length: 20 , Coded Values: [Active: Active] , [Retired: Retired] , [Removed: Removed] , ...1 more... )
• Service ( type: esriFieldTypeString , alias: Service , length: 20 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Retired: Retired] )
• AirFlow ( type: esriFieldTypeString , alias: Air Flow , length: 10 , Coded Values: [Draw-Thru: Draw-Thru] , [Blow-Thru: Blow-Thru] )
• CFMRating ( type: esriFieldTypeSmallInteger , alias: CFM Rating )
• StaticPressureRating ( type: esriFieldTypeSmallInteger , alias: Static Pressure Rating )
• Drive ( type: esriFieldTypeString , alias: Drive , length: 10 , Coded Values: [Direct: Direct] , [Belt: Belt] , [Gearbox: Gearbox] , ...1 more... )
• PulleyDimensions_Motor ( type: esriFieldTypeDouble , alias: Pulley Dimensions_Motor (in) )
• PulleyDimensions_Fan ( type: esriFieldTypeDouble , alias: Pulley Dimensions_Fan (in) )
• BeltSize ( type: esriFieldTypeDouble , alias: Belt Size (in) )
• BeltQuantity ( type: esriFieldTypeSmallInteger , alias: Belt Quantity )
• InboardFanBearingNum ( type: esriFieldTypeString , alias: Inboard Fan Bearing # , length: 10 )
• OutboardFanBearingNum ( type: esriFieldTypeString , alias: Outboard Fan Bearing # , length: 10 )
• CouplingType ( type: esriFieldTypeString , alias: Coupling Type , length: 30 )
• CouplingSize ( type: esriFieldTypeDouble , alias: Coupling Size (in) )
• CoolingCoilDesc ( type: esriFieldTypeString , alias: Cooling Coil Description , length: 255 )
• FilterTypeDesc ( type: esriFieldTypeString , alias: Filter Type Description , length: 255 )
• FilterSize ( type: esriFieldTypeDouble , alias: Filter Size (in) )
• FilterQuantity ( type: esriFieldTypeSmallInteger , alias: Filter Quantity )
• EvaporatorStyle ( type: esriFieldTypeString , alias: Evaporator Style , length: 100 )
• EvaporatorDimensions ( type: esriFieldTypeString , alias: Evaporator Dimensions (in) , length: 10 )
• HumidificationInfo ( type: esriFieldTypeString , alias: Humidification Info , length: 255 )
• CompressorNamePlateInfo ( type: esriFieldTypeString , alias: Compressor Name Plate Info , length: 255 )
• HeaterElement ( type: esriFieldTypeString , alias: Heater Element Type , length: 20 , Coded Values: [Gas: Gas] , [Electric: Electric] , [Hydronic: Hydronic] )
• AddlHVACInfo ( type: esriFieldTypeString , alias: Additional HVAC Information , length: 255 )
• AddlOperatorInfo ( type: esriFieldTypeString , alias: Additional Operator Information , length: 255 )
• DCNewFields ( type: esriFieldTypeString , alias: DC_New Fields or Values , length: 255 )
• DCAddlComments ( type: esriFieldTypeString , alias: DC_Additional Comments , length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• PARENTGlobalID ( type: esriFieldTypeGUID , alias: PARENTGlobalID , length: 38 )

Relationships:

• Motor (358) -- Related To: Motor (72)
• Actuator (98) -- Related To: Actuator (14)
• HVAC (357) -- Related To: HVAC (61)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata