Information Asset Detail

Show All
Identifying and Definitional Attributes
Strategic Alignment Attributes
Collection and Usage Attributes
Relational Attributes
Source and Reference Attributes

Decision Support System (DSS) Data Collection

Identifying and Definitional Attributes

Identifier & Version

QH 020049 v3

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

Support Perf Measure Text

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) , and
- QHRisk.

New

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

Queensland

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.

Site 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)
https://qheps.health.qld.gov.au/__data/assets/pdf_file/0034/2179456/dss-security-policy-pol-425-2021.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 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

Related Metadata References_IR

1 - 1

View	Relationship	Metadata Item Type	Metadata Item Subtype	Name	Identifier & Version	Approval Status
	Supersedes	Information Asset	Data Collection	Decision Support System (DSS) Data Collection	QH 020049 Version 2	Current

Implementation in Metadata Sets

Implemented

No Metadata Items

Included Data Elements and Performance Indicators

Included DE

1 - 1

View	Metadata Item Type	Metadata Item Subtype	Name	Identifer & Version	Obligation	Approval Status	Effective From	Effective To
	Data Element	Data Element	Person-occupation (QHD job code)	QH 042728 Version 2	Conditional	Current	01-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