Impact of a data warehouse model for improved decision-making process in healthcare

The health system is one sector dealing with a deluge of complex data. Many healthcare organisations struggle to utilise these volumes of health data effectively and efficiently. Also, there are many healthcare organisations, which still have stand-alone systems, not integrated for management of information and decision-making. This shows, there is a need for an effective system to capture, collate and distribute this health data. Therefore, implementing the data warehouse concept in healthcare is potentially one of the solutions to integrate health data. Data warehousing has been used to support business intelligence and decision-making in many other sectors such as the engineering, defence and retail sectors. The research problem that is going to be addressed is, "how can data warehousing assist the decision-making process in healthcare". To address this problem the researcher has narrowed an investigation focusing on a cardiac surgery unit. This research used the cardiac surgery unit at the Prince Charles Hospital (TPCH) as the case study. The cardiac surgery unit at TPCH uses a stand-alone database of patient clinical data, which supports clinical audit, service management and research functions. However, much of the time, the interaction between the cardiac surgery unit information system with other units is minimal. There is a limited and basic two-way interaction with other clinical and administrative databases at TPCH which support decision-making processes. The aims of this research are to investigate what decision-making issues are faced by the healthcare professionals with the current information systems and how decision-making might be improved within this healthcare setting by implementing an aligned data warehouse model or models. As a part of the research the researcher will propose and develop a suitable data warehouse prototype based on the cardiac surgery unit needs and integrating the Intensive Care Unit database, Clinical Costing unit database (Transition II) and Quality and Safety unit database [electronic discharge summary (e-DS)]. The goal is to improve the current decision-making processes. The main objectives of this research are to improve access to integrated clinical and financial data, providing potentially better information for decision-making for both improved from the questionnaire and by referring to the literature, the results indicate a centralised data warehouse model for the cardiac surgery unit at this stage. A centralised data warehouse model addresses current needs and can also be upgraded to an enterprise wide warehouse model or federated data warehouse model as discussed in the many consulted publications. The data warehouse prototype was able to be developed using SAS enterprise data integration studio 4.2 and the data was analysed using SAS enterprise edition 4.3. In the final stage, the data warehouse prototype was evaluated by collecting feedback from the end users. This was achieved by using output created from the data warehouse prototype as examples of the data desired and possible in a data warehouse environment. According to the feedback collected from the end users, implementation of a data warehouse was seen to be a useful tool to inform management options, provide a more complete representation of factors related to a decision scenario and potentially reduce information product development time. However, there are many constraints exist in this research. For example the technical issues such as data incompatibilities, integration of the cardiac surgery database and e-DS database servers and also, Queensland Health information restrictions (Queensland Health information related policies, patient data confidentiality and ethics requirements), limited availability of support from IT technical staff and time restrictions. These factors have influenced the process for the warehouse model development, necessitating an incremental approach. This highlights the presence of many practical barriers to data warehousing and integration at the clinical service level. Limitations included the use of a small convenience sample of survey respondents, and a single site case report study design. As mentioned previously, the proposed data warehouse is a prototype and was developed using only four database repositories. Despite this constraint, the research demonstrates that by implementing a data warehouse at the service level, decision-making is supported and data quality issues related to access and availability can be reduced, providing many benefits. Output reports produced from the data warehouse prototype demonstrated usefulness for the improvement of decision-making in the management of clinical services, and quality and safety monitoring for better clinical care. However, in the future, the centralised model selected can be upgraded to an enterprise wide architecture by integrating with additional hospital units’ databases.

Conversation, community and kids: blogging for youth at Gold Coast City Council libraries

In late 2007, Gold Coast City Council libraries embarked on an online library project, designed to ramp up libraries’ online services to customers. As part of this project, the Young People’s team identified a need to connect with youth aged 12 to 16 in the online environment, in order to create a direct channel of communication with this market segment and encourage them to engage with the library. Blogging was identified as an appropriate means of communicating with both current and potential library customers from this age group. The Young People’s team consequently prepared a concept plan for a youth blog for launch in Children’s Book Week 2008 and are working towards development of management and administrative models and documentation and implementation of the blog itself. While many libraries have been quick to take up Web 2.0-style services, there has been little formal publication about the successes (or failures) of this type of project. Likewise, few libraries have published about the planning, management, and administration of such services. The youth blog currently in development at Gold Coast City Council libraries will be supported by a robust planning phase and will be rigorously evaluated as part of the project. This paper will report on the project (its aims, objectives and outputs), the planning process, and the evaluation activities and outcomes.

