2020-06 s dispo table cleanup

From CCMDB Wiki
Revision as of 14:20, 2020 June 5 by Ttenbergen (talk | contribs) (Created page with "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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Emailed Pagasa to change STB_E5a-880 one to service location STB_E5 so we can delete it. 
  • SMW


  • Cargo


  • Categories

Records with no corresponding entries

The following records had no corresponding entries at all. They were entirely removed from the table:

Records with s_location = true and no corresponding Service/Location entries

The s_location field expresses that a record can be a service location.

  • not summarized
  • SMW


  • Cargo


  • Categories
  • 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: