data warehousing at lancashire care nhs trust l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing at Lancashire Care NHS Trust PowerPoint Presentation
Download Presentation
Data Warehousing at Lancashire Care NHS Trust

Loading in 2 Seconds...

play fullscreen
1 / 16

Data Warehousing at Lancashire Care NHS Trust - PowerPoint PPT Presentation


  • 183 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the trust
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

lct info systems
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

ncrs deployment
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

data warehouse
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

health data manager
…Health Data Manager!

ASSIST Presentation

why health data manager
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

how it works 1
How it works (1)

ASSIST Presentation

how it works 2
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

lct current reporting configuration
LCT Current Reporting Configuration

Performance

Dashboard

iPM

Web Info

Reports

Statutory

Returns

E-CPA

HDM Reports

ASSIST Presentation

implementation issues
Implementation Issues
  • Data Extract Issues
    • Versions and Loads
    • Completeness
    • Timeliness/Validation checking/LSP Relationship
  • Understanding Universes
  • New application

ASSIST Presentation

future developments
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

questions
Questions?

ASSIST Presentation