Name: HVAC_1

Display Field: NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6430095ef73f4fd4b8943502a62803b6

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 50 )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 50 )
• TAG ( type: esriFieldTypeString, alias: TAG, length: 20 )
• SIZE_ ( type: esriFieldTypeString, alias: SIZE, length: 20 )
• ROOM_LOCATION ( type: esriFieldTypeString, alias: ROOM_LOCATION, length: 100 )
• NOTES ( type: esriFieldTypeString, alias: DESCRIPTION, length: 50 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, length: 8 )
• YEAR_ ( type: esriFieldTypeSmallInteger, alias: YEAR )
• EQUIP_TYPE ( type: esriFieldTypeString, alias: EQUIP_TYPE, length: 50 )
• USEFUL_LIFE ( type: esriFieldTypeString, alias: USEFUL_LIFE, length: 3 )
• CONDITION_RATING ( type: esriFieldTypeString, alias: CONDITION_RATING, length: 2 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 50 )
• PARENTID ( type: esriFieldTypeString, alias: PARENTID, length: 50 )
• PLANTID ( type: esriFieldTypeString, alias: PLANTID, length: 50 )
• CAPACITY ( type: esriFieldTypeString, alias: CAPACITY, length: 50 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 50 , Coded Values: [AIR CONDITIONER: AIR CONDITIONER] , [AIR CONDITIONING LIQUID CHILLER: AIR CONDITIONING LIQUID CHILLER] )
• REMAINING_LIFE ( type: esriFieldTypeString, alias: REMAINING_LIFE, length: 3 )
• PERCENT_CONSUMED ( type: esriFieldTypeString, alias: PERCENT CONSUMED, length: 4 )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 2 )
• MP2_ID_ ( type: esriFieldTypeString, alias: MP2_ID_, length: 40 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 1073741822 )
• SUBLOCATION1 ( type: esriFieldTypeString, alias: SUBLOCATION1, length: 100 )
• SUBLOCATION2 ( type: esriFieldTypeString, alias: SUBLOCATION2, length: 100 )
• SERIALNUM ( type: esriFieldTypeString, alias: SERIALNUM, length: 30 )
• MODELNUM ( type: esriFieldTypeString, alias: MODELNUM, length: 30 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 50 )
• VENDORID ( type: esriFieldTypeString, alias: VENDORID, length: 30 )
• AMP ( type: esriFieldTypeString, alias: AMP, length: 30 )
• BELT_LOWER ( type: esriFieldTypeString, alias: BELT_LOWER, length: 30 )
• BELT_UPPER ( type: esriFieldTypeString, alias: BELT_UPPER, length: 30 )
• FRAME ( type: esriFieldTypeString, alias: FRAME, length: 50 )
• HP ( type: esriFieldTypeString, alias: HP, length: 20 )
• HZ ( type: esriFieldTypeString, alias: HZ, length: 20 )
• KW ( type: esriFieldTypeString, alias: KW, length: 20 )
• LENGTH ( type: esriFieldTypeString, alias: LENGTH, length: 25 )
• LUBRICATION ( type: esriFieldTypeString, alias: LUBRICATION, length: 50 )
• PHASE ( type: esriFieldTypeString, alias: PHASE, length: 100 )
• PSI ( type: esriFieldTypeString, alias: PSI, length: 20 )
• RATIO ( type: esriFieldTypeString, alias: RATIO, length: 25 )
• ROTATION ( type: esriFieldTypeString, alias: ROTATION, length: 25 )
• RPM_INPUT ( type: esriFieldTypeString, alias: RPM_INPUT, length: 25 )
• RPM_OUTPUT ( type: esriFieldTypeString, alias: RPM_OUTPUT, length: 25 )
• RPM_STROKE ( type: esriFieldTypeString, alias: RPM_STROKE, length: 25 )
• VOLTS ( type: esriFieldTypeString, alias: VOLTS, length: 20 )
• WEIGHT ( type: esriFieldTypeString, alias: WEIGHT, length: 25 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• ASSETCONDITIONRATING ( type: esriFieldTypeSmallInteger, alias: ASSETCONDITIONRATING , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• PERFORMANCERATING ( type: esriFieldTypeSmallInteger, alias: PERFORMANCERATING )
• RELIABILITYRATING ( type: esriFieldTypeSmallInteger, alias: RELIABILITYRATING )
• MAINTAINABILITYRATING ( type: esriFieldTypeSmallInteger, alias: MAINTAINABILITYRATING )
• REPAIRHISTORYRATING ( type: esriFieldTypeSmallInteger, alias: REPAIRHISTORYRATING )
• PERCENTLIFECONSUMED ( type: esriFieldTypeSmallInteger, alias: PERCENTLIFECONSUMED )
• ASSETINSTALLDATE ( type: esriFieldTypeDate, alias: ASSETINSTALLDATE, length: 8 )
• MAXPOTENTIALLIFE ( type: esriFieldTypeSmallInteger, alias: MAXPOTENTIALLIFE )
• EFFECTIVEECONOMICLIFE ( type: esriFieldTypeSmallInteger, alias: EFFECTIVEECONOMICLIFE )
• EFFECTIVEUSEFULFLIFE ( type: esriFieldTypeSmallInteger, alias: EFFECTIVEUSEFULFLIFE )
• MAXNUMBERREHABS ( type: esriFieldTypeSmallInteger, alias: MAXNUMBERREHABS )
• LASTREHABDATE ( type: esriFieldTypeDate, alias: LASTREHABDATE, length: 8 )
• SOCIALCOF ( type: esriFieldTypeDouble, alias: SOCIALCOF , Range: [1, 10] )
• ENVIRONMENTALCOF ( type: esriFieldTypeDouble, alias: ENVIRONMENTALCOF , Range: [1, 10] )
• ECONOMICCOF ( type: esriFieldTypeDouble, alias: ECONOMICCOF , Range: [1, 10] )
• ASSETREDUNDANCY ( type: esriFieldTypeDouble, alias: ASSETREDUNDANCY )
• OTHERMITIGATIONALFACTOR ( type: esriFieldTypeDouble, alias: OTHERMITIGATIONALFACTOR )
• RESULTANTRISKSCORE ( type: esriFieldTypeDouble, alias: RESULTANTRISKSCORE )
• INHERENTRISKSCORE ( type: esriFieldTypeDouble, alias: INHERENTRISKSCORE )
• REPLACEMENTCOST ( type: esriFieldTypeDouble, alias: REPLACEMENTCOST )
• REHABCOST ( type: esriFieldTypeDouble, alias: REHABCOST )
• ANNUALOPERATIONALCOST ( type: esriFieldTypeDouble, alias: ANNUALOPERATIONALCOST )
• ANNUALMAINTENANCECOST ( type: esriFieldTypeDouble, alias: ANNUALMAINTENANCECOST )
• ANNUALADMINCOST ( type: esriFieldTypeDouble, alias: ANNUALADMINCOST , Range: [1, 10] )
• CIPINVESTMENT ( type: esriFieldTypeDouble, alias: CIPINVESTMENT , Range: [1, 10] )
• TABLENAME ( type: esriFieldTypeString, alias: TABLENAME, length: 25 )

Relationships:

• Building (1) -- Related To: Building (1)

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

  Iteminfo   Thumbnail   Metadata