[WWW - 2023.07.31]

Information Asset Detail

Budget Planning Tool (BPT) Data Collection
Identifying and Definitional Attributes
QH 020265 v1
Information Asset
Data Collection
Current
01-Jan-2012		Superseded
16-Jul-2019
Documented
-
01-Jan-2012
30-Jun-2019
Budget Planning Tool Data Collection
Strategic Alignment Attributes
No
No
No
No
No
No
Collection and Usage Attributes
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.
Queensland
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.
All Queensland Health Hospital and Health Services and DoH Divisions - secured access.
Via FAMMIS General Ledger and DSS Necto.
Nightly updates from FAMMIS for cost centre and general ledger account codes, fortnightly from SAP HR Payroll for position number and paypoints.
IN-CONFIDENCE
As defined by each Corporate Divisional Executive Director or HHS CFO.
Extracts (for-from): Financial data from QH General Ledger, Labour, FTE data from SAP HR Payroll.
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.
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

Related Metadata References_IR

  • 1 - 1
ViewRelationshipMetadata Item TypeMetadata Item SubtypeNameIdentifier & VersionApproval Status
Has been superseded byInformation AssetData CollectionBudget Planning Tool (BPT) Data CollectionQH 020265 Version 2Current
Implementation in Metadata Sets

Implemented

No Metadata Items
Included Data Elements and Performance Indicators

Included DE

No Metadata Items
Source and Reference Attributes
Amount; Budget; Cost centre; DSS; FTE; HRMIS; Hierarchies; Human resources; Pay point; Position; SAP BPC; SAP EEC6; SAP S4/HANA; Stream;