Template:Location dropdown cleanup: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>Temporary template to ensure consistent messaging on this topic.  
<noinclude>Temporary template to ensure consistent messaging on this topic.  


----
</noinclude>=== "Can we remove the items that are no longer [[Service/Location]]s, [[Previous Location]]s, [[Pre-admit Inpatient Institution]]s or [[dispo]] locations from the dropdowns?" ===
We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.
{{Todo
{{Todo
| who = Tina  
| who = Tina  
| todo_added =  2020-10-20
| todo_added =  2020-10-20
| todo_action = 2021-10-05
| todo_action = 2022-03-05
| question =  
| question = _regular
* Since no one person knows when an s_dispo item is no longer used on any laptop. Made [[CFE]] query ''z_s_dispo_inactivatable'' to check. Emailed Julie and Lisa to find out if OK to remove these from the list, and/or if there are other items that should be removed from the list. [[User:Ttenbergen|Ttenbergen]] 15:33, 2021 July 14 (CDT)
* Since no one person knows when an s_dispo item is no longer used on any laptop. Made [[CFE]] query ''z_s_dispo_inactivatable'' to check. Should check that query occasionally to review if other things can be cleaned up.
** This was flagged again. Tweaked and ran the query, and found the following available and unused on currently active patients on 2021-10-05:
*CON - OR
*CON - recovery
*CON ambulatory care
*GRA ambulatory care
*GRA_MICU
*HSC Cardiac cath Lab
*HSC Lennox Bell
*HSC_A7S stepdown
*OAK - OR
*OAK - recovery
*OAK ambulatory care
*OAK Dialysis Unit
*STB - Transitional care
*VIC - OR
*VIC - recovery
*VIC - Transitional care
*VIC ambulatory care
Some of these might still be legit just not currently used. Can any be deactivated? Sherry's question made me think that there should be more that should be taken off. It could be that there are pre-patient-follow profiles left that use the old entries, but that's a while ago, so it's also possible that collectors are not using the codes consistently. Sherry, could you give me three sample locations, and the field from which you think they should be no longer available? [[User:Ttenbergen|Ttenbergen]] 10:49, 2021 October 5 (CDT)
 
}}
}}
 
----
</noinclude>=== "Can we remove the items that are no longer [[Service/Location]]s, [[Previous Location]]s, [[Pre-admit Inpatient Institution]]s or [[dispo]] locations from the dropdowns?" ===
We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.


== query of what is currently available ==
== query of what is currently available ==
<pre>SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo
{{Collapsable
| always= SQL
| full=  <pre>SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo
FROM s_dispo
FROM s_dispo
WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True));
WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True));
</pre>
</pre>}}


== Query of what is currently used ==
== Query of what is currently used ==
query z_s_dispo_inactivatable 2021-10-05 contains the following:
query z_s_dispo_inactivatable
<pre>
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, L_Log_PIL.CountOfD_ID, s_dispo.previous_location, L_Log_P.CountOfD_ID, s_dispo.s_location, L_Log_SL.CountOfD_ID, s_dispo.dispo, L_Log_D.CountOfD_ID
FROM (((s_dispo LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Pre_admit_Inpatient_Institution
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete"))
GROUP BY L_Log.Pre_admit_Inpatient_Institution)  AS L_Log_PIL ON s_dispo.dispo_ID = L_Log_PIL.Pre_admit_Inpatient_Institution) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Previous_Location
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete"))
GROUP BY L_Log.Previous_Location)  AS L_Log_P ON s_dispo.dispo_ID = L_Log_P.Previous_Location) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID,  L_Log.Service_Location
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete"))
GROUP BY L_Log.Service_Location)  AS L_Log_SL ON s_dispo.dispo_ID = L_Log_SL.Service_Location) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Dispo
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete"))
GROUP BY L_Log.Dispo)  AS L_Log_D ON s_dispo.dispo_ID = L_Log_D.Dispo
WHERE (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True) AND ((L_Log_PIL.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True) AND ((L_Log_P.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True) AND ((L_Log_SL.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True) AND ((L_Log_D.CountOfD_ID) Is Null))
ORDER BY s_dispo.location_name;
</pre>

Latest revision as of 13:52, 2023 May 4

Temporary template to ensure consistent messaging on this topic.

_regular

  • Since no one person knows when an s_dispo item is no longer used on any laptop. Made CFE query z_s_dispo_inactivatable to check. Should check that query occasionally to review if other things can be cleaned up.
  • added: 2020-10-20
  • action: 2022-03-05
  • Cargo


  • Categories

"Can we remove the items that are no longer Service/Locations, Previous Locations, Pre-admit Inpatient Institutions or dispo locations from the dropdowns?"

We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.

query of what is currently available

SQL   
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo
FROM s_dispo
WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True));

Query of what is currently used

query z_s_dispo_inactivatable