[WWW - 2021.12.16]

Breadcrumb_KW

Decision Support System (DSS) Data Collection
Identifying and Definitional Attributes
Identifier
QH 020049
Version
3
Metadata Item Type
Information Asset
Metadata Set Type
Data Collection
Approval Status
Draft
30-Jun-2021 
Approval Type
Standard
Approving Authority
Information Management Strategic Governance Committee (IMSGC), Queensland Health
Effective From
01-Jul-2021
Effective To
-
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
The Queensland Health Decision Support System (DSS) is used by all Hospital and Health Services (HHS) and all Department of Health (DoH) entities every day.
Absence would cause significant impact on QH business
Yes
Utilised state-wide by over 6,500 Queensland Health staff annually, 3,300 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 -Support the delivery of sustainable health services through integrated policy, 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 ECC6 & Lattice),
- Leave Forecast & Diversity (SAP ECC6),
- Finance & General Ledger (SAP R/3 / FAMMIS & SAP S/4),
- Vendor Invoice Management (SAP S/4)
- Extended Warehouse Management (SAP S/4),
- Activity Based Funding (HBCIS, Heath Statistics Oracle database),
- iLearn (Learning Management System),
- Roster Management & Workforce Planning (WorkBrain & WorkMAPP)
- Private Practice Doctor Billing (PractiX & MediRecords),
- Nurse Sensitive Indicators
- Nurse KPIs (sourced from various DSS Modules), 
- Scorecard
- KPI Reporting (sourced from various DSS Modules),
- Procurement / Materials Management (FAMMIS & SAP S/4),
- Equipment Maintenance (SAP R/3 CMMS FAMMIS & SAP S/4),
- 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 / Capital Projects (SAP R/3 FAMMIS & SAP S/4), 
- OrgTRx / Antimicrobial Stewardship (AUSLAB & other state LISs),
- MedTRx
- Commonwealth Financial and Residential Activity Collection (FRAC), 
- Queensland Health Monthly Activity Collection (MAC), 
- Debtors (SAP R/3 FAMMIS & SAP S/4),
- Casepay PRISM (payroll pre July 2003).
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, 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 mins., finance, HR and WorkBrain data updated every night, ABF data updated most weekends, payroll data 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 - 
DSS Decision Support System Policy QH-POL-425:2021 (health.qld.gov.au)
<INTERNAL QH LINK NOT AVAILABLE> 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 module) allow state-wide benchmarking whereas other modules (e.g. HR Payroll & Finance modules) 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 SAP ALT_7 organisational hierarchy e.g. HHSs can't access other HHS data unless approved by that HHS’s Chief Finance Officer or Chief Executive Officer.
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 and a state-wide Data Custodian who are 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 etc.
Reporting Requirements
Focused on daily, fortnightly, monthly, quarterly 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 scorecards 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
Supersedes Decision Support System (DSS) Data Collection QH 020049 Version 2
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-2021
Data Quality Declaration 
Medium quality, used for monthly performance reporting across Queensland Health and some information published in summary in the QH and HHS annual reports as part of their annual financial statements.
Source and Reference Attributes
Source Systems 
Various, as previously described.
Source Organisation
Finance Branch, Corporate Services Division, Department of Health, QH.
Source Document
The DSS QHEPS home page is assessable at DSS Homepage (health.qld.gov.au) or <INTERNAL QH LINK NOT AVAILABLE>.
The DSS QHEPS page containing data definitions and module overviews is accessible at DSS Supporting Documents (health.qld.gov.au) or <INTERNAL QH LINK NOT AVAILABLE>.
The DSS Finance S/4 module data item definitions are assessable at Finance Module Glossary 2021 (health.qld.gov.au) or
<INTERNAL QH LINK NOT AVAILABLE>.
The DSS HR Payroll module data item definitions are assessable at DSS HR Payroll (SAP) Glossary of Terms 25 October 2016 (health.qld.gov.au) or <INTERNAL QH LINK NOT AVAILABLE>.
Listing of DSS modules and their functions, owners, key data items, etc. is assessable at Source Systems DSS Data Sets Matrix v 11 - 11 May 2018 (health.qld.gov.au) or .au/__data/assets/pdf_file/0019/1808020/dss-source-sys-data-sets-matrix.pdf.
 
 
 
 
 
Keywords

ABF; Activity; Activity based funding; Admission; ALOS; Analysis; Average length of stay; Bed; Benchmarking; Budget; Capital; Decision support system; Discharge; DSS; Fee; Finance; Financial Management; FTE; Full time equivalent; Headcount; HR; Human resources; Income; Invoice; Key performance indicator; KPI; Leave; Leave management; Occupancy; Payroll; Resource management; Revenue; Risk; Separations; Staff; Variance; Waiting time