Project Overstay2: Difference between revisions

Generation of data (will be moved before go-live): removing this section from this page. This page is for collection instructions and raw data meaning only, and it already directs to Overstay2 Overview for context.
Line 20: Line 20:
{{ListICD10Category | categoryName = Dementia}}
{{ListICD10Category | categoryName = Dementia}}
* [[Previous Location]] if that is still what we want to use for "from out of town" now that we have [[Postal Code]].
* [[Previous Location]] if that is still what we want to use for "from out of town" now that we have [[Postal Code]].
=== Generation of data (will be moved before go-live) ===
*In the generation of data, I have used the following:
{{DT |
*OutsideWPG - I have used [[Previous Location]] because Leigh Anne specified the patient came from a facility outside of Winnipeg.
** MB - I would think Leigh Anne had used the [[Province]] because the data set  has no [[Postal Code]]  yet
** I just checked the query ''check_from_out_of_town'' I used to derive this and it only considered [[Pre-admit Inpatient Institution]] having geog like "out-of*"! [[User:Ttenbergen|Ttenbergen]] 16:57, 24 January 2025 (CST)
*** Will ask Dr. Roberts what this was all about to better understand what to use now. Specifically, if we use previous location, would we only care about hospitals, or also e.g. nursing stations, PCH, hospice, "unknown/other" loc_types.  [[User:Ttenbergen|Ttenbergen]] 16:51, 24 January 2025 (CST)
}}
{{DJ
|*Charlson categories are provided but the CCMDB Script model  only includes MI, Pulmonary, Connective, Renal
** It also contains the full score as part of Charlson_nh. [[User:Ttenbergen|Ttenbergen]] 19:15, 25 January 2025 (CST)
*** correct, there are selected subcategories and also FULL CHARLSON SCORE for those from Nursing Home. --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
** I think "connective" became "Rheumatic disease" in ICd10, right? [[User:Ttenbergen|Ttenbergen]] 16:41, 24 January 2025 (CST)
*** Yes it refers to Connective Tissue Disease-Rheumatic Disease. --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
}}
**NH (Nursing Home) - these data are from the tmp Overstay and the NH start dates from Manitoba Health which DR Roberts requested. we do not have the [[Pre acute living situation]] at that time but I agree just to use the [[Pre acute living situation]] . When I Have looked at the CCMDB script I noticed that NH includes PCH and Chronic Health Facility, is this correct?
*ADL score - I have used the 0,3,6  values (same ADL as in ALERT score)
{{Discuss |
* ADLmean_nh - in the CCMDB Script it is written -- Adlmean_nh {{=}} (ADLScore - 12)*(from a nursing home),  what does 12 mean?
** Very good question. The function adl_sc used to get the individual scores just generates a score of 0, 3 or 6, or -1 if given bad input. That doesn't explain why -12. And I can't imagine why this would be. But it's consistent between two functions, so unlikely to be just a finger fumble. [[User:Ttenbergen|Ttenbergen]] 19:15, 25 January 2025 (CST)
*** looks like  '''ADLmean''' does not imply average of the 6 individual ADL categories (e.g. total ADL SCore/6)  but (TOTAL ADL Score -12). I'm guessing here, maybe 12 is the Grand Mean of total ADL and Leigh Anne is trying to evaluate the deviation of the individual data point from the mean of the dataset of those from Nursing Home . --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
}}
** same with Adlmean_age = (ADLScore - 12)*(age), what does 12 mean?
** Charlson_nh = (Charlson score)*(from a nursing home)  -- this is clear. --[[User:JMojica|JMojica]] 13:53, 24 January 2025 (CST)


=== Data Entry Instructions ===   
=== Data Entry Instructions ===