Skip to main content
All CollectionsFeature Announcements2025January 2025
Updated Data Retention Logic for Current Patient Placement - Data IQ®
Updated Data Retention Logic for Current Patient Placement - Data IQ®
William Pelino avatar
Written by William Pelino
Updated over a month ago

Updated

Updated the data retention logic for the Current Patient Placement data source.

Problem

We found that placement records that had not been updated within the past 48 hours were automatically removed.

Solution

Current Patient Placement will now retain all placement records for patients who are still in-house, ensuring that the patient status for all placements associated with a patient is accurately represented.

Key Changes:

  • New Retention Logic: All placement records for in-house patients will now be retained, regardless of their update frequency, to ensure that all placement statuses are visible.

  • Impact on Data Volume: Due to the retention of all active placements, you may see an increased volume of placement records in the Current Patient Placement data source.

Note:

  • This data source now contains all placements for an active patient visit (according to the updated retention logic), which can result in multiple placement records for the same patient visit if multiple placements occur within a 48-hour period.

  • Multiple placement records often occur when there is a Pre-Admit Placement alongside an open Pending Transfer Placement.

  • Therefore, it is not accurate to expect only a single placement record for a patient visit in this table.

Filtering Recommendations:

To filter and view more specific placement data, please use appropriate filters in Tableau, such as:

  • If you wish to see fewer placement records per patient you will need to utilize filters in Tableau, such as Patient Status Type.

  • If you only want to view the latest record for a patient, please use the following calculated fields in Tableau (substitute the relevant timestamp for your use case):

    • Max Patient Record
      {FIXED [Patient Visit Number]: MAX([Bed Request Timestamp])}

    • Max Patient Record Filter

      IF [Bed Request Timestamp] = [Max Patient Record] THEN 'Keep' ELSE 'Remove' END

  • If your use case requires a different timestamp, you will only need to swap out the timestamp in the first calculation. Add 'Max Patient Record Filter' as a filter to the worksheet and filter to only keep the records with 'Keep'. This will ensure that there is only one record per patient in the worksheet.

Did this answer your question?