[WWW - 2023.07.31]

Information Asset Detail

Monthly Activity Collection (MAC)
Identifying and Definitional Attributes
QH 020008 v2
Information Asset
Data Collection
Draft
12-Mar-2020		Current
21-Sep-2021
Standard
Information Management Strategic Governance Committee (IMSGC), Queensland Health
01-Jul-2019
30-Jun-2022
The Monthly Activity Collection (MAC) collects aggregate (or summary) level data on 'Admitted' and 'Non-admitted' patient activity and 'Bed Availability'. These data are submitted monthly to the Department of Health by the in-scope 'reporting entities' of the different levels of Queensland's public hospital system. Whilst data are primarily reported to comply with State and Commonwealth Government reporting requirements, there are additional uses of these data including informing cost modelling, funding, research and local business management.
MAC
Strategic Alignment Attributes
Yes
Yes
Yes
Yes
Yes
Yes
Collection and Usage Attributes
Non-admitted patient activity to be reported to the MAC includes:
- outpatient service events (OSEs) provided by clinics deemed as 'in scope' for reporting as determined by the IHPA's General list of in-scope public hospital services. Whilst the 'General list' does not include Tier 2 clinic classes of 'General Practice and Primary Care' (20.06), 'Aged Care Assessment' (40.02), 'Family Planning' (40.27), 'General Counselling' (40.33), and 'Primary Health Care' (40.08) as in-scope public hospital services, these clinic types must be reported.
Classification of clinic services will be to the appropriate CCC/Tier 2 clinic class for reporting at the jurisdictional health authority (Queensland Health), Hospital and Health Service (Local Hospital Network (LHN)) and hospital levels.

- Primary and Community Health service events (PCHSEs) provided by Primary and Community Health Services clinics that are not able to be classified to a CCC/Tier 2 clinic class and for which funding corresponds with cost centres designated as 'Non-ABF Service Categories' in the general ledger 'Funding Split Hierarchy'.
Classification of these clinic services will be to a service type identified in the Service type classifications and counting rules for reporting at the HHS level and may include activity for services that are outsourced. This activity does not fit the criteria prescribed in General list of in-scope public hospital services ie considered ABF in scope services, as these would be able to be reported against the appropriate Tier 2 clinic classification.

- occasions of service provided by clinics at the facility level that do not deliver clinical care eg activities such as home cleaning, meals on wheels or home maintenance. Whilst in the scope of MAC, these activities are not service events. This activity is collected for State reporting purposes (refer to Other Outreach Services for more information).

Further, this activity must:
- be activity that is funded by the jurisdictional health authority (Queensland Health), Hospital and Health Service, or hospital
- be irrespective of location (includes on-campus and off-campus), and
- be included regardless of setting or mode

Excludes:
- services provided from grants issued by the Commonwealth
- services that are the policy and funding responsibility of another state government department or the Commonwealth are not in scope for this collection, as activity would be reported elsewhere. Similarly, mental health and oral health service activity is reported via service specific information systems such as Consumer Integrated Mental Health Application (CIMHA) and Information System Oral Health (ISOH) and should therefore not be reported to the MAC
- services provided by email
- services provided to patients in the admitted, emergency department or emergency service care settings.

The OSE activity that is to be reported to the MAC is 'the total number of individual session non-admitted service events provided by an establishment' and 'the total number of group session non-admitted service events provided by an establishment'.

The PCHSE activity that is to be reported to the MAC for non-admitted patients is 'the total number of 'PCHSEs' provided to non-admitted patients in the reference period, for each of the Primary and Community Health service types.
Queensland
Public hospitals, public residential psychiatric hospitals, public multi-purpose health services, public residential aged care services, Hospital and Health Services (HHSs) and the State.
MAC data are routinely published on the Queensland Health Internet and Intranet sites as well as in Australian Government publications such as Report on Government Services (ROGS), Australian Hospital Statistics and the My Hospitals web-site.
Data collected on a monthly basis and a finalised file is released annually.
SENSITIVE
Ad hoc requests for data are handled by the Statistical Reporting and Coordination Unit, Statistical Services Branch.
Requests for access to data are considered on a case-by-case basis.

To request aggregated or summary data and statistics, email HlthStat@health.qld.gov.au.

To request linked data and/or potentially identifiable data for research purposes, email HSBresearch@health.qld.gov.au. Release of identifiable or potentially identifiable data requires Data Custodian approval. Data may be requested for research purposes or for other authorised purposes if permitted under the relevant State legislation.

For further information refer to the 'How to access data from the Statistical Services Branch' page on the Queensland Health internet site: https://www.health.qld.gov.au/hsu/how-to-access-data-from-ssb
Any caveats on the data will be included with the data.
Public hospitals, public residential psychiatric hospitals, public residential aged care facilities and multi-purpose health services provide monthly returns electronically (web-based forms) through MAC Online.
MAC reporting is mandatory and is prescribed in Schedule 4 of the HHS Service Agreements. Data are submitted by each reporting entity to the Statistical Collections and Integration Unit (SCIU), Statistical Services Branch (SSB) of the Department of Health where it is prepared for reporting purposes.

Commonwealth Government Reporting Requirements:

Department of Health (Commonwealth): Under the National Healthcare Agreement, the Queensland Department of Health (QDoH) is required to supply the Commonwealth's Department of Health (CDoH) with hospital activity data on Queensland's public health system.

Australian Institute of Health and Welfare (AIHW): As a signatory to the National Health Information Agreement, QDoH is required to provide hospital activity data to the AIHW according to agreed National Minimum Data Sets (NMDSs). To comply with these reporting obligations, service event data reported to the MAC is used to meet the Non-Admitted Patient Care Aggregate National Best Endeavours Data Set (NAPCA NBEDS).

Independent Hospital Pricing Authority (IHPA): In addition to the above reporting requirements for the CDoH and the AIHW, QDoH must provide non-admitted patient service event activity to IHPA6 at both the aggregate-level and the patient-level. Aggregate-level data is provided according to the NAPCA NBEDS and patient-level data is provided according to the Non-admitted patient NBEDS. Both of these data set specifications collect data at the three different levels of the public hospital system being the hospital, the HHS and the State.
SSB - monthly.
AIHW - annually.
IHPA - quarterly.
2019 AUDIT: The MAC data elements listed below are undergoing review as the respective Data Supply Requirements (DSRs) are completed.
Relational Attributes
Related Metadata References

Related Metadata References_IR

  • 1 - 1
ViewRelationshipMetadata Item TypeMetadata Item SubtypeNameIdentifier & VersionApproval Status
SupersedesInformation AssetData CollectionMonthly Activity Collection (MAC)QH 020008 Version 1Superseded
Implementation in Metadata Sets

Implemented

No Metadata Items
Included Data Elements and Performance Indicators

Included DE

  • 1 - 19
ViewMetadata Item TypeMetadata Item SubtypeNameIdentifer & VersionObligationApproval StatusEffective FromEffective To
Data ElementData Element ConceptAdmitted patientQH 040380 Version 2Current01-Jul-201930-Jun-2022
Data ElementDerived Data ElementAdmitted patient-length of stay (excluding leave days), total days at point during episode of careQH 040016 Version 2ConditionalCurrent01-Jul-201930-Jun-2022
Data ElementData Element ConceptAvailable bedQH 040260 Version 1Current01-Jul-201930-Jun-2022
Data ElementData Element ConceptAvailable bed alternativeQH 040261 Version 1Current01-Jul-201930-Jun-2022
Data ElementDerived Data ElementEpisode of admitted patient care (newborn)-total number of acute (qualified)/unqualified daysQH 040375 Version 2ConditionalCurrent01-Jul-201930-Jun-2022
Data ElementDerived Data ElementEstablishment-number of group session non-admitted patient service events, total service eventsQH 042646 Version 2ConditionalCurrent01-Jul-201930-Jun-2022
Data ElementDerived Data ElementFacility-available bed (admitted contracted care), average numberQH 041769 Version 2MandatoryDraft01-Jul-201930-Jun-2022
Data ElementDerived Data ElementFacility-available bed (neonatal admitted care, non-special-care), average numberQH 041529 Version 1MandatoryCurrent01-Jul-201930-Jun-2022
Data ElementDerived Data ElementFacility-available bed (overnight-stay admitted care), average numberQH 041527 Version 2MandatoryDraft01-Jul-201930-Jun-2022
Data ElementDerived Data ElementFacility-available bed (same-day admitted care), average numberQH 041528 Version 2MandatoryDraft01-Jul-201930-Jun-2022
Data ElementData ElementFacility-facility typeQH 040263 Version 14MandatoryCurrent01-Jul-202130-Jun-2022
Data ElementData ElementFacility-facility typeQH 040263 Version 13MandatorySuperseded01-Jul-201930-Jun-2021
Data ElementData ElementHealthcare statutory body-hospital and health service codeQH 041594 Version 2MandatoryCurrent01-Jul-201930-Jun-2022
Data ElementData ElementHospital service-care typeQH 040013 Version 9Current01-Jul-202030-Jun-2022
Data ElementData ElementHospital service-care typeQH 040013 Version 8Superseded01-Jul-201930-Jun-2020
Data ElementData Element ConceptLive birthQH 040055 Version 2Current01-Jul-201930-Jun-2022
Data ElementData ElementNon-admitted patient service event-new/review clinical service statusQH 041686 Version 1Current01-Jul-201930-Jun-2022
Data ElementDerived Data ElementNumber of individual sessionsQH 040262 Version 1Current01-Jul-201930-Jun-2022
Data ElementData Element ConceptSeparationQH 040017 Version 2Current01-Jul-201930-Jun-2022
Source and Reference Attributes
MAC; MAS; Monthly Activity;