Name: DCV

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)
• DCVSystem (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVSystemReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVSystemNote1 (type: esriFieldTypeString, alias: Insufficient ventilation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVSystemNote2 (type: esriFieldTypeString, alias: Not installed as per manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVSystemNote3 (type: esriFieldTypeString, alias: Excessive noise Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVSystemNote4 (type: esriFieldTypeString, alias: Barriers compromised by the installation of the system Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVSystemNote5 (type: esriFieldTypeString, alias: Not as per design Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutlets (type: esriFieldTypeString, alias: Inlets/Outlets, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVInletsOutletsReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVInletsOutletsNote1 (type: esriFieldTypeString, alias: Vents blocked Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote2 (type: esriFieldTypeString, alias: Vents not sleeved Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote3 (type: esriFieldTypeString, alias: Not correctly positioned Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote4 (type: esriFieldTypeString, alias: Inlets not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote5 (type: esriFieldTypeString, alias: Outlets not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote6 (type: esriFieldTypeString, alias: Permanent vent not fitted but required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote7 (type: esriFieldTypeString, alias: Permanent vent not installed to standard Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote8 (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)
• DCVInletsOutletsNote9 (type: esriFieldTypeString, alias: Not as per manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote10 (type: esriFieldTypeString, alias: Mechanical extract ventilation advisory note not available Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVInletsOutletsNote11 (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)
• DCVFan (type: esriFieldTypeString, alias: Fan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVFanReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVFanNote1 (type: esriFieldTypeString, alias: Spur not fitted/ Incorrect fuse fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVFanNote2 (type: esriFieldTypeString, alias: Incorrectly fitted/ not safely fitted Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVFanNote3 (type: esriFieldTypeString, alias: No suitable access for maintenance Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVFanNote4 (type: esriFieldTypeString, alias: Poorly sited/ not installed as such to minimise duct length and restrictions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDucting (type: esriFieldTypeString, alias: Ducting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVDuctingReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVDuctingNote1 (type: esriFieldTypeString, alias: Not insulated Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote2 (type: esriFieldTypeString, alias: Not adequately supported Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote3 (type: esriFieldTypeString, alias: Not sealed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote4 (type: esriFieldTypeString, alias: Excessive ducting or bends Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote5 (type: esriFieldTypeString, alias: Installed where it can be damaged Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote6 (type: esriFieldTypeString, alias: No boxing where required Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDuctingNote7 (type: esriFieldTypeString, alias: No fire proofing Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVDocumentation (type: esriFieldTypeString, alias: Documentation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVDocumentationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVDocumentationNote1 (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)
• DCVDocumentationNote2 (type: esriFieldTypeString, alias: Operation and maintenance manual not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DCVContractorMakingGood (type: esriFieldTypeString, alias: Contractor Making Good, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DCVContractorMakingGoodReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCVContractorMakingGoodNote1 (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_DCV (12) -- 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