Name: Compliance_Tracker

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Client (type: esriFieldTypeString, alias: Client, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Store_Number (type: esriFieldTypeInteger, alias: Store Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NR_property_ref_no_ (type: esriFieldTypeString, alias: NR property ref no., SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Transparency_Rating (type: esriFieldTypeInteger, alias: Transparency Rating, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Station (type: esriFieldTypeString, alias: Station, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Retail_Unit (type: esriFieldTypeString, alias: Retail Unit, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Unit_Risk (type: esriFieldTypeInteger, alias: Unit Risk, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Notes_and_Mitigation (type: esriFieldTypeString, alias: Notes and Mitigation, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Electrical_Installation_Conditi (type: esriFieldTypeDate, alias: Electrical Installation Condition Report 5 Yearly, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Annual_Emergency_Light_Test_Cer (type: esriFieldTypeDate, alias: Annual Emergency Light Test Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Annual_Gas_Safe_Certificate (type: esriFieldTypeDate, alias: Annual Gas Safe Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• F_Gas_Annual_Leak_Test_Certific (type: esriFieldTypeDate, alias: F-Gas Annual Leak Test Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• F_Gas_Register (type: esriFieldTypeString, alias: F-Gas Register, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Annual_Employers_Liability_Insu (type: esriFieldTypeDate, alias: Annual Employers Liability Insurance Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Buildings_Insurance (type: esriFieldTypeString, alias: Buildings Insurance, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Annual_Lift_Engineers_Test_Cert (type: esriFieldTypeDate, alias: Annual Lift Engineers Test Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• PSSR_Applicable___Pressurized_C (type: esriFieldTypeDate, alias: PSSR Applicable - Pressurized Coffee Machine Certificates, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Coffee_machine_PSSR_2 (type: esriFieldTypeDate, alias: Coffee machine PSSR 2, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Coffee_macine_PSSR_3 (type: esriFieldTypeDate, alias: Coffee macine PSSR 3, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Coffee_macine_PSSR_4 (type: esriFieldTypeDate, alias: Coffee macine PSSR 4, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Annual_Portable_Appliance_Test_ (type: esriFieldTypeDate, alias: Annual Portable Appliance Test Certificate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ANSUL_system_annual_service_dat (type: esriFieldTypeDate, alias: ANSUL system annual service date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Fire_appliance_annual_service_d (type: esriFieldTypeDate, alias: Fire appliance annual service date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Fire_Risk_Assessment__Annual_Re (type: esriFieldTypeDate, alias: Fire Risk Assessment (Annual Review Date), SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Asbestos_register_on_site (type: esriFieldTypeString, alias: Asbestos register on-site, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Legionella__Water_Chlorination (type: esriFieldTypeString, alias: Legionella/ Water Chlorination, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Electrical_Overdue (type: esriFieldTypeInteger, alias: Electrical Overdue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EmergencyLight_Overdue (type: esriFieldTypeInteger, alias: Emergency Light Overdue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gas_Overdue (type: esriFieldTypeInteger, alias: Gas Overdue, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/19/2020 2:05:47 PM

Schema Last Edit Date: 8/19/2020 2:05:47 PM

Data Last Edit Date: 8/19/2020 2:05:47 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat