1 / 16

Data Warehousing at Lancashire Care NHS Trust

Data Warehousing at Lancashire Care NHS Trust. Tim Harvey – Head of Information Helen Dean – Information Analyst. The Trust. Established 2002 Provides Mental Health and Substance Misuse services across Lancashire Provides Secure Mental Health services for Lancashire & Cumbria Over 3500 Staff

huong
Download Presentation

Data Warehousing at Lancashire Care NHS Trust

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehousing at Lancashire Care NHS Trust ASSIST Presentation

  2. Tim Harvey – Head of InformationHelen Dean – Information Analyst ASSIST Presentation

  3. The Trust • Established 2002 • Provides Mental Health and Substance Misuse services across Lancashire • Provides Secure Mental Health services for Lancashire & Cumbria • Over 3500 Staff • Over 120 Sites ASSIST Presentation

  4. LCT Info Systems • Pre-Connecting for Health • Six Legacy PAS Systems • Hosted by Acute Trusts • Reliant on Service Level Agreements • No structure to Information provision • No Data Integration ASSIST Presentation

  5. NCRS Deployment • iPM implementation- April 2005 • Community rollout- April 2006 • Data Extracts received on a 24hr basis • Initial Loads and Delta Loads • No Extract Management solution provided ASSIST Presentation

  6. Data Warehouse • In-house solution not feasible • CfH solution not available at the time of go-live • Reviewed off the shelf products and… ASSIST Presentation

  7. …Health Data Manager! ASSIST Presentation

  8. Why Health Data Manager? • Designed specifically for NHS and Data Extracts • Provide integration, storage, analysis and presentation within one application • System C part of CSC Alliance • Keeps data under ‘local’ control • Ability to incorporate other system data • Ease of use ASSIST Presentation

  9. How it works (1) ASSIST Presentation

  10. How it works (2) 24 Hours Stage 1 Job Stage 2 Job Extract Files Staging Tables HDM Tables CSV Oracle Business Objects/ Web Intelligence ASSIST Presentation

  11. ASSIST Presentation

  12. ASSIST Presentation

  13. LCT Current Reporting Configuration Performance Dashboard iPM Web Info Reports Statutory Returns E-CPA HDM Reports ASSIST Presentation

  14. Implementation Issues • Data Extract Issues • Versions and Loads • Completeness • Timeliness/Validation checking/LSP Relationship • Understanding Universes • New application ASSIST Presentation

  15. Future Developments • Community Activity • Information Portal • Feasibility of using full Business Objects Application • Migrate Warehouse from Oracle to SQL • Expand usage of HDM ASSIST Presentation

  16. Questions? ASSIST Presentation

More Related