Sociobiological Aspects of Resilience

The chapter approaches resilience from an evolutionary psychology perspective. In recent years scientific studies have revealed many of the biological processes associated with resilient behaviour. The authors argue that the internal constitution and mental toughness of the individual will provide a core protection for life's inevitable tests. A nurtured developing brain 'in-utero' and a physically close dyadic relationship in the early years of life, are crucial to the provision of a resilient personality. Many descriptors of the construct of resilience presented in various studies are explored in this chapter.

A Research Framework for Investigating Public Private Partnerships (PPP) in Hong Kong

PPP is a general term covering all contracted relationships between the public and private sectors to produce a public asset or to deliver a public service. Its major advantage lies in utilising resources from the private sector to alleviate some of the financial burdens of the government. The Asian financial turmoil in the late 1990s has imposed enormous pressure on the budget of the Hong Kong Special Administrative Region (HKSAR) Government. With a continuous outcry for better public services due to the rapid development of Hong Kong, alternative financing models need to be sought to ensure sustainability. Hong Kong has the advantage of being the international gateway to Mainland China, and with this benefit has attracted overseas enterprises to base their offices in Hong Kong for the Asian market. Obviously the private sector has much to contribute. The HKSAR Government has realised the benefits of using PPP in Hong Kong as well as the success achieved overseas. But a more thorough research is needed to develop the most suitable practice of PPP in terms of project nature, project complexity, project type and project scale under which PPP is most appropriate for Hong Kong. This paper provides an initial report of a research project being funded by the Research Grants Council (RGC) of the HKSAR. The project aims to evaluate the benefits and risks of PPP adopted in Australia and the United Kingdom, and from these previous experiences to develop a best practice framework for implementing PPP in Hong Kong. It firstly reports on the status of PPP development trend and the hands-on experiences which have been drawn in these countries. Qualitative and quantitative research methods applied in conducting the research are discussed. The likely impacts of the study are highlighted. It is believed that the construction industry and the government would benefit a lot as a result of this study, and further procurement and project financing options would be opened up for delivering better future public service.

Drawing the line : the legal status and treatment of the 17-year-old accused in Queensland

Seventeen year olds who come into contact with the police in Queensland are classified as adults and are not afforded the protections available under the Youth Justice Act 1992 (Qld) (YJA). As with any other adult, their offences are dealt with under a raft of legislative provisions including the Criminal Code 1889 (Qld) (the Code), the Police Powers and Responsibilities Act 2000 (Qld) (PPRA) and the Penalties and Sentences Act 1992 (Qld) (PSA). This article argues that this situation is unfair and contravenes international human rights agreements which Australia has ratified, in particular the United Nations Convention on the Rights of the Child (CROC). Article 1 of that Convention defines a child as a person under the age of 18. The youth offences legislation in Queensland only applies to those who have not yet turned 17. This article examines the effects of this anomaly in Queensland, focusing in particular on the pre-adjudication treatment of ‘17 year old adults’.

A multi-level model of leadership in complex project management

Management (or perceived mismanagement) of large-scale, complex projects poses special problems and often results in spectacular failures, cost overruns, time blowouts and stakeholder dissatisfaction. While traditional project management responds with increasingly administrative constraints, we argue that leaders of such projects also need to display adaptive and enabling behaviours to foster adaptive processes, such as opportunity recognition, which requires an interaction of cognitive and affective processes of individual, project, and team leader attributes and behaviours. At the core of this model we propose is an interaction of cognitive flexibility, affect and emotional intelligence. The result of this interaction is enhanced leader opportunity recognition that, in turn, facilitates multilevel outcomes.

Legal Profession Act 2007 s 319 - Whether costs agreement made after trial valid and enforceable - whether agreement had retrospective operation

The decision in QCOAL Pty Ltd v Cliffs Australia Coal Pty Ltd [2010] QSC 479 involved an examination of a number of issues relating to the assessment of costs under the Legal Profession Act 2007 (Qld). The decision highlights a range of issues which, in slightly different circumstances, may have deprived the successful party of the right to recover costs by reference to the costs agreement.

District Court debt decisions

This article examines the distinction between a "liquidated demand" and a claim for "unliquidated damages" and the implications of that distinction on the procedure for obtaining a judgment if the defendant fails to file a notice of intention to defend.

Devil's in the detail : judgment highlights need for invoice transparency

