[WWW - 2021.12.16]
  • MS

  • MS detail

Breadcrumb_DS

Budget Planning Tool (BPT) Data Collection
Identifying and Definitional Attributes
Identifier
QH 020265
Version
1
Metadata Item Type
Information Asset
Metadata Set Type
Data Collection
Approval Status
Current
01-Jan-2012 		Superseded
16-Jul-2019 
Approval Type
Documented
Approving Authority
-
Effective From
01-Jan-2012
Effective To
30-Jun-2019
Description 
-
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 
-
Purpose 
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).
Scope 
Open to approved and registered Users State-wide who have been granted appropriate security access.
Coverage
QLD
Content
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
IN-CONFIDENCE
Accessibility 
As defined by each Corporate Divisional Executive Director or HHS CFO.
Access Constraints
-
Use Constraints
-
Methodology 
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
-
Comments
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