Centralized data front end.accdb Change Log 2019: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "PL missing L Tables content" to "Reconnect_check_missing_L Tables_content query"
m Text replacement - "Created Variables Common table" to "Created_Variables_Common table (see Created_Variables_Common_2021 table)"
 
(One intermediate revision by the same user not shown)
Line 40: Line 40:
===2019-08-08===
===2019-08-08===
(must have been rolled, pagasa had it...)  
(must have been rolled, pagasa had it...)  
* updated [[Created Variables CC maker query]] as per email exchange between Julie and Allan:  
* updated Created Variables CC maker query (see [[Created Variables CC maker 2021 query]]) as per email exchange between Julie and Allan:  
** added (as in sum) field [ApTotal_Neuro] to field [ApTotal_Physiological]
** added (as in sum) field [ApTotal_Neuro] to field [ApTotal_Physiological]
** removed [ApTotal_Neuro] from call to [APACHE_Total]
** removed [ApTotal_Neuro] from call to [APACHE_Total]
Line 64: Line 64:
===2019-05-09-3===
===2019-05-09-3===
rolled out Ttenbergen 22:57, 2019 May 9 (CDT)
rolled out Ttenbergen 22:57, 2019 May 9 (CDT)
* changed the data type for the [[ER Delay]] in [[Created Variables Common table]] to 'single' to be same as other transfer delay and LOS, as per request from Julie by email from 2019-03-27 Ttenbergen 22:57, 2019 May 9 (CDT)
* changed the data type for the [[ER Delay]] in Created_Variables_Common table (see [[Created_Variables_Common_2021 table]]) to 'single' to be same as other transfer delay and LOS, as per request from Julie by email from 2019-03-27 Ttenbergen 22:57, 2019 May 9 (CDT)


===2019-05-09-2===
===2019-05-09-2===

Latest revision as of 15:05, 2023 April 19

see the Development Documentation Category for other development logs This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks.

Log

2020-...

See Centralized data front end.accdb Change Log 2020

2019-11-18

rolled out

2019-11-17

rolled out

2019-09-24

rolled from Pagasa's desk

  • updated more things for reconnector

2019-09-19

rolled out from Trish's desk

  • updated several things I got wrong in reconnector on first try.

2019-09-18

rolled out Ttenbergen 17:35, 2019 September 18 (CDT)

  • changed CCMDB.accdb to CCMDB.accdb, and centralized_data.mdb to centralized_data.accdb Ttenbergen 17:35, 2019 September 18 (CDT)

2019-09-11

rolled out PTorres 13:48, 2019 September 11 (CDT)

2019-08-08

(must have been rolled, pagasa had it...)

  • updated Created Variables CC maker query (see Created Variables CC maker 2021 query) as per email exchange between Julie and Allan:
    • added (as in sum) field [ApTotal_Neuro] to field [ApTotal_Physiological]
    • removed [ApTotal_Neuro] from call to [APACHE_Total]
  • updated Function APACHE_Total to not add [ApTotal_Neuro] since it's now already included
  • clean-up: deleted query created_variables_CC_maker1

2019-07-25

rolled out PTorres 13:51, 2019 July 25 (CDT)

2019-06-13

rolled out PTorres 14:10, 2019 June 13 (CDT)

2019-06-04

rolled out PTorres

2019-05-15

2019-05-09-3

rolled out Ttenbergen 22:57, 2019 May 9 (CDT)

  • changed the data type for the ER Delay in Created_Variables_Common table (see Created_Variables_Common_2021 table) to 'single' to be same as other transfer delay and LOS, as per request from Julie by email from 2019-03-27 Ttenbergen 22:57, 2019 May 9 (CDT)

2019-05-09-2

rolled out Ttenbergen 18:06, 2019 May 9 (CDT)

2019-05-09

rolled out --PTorres 14:20, 2019 May 9 (CDT)

2019-05-02

rolled outPTorres 15:49, 2019 May 2 (CDT)

P Outstanding Dispo query

2019-04-25

