PatientFollow Project: Difference between revisions

Line 39:

== What would be the actual chart number split per site and per collector ==

{{Discuss|

I think this needs an update as to what we are supposed to do, I don't believe MineMine button is being used? }}

* I think this needs an update as to what we are supposed to do, I don't believe MineMine button is being used? (blezak)

** Correct, I have updated it, please see if it makes sense now. Ttenbergen 11:56, 2020 October 21 (CDT) }}

We would essentially take the sum EFTs per program/site and consider them as 100%, and then assign the chart numbers based on that percentage. For example, if a site has 3 collectors that are each a .5EFT, each collector would get 33% of that site's new admissions, so collector A might get charts ending in 00-33, collector B 34-66, and collector C 67-99.

The actual split is ~~implemented using the~~ [[~~"Mine! Mine!" button~~]]~~. See [[s_PatientFollow_distribution table]] for master version of current distribution~~.

The actual split is automatically reflected in [[Cognos Admitter]], no additional filtering needed.

The ~~excel sheet with Julie~~'~~s analysis~~ is ~~at S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test~~ and ~~Data~~.~~xlsx~~

=== Viewing the numbers assigned to a given laptop ===

The assignment is a matter of laptop, chart number ending and the date at which point a specific distribution started. We don't want to store it here on the wiki because it is kind of messy and hard to keep updated. Use [["Show PatientFollow allocation" button]] to see which numbers are assigned to the laptop you are working on during which timeframe.

{{Collapsable

| always= The last two digits of chart numbers are evenly distributed and can be used for this.

| full= * Tina has taken a basic look at the distribution of these numbers and emailed Julie and Trish for feedback. Ttenbergen 17:31, 2019 August 1 (CDT)

** Julie did additional analysis by looking at the distribution of the '''last two digits''' numbers from last 5 years 2014 to 2018 as follows: 1) all sites together, 2) each site separately 3) each year from all sites separately and 4) each site and year - the distributions showed similarity with few peaks in some numbers. She grouped the last two digits numbers into a) 10 subgroups (e.g. 0-9,10-19,20-29, …, 90-99 ) and b) 20 subgroups (e.g. 0-4, 5-9, 10-14, 15-19, …, 95-99) and their distributions showed uniformly across subgroups. Each of the 10 subgroups showed counts close to 10% while each of the 20 subgroups showed counts close to 5%. The histograms are in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''. The results support the viability of using the last two digits of the chart number in allocating patients among the data collectors.

** Julie did additional analysis by looking at the distribution of the '''last two digits''' numbers from last 5 years 2014 to 2018 as follows: 1) all sites together, 2) each site separately 3) each year from all sites separately and 4) each site and year - the distributions showed similarity with few peaks in some numbers. She grouped the last two digits numbers into a) 10 subgroups (e.g. 0-9,10-19,20-29, …, 90-99 ) and b) 20 subgroups (e.g. 0-4, 5-9, 10-14, 15-19, …, 95-99) and their distributions showed uniformly across subgroups. Each of the 10 subgroups showed counts close to 10% while each of the 20 subgroups showed counts close to 5%. The histograms are in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''. The results support the viability of using the last two digits of the chart number in allocating patients among the data collectors. Additional analysis info is in S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test and Data.xlsx

*** Additional analyses were done separately for Medicine and Critical Program for each site and 1) each year, 2) each quarter and 3 )each month to determine any seasonal variation across time. The distributions are generally uniform across subgroups with relatively few peaks. However, there seems to be some seasonal variation which is observed more in Critical Care than Medicine Program. The histograms are also in in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''.

** Julie also did the distribution of the '''first two digits''' numbers and found out that the distribution was skewed to the right. Therefore, this cannot be used as a tool for allocating patients. The distribution is in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution'' .

@@ Line 39: / Line 39: @@
 == What would be the actual chart number split per site and per collector ==
 {{Discuss|
-I think this needs an update as to what we are supposed to do, I don't believe MineMine button is being used? }}
+* I think this needs an update as to what we are supposed to do, I don't believe MineMine button is being used? (blezak)
+** Correct, I have updated it, please see if it makes sense now. Ttenbergen 11:56, 2020 October 21 (CDT) }}
 We would essentially take the sum EFTs per program/site and consider them as 100%, and then assign the chart numbers based on that percentage. For example, if a site has 3 collectors that are each a .5EFT, each collector would get 33% of that site's new admissions, so collector A might get charts ending in 00-33, collector B 34-66, and collector C 67-99.
-The actual split is implemented using the [["Mine! Mine!" button]]. See [[s_PatientFollow_distribution table]] for master version of current distribution.
+The actual split is automatically reflected in [[Cognos Admitter]], no additional filtering needed.
-The excel sheet with Julie's analysis is at S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test and Data.xlsx
+=== Viewing the numbers assigned to a given laptop ===
+The assignment is a matter of laptop, chart number ending and the date at which point a specific distribution started. We don't want to store it here on the wiki because it is kind of messy and hard to keep updated. Use [["Show PatientFollow allocation" button]] to see which numbers are assigned to the laptop you are working on during which timeframe.
 {{Collapsable
 | always= The last two digits of chart numbers are evenly distributed and can be used for this.
 | full= * Tina has taken a basic look at the distribution of these numbers and emailed Julie and Trish for feedback. Ttenbergen 17:31, 2019 August 1 (CDT)
-** Julie did additional analysis by looking at the distribution of the '''last two digits''' numbers from last 5 years 2014 to 2018 as follows: 1) all sites together, 2) each site separately 3) each year from all sites separately and 4) each site and year - the distributions showed similarity with few peaks in some numbers.  She grouped the last two digits numbers  into a) 10 subgroups (e.g. 0-9,10-19,20-29, …, 90-99 ) and b) 20 subgroups (e.g. 0-4, 5-9, 10-14, 15-19, …, 95-99)  and their distributions showed uniformly across subgroups. Each of the 10 subgroups showed counts close to 10% while each of the 20 subgroups showed counts close to 5%. The histograms are in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''.  The results support the viability of using the last two digits of the chart number in allocating patients among the data collectors.
+** Julie did additional analysis by looking at the distribution of the '''last two digits''' numbers from last 5 years 2014 to 2018 as follows: 1) all sites together, 2) each site separately 3) each year from all sites separately and 4) each site and year - the distributions showed similarity with few peaks in some numbers.  She grouped the last two digits numbers  into a) 10 subgroups (e.g. 0-9,10-19,20-29, …, 90-99 ) and b) 20 subgroups (e.g. 0-4, 5-9, 10-14, 15-19, …, 95-99)  and their distributions showed uniformly across subgroups. Each of the 10 subgroups showed counts close to 10% while each of the 20 subgroups showed counts close to 5%. The histograms are in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''.  The results support the viability of using the last two digits of the chart number in allocating patients among the data collectors. Additional analysis info is in S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test and Data.xlsx
 *** Additional analyses were done separately for Medicine and Critical Program for each site and 1) each year, 2) each quarter and 3 )each month to determine any seasonal variation across time. The distributions are generally uniform across subgroups with relatively few peaks.   However, there seems to be some seasonal variation  which is observed more in Critical Care than Medicine Program. The histograms are also in  in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution''.
 ** Julie also did the distribution of the '''first two digits''' numbers and  found out that the distribution was skewed to the right. Therefore, this cannot be used as a tool for allocating patients. The distribution is in ''X:\CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution'' .