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.