2020-06 s dispo table cleanup
This page describes what was done during the cleanup of the S dispo table and S locations allowed collection table started 2020-06-05.
Query
We needed to make sure that entries were never used in either Pre-admit Inpatient Institution field, Previous Location, Service/Location or Dispo.
| The following query was used. It takes a good long while to run. Don't even try it without filtering for a specific unit first. |
|
SELECT s_dispo.location_name, s_dispo.active, s_locations_allowed_collection.Laptop_identifier, Count(pa.D_ID) AS pa, Count(p.D_ID) AS p, Count(sl.D_ID) AS sl, Count(d.D_ID) AS d, sl.RecordStatus FROM ((((s_dispo LEFT JOIN s_locations_allowed_collection ON s_dispo.location_name = s_locations_allowed_collection.ServiceLocation) LEFT JOIN L_Log AS sl ON s_dispo.dispo_ID = sl.Service_Location) LEFT JOIN L_Log AS p ON s_dispo.dispo_ID = p.Previous_Location) LEFT JOIN L_Log AS d ON s_dispo.dispo_ID = d.Dispo) LEFT JOIN L_Log AS pa ON s_dispo.dispo_ID = pa.Pre_admit_Inpatient_Institution WHERE (((s_dispo.s_location)=True)) GROUP BY s_dispo.location_name, s_dispo.active, s_locations_allowed_collection.Laptop_identifier, sl.RecordStatus; |
S locations allowed collection table entries for inactive records
The following were allowed but their corresponding records in s_dispo table were inactive. They have been removed from S locations allowed collection table:
- STB_EMIPb - 0 entries, deleted
- STB_E6bB - 0 entries, deleted
- STB_E5b - 0 entries, deleted
entries with s_location = true but no entry in allowed table
The following had entries in S dispo table with s_location = true, but no corresponding entry in the allowed table. This means they were not available to enter.
- STB_B5a - 0 entries, deleted
- STB_E5a - 1 entry, STB_E5a-880
|
|
Records that had been added in covid madness but were never used
- The following records had no corresponding entries at all. They were entirely removed from the table:
- HSC_H7_MI
- HSC_H7_SI
Records with s_location = true and no corresponding Service/Location entries
The s_location field expresses that a record can be a service location.
|
|
|
- s_location true, active, allowed, has records : keep as is
- s_location true, active, allowed, no records :
- s_location true, active, no allowed, has records
- s_location true, active, no allowed, no records :
- s_location true, not active, allowed, has records :
- s_location true, not active, allowed, no records :
- s_location true, not active, not allowed, has records :
- s_location true, not active, not allowed, no records :
Related articles
| Related articles: |