[WWW - 2021.12.16]

Breadcrumb_KW

Decision Support System (DSS) Data Collection
Identifying and Definitional Attributes
Identifier
QH 020049
Version
2
Metadata Item Type
Information Asset
Metadata Set Type
Data Collection
Approval Status
Draft
17-Jul-2019 		Current
21-Sep-2021 
Approval Type
Standard
Approving Authority
Information Management Strategic Governance Committee (IMSGC), Queensland Health
Effective From
01-Jul-2019
Effective To
30-Jun-2021
Description 
Data transferred from other Queensland Health systems into the Queensland Health Decision Support System (DSS).
Short Name
DSS Data Collection
Strategic Alignment Attributes
Actual or potential statewide coverage
Yes
Used by all Hospital and Health Services (HHS) and all Department of Health (DoH) entities most days.
Absence would cause significant impact on QH business
Yes
Utilised state-wide by around 5,500 Queensland Health staff annually, 3,000 Queensland Health staff monthly and 700 Queensland Health staff most weekdays.
Supports enterprise-wide decision making
Yes
Joins numerous key performance indicator (KPI) data sets in one view and state-wide benchmarking. Contains data on most Queensland Health KPIs with drill through.to additional detail (e.g. transactions).
Supports enterprise-wide reporting requirements
Yes
Joins numerous KPI data sets in one view and state-wide benchmarking. Contains data on most Queensland Health KPIs with drill through.to additional detail (e.g. transactions).
Supports the strategic directions of QH
Yes
DoH strategic objective 6 - Set the agenda through integrated policy, planning, funding and implementation efforts.
Strategic Asset Indicator
Yes
Collection and Usage Attributes
Guide for Use 
DSS is a business intelligence (BI) tool with over 30 different data sets / modules including:
- HR Payroll (SAP), 
- Finance Dollars & General Ledger (FAMMIS & S4), 
- Activity Based Funding (HBCIS, Heath Statistics Oracle database), 
- iLearn (Learning Management System), 
- Roster Management (WorkBrain), 
- Private Practice Doctor Billing (PractiX & MediRecords), 
- Nurse Sensitive Indicators
- Nurse KPIs (various DSS Modules), Scorecard
- KPI Reporting (sourced from various DSS Modules), 
- Procurement Spend Analytics / Materials Management (FAMMIS), 
- CMMS Equipment Maintenance (FAMMIS), 
- WorkMAPP, Blood & Pathology Management (AUSLAB & ABF), 
- RAPID / Hospital at a Glance (HBCIS, EDIS, Trendcare),
- Central Pharmacy Distributions (iPharmacy), 
- Ryan's Rule (sourced from 1300 Health Call Centre database), 
- Investment Management / Internal Orders (FAMMIS Capital Projects), 
- OrgTRx / Antimicrobial Stewardship (AUSLAB & other state LISs), 
- Commonwealth Financial and Residential Activity Collection (FRAC), 
- Queensland Health Health Statistics Monthly Activity Collection (MAC), 
- Patient Flow / SaTR, 
- Debtors, 
- Veterans Affairs, 
- Casepay PRISM (payroll pre July 2003), and 
- QHRisk.
Purpose 
A Business Intelligence (BI) tool that consolidates Queensland Health data for the facilitation of analysis, reporting, benchmarking and performance monitoring purposes.
Scope 
All of Queensland Health including DoH, HHSs and their facilities. Queensland Health data is consolidated at the various organisational levels including cost centre, hospital, department, division and state-wide.
Coverage
QLD
Content
Data includes financial, payroll, human resources, hospital activity and activity based funding (ABF), pharmacy, materials management, pathology, risk, clinical quality and Medicare billing data for multi-dimensional analysis at summary or transaction levels. Metadata for DSS is as recorded against the core systems that DSS gets its data from as detailed in Guide for Use.
Sites Implemented 
All of Queensland Health including DoH and HHSs and their facilities.
Published Outputs 
Internal performance reporting and benchmarking.
Frequency of Updates
Continuous; e.g. users can load local data at any time, RAPID module data updated every five minutes, FAMMIS, HR and WorkBrain data updated every night, ABF data updated most weekends, payrolldata updated every fortnight, AUSLAB data updated every month.
Information Security Classification
SENSITIVE
Accessibility 
Access is only available to Queensland Health staff or contractors with appropriate permissions as defined by DSS Security Policy - https://www.health.qld.gov.au/__data/assets/pdf_file/0035/395972/qh-pol-425.pdf

