CCU Service Tracking: Difference between revisions
Ttenbergen (talk | contribs) m template use |
Ttenbergen (talk | contribs) m Template:CCMDB Data Integrity Checks change, replaced: {{CCMDB Data Integrity Checks}} → {{CCMDB Data Integrity Checks|implemented}} |
||
| Line 1: | Line 1: | ||
{{Project | |||
| Project = | | Project = CCU Service Tracking | ||
| ProjectActive = legacy | | ProjectActive = legacy | ||
| ProjectProgram = CC | | ProjectProgram = CC | ||
| Line 44: | Line 44: | ||
** Done (07Aug2015) and all the patients under Cardiology service with admit dates from Oct 1, 2010 to May 31, 2015 are appended in L_TmpV2 table of CFE. Included are those with whole stay at MICU under Cardiology service (N=586) and the 13 cases found with partial stay under Cardiology service (i.e. they have 2 records in L_TmpV where the first one denotes the CCU service and the second one is the change to MICU service). [[User:JMojica|JMojica]] 17:00, 2015 August 11 (CDT) | ** Done (07Aug2015) and all the patients under Cardiology service with admit dates from Oct 1, 2010 to May 31, 2015 are appended in L_TmpV2 table of CFE. Included are those with whole stay at MICU under Cardiology service (N=586) and the 13 cases found with partial stay under Cardiology service (i.e. they have 2 records in L_TmpV where the first one denotes the CCU service and the second one is the change to MICU service). [[User:JMojica|JMojica]] 17:00, 2015 August 11 (CDT) | ||
== | ==CCMDB Data Integrity Checks== | ||
* query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | * query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | ||
* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | * query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | ||
| Line 56: | Line 56: | ||
STB/MICU -Merged files | STB/MICU -Merged files | ||
We had 13 patients edited manually - combined to one admission (CCU in MICU under CCU care then transferred to MICU service. instead of having 2 admission in MICU, made it one. The | We had 13 patients edited manually - combined to one admission (CCU in MICU under CCU care then transferred to MICU service. instead of having 2 admission in MICU, made it one. The CCU Service Tracking in TMP had been updated due to these changes (i.e. two rows containing ITEM=CCU and start date_time=admit date_time in CCU service as well as ITEM=MICU and start date_time=admit date_time in MICU service were added for each D_ID). | ||
*STB_MICU-26117 | *STB_MICU-26117 | ||
**Merged into one all tables except old tiss in July 23,2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-26128. | **Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-26128. | ||
*STB_MICU-26611 | *STB_MICU-26611 | ||
**Merged into one all tables except old tiss in July 23,2015. Old tiss fixed and added May 10, 2017. Kept 26611 and deleted STB_MICU-26626 | **Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26611 and deleted STB_MICU-26626 | ||
*STB_MICU-26683 | *STB_MICU-26683 | ||
**Merged into one all tables except old tiss in July 23,2015. Old tiss fixed and added May 10, 2017. Kept 26683 and deleted STB_MICU-26695 | **Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26683 and deleted STB_MICU-26695 | ||
*STB_MICU-27144 | *STB_MICU-27144 | ||
**Merged into one all tables except old tiss in July 23,2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-27161 | **Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-27161 | ||
*STB_MICU-27861 | *STB_MICU-27861 | ||
**Merged into one July 23,2015. Kept 27861 and deleted STB_MICU-27876 | **Merged into one July 23, 2015. Kept 27861 and deleted STB_MICU-27876 | ||
*STB_MICU-27917 | *STB_MICU-27917 | ||
**Merged into one July 23,2015. Kept 27917 and deleted STB_MICU-27930 | **Merged into one July 23, 2015. Kept 27917 and deleted STB_MICU-27930 | ||
*STB_MICU-28043 | *STB_MICU-28043 | ||
**Merged into one July 23,2015. Kept 28043 and deleted STB_MICU-28048 | **Merged into one July 23, 2015. Kept 28043 and deleted STB_MICU-28048 | ||
*STB_MICU-28205 | *STB_MICU-28205 | ||
**Merged into one July 23,2015. Kept 28205 and deleted STB_MICU-28216 | **Merged into one July 23, 2015. Kept 28205 and deleted STB_MICU-28216 | ||
*STB_MICU-28233 | *STB_MICU-28233 | ||
**Merged into one July 23,2015. Kept 28233 and deleted STB_MICU-28244 | **Merged into one July 23, 2015. Kept 28233 and deleted STB_MICU-28244 | ||
*STB_MICU-28330 | *STB_MICU-28330 | ||
**Merged into one July 23,2015. Kept 28330 and deleted STB_MICU-28340 | **Merged into one July 23, 2015. Kept 28330 and deleted STB_MICU-28340 | ||
*STB_MICU-28629 | *STB_MICU-28629 | ||
**Merged into one July 23,2015. Kept 28629 and deleted STB_MICU-28652 | **Merged into one July 23, 2015. Kept 28629 and deleted STB_MICU-28652 | ||
*STB_MICU-28727 | *STB_MICU-28727 | ||
**Merged into one July 23,2015. Kept 28727 and deleted STB_MICU-28741 | **Merged into one July 23, 2015. Kept 28727 and deleted STB_MICU-28741 | ||
*STB_MICU-28884 | *STB_MICU-28884 | ||
**Merged into one July 23,2015. Kept 28884 and deleted STB_MICU-28901 | **Merged into one July 23, 2015. Kept 28884 and deleted STB_MICU-28901 | ||
--[[User:PTorres|PTorres]] 10:02, 2015 October 2 --(CDT)[[User:PTorres|PTorres]] 16:54, 2017 May 10 (CDT) | --[[User:PTorres|PTorres]] 10:02, 2015 October 2 --(CDT)[[User:PTorres|PTorres]] 16:54, 2017 May 10 (CDT) | ||
| Line 90: | Line 90: | ||
[[Category: | [[Category:L TmpV2 Data]] | ||
[[Category: All Legacy Projects ICU]] | [[Category:All Legacy Projects ICU]] | ||