Name: CavityWallInsulation

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)
• CavityWallInsulationInsulation (type: esriFieldTypeInteger, alias: Insulation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationInsulationInsulationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationInsulationNote1 (type: esriFieldTypeString, alias: Not as per Specification Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationWallAreaToBeFilled (type: esriFieldTypeInteger, alias: Wall Area to be Filled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationInsulationWallAreaReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationWallAreaNote1 (type: esriFieldTypeString, alias: Insulation Does Not Fill Accessible Area Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationDrillPattern (type: esriFieldTypeInteger, alias: Drill Pattern, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationInsulationDrillPatternReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationDrillPatternNote1 (type: esriFieldTypeString, alias: Drill Hole Pattern not to NSAI certificate Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationDrillPatternNote2 (type: esriFieldTypeString, alias: Sealing of drill holes not to scheme standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationCavityBrushes (type: esriFieldTypeInteger, alias: Cavity Brushes, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationCavityBrushesReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationCavityBrushesNote1 (type: esriFieldTypeString, alias: Not as per Scheme Standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationCavityBrushesNote2 (type: esriFieldTypeString, alias: Required but not fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationTopOfCavitiesCapped (type: esriFieldTypeInteger, alias: Top of Cavities Capped, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationTopOfCavitiesCappedReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationTopOfCavitiesCappedNote1 (type: esriFieldTypeString, alias: Not closed to scheme standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationNSAIAgrementCert (type: esriFieldTypeInteger, alias: NSAI Agreement Cert, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationNSAIAgrementCertReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationNSAIAgrementCertNote1 (type: esriFieldTypeString, alias: Not Provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilation (type: esriFieldTypeInteger, alias: Ventilation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationVentilationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationVentilationNote1 (type: esriFieldTypeString, alias: Insufficient Ventilation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote2 (type: esriFieldTypeString, alias: Background vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote3 (type: esriFieldTypeString, alias: Mechanical vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote4 (type: esriFieldTypeString, alias: Vents blocked Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote5 (type: esriFieldTypeString, alias: Permanent vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote6 (type: esriFieldTypeString, alias: Permanent vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote7 (type: esriFieldTypeString, alias: Background vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote8 (type: esriFieldTypeString, alias: Mechanical vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote9 (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)
• CavityWallInsulationVentilationNote10 (type: esriFieldTypeString, alias: Vents not sleeved Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationVentilationNote11 (type: esriFieldTypeString, alias: Not to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationWallPenetrations (type: esriFieldTypeInteger, alias: Wall Penetrations, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationWallPenetrationsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationWallPenetrationsNote1 (type: esriFieldTypeString, alias: Not Sealed and Watertight Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationBeadAdhesive (type: esriFieldTypeInteger, alias: Bead Adhesive, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationBeadAdhesiveReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationBeadAdhesiveNote1 (type: esriFieldTypeString, alias: Insufficient Adhesive Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationBeadSpillage (type: esriFieldTypeInteger, alias: Bead Spillage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationBeadSpillageReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationBeadSpillageNote1 (type: esriFieldTypeString, alias: ESB Meter Box Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationBeadSpillageNote2 (type: esriFieldTypeString, alias: Gas Meter Box Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationElectrical (type: esriFieldTypeInteger, alias: Electrical, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationElectricalReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationElectricalNote1 (type: esriFieldTypeString, alias: Boiler Flue Compromised By Works Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CavityWallInsulationCEMarkForInsulation (type: esriFieldTypeInteger, alias: CE Mark for Insulation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CavityWallInsulationCEMarkForInsulationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CavityWallInsulationCEMarkForInsulationNote1 (type: esriFieldTypeString, alias: No Evidence That Insulation Has CE Mark 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_CavityWallInsulation (2) -- 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