Name: SolarInstallation

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)
• SolarInstallationSystemDetails (type: esriFieldTypeString, alias: System Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationSystemDetailsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationSystemDetailsNote1 (type: esriFieldTypeString, alias: System not designed as per specification Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSystemDetailsNote2 (type: esriFieldTypeString, alias: Cylinder not sized as per specification Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationInstallationOfCollectors (type: esriFieldTypeString, alias: Installation of Collectors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationInstallationOfCollectorsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationInstallationOfCollectorsNote1 (type: esriFieldTypeString, alias: Collectors not adequately fastened to the roof Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationControls (type: esriFieldTypeString, alias: Controls, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationControlsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationControlsNote1 (type: esriFieldTypeString, alias: The electrical controls, including immersion and temperature sensors are not operating correctly Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationControlsNote2 (type: esriFieldTypeString, alias: Temperature readings and controller settings incorrect Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationControlsNote3 (type: esriFieldTypeString, alias: Circulation pump not working correctly Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationDomesticHotWaterInstallation (type: esriFieldTypeString, alias: Domestic Hot Water Installation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationDomesticHotWaterInstallationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationDomesticHotWaterInstallationNote1 (type: esriFieldTypeString, alias: Anti-water boiling controls not in place Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationDomesticHotWaterInstallationNote2 (type: esriFieldTypeString, alias: No temperature interlock present between solar heated storage and auxiliary heating Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopAncillaryValves (type: esriFieldTypeString, alias: Solar Loop Ancillary/Valves, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationSolarLoopAncillaryValvesReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationSolarLoopAncillaryValvesNote1 (type: esriFieldTypeString, alias: Expansion and pressure release valve not installed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopAncillaryValvesNote2 (type: esriFieldTypeString, alias: Connection of solar loop to storage tank heat exchanger is incorrect Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopAncillaryValvesNote3 (type: esriFieldTypeString, alias: Expansion vessel not sized correctly as per specification Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopSystemDetails (type: esriFieldTypeString, alias: Solar Loop System Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationSolarLoopSystemDetailsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationSolarLoopSystemDetailsNote1 (type: esriFieldTypeString, alias: Pressure in the solar loop incorrect as per manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopPipework (type: esriFieldTypeString, alias: Solar Loop Pipework, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationSolarLoopPipeworkReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationSolarLoopPipeworkNote1 (type: esriFieldTypeString, alias: Pipe penetrations of building fabric not sealed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopPipeworkNote2 (type: esriFieldTypeString, alias: Leaks detected on solar loop pipework or system components Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationSolarLoopInsulation (type: esriFieldTypeString, alias: Solar Loop Insulation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationSolarLoopInsulationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationSolarLoopInsulationNote1 (type: esriFieldTypeString, alias: Inadequate pipe insulation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationElectrical (type: esriFieldTypeString, alias: Electrical, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationElectricalReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationElectricalNote1 (type: esriFieldTypeString, alias: Earthing incomplete Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationElectricalNote2 (type: esriFieldTypeString, alias: No non switchable spur visible/ poorly located Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationCEMark (type: esriFieldTypeString, alias: CE Mark, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationCEMarkReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationCEMarkNote1 (type: esriFieldTypeString, alias: No evidence of CE mark Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationCommissioningCertificate (type: esriFieldTypeString, alias: Commissioning Certificate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationCommissioningCertificateReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationCommissioningCertificateNote1 (type: esriFieldTypeString, alias: No evidence of Declaration of Conformity Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationDeclarationOfConformity (type: esriFieldTypeString, alias: Declaration of Conformity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationDeclarationOfConformityReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationDeclarationOfConformityNote1 (type: esriFieldTypeString, alias: No evidence of Commissioning Certificate Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationDocumentation (type: esriFieldTypeString, alias: Documentation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarInstallationDocumentationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarInstallationDocumentationNote1 (type: esriFieldTypeString, alias: No evidence of RECI/ETCI Certificate Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarInstallationDocumentationNote2 (type: esriFieldTypeString, alias: No evidence of Operation & Maintenance (O&M) Manual 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_SolarInstallation (7) -- 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