Name: HVAC_1

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e5c8418c6a9347388df92fe100e70b43

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, 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
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:

Fields:

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

Templates:

• Name: HVAC_1
  Description:
  Prototype:
  CIPINVESTMENT: null
  TABLENAME: null
  ASSET_TYPE: HVAC
  NAME: null
  TAG: null
  SIZE_: null
  ROOM_LOCATION: null
  NOTES: null
  INSTALL_DATE: null
  YEAR_: null
  EQUIP_TYPE: null
  USEFUL_LIFE: null
  CONDITION_RATING: null
  ASSETID: null
  PARENTID: null
  PLANTID: MCDOWELL_CREEK
  CAPACITY: null
  TYPE: null
  REMAINING_LIFE: null
  PERCENT_CONSUMED: null
  CONDITION: null
  MP2_ID_: null
  DESCRIPTION: null
  SUBLOCATION1: null
  SUBLOCATION2: null
  SERIALNUM: null
  MODELNUM: null
  MANUFACTURER: null
  VENDORID: null
  AMP: null
  BELT_LOWER: null
  BELT_UPPER: null
  FRAME: null
  HP: null
  HZ: null
  KW: null
  LENGTH: null
  LUBRICATION: null
  PHASE: null
  PSI: null
  RATIO: null
  ROTATION: null
  RPM_INPUT: null
  RPM_OUTPUT: null
  RPM_STROKE: null
  VOLTS: null
  WEIGHT: null
  LOCATION: null
  ASSETCONDITIONRATING: null
  PERFORMANCERATING: null
  RELIABILITYRATING: null
  MAINTAINABILITYRATING: null
  REPAIRHISTORYRATING: null
  PERCENTLIFECONSUMED: null
  ASSETINSTALLDATE: null
  MAXPOTENTIALLIFE: null
  EFFECTIVEECONOMICLIFE: null
  EFFECTIVEUSEFULFLIFE: null
  MAXNUMBERREHABS: null
  LASTREHABDATE: null
  SOCIALCOF: null
  ENVIRONMENTALCOF: null
  ECONOMICCOF: null
  ASSETREDUNDANCY: null
  OTHERMITIGATIONALFACTOR: null
  RESULTANTRISKSCORE: null
  INHERENTRISKSCORE: null
  REPLACEMENTCOST: null
  REHABCOST: null
  ANNUALOPERATIONALCOST: null
  ANNUALMAINTENANCECOST: null
  ANNUALADMINCOST: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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