Name: HVAC

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: HVAC
  Description:
  Prototype:
  DCAddlComments: null
  PARENTGlobalID: null
  AssetID:
  AssetName: null
  FacilitySiteName: null
  ParentID: null
  OrigEquipNumber: null
  Type: null
  Criticality: null
  CriticalityComments: null
  Condition: null
  ConditionComments: null
  StartUpDate: null
  Location: null
  SerialNumber: null
  ModelNumber: null
  Description: null
  Manufacturer: null
  Vendor: null
  WarrantyDate: null
  OriginalCost: null
  ReplacementCost: null
  EstimatedLife: null
  Process: null
  O_MLink: null
  CIPName: null
  CIPNumber: null
  PurchaseDate: null
  Classification: null
  LifecycleStatus: null
  Service: null
  AirFlow: null
  CFMRating: null
  StaticPressureRating: null
  Drive: null
  PulleyDimensions_Motor: null
  PulleyDimensions_Fan: null
  BeltSize: null
  BeltQuantity: null
  InboardFanBearingNum: null
  OutboardFanBearingNum: null
  CouplingType: null
  CouplingSize: null
  CoolingCoilDesc: null
  FilterTypeDesc: null
  FilterSize: null
  FilterQuantity: null
  EvaporatorStyle: null
  EvaporatorDimensions: null
  HumidificationInfo: null
  CompressorNamePlateInfo: null
  HeaterElement: null
  AddlHVACInfo: null
  AddlOperatorInfo: null
  DCNewFields: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Motor (353) -- Related To: Motor (72)
• Instrumentation (354) -- Related To: Instrumentation (64)
• Filter (294) -- Related To: Filter (44)
• ElectricalEquipment (275) -- Related To: ElectricalEquipment (39)
• ControlPanel (237) -- Related To: ControlPanel (31)
• Actuator (97) -- Related To: Actuator (14)
• Valve (355) -- Related To: Valve (101)
• BlowerUnit (190) -- Related To: BlowerUnit (23)
• Heater (341) -- Related To: Heater (58)
• PumpUnit (356) -- Related To: PumpUnit (80)
• HeatExchanger (347) -- Related To: HeatExchanger (59)
• Fan (291) -- Related To: Fan (43)
• HVACComponent (357) -- Related To: HVACComponent (62)
• Area (135) -- Related To: Area (18)
• Basin (19) -- Related To: Basin (7)
• Building (31) -- Related To: Building (8)
• Valve_Vault (8) -- Related To: Valve_Vault (4)
• AirDryer (110) -- Related To: AirDryer (16)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata