User:Ttenbergen/questions for tina
Jump to navigation
Jump to search
Questions
Toggle columns: ModDate
edit | page | question | ModDate |
---|---|---|---|
edit | page | question | ModDate |
edit | PowerBI Data Model for CCMDB | ER Delay and Overstay
Note from email from Julie 2024-20-24: I do not use any cut-off e.g. 2020-10-15 because the tmp has been populated by boarding data since July 2018 for ICU and Sept 2019 for Med. The cut-off Oct 2020 Patient Follow only applies for tmp Service but not for tmp Boarding loc. By the way. the patient follow started early at Grace Oct 1, 2020 (they piloted it), while HSC and STB started Oct15, 2020. Similar with EMIPs, I have two sources of ER-delay namely 1. from Accept and Arrive 2. from Tmp : first boarding dttm and second boarding dttm. If both have values, I use the one from the tmp source. | 2024-12-12 12:11:55 AM |
edit | DSM Lab Extract |
| 2023-07-05 5:36:20 PM |
edit | Query check ACP Status Collection |
| 2025-06-11 6:11:39 AM |
edit | Overstay2 data processing and reporting in CFE |
| 2025-02-23 10:13:18 PM |
edit | Project Overstay2 |
| 2025-06-09 12:16:33 AM |
edit | Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg |
| 2025-06-11 5:43:19 AM |
edit | Query NDC Bad Postal Code |
| 2025-03-18 10:17:59 PM |
edit | Link suspect visitAdmitDtTm mult to-from-home query |
| 2025-03-12 2:24:45 AM |
edit | ACP Status Collection |
| 2025-06-13 3:35:50 PM |
edit | Data definition for contributing factors for the Overstay2 project |
| 2025-06-09 2:51:29 PM |
edit | Chronic Health Facility |
| 2025-06-10 3:59:37 PM |
edit | Query check has transfer ready date or checkbox |
| 2024-11-15 6:12:47 PM |
edit | LAU Collection Project | Dan was right, this field is a mess trying to use our current definition with a population of patients that don't really fit an acute medicine profile. If the patient went to Rehab the Transfer Ready DtTm will reflect the time they are accepted, if they became palliative the Transfer Ready DtTm will reflect when they became so, otherwise much of this was a judgment call, as many would be deemed transfer ready on admission by our definition.Lisa Kaita 07:59, 11 April 2025 (CDT) | 2025-06-11 2:00:13 PM |
edit | LAU LTC consult | for this field the default entry for yes is the LTC Medical application, however I later realized that this is not a consult per se, as some have this completed without an actual consult to LTC (the learning process for this project was confusing, I should have spoken to someone from LTC before starting this) I continued to enter it this way, but also answered "yes" for those that had an actual LTC consult where the dttm were either earlier than the medical application or they did not have a medical application but had a LTC consult, I noted details in the Q column and the notes. I know this is an analysis nightmare but I think I can clean this up if before Julie does her analysis I go through these records Lisa Kaita 07:44, 11 April 2025 (CDT) | 2025-05-07 12:33:11 AM |
edit | LAU Public Trustee | I also used this field for FORM 21 but documented it in the Q column, should we take this out? I think there were a handful of these Lisa Kaita 07:27, 11 April 2025 (CDT) | 2025-05-03 5:39:57 AM |
edit | Chronic Health Facility | in s_dispo, Riverview has inpatient checked, Deer lodge does not. When all this is settled they should probably become consistent... but not sure which so not now. | 2025-06-10 3:59:37 PM |
edit | Created TransferReady query | Still need to import this into master CFE, the version I have right now is messed up. Here it is: | 2024-11-22 6:08:24 AM |
edit | Re-analysis and generation of Overstay2 model | still needs to be set up by Tina... | 2025-06-12 10:43:53 PM |
edit | Geri Rehab | this is one of the things we needed to discuss further, currently we capture RR5 as HSC_ward, but it is a combination of spinal cord rehab, NMSK rehab, amputation rehab, Riverview has stroke rehab, Deer Lodge has Geri rehab, If we are capturing these rehab wards for CGH, SOGH and VGH should we not be capturing this for all dispo locations that are rehab? Lisa Kaita 13:11, 8 April 2025 (CDT) | 2025-06-05 8:21:44 PM |
edit | High-Obs Wards | Tina to add. | 2025-03-20 5:17:20 PM |
To dos
wiki page | question | action |
---|---|---|
wiki page | question | action |
R Filter Field | _after
| 2023-07-13 |
Blood Product Data | _after
| 2022-06-22 |
Direct Data Access for RIS/PACS | _after
| 2022-06-22 |
Query check long transfer delay | _after
| 2022-08-04 |
Arrive DtTm field | _after
| 2023-05-04 |
Accept DtTm field | _ccmdb_dev
| 2023-05-04 |
R Filter Field | _CFE_Data_reconsolidate
| 2023-07-13 |
Hospitalization ID | _CFE_Data_reconsolidate
| 2022-09-25 |
Cross Check Engine | _dev_CCMDB
| 2022-04-27 |
S Priorities table | _dev_CCMDB
| 2023-05-17 |
Problems related to event timing of data consistency checks | _dev_ccmdb
| 2022-04-13 |
ClientGUID field | _dev_ccmdb
| 2022-09-25 |
Centralized data.mdb Requested Changes | _dev_centralized_data
| 2023-05-09 |
Processing errors in patient data | _dev_CFE
Automate the populating of notes so button just does it.
| |
Centralized data front end.accdb Change Request | _dev_CFE
| |
Centralized data front end.accdb Change Request | _dev_CFE
| |
CFE Inline Integrity Checks | _dev_CFE
| 2022-09-06 |
Query Mgmt Collector Admission Count | _Dev_CFE mgmt queries
| |
S dispo Collector Location table | _Dev_CFE mgmt queries
| |
DC Treatment | _dev_CFE_Data
| 2023-05-04 |
Location metadata storage | _locationData
| 2022-02-09 |
Collection location documentation | _locationData
| |
Location metadata storage | _locationData
| 2022-06-22 |
Query maintenance s tmp deletables | _regular * this should be done regularly, maybe every 6 months | 2023-02-10 |
Template:Location dropdown cleanup | _regular
| 2022-03-05 |
S dispo table | _wiki housekeeping
| 2022-02-10 |
S ICD10 Chapter block pattern table | _wiki housekeeping
| |
Collection location documentation | _wiki_housekeeping
| 2021-09-01 |
LOS | _wiki_housekeeping
| 2022-03-01 |
Palliative patient |
| 2025-06-11 |
Query check long transfer delay |
| |
ClientGUID field |
| 2022-06-30 |
High-Obs Wards |
| 2022-10-19 |
HSC-GA7S |
| |
APACHE Acute Diagnoses |
| |
HSC-GA7S |
| |
Transfusion of plasma products |
| 2023-09-30 |
HSC-GA7S |
| |
S Pathogens table |
| 2023-05-17 |
S AllDiagnoses table |
| 2023-05-17 |
"cannot open any more tables" in Access |
| 2022-12-07 |
Eliminating distinction between different ward types | CTU vs NTU - we decided at task that we wanted to eliminate the distinction. A lot of things are part of their network of information, so we will need to work out the details above before we can move ahead.
| |
Query check tmp 2 BL TR S same tm | do we have a query where two consecutive date_times have the same boarding loc? When checking ER_delay, found 2 cases with 2 ER entries which when re-checked was typo error on the second location. --JMojica 13:44, 2024 October 24 (CDT) | |
APACHE Acute Diagnoses | just Tina's working notes:
Scenarios:
AND any admit procedure is EITHER: (a) of the form 1.AA.xx, 1.AB.xx, 1.AC.xx, 1.AE.xx, 1.AD.xx, 1.AG.xx, 1.AJ.xx, 1.AK.xx, 1.AN.xx, 1.AP.xx
or (b) 2.AA.71.yy, 2.AB.71.yy, 2.AC.71.yy, 2.AE.71.yy, 2.AD.71.yy, 2.AG.71.yy, 2.AJ.71.yy, 2.AK.71.yy, 2.AN.71.yy, 2.AP.71.yy
| |
STB-L2HA | locationData
| 2022-06-28 |
S LocationData table | locationData
---
| 2022-02-10 |
Query NDC Bad Postal Code | PWC
| 2022-07-15 |
Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb | The query to re-populate this one is now incomplete; don't delete it, just review the output of the re-generating query against this one until fixed; deleting and re-importing breaks TISS and other entry functionatlity. | |
EPR Analytics | z
| 2022-01-01 |
Questioning data back to collectors | z
This process is more automated and would need to be validated before we could implement. It would be the least work for all involved, though, I think. We keep discussing this, talked about it again today. Ttenbergen 17:44, 2016 December 1 (CST) |