Name: ExternalWallInsulation

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• ExternalWallInsulationInsulation (type: esriFieldTypeInteger, alias: Insulation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationInsulationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationInsulationNote1 (type: esriFieldTypeString, alias: Not as per Specification Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationInsulationNote2 (type: esriFieldTypeString, alias: Insulation does not cover accessible area, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationDetailingAroundWindowsDoors (type: esriFieldTypeInteger, alias: Detailing Around Windows/Doors, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationDetailingAroundWindowsDoorsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationDetailingAroundWindowsDoorsNote1 (type: esriFieldTypeString, alias: Detailing around Windows / Doors - Not as NSAI cert Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationDetailingAroundWindowsDoorsNote2 (type: esriFieldTypeString, alias: Not as per scheme standards Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationDetailingAroundWindowsDoorsNote3 (type: esriFieldTypeString, alias: Incomplete Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationDetailingAroundWindowsDoorsNote4 (type: esriFieldTypeString, alias: Using non approved fixtures/fittings/sills Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationIrregularities (type: esriFieldTypeInteger, alias: Irregularities, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationIrregularitiesReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationIrregularitiesNote1 (type: esriFieldTypeString, alias: Excessive contours on walls Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationIrregularitiesNote2 (type: esriFieldTypeString, alias: Not fixed securely, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationJointsAndSeals (type: esriFieldTypeInteger, alias: Joints and Seals, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationJointsAndSealsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationJointsAndSealsNote1 (type: esriFieldTypeString, alias: Joints and Seals - Not as NSAI cert Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilation (type: esriFieldTypeInteger, alias: Ventilation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationVentilationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote1 (type: esriFieldTypeString, alias: Insufficient ventilation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote2 (type: esriFieldTypeString, alias: Vents blocked Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote3 (type: esriFieldTypeString, alias: Permanent vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote4 (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)
• ExternalWallInsulationVentilationNote5 (type: esriFieldTypeString, alias: Mechanical vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote6 (type: esriFieldTypeString, alias: Background vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote7 (type: esriFieldTypeString, alias: Mechanical vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote8 (type: esriFieldTypeString, alias: Background vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote9 (type: esriFieldTypeString, alias: Permanent vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote10 (type: esriFieldTypeString, alias: Vents not sleeved Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote11 (type: esriFieldTypeString, alias: Roof ventilation compromised by External Insulation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationVentilationNote12 (type: esriFieldTypeString, alias: Not to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCables (type: esriFieldTypeInteger, alias: ESB Service Cables, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationESBServiceCablesReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCablesNote1 (type: esriFieldTypeString, alias: ESB Service Cables not in accordance with ESB Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCablesNote2 (type: esriFieldTypeString, alias: ESB cable buried under insulation not in accordance with ESB Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCablesNote3 (type: esriFieldTypeString, alias: ESB cable not clipped or in trunking not in accordance with ESB Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCablesNote4 (type: esriFieldTypeString, alias: Meter box has not been extended in accordance with ESB Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationESBServiceCablesNote5 (type: esriFieldTypeString, alias: ESB supply cable anchors not in accordance with ESB Job Aide Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationFlueInstallation (type: esriFieldTypeInteger, alias: Flue Installation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationFlueInstallationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationFlueInstallationNote1 (type: esriFieldTypeString, alias: Boiler flue compromised by works Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationFlueInstallationNote2 (type: esriFieldTypeString, alias: Flue graded incorrectly Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationExternalPlumbingFixing (type: esriFieldTypeInteger, alias: External Plumbing Fixing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationExternalPlumbingFixingReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationExternalPlumbingFixingNote1 (type: esriFieldTypeString, alias: External Plumbing Fixing - Not as per NSAI cert Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationExternalPlumbingFixingNote2 (type: esriFieldTypeString, alias: Partially Complete Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationExternalPlumbingFixingNote3 (type: esriFieldTypeString, alias: Not securely fixed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationExternalPlumbingFixingNote4 (type: esriFieldTypeString, alias: Not correctly reinstated Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationElectricalWork (type: esriFieldTypeInteger, alias: Electrical Work, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationElectricalWorkReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationElectricalWorkNote1 (type: esriFieldTypeString, alias: Not to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationGasServices (type: esriFieldTypeInteger, alias: Gas Services, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationGasServicesReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationGasServicesNote1 (type: esriFieldTypeString, alias: Gas meter box not in accordance with Bord Gais Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationGasServicesNote2 (type: esriFieldTypeString, alias: Gas pipe covered by insulation /not in accordance with Bord Gais Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationGasServicesNote3 (type: esriFieldTypeString, alias: Gas pipe not sleeved through insulation and wall in accordance with Bord Gais Job Aid Note Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationExternalFittings (type: esriFieldTypeInteger, alias: External Fittings, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationExternalFittingsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationExternalFittingsNote1 (type: esriFieldTypeString, alias: Fittings not re-instated (e.g. lights, gates etc) Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationCEMarkForInsulation (type: esriFieldTypeInteger, alias: CE Mark for Insulation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationCEMarkForInsulationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationCEMarkForInsulationNote1 (type: esriFieldTypeString, alias: No evidence that insulation has CE mark Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationNSAIAgrementCertificate (type: esriFieldTypeInteger, alias: NSAI Agrement Cert, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationNSAIAgrementCertificateReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationNSAIAgrementCertificateNote1 (type: esriFieldTypeString, alias: Not Provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ExternalWallInsulationNSAICertifiedInstaller (type: esriFieldTypeInteger, alias: NSAI Certified Installer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ExternalWallInsulationNSAICertifiedInstallerReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExternalWallInsulationNSAICertifiedInstallerNote1 (type: esriFieldTypeString, alias: No evidence that Installer is NSAI certified 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_ExternalWallInsulation (3) -- Related To: KSN___NDB_Scheme_Inspection_Form___Deep_Retrofit (14)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat