[WWW - 2023.07.31]

Information Asset Detail

Decision Support System (DSS) Data Collection
Identifying and Definitional Attributes
QH 020049 v2
Information Asset
Data Collection
Draft
17-Jul-2019		Current
21-Sep-2021
Standard
Information Management Strategic Governance Committee (IMSGC), Queensland Health
01-Jul-2019
30-Jun-2021
Data transferred from other Queensland Health systems into the Queensland Health Decision Support System (DSS).
DSS Data Collection
Strategic Alignment Attributes
Yes
Used by all Hospital and Health Services (HHS) and all Department of Health (DoH) entities most days.
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.
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).
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).
Yes
DoH strategic objective 6 - Set the agenda through integrated policy, planning, funding and implementation efforts.
Yes
Collection and Usage Attributes
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.
A Business Intelligence (BI) tool that consolidates Queensland Health data for the facilitation of analysis, reporting, benchmarking and performance monitoring purposes.
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.
Queensland
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.
All of Queensland Health including DoH and HHSs and their facilities.
Internal performance reporting and benchmarking.
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.
SENSITIVE
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.
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.
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.
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.
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.
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.
Continuous to meet operational needs.
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

Related Metadata References_IR

  • 1 - 2
ViewRelationshipMetadata Item TypeMetadata Item SubtypeNameIdentifier & VersionApproval Status
SupersedesInformation AssetData CollectionDecision Support System (DSS) Necto Data CollectionQH 020049 Version 1Superseded
Has been superseded byInformation AssetData CollectionDecision Support System (DSS) Data CollectionQH 020049 Version 3Draft
Implementation in Metadata Sets

Implemented

No Metadata Items
Included Data Elements and Performance Indicators

Included DE

  • 1 - 1
ViewMetadata Item TypeMetadata Item SubtypeNameIdentifer & VersionObligationApproval StatusEffective FromEffective To
Data ElementData ElementPerson-occupation (QHD job code)QH 042728 Version 2ConditionalCurrent01-Jul-201930-Jun-2021
Medium quality, used for monthly performance reporting across Queensland Health.
Source and Reference Attributes
Various, as previously described.
Finance Branch.
INTERNAL QH LINK NOT AVAILABLE
ABF; ALOS; Activity; Admission; Analysis; Average length of stay; Bed; DSS; Decision support system; Discharge; FTE; Finance; HR; Headcount; Human resources; KPI; Key performance indicator; Occupancy; Payroll; Resource management; Risk; Waiting time;