[WWW - 2021.12.16]
Identifying and Definitional Attributes
QH 020265
Metadata Item Type
Information Asset
Metadata Set Type
Data Collection
Approval Status
Approval Type
Approving Authority
Effective From
Effective To
Short Name
Budget Planning Tool Data Collection
Strategic Alignment Attributes
Actual or potential statewide coverage
Absence would cause significant impact on QH business
Supports enterprise-wide decision making
Supports enterprise-wide reporting requirements
Supports the strategic directions of QH
Strategic Asset Indicator
Collection and Usage Attributes
Guide for Use
To provide Queensland Health with a consistent and standard platform for developing budget targets for FTE and finance dollars which interfaces with both the financial system FAMMIS and the Decision Support System (DSS).
Open to approved and registered Users State-wide who have been granted appropriate security access.
Financial and Payroll FTE data for multi-dimensional analysis at summary or transaction levels with applications for: Finance for managing dollars at Cost Centre and GL account level, Workforce and Establishment for managing FTE and labour business rules at Cost Centre, Payclass and position number level.
Sites Implemented
All Queensland Health Hospital and Health Services and DoH Divisions - secured access.
Published Outputs
Via FAMMIS General Ledger and DSS Necto.
Frequency of Updates
Nightly updates from FAMMIS for cost centre and general ledger account codes, fortnightly from SAP HR Payroll for position number and paypoints.
Information Security Classification
As defined by each Corporate Divisional Executive Director or HHS CFO.
Access Constraints
Use Constraints
Extracts (for-from): Financial data from QH General Ledger, Labour, FTE data from SAP HR Payroll.
Statistical Unit
Reporting Requirements
The system allows for entry of workforce (FTE) and financial (dollar) data through templates developed in Microsoft Excel. The system is designed to develop labour budgets directly from workforce plans using a consistent and standard methodology. Workforce plans can be developed at pay classification/point level or at position number using standard QH wage rates and business rules reflective of geographical locations across the state. The system utilises information from the (ALT 7) cost centre hierarchy, general ledger account codes, SAP HR Payroll master data and standard QH pay points. The system provides a platform for managing large volumes of data and an element of consolidation for all hierarchies in the system. The system also provides a reporting capability prior to the upload of data in both FAMMIS and DSS for standard reporting.
Frequency of Reporting Requirements
BPT replaced HHS and Division specific budget spreadsheet and locally developed systems which had no consistency across sites.  
BPT is a user friendly information system and assists in "top level" decision making based on a common and consistent methodology for all users and provides comparable data outputs.  
Data can be viewed at the lowest level; pay class or position for FTE data or general ledger account code for Finance data. The data can also be rolled up and viewed at the highest level; eg: HHS/Division or at various levels of the Account Code hierarchy.  
The benefits of BPT include:
- Consistency in Budget development across all HHSs and Divisions;
- Improved transparency on how budgets are developed;
- Centrally administered and supported to ensure consistency throughout the Budget development process;
- The system is secured and restricted to appropriate user access for the Cost Centre hierarchy as determined by senior managers and policies of each HHS/Division;
- Groups of users (common areas) have access to the same level of data.  
BPT is available daily with a nightly maintenance window for background processing and data updates.  BPT is updated nightly from FAMMIS for cost centre and GL account codes, and fortnightly from SAPHR Payroll for position number detail.  Data uploads to DSS Necto and FAMMIS are run nightly from staging tables.
Relational Attributes
Related Metadata References
Has been superseded by Budget Planning Tool (BPT) Data Collection QH 020265 Version 2
Implementation in
Included Data Elements and Performance Indicators
Data Quality Declaration
Source and Reference Attributes