MAGENTUS SOFTWARE LIMITED

DMS - SQL Suite - Data Extraction / Reporting Services

SQLSuite is a fully automated solution for harnessing health data. Providing data management services supporting business intelligence, risk stratification, medicines optimisation and clinical research, along with GP data extraction services.

Features

• Fully identifiable, pseudonymised or anonymised datasets can be created.
• Flexible output locations.
• Strong, approved consent model and process.
• Flexible managed scheduling capabilities.
• Multi-project participation.
• Fully managed automated extraction service.
• Secure encrypted data transfer.
• Automated update mechanism.
• Cross principal GP system normalised outputs.
• Compatible with all clinical coding systems.

Benefits

• Single source for data requirements regardless of GP Practice system.
• Normalised/Standardised data format regardless of the originating GP system.
• Proven track record delivering local, regional, national studies/projects.
• Managed implementation from scoping to go-live.
• Fully managed service, guiding/advising on best methods and processes.
• Assist customers with data specification.
• Assist Customers with IG and Consent Models.
• Remotely monitored support service.
• GPSOC IM1 bulk interface accredited against all principal systems.

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at uk-sales@magentus.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 15

Service ID

173475095718566

Contact

Paula Hadley
07512 303299
uk-sales@magentus.com

About your service

• Service categories:

  Application Development and Deployment

  Analytics and business intelligence

  • Advanced and predictive analytics
• Multi cloud support: No

Service scope

• Software add-on or extension: No
• Cloud deployment model: Hybrid cloud
• Service constraints: Primary Supplier data is provided via NHS Digital's ‘IM1 Bulk interface’ and can be up to 48 hours old, so should not be used for direct patient care.
• System requirements:
  • .NET Framework 4.7+
  • HTTPS access to Magnetus webservices

User support

• Email or online ticketing support: Yes
• Support response times: In line with SLA outlined within the customer contract.
• User can manage status and priority of support tickets: No
• Phone support: Yes
• Phone support availability: 9 to 5 (UK time), Monday to Friday
• Web chat support: No
• Onsite support: No
• Support levels: Technical team provide full customer support who also liaise with our 3rd Line Support with advanced technical skills where required. Service Lead manages 2 Delivery Leads who oversee the technical team.
• Support available to third parties: Yes

Onboarding and offboarding

• Getting started: User documentation. 3rd Line can assist remotely if required.
• Service documentation: Yes
• Documentation formats:
  • PDF
  • Other
• Other documentation formats: MS Word
• End-of-contract data extraction: Not Applicable. All query schedules are disabled. Primary supplier data is disposed of and feeds stopped, if there are no other projects reliant upon it.; Data is deleted when project ends
• End-of-contract process: All query schedules are disabled. Primary supplier data is disposed of and feeds stopped, if there are no other projects reliant upon it. Data is deleted when project ends
• Documentation accessibility standard: None or don’t know
• How the documentation is accessible: Secured internal location.

Using the service

• Web browser interface: No
• Application to install: Yes
• Compatible operating systems: Windows
• Designed for use on mobile devices: No
• Service interface: Yes
• User support accessibility: None or don’t know
• Description of service interface: Windows desktop application, allowing GP practice users with reporting options.
• Accessibility standards: None or don’t know
• Description of accessibility: Users can run predefined reports
• Accessibility testing: Not Applicable.
• API: No
• Customisation available: Yes
• Description of customisation: Queries are developed based on customer specifications.

Scaling

• Independence of resources: Scheduling of reports are monitored by Service team and distributed accordingly.

Analytics

• Service usage metrics: Yes
• Metrics types: Customer variance reports.
• Reporting types: Regular reports
• Resource tagging: Yes
• FOCUS resource tagging: Yes

Resellers

• Supplier type: Not a reseller

Staff security

• Staff security clearance: Other security clearance
• Government security clearance: None

Asset protection

• Knowledge of data storage and processing locations: Yes
• Data storage and processing locations: United Kingdom
• User control over data storage and processing locations: No
• Datacentre security standards: Complies with a recognised standard (for example CSA CCM version 4.0)
• Penetration testing frequency: At least once a year
• Penetration testing approach: ‘IT Health Check’ performed by a CREST-approved service provider
• Protecting data at rest: Physical access control, complying with another standard
• Data sanitisation process: Yes
• Equipment disposal approach: A third-party destruction service
• Data sanitisation type: Deleted data can’t be directly accessed / Cryptographic Erasure

Data importing and exporting

• Data export approach: There is no user export function. Outputs generated from SQLSuite are sent directly to customer defined end points.
• Data export formats: CSV
• Data import formats: CSV

Data-in-transit protection

• Data protection between buyer and supplier networks:
  • Private network or public sector network
  • TLS (version 1.2 or above)
  • Other
• Other protection between networks: All payloads are transported point to point using our bespoke A2 software, via secure SFTP using Public/Private key authentication, or via S3 over HTTPS. The payloads themselves are also secured using a combination of AES 256-bit and RSA 2048-bit encryption.; the above is inline with NHS England Approved Cryptographic Algorithms Good Practice Guideline
• Data protection within supplier network:
  • TLS (version 1.2 or above)
  • Other
• Other protection within supplier network: All data in transit is secured using a combination of AES 256-bit and RSA 2048-bit encryption.

Availability and resilience

• Guaranteed availability: SLA is outlined in commercial discussions and any breach of SLA is immediately reviewed with the technical teams and if a 3rd party have incurred the SLA breach.
• Approach to resilience: AWS provides Single instance uptime percentage of at least 99.5%.
• Outage reporting: Service outages are provided via our Service team, via email alerts.

Identity and authentication

• User authentication needed: Yes
• User authentication: Limited access network (for example PSN)
• Access restrictions in management interfaces and support channels: There are 2 use cases.; 1. Operational Support - This is restricted to Magentus staff and by IP address. Access is HTTPS via HSCN network only.; 2. Service - Communication is via HTTPS providing key/token pair.
• Access restriction testing frequency: At least once a year
• Management access authentication: Limited access network (for example PSN)

Audit information for users

• Access to user activity audit information: No audit information available
• Access to supplier activity audit information: Users contact the support team to get audit information
• How long supplier audit data is stored for: At least 12 months
• How long system logs are stored for: At least 12 months

Security governance

• Named board-level person responsible for service security: Yes
• Security governance certified: Yes
• Security governance standards:
  • ISO/IEC 27001
  • Other
• Other security governance standards: Cyber Essentials Plus
• Information security policies and processes: Policies are reviewed / updated regularly. Internal and external audits are performed on a scheduled basis. Cyber Security training on a monthly basis. All new staff undertake mandatory IG/ IS training.
• Software Security Code of Practice: Yes

Operational security

• Configuration and change management standard: Complies with a recognised standard, for example CSA CCM v4.0 or SSAE-18 / ISAE 3402
• Configuration and change management approach: ISO 27001 A12 - Change Management Policy.
• Vulnerability management type: Undisclosed
• Vulnerability management approach: Tenable scheduled. Patches applied within 3 days.
• Protective monitoring type: Undisclosed
• Protective monitoring approach: DMS 3rd line Support identify risks and are logged / escalated appropriately. Cyber Security suite actively monitors environments to protect against malware, AV, etc.
• Incident management type: Undisclosed
• Incident management approach: ISO 27001 A16 - Incident Management Process
• Post-quantum cryptography secure: No

Secure development

• Approach to secure software development best practice: Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v4.0)

Public sector networks

• Connection to public sector networks: Yes
• Connected networks: Health and Social Care Network (HSCN)

Pricing

• Discount for educational organisations: No
• Free trial available: No

Discount percentage by annual call-off contract value (excluding VAT)

• Less than £250,000: 0%
• Between £250,000 and £500,000: 0%
• Between £500,001 and £1,000,000: 0%
• Between £1,000,001 and £2,500,000: 0%
• Between £2,500,001 and £5,000,000: 0%
• Over £5,000,001: 0%

Non-mandatory Standards and certifications

• ISO/IEC 27001 certification: Yes
• Who accredited the ISO/IEC 27001: Bsi
• ISO/IEC 27001 accreditation date: Sunday 21 April 2024
• What the ISO/IEC 27001 doesn’t cover: Not applicable - all delivery of software and services is covered by our ISO 27001 certification.
• ISO 28000:2022 certification: No
• ISO 9001 certification: Yes
• Who accredited the ISO 9001 certification: Bsi
• ISO 9001 accreditation date: Tuesday 6 February 2024
• What the ISO 9001 doesn’t cover: Not Applicable - all delivery of software and services is covered by our ISO 9001 certification.
• Quality management systems (QMS): Yes
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: No
• Cyber Essentials Alternative: None of the criteria
• Cyber essentials plus: Yes
• Please provide your Cyber Essentials Plus Certificate Number: Fedd0141-a128-442c-b2b3-50b94fc8b361
• Other security certifications: No

Social value

• Section B - Commitment for Future: Delivery:

  • Mission: Kick start economic growth. To secure the highest sustained growth in the G7 - with good jobs and productivity growth in every part of the country making everyone, not just a few, better off.

    Policy Outcome 1: Fair work: That offers fair wages and good working conditions. Help people get a job, stay in work, and progress in their careers, with good employment opportunities across the country. Notes: Where there is a large proportion of labour costs in the contract, commercial teams should consider MAC in Outcome 1 as a priority

    • New apprenticeships on the contract workforce in the relevant area that meet the criteria set out in MAC 1b
    • Monitoring of employee engagement rates (by protected characteristic) and, where necessary, the development of actions to ensure all voices are heard across the diversity of the workforce
    • Employment contracts that reflect actual hours worked; steps taken to ensure employees understand their contracts and have the ability to review and adjust them if actual hours regularly exceed contracted hours
    • Activities that support an environment where staff are educated about and feel empowered to report and address bullying and harassment
    • Activities to cascade good practice on fair working conditions throughout the supply chain
    • Payment of more than the National Minimum Wage or National Living Wage (as appropriate) to the contract workforce
    • Entitlement to sick pay for the contract workforce, with provision in place for any staff who do not meet the earnings threshold for statutory sick pay, payment of sick pay from day one of absence and payment of staff on the contract workforce who are off sick a replacement income of 100% of their usual earnings for as long as possible
    • Understanding of the modern slavery risks and issues affecting the market, industry, sector or country (of origin or of source) relevant to the contract, and the workforce in the supplier’s own organisation and those of its key subcontractors
    • Measures to identify, mitigate and manage modern slavery risks relating to the contract and how these will be implemented
    • Outline policies and practices to be applied to or put in place for the contract to mitigate and manage modern slavery risks, including: Pre-employment checks, recruitment practices. Workplace conditions, safeguarding plans and processes in place and regular monitoring with relevant groups considered, which may include sampling

  • Mission: Build an NHS fit for the future: That is there when people need it; with fewer lives lost to the biggest killers; in a fairer Britain, where everyone lives well for longer.

    Policy Outcome 8: Increasing productivity through physical and mental wellbeing: In the supply chain and communities in the relevant area.

    • Understanding of issues relating to health and wellbeing, including physical and mental health, in the contract workforce
    • Actions to invest in the physical and mental health and wellbeing of the contract workforce

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at uk-sales@magentus.com. Tell them what format you need. It will help if you say what assistive technology you use.