Difference between revisions of "Missing TotalLOS Data from IBID Query"

Latest revision as of 14:43, 25 July 2013

Overview

This problem manifests itself as the TotalLOS column being empty in output from the IBID Query function. This affected all versions of the software up to and including v1.1.8.

Software Patch

The software patch takes the form of an SQL script that re-creates the VIEW_IBID_DISCHARGE object so that the TotalLOS field is correctly output.

The file is available as a download on [[1]] to all registered users. Look for the download TotalLOS (IBID Query) Patch UF#665 in the Misc Downloads section.

SQL

Instead of downloading the SQL file, you can cut & paste the contents here:

DROP VIEW [dbo].[VIEW_IBID_DISCHARGE];

GO

CREATE VIEW [dbo].[VIEW_IBID_DISCHARGE] (IBID_MAIN_ID, IBID_ADMISSION_ID, TOTALLOS, DISCHORDEATHDATE, DISCHORDEATHTIME, DEATH, DISCHARGE_NURSE, DISCHARGEDEST, DISCHARGEDEST_DESC, DISCHARGEWEIGHT, WEIGHTLOSS, DISCHDRESSING, DISCHARGE_INFO_GIVEN, POSTMORTEM, OTHERCAUSESOFDEATH, GENERALCOMMENTS) 
AS
SELECT
    ADM.IBID_MAIN_ID,
    ADM.IBID_ADMISSION_ID,
    A_DIS.TOTALLOS,
    ADM.DISCHORDEATHDATE,
    ADM.DISCHORDEATHTIME,
    ADM.DEATH,
    ADM.DISCHARGE_NURSE,
    ADM.DISCHARGEDEST,
    DISCHDESTCODE.TERM_DESC AS DISCHARGEDEST_DESC,
    ADM.DISCHARGEWEIGHT,
    ADM.WEIGHTLOSS,
    ADM.DISCHDRESSING,
    ADM.DISCHARGE_INFO_GIVEN,
    ADM.POSTMORTEM,
    ADM.OTHERCAUSESOFDEATH,
    ADM.GENERALCOMMENTS
FROM IBID_ADMISSIONDISCHARGE ADM 
LEFT JOIN IBIDA_DISCHARGE A_DIS ON (ADM.IBID_MAIN_ID = A_DIS.IBID_MAIN_ID)
LEFT JOIN CODES DISCHDESTCODE ON (ADM.DISCHARGEDEST = DISCHDESTCODE.CONCEPT_CODE) AND (DISCHDESTCODE.CODE_LIST = 'IBID_DISCHARGEDEST');

GO

UPDATE [dbo].[DB_INFORMATION] SET CACHE_DATE = CURRENT_TIMESTAMP;

GO

The change is on the line A_DIS.TOTALLOS which has been altered from ADM.TOTALLOS. In addition we've added a left join to IBIDA_DISCHARGE on the second to last line. This is required to access the A_DIS.TOTALLOS field.