Name: MVHR

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• MVHRSystem (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRSystemReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRSystemNote1 (type: esriFieldTypeString, alias: Insufficient ventilation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRSystemNote2 (type: esriFieldTypeString, alias: Not installed as per manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRSystemNote3 (type: esriFieldTypeString, alias: Excessive noise Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRSystemNote4 (type: esriFieldTypeString, alias: Distribution grilles not locked Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRSystemNote5 (type: esriFieldTypeString, alias: Barriers compromised by the installation of the system Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRSystemNote6 (type: esriFieldTypeString, alias: Not as per design Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutlets (type: esriFieldTypeString, alias: Inlets/Outlets, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRInletsOutletsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRInletsOutletsNote1 (type: esriFieldTypeString, alias: Vents blocked Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote2 (type: esriFieldTypeString, alias: Vents not sleeved Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote3 (type: esriFieldTypeString, alias: Not correctly positioned Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote4 (type: esriFieldTypeString, alias: Inlets not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote5 (type: esriFieldTypeString, alias: Outlets not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote6 (type: esriFieldTypeString, alias: Permanent vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote7 (type: esriFieldTypeString, alias: Permanent vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote8 (type: esriFieldTypeString, alias: Defunct inlets/outlets of the original system not decommissioned or removed where required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote9 (type: esriFieldTypeString, alias: Not as per manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote10 (type: esriFieldTypeString, alias: Mechanical extract ventilation advisory note not available Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote11 (type: esriFieldTypeString, alias: Mechanical extract ventilation installed in the same room as an open flued appliance Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote12 (type: esriFieldTypeString, alias: Movement sensors not installed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRInletsOutletsNote13 (type: esriFieldTypeString, alias: Insufficient distance between inlets and outlets Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRHeatRecoveryUnit (type: esriFieldTypeString, alias: Heat Recovery Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRHeatRecoveryUnitReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRHeatRecoveryUnitNote1 (type: esriFieldTypeString, alias: Spur not fitted/ Incorrect fuse fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRHeatRecoveryUnitNote2 (type: esriFieldTypeString, alias: Incorrectly fitted/ not safely fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRHeatRecoveryUnitNote3 (type: esriFieldTypeString, alias: Poorly sited (for safe electrical insolation, allow adequate cooling of air, minimise duct length) Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRHeatRecoveryUnitNote4 (type: esriFieldTypeString, alias: No suitable access for maintenance Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRHeatRecoveryUnitNote5 (type: esriFieldTypeString, alias: Not adequately insulated Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDucting (type: esriFieldTypeString, alias: Ducting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRDuctingReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRDuctingNote1 (type: esriFieldTypeString, alias: Not insulated where required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote2 (type: esriFieldTypeString, alias: Not adequately supported Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote3 (type: esriFieldTypeString, alias: Not sealed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote4 (type: esriFieldTypeString, alias: Excessive ducting or bends Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote5 (type: esriFieldTypeString, alias: Installed where it can be damaged Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote6 (type: esriFieldTypeString, alias: No boxing where required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote7 (type: esriFieldTypeString, alias: No fireproofing Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDuctingNote8 (type: esriFieldTypeString, alias: Metallic duct not earth bonded/ not to ETCI standards Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrain (type: esriFieldTypeString, alias: Condensate Drain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRCondensateDrainReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRCondensateDrainNote1 (type: esriFieldTypeString, alias: Not fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrainNote2 (type: esriFieldTypeString, alias: Not adequately supported Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrainNote3 (type: esriFieldTypeString, alias: Not insulated Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrainNote4 (type: esriFieldTypeString, alias: Insufficient back fall Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrainNote5 (type: esriFieldTypeString, alias: Condensate traps not fitted where required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRCondensateDrainNote6 (type: esriFieldTypeString, alias: Not correctly terminating Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDocumentation (type: esriFieldTypeString, alias: Documentation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRDocumentationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRDocumentationNote1 (type: esriFieldTypeString, alias: IVIA commissioning checklist sheet not completed/ not uploaded to the database Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRDocumentationNote2 (type: esriFieldTypeString, alias: Operation and maintenance manual not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MVHRContractorMakingGood (type: esriFieldTypeString, alias: Contractor Making Good, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MVHRContractorMakingGoodReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MVHRContractorMakingGoodNote1 (type: esriFieldTypeString, alias: Property not returned to manner in which it was found Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• KSN___NDB_Scheme_Inspection_Form___Deep_Retrofit_MVHR (11) -- Related To: KSN___NDB_Scheme_Inspection_Form___Deep_Retrofit (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/18/2021 3:17:17 AM

Schema Last Edit Date: 5/18/2021 3:17:17 AM

Data Last Edit Date: 5/18/2021 3:17:17 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat