PatientFollow Project: Difference between revisions

(8 intermediate revisions by 2 users not shown)

Line 16:

== Actual chart number split per site and per laptop ==

The split is automatically reflected in [[Cognos2 Service Starter]], no additional filtering needed.

The split is automatically reflected in [[Cognos2 Service Starter]], no additional filtering needed. The corresponding data is stored in [[S PatientFollow distribution table]].

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

Line 28:

== Follow between medicine/critical care or just within one program ==

~~For now~~ we ~~are testing this~~ just following patients within the same program, ~~eg if a patient were admitted~~ to ~~a medicine ward, then ICU, and then back~~ to ~~the same medicine ward, then the medicine collector would get the two med admissions, and the CC~~ collector ~~would~~ collect the ~~ICU stay. This may change in the future but would require fairly significant changes to [[CCMDB.accdb Data Integrity Checks~~]] ~~and other settings in [[CCMDB~~.~~accdb]].~~

Initially we were just following patients within the same program, but later we moved on to [[Change to having each collector collect both programs on the same laptop]].

~~=== Programming that would need to be updated to be able to use a laptop across programs ===~~

* cross checks have been checked as part of previous project, should work

* Generupdate / query check_tmp_generate_allowed

* Hider

* Converter functions Hosp, Loc, Prog

== old process and questions that were addressed ==

{{Collapsable

| always= old process and questions that were addressed

Line 63:

Line 58:

| 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. Additional analysis info is in S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test and Data.xlsx

** 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 ''{{S:\MED\MED_CCMED}}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''.

*** 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 ''{{S:\MED\MED_CCMED}}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'' .

** 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 ''{{S:\MED\MED_CCMED}}CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution'' .

* I think this is a good starting strategy to allocate patients among the data collectors proportionately in each site.}}

Line 96:

Line 91:

=== Transition dates ===

Since this demarcation comes up repeatedly, use [[query created_PatientFollow]] so this is done consistently.

{{Collapsable

| always= Transition dates

Line 108:

Line 105:

*(Excludes HSC IICU)

**All patients who have an ''Accept DtTm'' or [[Dispo DtTm field | Dispo DtTm]] ON or AFTER '''2020-Oct-15''' the collector will apply the patient follow model

** In the Task meeting Nov 30,2021, it was decided that HSC CC has to go back to the old system, admissions at HSC MICU and HSC SICU ~~are in~~ separate ~~record and no longer continuous as one record~~. ~~There were only 11 records from~~ '''2020-Oct-15'''~~already~~ vetted ~~that~~ were un-winded.

** In the Task meeting '''Nov 30,2021''', it was decided that HSC CC has to go back to the old system, continuous admissions at HSC MICU and HSC SICU had been changed and made into 2 separate records onwards. From '''2020-Oct-15''', there were only 11 vetted records having such case and they were un-winded.

====STB====

STB Med

Line 124:

Line 121:

[[Category:PatientFollow Project| *]]

[[Category:Change explainer page]]

@@ Line 16: / Line 16: @@
 == Actual chart number split per site and per laptop ==
-The split is automatically reflected in [[Cognos2 Service Starter]], no additional filtering needed.
+The split is automatically reflected in [[Cognos2 Service Starter]], no additional filtering needed. The corresponding data is stored in [[S PatientFollow distribution table]].
 === Viewing the numbers assigned to a given laptop ===
@@ Line 28: / Line 28: @@
 == Follow between medicine/critical care or just within one program ==
-For now we are testing this just following patients within the same program, eg if a patient were admitted to a medicine ward, then ICU, and then back to the same medicine ward, then the medicine collector would get the two med admissions, and the CC collector would collect the ICU stay. This may change in the future but would require fairly significant changes to [[CCMDB.accdb Data Integrity Checks]] and other settings in [[CCMDB.accdb]].
+Initially we were just following patients within the same program, but later we moved on to [[Change to having each collector collect both programs on the same laptop]].
-=== Programming that would need to be updated to be able to use a laptop across programs ===
-* cross checks have been checked as part of previous project, should work
-* Generupdate / query check_tmp_generate_allowed
-* Hider
-* Converter functions Hosp, Loc, Prog
+== old process and questions that were addressed ==
 {{Collapsable
 | always= old process and questions that were addressed
@@ Line 63: / Line 58: @@
 | 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. Additional analysis info is in S:\MED\MED_CCMED\ChartLastDigitAnalysis\NormalizedCounts_Comparison\2_Paired T-Test and Data.xlsx
+** 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 ''{{S:\MED\MED_CCMED}}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''.
+*** 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 ''{{S:\MED\MED_CCMED}}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'' .
+** 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 ''{{S:\MED\MED_CCMED}}CCMDB_Special_Projects\Project_PatientFollow_ChartNumberDistribution'' .
 * I think this is a good starting strategy to allocate patients among the data collectors proportionately in each site.}}
@@ Line 96: / Line 91: @@
 === Transition dates ===
+Since this demarcation comes up repeatedly, use [[query created_PatientFollow]] so this is done consistently.
 {{Collapsable
 | always= Transition dates
@@ Line 108: / Line 105: @@
 *(Excludes HSC IICU)
 **All patients who have an ''Accept DtTm'' or [[Dispo DtTm field | Dispo DtTm]] ON or AFTER '''2020-Oct-15''' the collector will apply the patient follow model
-** In the Task meeting Nov 30,2021, it was decided that HSC CC has to go back to the old system, admissions at HSC MICU and HSC SICU are in separate record and no longer continuous as one record.  There were  only 11 records from '''2020-Oct-15'''already vetted that were un-winded.
+** In the Task meeting '''Nov 30,2021''', it was decided that HSC CC has to go back to the old system, continuous admissions at HSC MICU and HSC SICU had been changed and made into 2 separate records onwards.  From '''2020-Oct-15''', there were  only 11 vetted  records  having such case  and they were un-winded.
 ====STB====
 STB Med
@@ Line 124: / Line 121: @@
 [[Category:PatientFollow Project| *]]
+[[Category:Change explainer page]]