rolled out PTorres 11:55, 2019 April 25 (CDT

  • Tiss query also available in the downlist.

2019-04-09

rolled out Ttenbergen 11:10, 2019 April 10 (CDT)

  • updated query NDC_Dxs_vs_TISS_Dialysis to no longer require a TISS for apparently requiring Dxs since KDIGO definitions don't require dialysis.

2019-03-27

rolled out PTorres 10:26, 2019 March 27 (CDT)

2019-03-26

rolled out PTorres 14:16, 2019 March 26 (CDT)

2019-03-21

rolled out Ttenbergen 11:33, 2019 March 21 (CDT)

2019-03-20

rolled

  • tweaks to Query NDC Dxs vs TISS Dialysis PTorres 11:45, 2019 March 20 (CDT)

2019-03-13

rolled by Pagasa Ttenbergen 17:05, 2019 March 13 (CDT)

  • updated query NDC_Trach_Dx_TISS; this was the first look at he query and there were lots of false positives. Ttenbergen 17:05, 2019 March 13 (CDT)

2019-03-06

rolled PTorres 14:12, 2019 March 6 (CST)

2019-02-07

rolled PTorres 09:38, 2019 February 7 (CST)

  • deleted query "Query NDC discharged incomplete" as it is not used.
  • deleted done in Query NDC Dialysis TISS CCI now.
    • query "Query NDC CRRT TISS CCI"
    • Query NDC HD TISS CCI
    • Query NDC PD TISS CCI

2019-01-30

rolled to server Ttenbergen 09:00, 2019 February 7 (CST)

2019-01-30

  • copied to Master PTorres 10:22, 2019 January 30 (CST)
  • updated query "NDC_missing_L_Tables_content" - was broken because still looking at old l_dxs and l_como; but also tweaked false positives
  • Reconnect_check_missing_L Tables_content query - had false positives due to wrong CCI logic
  • also re-imported some old CLI, CRRT and VAP queries to be able to check them until the last pre-ICD10 patients are gone.

2019-01-07

rolled Ttenbergen 09:29, 2019 January 30 (CST)

  • updated Form LinkList that is triggered from "open suspect links" (used in Correcting suspect links) button to eliminate an error it was giving involving the ancient survive/expire field. However, this form is still not working right, and won't until Deceased patients is worked out. Added question about this there. Chances are we don't need this any more since this stuff is usually done with PLs and NDCs now. Left question in Deceased patients to deal with when that is resolved. Ttenbergen 08:38, 2019 January 7 (CST)
  • updated to name additional D_ID fields so this will work in query dropdown:
  • updated Function confirm_files_and_links() to no longer reconnect "s_ICD10_Block_Dxs", "s_ICD10_Blocks"
  • fixed problem with link_suspect_negative_transit_time query
  • re-connected the L_ICD10_subform_form to allow viewing dx descriptions rather than codes; turns out things are still fast, so the slow-down problem before must have been due to the CCI forms, which I don't need to re-connect because they list names already.

2019-01-02

copied to server Ttenbergen 23:24, 2019 January 6 (CST)

  • added rudimentary CCI and ICD10 forms; will need to make better
  • updated Function confirm_files_and_links() to include the new tables used in ICD10 and CCI:
    • s_CCI_Categories
    • s_CCI_Categories_Collection_Mode
    • s_ICD10_APACHE_Como_patterns
    • s_ICD10_APACHE_Dx_patterns
    • s_ICD10_Charlson_Como_conditions
    • s_ICD10_Charlson_Como_patterns
    • s_ICD10_Block_Dxs
    • s_ICD10_Blocks
  • imported queries and modified to use D_ID instead of Pat_ID as appropriate:
    • L_ICD10_APACHE_Comorbids
    • L_ICD10_APACHE_Dx
    • L_ICD10_Charlson_Agepts
    • L_ICD10_Charlson_component_points
    • L_ICD10_Charlson_dxs
    • L_ICD10_Charlson_score
    • s_ICD10_APACHE_Comorbids
    • s_ICD10_APACHE_Dx
    • s_ICD10_Charlson_Comorbids
  • query updates/creations:
  • deleted
    • "NDC Missing TransferDate w pivot" as confirmed by Julie on that page
    • "NDC_Pacemaker_TISS_wo_acquired" - was rolled in with query NDC Pacemaker acquired vs TISS
    • "NDC_VAP_no_TISS" deleted for now; the old one was old dxs so no longer any good, and check currently does not make sense under new collection rules.
  • renamed "NDC missing L Tables content" to Reconnect_check_missing_L Tables_content query as confirmed by Julie since that is really something that needs to be run before linking

2018-...

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2019&oldid=159050"