| edit | S dispo table |
- "Hospice - other, WPG" is currently not grouped as Hospital = "Other Institution in WPG" as the other hospices - should it be? Ttenbergen 17:03, 11 March 2025 (CDT)
| 2025-03-12 5:26:14 AM |
| edit | Charlson Comorbidity Index |
Do we ever include the age in the Charlson score? Should we? If not, we need to clearly document that, since others looking at this score would expect us to use the original definition. Ttenbergen 11:03, 28 January 2025 (CST)
- No, the one I had provided with label =Charlson Score has no Age , just sum of all categories. The APACHE SCORE for sure has the AGE score and not Charlson Score. --JMojica 11:26, 28 January 2025 (CST)
Did we include age as part of the data used to generate the Overstay model? We need to use whatever we used for that in our score and generator.
- The problem is I did not see the final overstay model and I'm only relying on what was on the WIKI Overstay Predictor Project Algorithm showing the AGE and AgexADLmean. In Rodrigo's model, Age is included. I would presume Leigh Anne also included it.--JMojica 11:26, 28 January 2025 (CST)
- I just re-read your original answer, and it actually addressed my question: any Charlson Score you gave them did not include that age factor. I am pretty sure the official Charlson score does include an age factor, I implemented it in CCMDB (not CFE for some reason) "L_ICD10_Charlson_Agepts" query. We had this conversation before, but then I didn't document what was the reason to omit the age from the score. It makes a significant difference to the score, so whoever uses our data (eg is it included in our dump to MCHP) would expect it to include the age portion. Ttenbergen 18:08, 29 January 2025 (CST)
| 2025-03-18 10:18:15 PM |
| edit | Re-analysis and generation of Overstay2 model |
Does this page miss anything that is not addressed elsewhere as per pages either linked from here or from Overstay2 Overview? If not feel free to delete this question. Ttenbergen 15:19, 23 February 2025 (CST) | 2025-03-11 10:24:07 PM |
| edit | SBGH L2 |
I have linked this in from several reports based on those having "L2" in them. There might be others where I just don't know that they also use this building location because they word it through stb icu or cardiac unit or something. It would be worth updating and linking those reports so that, when a location related to them changes, we will be easily able to find it on the wiki and know the underlying SAS might need updating. Ttenbergen 12:35, 20 March 2025 (CDT) | 2025-03-21 3:27:04 AM |
| edit | ER Delay |
I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST) | 2025-03-18 10:18:16 PM |
| edit | S dispo.loc type |
in s_dispo table HSC Lennox Bell is listed as loc_type=unknown/other ; many in that location would be most similar to "home", so should these be grouped as "non-patient" instead? Wherever we deal with "home", are we already including these? For example, for Readmission to MedWard, would we include anyone who has been discharged to a "non-patient" location, or do we use more explicit groupings? Ttenbergen 15:24, 11 March 2025 (CDT)
also in s_dispo table HSC Lennox Bell is listed as site=HSC; it kind of is, but wherever that column is used to group, would this be a location we would expect in that group? Or should it be blank? Ttenbergen 15:24, 11 March 2025 (CDT) | 2025-03-11 10:13:35 PM |
| edit | Re-analysis and generation of Overstay2 model |
is this really simply "to a non-hospital location" or is it the same as above: "to a destination outside of the hospital of the admission (can be to other hospital)"?
| 2025-03-11 10:24:07 PM |
| edit | Instructions for importing a batch of DSM Data |
Thanks for updating, but I don't understand... I thought the whole idea with having them in L_Problems_D_ID would be that that is the actual data used to do the translation from one ID to the other. Do you mean you actually hard-code it in SAS instead? I ask because you say you need to modify the SAS program to incorporate the change. Ttenbergen 21:47, 14 March 2025 (CDT)
- That is correct, I add a line in my SAS code to change the unmatched D_ID between the DSM dumped data versus the L_LOG D_IDs. Pagasa was instructed to list down in the L_Problems_D_ID those D_ID she had changed during her data processing task if these D_IDs had already been for DSM request. There will be no entry in the L_Problems_D_ID if any change in D_ID happens before sending a DSM request. So far, SAS finds zero of such case. If in case, SAS finds any record in the requestor not in L_LOG, that is only the time the SAS code assigns a new D_ID to the dumped DSM D_ID so as to be consistent with the L_Log D_ID. --JMojica 10:38, 17 March 2025 (CDT)
| 2025-03-17 3:38:11 PM |
| edit | ER Delay |
This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)
- OK, will be working on this getting data from Moves for Medicine from period Sept 2007 to June 3, 2011. will give to Pagasa for upload to Arrive DtTm field. I will update the WIKI as soon as done. Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing. --JMojica 16:35, 2024 December 11 (CST)
| 2025-03-18 10:18:16 PM |
| edit | Readmission to MedWard |
when we were setting up LAU collection readmission data we realized that we are not clear on what exactly is included in a Discharged to community. We should decide how to define that and whether it should apply here and/or for other reports. | 2025-03-20 2:51:18 AM |
| edit | Standard data cleaning process |
While discussing Visit Admit DtTm differences within same admission at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 I realized we don't have any part of your "cleaning" process documented. We should, even if it is a rudimentary notice of the SAS files you use and what you check for. Ttenbergen 21:51, 11 March 2025 (CDT)
If there is linking beyond Populate linking pairs, or if you use a different linkage, we need to document that as well; do you? Ttenbergen 21:51, 11 March 2025 (CDT) | 2025-03-12 2:51:43 AM |
| edit | Project Overstay2 |
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. Ttenbergen 19:15, 25 January 2025 (CST)
- correct, there are selected subcategories and also FULL CHARLSON SCORE for those from Nursing Home. --JMojica 09:29, 27 January 2025 (CST)
- I think "connective" became "Rheumatic disease" in ICd10, right? Ttenbergen 16:41, 24 January 2025 (CST)
- Yes it refers to Connective Tissue Disease-Rheumatic Disease. --JMojica 09:29, 27 January 2025 (CST)
| 2025-03-05 1:56:38 AM |
| edit | S dispo.geog | Use
??? | 2025-03-12 4:47:50 AM |
| edit | L TmpV2 multi-entry clean-up | Did we ever resolve this? What was the outcome? If we didn't resolve it, do we still need to? If not, can we delete this page? | 2025-03-15 3:15:57 AM |
| edit | Re-analysis and generation of Overstay2 model | Do you have numbers for something like false positives/ false negatives/ positive predictive value/ etc? Will rely on you to make this something that would satisfy someone questioning this from a statistical angle. Ttenbergen 15:19, 23 February 2025 (CST) | 2025-03-11 10:24:07 PM |
| edit | DSM Labs data.accdb | Emailed Julie:
- found overlap in old file, what does it mean
- proposed using labDtTm for split threshold
Ttenbergen 16:51, 2024 May 2 (CDT) | 2025-03-18 10:17:54 PM |
| edit | S dispo.center | Is this just an arbitrary sorting of units or is there a plan to it? Ttenbergen 16:02, 11 March 2025 (CDT) | 2025-03-11 10:09:28 PM |
| edit | Re-analysis and generation of Overstay2 model | number | 2025-03-11 10:24:07 PM |
| edit | S dispo.geog | Should these be geog = winnipeg
- Interventional Radiology
- Other Procedure Location
| 2025-03-12 4:47:50 AM |
| edit | Scanning to network | That scanner is gone, right? | 2025-03-18 11:06:02 PM |
| edit | Re-analysis and generation of Overstay2 model | where? | 2025-03-11 10:24:07 PM |