Missing TotalLOS Data from IBID Query
This is a Technical (IT) Instructions topic
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.