This article considers the implications of the decision in Clayton Utz Lawyers v P & W Enterprises Pty Ltd [2011] QDC 5, and the meaning of "itemised bill" as defined in the Legal Profession Act 2007 (Qld).

A nod to consent : in step with the UCPR

This article considers the decision of Robin DCJ in CTP Manager Limited v Ascent Pty Ltd [2011] QDC 74 and the likely impact of the decision on the practice in the court registries in similar circumstances.

Interim bills and costs assessment : was the application in or out of time?

This article examines the decision in Turner v Mitchells Solicitors [2011] QDC 61 and the issue whether an application for assessment of costs under an interim bill at the time of a final bill is subject to the usual 12-month restriction.

Optimal allocation of water in village irrigation systems of Sri Lanka

This PhD study examines whether water allocation becomes more productive when it is re-allocated from 'low' to 'high' efficient alternative uses in village irrigation systems (VISs) in Sri Lanka. Reservoir-based agriculture is a collective farming economic activity, which inter-sectoral allocation of water is assumed to be inefficient due to market imperfections and weak user rights. Furthermore, the available literature shows that a „head-tail syndrome. is the most common issue for intra-sectoral water management in „irrigation. agriculture. This research analyses the issue of water allocation by using primary data collected from two surveys of 460 rice farmers and 325 fish farming groups in two administrative districts in Sri Lanka. Technical efficiency estimates are undertaken for both rice farming and culture-based fisheries (CBF) production. The equi-marginal principle is applied for inter and intra-sectoral allocation of water. Welfare benefits of water re-allocation are measured through consumer surplus estimation. Based on these analyses, the overall findings of the thesis can be summarised as follows. The estimated mean technical efficiency (MTE) for rice farming is 73%. For CBF production, the estimated MTE is 33%. The technical efficiency distribution is skewed to the left for rice farming, while it skewed to the right for CBF production. The results show that technical efficiency of rice farming can be improved by formalising transferability of land ownership and, therefore, water user rights by enhancing the institutional capacity of Farmer Organisations (FOs). Other effective tools for improving technical efficiency of CBF production are strengthening group stability of CBF farmers, improving the accessibility of official consultation, and attracting independent investments. Inter-sectoral optimal allocation shows that the estimated inefficient volume of water in rice farming, which can be re-allocated for CBF production, is 32%. With the application of successive policy instruments (e.g., a community transferable quota system and promoting CBF activities), there is potential for a threefold increase in marginal value product (MVP) of total reservoir water in VISs. The existing intra-sectoral inefficient volume of water use in tail-end fields and head-end fields can potentially be removed by reducing water use by 10% and 23% respectively and re-allocating this to middle fields. This re-allocation may enable a twofold increase in MVP of water used in rice farming without reducing the existing rice output, but will require developing irrigation practices to facilitate this re-allocation. Finally, the total productivity of reservoir water can be increased by responsible village level institutions and primary level stakeholders (i.e., co-management) sharing responsibility of water management, while allowing market forces to guide the efficient re-allocation decisions. This PhD has demonstrated that instead of farmers allocating water between uses haphazardly, they can now base their decisions on efficient water use with a view to increasing water productivity. Such an approach, no doubt will enhance farmer incomes and community welfare.

Central Queensland Mining Supplies Pty Ltd v Columbia Steel Casting Co Ltd

In Central Queensland Mining Supplies Pty Ltd v Columbia Steel Casting Co Ltd [2011] QSC 183 Applegarth J considered complaints made by the defendant about the approach the plaintiff had taken in its endeavour to comply with its disclosure obligation under r 211 of the Uniform Civil Procedure Rules 1999 (Qld). The judgment also provides an indication of the direction the court is taking in relation to disclosure and document management in matters involving large numbers of documents.

Practice and Procedure. Self-executing order - construction - whether further judicial at required for self-executing order to take effect

In Mango Boulevard Pty Ltd v Spencer [2010] QCA 207, a self-executing order had been made in consequence of continuing default by parties to the proceedings in meeting their disclosure obligations. The case involved several questions about the construction and implications of the self-executing order. This note focuses on the aspects of the case relating to that order.

Practice and procedure : a recent Court of Appeal case examines the meaning of 'third party payer' in terms of Part 3.4 of the Legal Profession Act 2007.

In Legal Services Commissioner v Wright [2010] QCA 321 the Queensland Court of Appeal allowed an appeal from the first instance decision. The decision involved the construction of “third party payer” in Part 3.4 of the Legal Profession Act 2007 (Qld).