Access is granted on-line by the various DSS Coordinators located within HHSs and their facilities and the DoH entities.  

Statewide access for certain modules is approved in line with the DSS Security Policy by Finance Branch or the state-wide coordinator for that module.
Access Constraints
As set out in DSS Security Policy, some modules (e.g. DSS Scorecard) allow state-wide benchmarking whereas other modules (e.g. HR Payroll) have very restricted access.
Use Constraints
For finance and HR Payroll modules, user security is based on the user's area of responsibility as identified within the ALT_7 FAMMIS organisational hierarchy e.g. HHSs can't access other HHS data unless approved by that HHS.
Methodology 
Data is extracted from numerous source systems via automated interfaces and warehoused within the Financial Solutions IT infrastructure.  Modules are built based on business requirements to collate source data into reporting views. DSS links multiple data sources in some views to produce indicator reporting. Each DSS module has a module owner who is regularly consulted to ensure business needs continue to be meet.
Statistical Unit
Various - dollars, FTEs, headcount, patients, beds, hours, occupancy, presentations, discharges, admissions, waiting times, average length of stay (ALOS), training completions, test counts, material quantities, risk profile, etc.
Reporting Requirements
Focused on month end, quarter end and annual reporting, comparing across periods and facilities / entities. DSS allows for both aggregated and drill down functionality empowering users in a hierarchical manner, to view large slices of relevant/ significant data with extract facilities to excel, work and PDF etc. DSS incorporates performance reporting inclusive of scorecard and dashboards.
Frequency of Reporting Requirements
Continuous to meet operational needs.
Comments
DSS system has had three significant user interface / front end upgrades since implementation in 1997, being DSS Holos initially, then DSS Panorama Novaview in 2008, then DSS Panorama Necto Flash in 2014 and DSS Panorama Necto HTML5 in 2019.  
 
DSS has had two databases, initially Sybase and then replaced in 1999 by Oracle supported by Microsoft SQL Server Analysis Services.  
 
DSS is a user-friendly business intelligence tool designed to allow a Queensland Health staff member with the appropriate security clearance to access reporting from any computer with Queensland Health intranet access.  
 
DSS provides both summary and detailed data with the capacity to design regular reports as per user needs.  
 
Data can be converted to tabular or graphical display within the application as well as exported within in several formats (excel, csv, pdf, etc).
Relational Attributes
Related Metadata References
Has been superseded by Decision Support System (DSS) Data Collection QH 020049 Version 3
Supersedes Decision Support System (DSS) Necto Data Collection QH 020049 Version 1
Implementation in
- 
Included Data Elements and Performance Indicators

Otherrelational

  • 1 - 1
ViewMetadata Item TypeNameAscendingIdentifier & VersionObligationApproval StatusEffective fromEffective to
Data ElementPerson-occupation (QHD job code)QH 042728 Version 2ConditionalCurrent01-Jul-201930-Jun-2021
Data Quality Declaration 
Medium quality, used for monthly performance reporting across Queensland Health.
Source and Reference Attributes
Source Systems 
Various, as previously described.
Source Organisation
Finance Branch.
Source Document
<INTERNAL QH LINK NOT AVAILABLE>
Keywords

ABF; Activity; Admission; ALOS; Analysis; Average length of stay; Bed; Decision support system; Discharge; DSS; Finance; FTE; Headcount; HR; Human resources; Key performance indicator; KPI; Occupancy; Payroll; Resource management; Risk; Waiting time