CCMDB Wiki

Centralized data front end.mdb Change Log 2014: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(242 intermediate revisions by 3 users not shown)
Line 1: Line 1:
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''


This article is the change log for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Request]] for requested changes.
This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes.


== Change Log ==
== Change Log ==
===2014-Dec-18===
copied to x:\ Ttenbergen 16:52, 2014 December 18 (CST)
* created table ''created_variables_common''; copy of created_variables_table but only the part common to CC and Med: D_ID, age, adm, trans, dis, LOS, Transfer_Delay, Ap_Eye, GCS_Eye_pts, GCS_Eye_text, GCS_Motor_pts,GCS_Motor_text, GCS_Verbal_pts,GCS_Verbal_text,GCS_Total
** created query ''Created_Variables_common_maker'' to populate above
* created table ''Created_Variables_CC'' combining the Apache elements and other CC only fields Ttenbergen 14:35, 2014 December 18 (CST)
** created query ''Created_Variables_CC_maker'' to populate above
* updated [[Calc created variables button]] to use those two new tables Ttenbergen 14:36, 2014 December 18 (CST)
* updated query ''link_suspect_negative_transit_time'' to always ignore old known errors: Not "GRA_N5-4786" And Not "GRA_N3-7555" And Not "CON_MICU-2008" And Not "CON_MICU-2185" And Not "HSC_CCU-29239" And Not "GRA_MICU-3291" And Not "GRA_MICU-3418" Ttenbergen 15:07, 2014 December 18 (CST)
* made query link_suspect_from_partner_no_match to replace ls_med_from... Ttenbergen 16:52, 2014 December 18 (CST)
===2014-Dec-15===
not rolled yet Ttenbergen 15:34, 2014 December 15 (CST)
* added the new H4H locations to table ''linking_location_var_pairs'' to fix false positives in linking suspects table Ttenbergen 15:34, 2014 December 15 (CST)
===2014-Dec-11===
copied to x: Ttenbergen 19:41, 2014 December 11 (CST)
* changed the sorting for the patient list to reflect the NDC queries' sort Ttenbergen 16:48, 2014 December 11 (CST)
===2014-Dec-10===
rolled Ttenbergen 17:24, 2014 December 10 (CST)
* imported Apache_Scoring changes from [[CCMDB.mdb_Change_Log_2014#2014-Dec-10]]
* fixed double-click for notes field so it will now open the notes form Ttenbergen 14:58, 2014 December 10 (CST)
* changed the copy-to-clipboard and start-email buttons to only set to questioned if the patient is not incomplete. Ttenbergen 15:12, 2014 December 10 (CST)
* commented out "References.AddFromFile ("C:\Centralized_CCMDB\CCMDB.accdb")" which wasn't doing what it was supposed to anyway. Ttenbergen 15:35, 2014 December 10 (CST)
* troubleshooting DB password that suddenly started to come up:
** made sure all set =s had corresponding set = nothing
===2014-Dec-07===
(was rolled, not sure exactly when...)
* spelling fix to Apache_scoring function Transfer_delay. Ttenbergen 23:29, 2014 December 7 (CST)
* imported CCMDB version of Apache_Scoring. Ttenbergen 23:29, 2014 December 7 (CST)
* fix to Apache_scoring function ApScore_PO2 Ttenbergen 23:36, 2014 December 7 (CST)
* removed query ''NDC_Highest_PseudoPHIN'' Ttenbergen 12:07, 2014 December 8 (CST)
* renamed some NDC_ queries to PL_
** NDC_orphans --> [[Reconnect_check_orphans query ]]
** NDC_Phin Fake or Blank --> PL_2Phin Fake or Blank
** NDC_Diff_Phin_SameLN_FN_DOB --> PL_DiffPhin_SameLN_FN_DOB
** NDC_SameChart_Site_Diff_Phin --> PL_SameChart_Site_Diff_Phin
** NDC_SamePhin_Diff_LN_FN_DOB_Sex --> PL_SamePhin_Diff_DOB_Sex
** NDC_SamePHIN_Site_Diff_chart --> PL_SamePHIN_Site_Diff_chart
** NDC_Chart_9_Digit --> PL_Chart_9_Digit
* updated form ''Patient_List'''s apply query dropdown box to see "PL_" queries as well
=== 2014-12-05 ===
copied to x:\ Ttenbergen 14:31, 2014 December 5 (CST)
* updated to eliminate false positives
** query ''link_suspect_medicine_from_med_no_partner''
** query ''link_suspect_medicine_to_med_no_partner''
** table ''linking_location_var_pairs''
* updated transfer delay to correspond to how Julie calculates it:
** function ''transfer_time_maker''
** query ''Created_Variables'' Ttenbergen 14:13, 2014 December 5 (CST)
=== 2014-11-27 ===
copied to x:\ Ttenbergen 17:03, 2014 November 27 (CST)
* made visible HSC labs, they had been hidden Ttenbergen 15:48, 2014 November 27 (CST)
* query ''link_suspect_from_ICU_but_single_encounter'' fixed, lists 136 cases now Ttenbergen 16:53, 2014 November 27 (CST)
* query ''link_suspect_to_ICU_but_single_encounter'' fixed, lists 104 cases now Ttenbergen 16:53, 2014 November 27 (CST)
* form ''Link List'' (open suspect pairs) updated to make D_ID columns wider Ttenbergen 16:53, 2014 November 27 (CST)
* fixed error with copy-and-paste button in patient viewer that had been created by when setting to "questioned" was added. Ttenbergen 16:56, 2014 November 27 (CST)
=== 2014-11-20 ===
copied to x:\ Ttenbergen 16:00, 2014 November 20 (CST)
* changed query ''primary_admit'' to limit to <> "incomplete" Ttenbergen 15:24, 2014 November 20 (CST)
* query ''created_apache_details'' changed to unique lines, and nulls fixed. Ttenbergen 16:00, 2014 November 20 (CST)
=== 2014-11-17 ===
copied to {{S:\MED\MED_CCMED}} Ttenbergen 18:03, 2014 November 17 (CST)
* updated query ''created_apache_details'' to draw GCS points from table rather than from function to speed it up. After adding medicine, it became way slower than the other created query. Ttenbergen 14:32, 2014 November 17 (CST)
=== 2014-11-12 ===
copied to x:\ Ttenbergen 16:51, 2014 November 12 (CST)
* changed queries to include medicine
** ''created_Apache_details''
** ''Created_Variables''
* confirmed spaces for "cat" form, the date/time displays fine for me; if doesn't for Pagasa still we will need to adjust on her PC and make that version master. Ttenbergen 16:51, 2014 November 12 (CST)
* updated Public Function Next_Pseudp_PHIN() to consider incompletes, since that's how Pagasa now uses this Ttenbergen 16:51, 2014 November 12 (CST)
* changed RecordStatus dropdown on viewer to not require "visible" to be true; Pagasa should bea ble to set anything Ttenbergen 16:53, 2014 November 12 (CST)
* changed clipboard button to also set RecordStatus to "questioned"
* changed mailer button to also set RecordStatus to "questioned"
* changed "generate mail" button in mailer to CC Trish by default
=== 2014-11-05 ===
rolled 2014-11-05
* added to, from, dates and binocs to cat
=== 2014-10-22 ===
Rolled out Ttenbergen 17:26, 2014 October 22 (CDT)
* added query ''1_time_only_set_3000_tr_date_to_null''; needs to be run against master... Ttenbergen 13:23, 2014 October 22 (CDT)
** somehow this got messed up again Ttenbergen 13:23, 2014 October 22 (CDT)
* updated query ''NDC_PHIN _Fake_or_blank'' to include incompletes as per Pagasa's request Ttenbergen 15:21, 2014 October 22 (CDT)
* changed table s_provinces in [[CCMDB.accdb]] to change province abbreviation for Newfoundland and Labrador should to NL not NF
* updated updating of linking pairs so it will give error and stop if there are any PHINs missing. Ttenbergen 16:57, 2014 October 22 (CDT)
* updated query 'NDC_Missing_TransferDate_wPivot'' as per email from Pagasa Ttenbergen 16:59, 2014 October 22 (CDT)
* uprdated code to link tables to include table Postal_Code_Master that now lives in centralized_data.mdb Ttenbergen 17:15, 2014 October 22 (CDT)
=== 2014-10-09 - 2 ===
rolled out Ttenbergen 18:27, 2014 October 9 (CDT)
* moved S_Standard_emails into [[Centralized_data.accdb]] Ttenbergen 18:27, 2014 October 9 (CDT)
* updated function ''confirm_files_and_links'' to run against [[CCMDB.accdb]] for s_ tables Ttenbergen 18:27, 2014 October 9 (CDT)
* updated reconnect button so it only gives the count if the L_Log, L_PHI and L_LogPHI are not the same. No sense having a gopher otherwise. Ttenbergen 18:27, 2014 October 9 (CDT)
=== 2014-10-09 ===
rolled Ttenbergen 15:41, 2014 October 9 (CDT)
* made structure of table ''Postal_Code_Master'' more efficient (strings only as long as needed, was huge) Ttenbergen 15:41, 2014 October 9 (CDT)
=== 2014-10-02 ===
rolled - Ttenbergen 11:10, 2014 October 6 (CDT)
* integrated Postal Codes from a different source for cross-checks. Ttenbergen 11:10, 2014 October 6 (CDT)
=== 2014-09-28 ===
rolled out Ttenbergen 14:30, 2014 October 2 (CDT)
* updated date formats in tmp entry form to not have input masks any longer Ttenbergen 12:24, 2014 September 29 (CDT)
* delete query ''linked_pairs'', will do it differently. Ttenbergen 09:17, 2014 October 1 (CDT)
* created form LinkList to facilitate [[Correcting suspect links‎]]. Ttenbergen 15:41, 2014 October 1 (CDT)
* added button to main form to open the LinkList. Ttenbergen 16:21, 2014 October 1 (CDT)
* added a msgbox to the reconnect button that gives a count of L_Log, L_PHI, L_Log_PHI. Ttenbergen 15:41, 2014 October 1 (CDT)
* excluded incomplete records from queries ''NDC_PHIN _Fake_or_blank'' and function ''Next_Pseudp_PHIN()'' to simplify [[Generating PseudoPHINs]].Ttenbergen 15:50, 2014 October 1 (CDT)
* updated NDC_CLI_* and NDV_VAP_* queries to only display admit date >=Now()-365 Ttenbergen 15:55, 2014 October 1 (CDT)
* changed the ''Vet all sent'' button to provide a count of the Recordstatus options before setting to vetted; this is so Pagasa won't have to look it up in query ''NDC_Unvetted''. Deleting query. Ttenbergen 16:06, 2014 October 1 (CDT)
* deleted obsolete numbered queries Ttenbergen 17:16, 2014 October 1 (CDT)
=== 2014-09-11 ===
rolled out Ttenbergen 23:00, 2014 September 28 (CDT)
* added functions random_nr_for_id() and next_id() in prep to enable adding records for all tables in CFE. Ttenbergen 13:53, 2014 September 28 (CDT)
* for forms (diags, comos, tmp, L_Labs_Flowsheet, L_Pharm_Flowsheet )Ttenbergen 22:41, 2014 September 28 (CDT)
** allowed edits and deletions (L_Labs_Flowsheet, L_Pharm_Flowsheet already were)Ttenbergen 22:41, 2014 September 28 (CDT)
** added "add ..." buttons Ttenbergen 22:41, 2014 September 28 (CDT)
=== 2014-08-25 ===
copied to x:\ Ttenbergen 15:14, 2014 August 26 (CDT)
* added query ''2014-08-26_province_update_processor'' and table ''2014-08-26_province_update_data'' for province updates, both can be deleted when done. Ttenbergen 14:43, 2014 August 26 (CDT)
=== 2014-08-14 ===
rolled out Ttenbergen 21:23, 2014 August 25 (CDT)
* deleted query ''15_fungin_problems'', done with - Ttenbergen 14:40, 2014 August 14 (CDT)
* deleted ''1_use_only*'' queries, done with - Ttenbergen 14:44, 2014 August 14 (CDT)
* deleted query ''000_ARF-fix'' Ttenbergen 14:44, 2014 August 14 (CDT)
* added query [[Query J in-process records]] for Julie; contains list of complete records that are not yet fully processed by Pagasa Ttenbergen 12:26, 2014 August 21 (CDT)
* added query ''query NDC_discharged_incomplete'' at Pagasa/Julie's request Ttenbergen 20:01, 2014 August 25 (CDT)
* update for the mail helper:
** added table s_standard_emails to contain the pre-set wordings. Ttenbergen 20:37, 2014 August 25 (CDT)
** split out function pt_demo_getter() to use same for all emailing Ttenbergen 20:37, 2014 August 25 (CDT)
** generated form ''standard_email_chooser Ttenbergen 20:37, 2014 August 25 (CDT)
* generated interface for Linking in [[Centralized data front end.accdb]], queries and code had been there for some time; more to do.
=== 2014-08-13 ===
copied to x:\ Ttenbergen 11:21, 2014 August 13 (CDT)
* added query ''TISS_form_missing_dates'' and its dependent queries ''TISS_admitted_date_range'' and ''TISS_form_present_date_range'' Ttenbergen 11:07, 2014 August 13 (CDT)
* deleted query ''TISS_all_days_there'' because I am pretty sure it was the beginning of the above from an effort from months ago... Ttenbergen 11:07, 2014 August 13 (CDT)
* added Public Function NCase to module global to normalcase Names Of Patients Ttenbergen 11:20, 2014 August 13 (CDT)
* updated PatientList to use the Normalcased versions of the names. Can't do same to viewer because there it needs to be editable.  Ttenbergen 11:20, 2014 August 13 (CDT)
=== 2014-08-11-2 ===
rolled to x: Ttenbergen 22:03, 2014 August 11 (CDT)
* Both queries created_Apache_details and Created_Variables are the same now. The differences were
** One included only CC and completes, the other included all; both are limited to only CC and completes now. The values really make little sense before checks are applied. Faster this way, too.
** One parameter for one of the scores was wrong. They are correct and identical now.
*As for the negative AaDO2s… [[AaDO2]] I thought we had concluded that a negative value could happen but should result in a meaningful score.
According to [[APACHE_Scoring_table]] the score should be 0 if AaDO2 <200, so that’s what it will be now.
=== 2014-08-11 ===
rolled Ttenbergen 16:44, 2014 August 11 (CDT)
*fixed query ''1_use_only_ARF_fix'' - Ttenbergen 16:35, 2014 August 11 (CDT)
=== 2014-07-31 ===
rolled Ttenbergen 15:48, 2014 August 11 (CDT)
* corrected [[AaDO2]] value in Created_variable to be same as in Created_variable_details; the previous one was using the parameters for the function wrong. Ttenbergen 13:55, 2014 July 31 (CDT)
* corrected [[AaDO2]] scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:40, 2014 July 31 (CDT)
=== 2014-07-17 ===
copied to x: Ttenbergen 20:00, 2014 July 24 (CDT)
* updated s_como to make left_join to charlsons; s_como is subset of s_alldxs that are comos, not just that are charlsons. Ttenbergen 16:13, 2014 July 21 (CDT)
* set up queries 1_use_only_fix_dx_casing, 1_use_only_med_apache_null_after_SAPS, 1_use_only_update_3000_transfer_dates_to_null; emailed Pagasa/Julie/Trish with use instructions Ttenbergen 17:26, 2014 July 21 (CDT)
* replaced [[s_charlson_dxs table]] with version from [[CCMDB.accdb]] that includes which are allowed as admit/complications Ttenbergen 11:18, 2014 July 24 (CDT)
* Charlson comorbid scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT)
** Charlson_Comorbid_Score
** Charlson_Comorbid_Score__detail
** Charlson_Comorbid_Score_Admit_detail
** Charlson_Comorbid_Score_Como_detail
* "bumped" the apache scoring code, it had somehow got itself hung up. de- and re-compile fixed it. Ttenbergen 18:16, 2014 July 24 (CDT)
* added following codes back to s_alldiagnoses... ('''this is really a data change''')
**Septic Arthritis legacy 29901
**Hepatitis legacy 40600
**AIDS legacy 84900
** a whole bunch of legacy *97 codes
=== 2014-07-14 ===
copied to x: Ttenbergen 16:59, 2014 July 17 (CDT)
* changed Apache Scoring module to capture null/zero scoring correctly Ttenbergen 15:15, 2014 July 17 (CDT)
* changed neuroscore to consider as numbers not strings to fix summing up Ttenbergen 15:32, 2014 July 17 (CDT)
* made viewer form's fields trans and discharge date formats consistent with other fields, ie dd-mmm-yyyy Ttenbergen 16:04, 2014 July 17 (CDT)
* updated query s_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query [[s_charlson_dxs table]] to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score_detail to use s_como Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT)
=== 2014-07-10-2 ===
rolled 2014 July 10 (CDT)
* problem generating child records in L_Dxs and all other child tables. Need to change how uniqueness is generated
** set up new function L_table_ID_gen to make IDs
** updated code for forms to use new function
*** DXs
*** Como
*** Pharm_flowsheet
*** Labs_flowhseet
*** tmp
** cleaned up max* queries that are no longer needed with new way
* updated form ''PatientList'' to allow NDC queries to work again, somehow the form got set to not allow edits
=== 2014-07-10 ===
copied to x:\ Ttenbergen 14:59, 2014 July 10 (CDT)
* grabbed newest table s_alldiagnoses from [[CCMDB.mdb_Change_Log_2014#2014-Jul-07]] Ttenbergen 15:17, 2014 July 7 (CDT)
* updated clipboard button for Pagasa, removed PHIN added location - Ttenbergen 15:48, 2014 July 7 (CDT)
* updated created_variables query which was giving different results on Julie's PC than Trish and Pagasa - Ttenbergen 14:58, 2014 July 10 (CDT)
* editing was disabled for diagnoses, fixed to be able to edit - Ttenbergen 14:58, 2014 July 10 (CDT)
=== 2014-07-04-int ===
rolled outTtenbergen 11:53, 2014 July 4 (CDT)
* added temporary forensic queries for Trish and Pagasa, didn't update the version number I think, but the queries start with 2_ and involve tmp and pc checks. Ttenbergen 11:53, 2014 July 4 (CDT)
=== 2014-06-27 ===
copied to x: Ttenbergen 14:46, 2014 June 27 (CDT)
* removed explicit edit restrictions from patient list because they were breaking the NDC dropdown Ttenbergen 14:05, 2014 June 27 (CDT)
* integrated "changed table ''[[s_charlson_dxs table]]'' to not duplicate values that should come from s_alldiagnoses. " as in CCMDB [[CCMDB.mdb_Change_Log_2014#2014-Jun-23]] Ttenbergen 14:08, 2014 June 27 (CDT)
=== 2014-06-26-2 ===
rolled Ttenbergen 17:29, 2014 June 26 (CDT)
* added compact and change button to main screen Ttenbergen 16:43, 2014 June 26 (CDT)
* 1_In_L_PHI_but_NOT_in_L_Log Ttenbergen 17:29, 2014 June 26 (CDT)
=== 2014-06-26 ===
copied to x:\
* changed query ''created_Apache_details'' to append table, and fixed table it appends to have data types as required by Julie. Ttenbergen 16:16, 2014 June 26 (CDT)
=== 2014-06-23 ===
copied to x: Ttenbergen 11:27, 2014 June 26 (CDT)
'''was rolled with jun 16 date''', sigh
* there have been no new changes but rolling out as new version because we are having weird discrepancies in how the program works on Trish's and Julie's PC Ttenbergen 11:27, 2014 June 26 (CDT)
* no changes Ttenbergen 21:47, 2014 June 23 (CDT)
=== 2014-06-16 ===
copied to x: Ttenbergen 21:47, 2014 June 23 (CDT)
* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_AllDiagnoses table]] Ttenbergen 15:48, 2014 June 19 (CDT)
* updated function ApScore_MeanBP(MBP) to work with the input it gets in query ''created_Apache_details'' Ttenbergen 16:20, 2014 June 19 (CDT)
* cleaning out temporary 1_ tables
** 1z_created_combined
** 1transdelaycheck
** 1check_userDef_function
** 1check_incl_function
** 1Check_import_ES
** 1Check_import_aptype
** 11_ES_Tester
** 11_AP_has_missing_ABG
** 11_AP_has_missing_bps_GCS_rates_types
** 11_AP_has_missing_chem
** 11 vap stuff
* added '''clipboard button''' next to form close button; this will copy pt data required for chart review to the clipboard for when Pagasa needs to notify collectors of an error; ctrl-v in an email will paste it Ttenbergen 20:56, 2014 June 23 (CDT)
* added query 1_In_L_Log_BUT_NOT_In_L_Phi as provided by Trish Ttenbergen 21:02, 2014 June 23 (CDT)
* added query P_Count_of _SENT_PAGASA_LIKES, '''renamed it to P_Count_of_sent''', cleared out the old counts-of-sents queries Ttenbergen 21:11, 2014 June 23 (CDT)
* updated forms patient_list and viewer to '''not allow editing while red'''. Ttenbergen 21:16, 2014 June 23 (CDT)
* changed patient viewer so
** for medicine patients, can't see labs and pharmacy and cc only Apache elements
** for cc patients, can't see ADLs
=== 2014-06-12 ===
given to Trish to roll Ttenbergen 17:18, 2014 June 16 (CDT)
* adding query ''Labs_requester'' to make test data for labs exporting Ttenbergen 16:49, 2014 June 12 (CDT)
* updated query ''NDC_orphans'' to ignore "questioned" patients Ttenbergen 13:56, 2014 June 16 (CDT)
* updated query ''ND_sub_CLI_DateinTMPV2'' to also accept tmp "CLI (call Basil Evan if MICU/SICU/IICU)" Ttenbergen 13:56, 2014 June 16 (CDT)
* made date formats consistent throughout patient list and view form. Ttenbergen 14:15, 2014 June 16 (CDT)
=== 2014-06-09 ===
copied to x - Ttenbergen 16:49, 2014 June 12 (CDT)
* added query ''Charlson_Comorbid_score_detail'' Ttenbergen 09:14, 2014 June 12 (CDT)
* minor changes to most functions in APACHE_Scoring to properly deal with Nulls... Ttenbergen 16:42, 2014 June 12 (CDT)
=== (same version as before because I forgot to update) ===
copied to {{S:\MED\MED_CCMED}} - Ttenbergen 15:49, 2014 June 9 (CDT)
* fixed Function ApTotal_Physiological() to be able to output Nulls (changed data type) Ttenbergen 15:49, 2014 June 9 (CDT)
=== 2014-05-29 ===
rolled out - Ttenbergen 11:21, 2014 June 9 (CDT)
* added ph to new variables details query
* realized and messed with problem in 1run only saps clean up queryTtenbergen 16:30, 2014 May 29 (CDT)
* fixed query ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''; it had two D_ID columns which was confusing the form that opens it. Ttenbergen 10:43, 2014 June 2 (CDT)
* updated queries ''NDC_orphans, query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2, NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2, NDC_CLI_unacceptable_date'' - Ttenbergen 16:04, 2014 June 2 (CDT)
* changed created_variables and apache scoring module to give null when no input or medicine. Ttenbergen 17:22, 2014 June 2 (CDT)
* updated function ''ApScore_Creat'' to properly double Creat score if ARF. Ttenbergen 09:47, 2014 June 4 (CDT)
* Updated function ApScore_AaDO2() now If AaDO2 < 200 Then ApScore_AaDO2 = 0
* Updated function ApScore_ABG(), now gives null when abg component is 0 or null inappropriately
=== 2014-05-28 ===
copied to x: Ttenbergen 14:26, 2014 May 29 (CDT)
* updated query ''NDC_orphans'' to except HSC_IICU to 10 day delay because it is also collected by multiple laptops Ttenbergen 11:10, 2014 May 29 (CDT)
* updated query ''NDC_CLI_unacceptable_date'' to use column name "CLI_date" instead of "VAP_date" Ttenbergen 11:26, 2014 May 29 (CDT)
* updated queries ''NDC_VAP_*'' and ''NDC_CLI_*'' to include only patients admitted after start of study as per QA Infection Audit Specs Ttenbergen 11:26, 2014 May 29 (CDT)
=== 2014-05-19 ===
copied to x: Ttenbergen 19:27, 2014 May 28 (CDT)
* query ''link_suspect_negative_transit_time'' to implement checks against '''Transfer time rule''' Ttenbergen 23:01, 2014 May 19 (CDT)
* query ''link_suspect_medicine_to_med_no_partner''
* query ''link_suspect_medicine_from_med_no_partner''
* query ''link_suspect_dead_then_alive''
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT)
* added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT)
* updated query NDC_Orphans to reflect [[Orphans_in_[[Centralized_data.accdb]]#ward.2Funits_with_more_than_one_collector]] Ttenbergen 22:35, 2014 May 26 (CDT)
* fixed function "transfer_time_maker"; it was failing when the transfer date is null. Ttenbergen 18:14, 2014 May 28 (CDT)
* added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT)
**    creatpts
**    agepts
**  AaDO2
* fixed query ''NDC_CLI-unacceptable-date'', was showing obs date, not date_var Ttenbergen 19:22, 2014 May 28 (CDT)
===2014-05-15 ===
copied to x:\ Ttenbergen 23:06, 2014 May 19 (CDT)
* updated query ''created_variables'' to use the convention for missing transfer times that is now documented in [[Transfer_Delay#Calculation when transfer time missing]]. Ttenbergen 16:08, 2014 May 19 (CDT)
* re-updated the [[Date of Birth |age]] definition in Module Apache_scoring to correspond with documentation, version appears to have got lost. Ttenbergen 21:07, 2014 May 19 (CDT)
* updated function Ap_Chronic in Module Apache_scoring; has ands and ors mixed without brackets, fixed order of precedence. Ttenbergen 21:49, 2014 May 19 (CDT)
* linking
** added query ''link_suspect_from_ICU_but_single_encounter''
** added query ''link_suspect_to_ICU_but_single_encounter''
===2014-05-14 ===
copied to x:\ Ttenbergen 16:31, 2014 May 15 (CDT)
* created table "linking_pairs" to contain D_IDs of successive admissions of same pt. Ttenbergen 15:23, 2014 May 14 (CDT)
* created module ''linking'' sub ''populate_linking_pairs()'' to populate table "linking_pairs" Ttenbergen 16:05, 2014 May 14 (CDT)
* updated apache physiological scoring in module apache_scoring Ttenbergen 10:23, 2014 May 15 (CDT)
===2014-05-12 ===
copied to x:\ Ttenbergen 12:21, 2014 May 14 (CDT)
* added column "is_ICU" to [[S_AdmitDischarge]] Ttenbergen 13:57, 2014 May 12 (CDT)
* working on NDC queries
** VAP Dx vs Tmp checking
*** renamed related queries to start with NDC_VAP
*** added query to check for tmp date > discharge date or < admit date + 1 (we discussed +2, but because we don't have a time for the VAP a +2 would have false positives)
** CLI Dx vs Tmp checking
*** renamed related queries to start with NDC_CLI
*** added query NDC_CLI_unacceptable_date to check for tmp date > discharge date or < admit date
===2014-05-08 ===
copied to x:\ Ttenbergen 17:27, 2014 May 8 (CDT)
* made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 16:16, 2014 May 8 (CDT)
===2014-05-05-2===
copied t x:\ Ttenbergen 20:53, 2014 May 5 (CDT)
* further re-consolidation of Apache_Scoring module Ttenbergen 20:53, 2014 May 5 (CDT)
===2014-05-05===
copied to x:\ - Ttenbergen 10:20, 2014 May 5 (CDT)
* restored ap_physiological score function; had got lost when apache_scoring module was imported from CCMDB.accdb. Ttenbergen 10:14, 2014 May 5 (CDT)
===2014-05-01===
copied to x: Ttenbergen 20:30, 2014 May 1 (CDT)
* imported updated module Apache_Scoring from CCMDB.accdb. Ttenbergen 18:05, 2014 May 1 (CDT)
* updated P_Outstanding_Admits to include a "has_discharge_date" field Ttenbergen 20:09, 2014 May 1 (CDT)
===2014-04-07===
released Ttenbergen 17:16, 2014 April 7 (CDT)
* changed colour for the no-edit version. Ttenbergen 16:10, 2014 April 7 (CDT)
===2014-03-24===
released to x:\ Ttenbergen 12:13, 2014 March 31 (CDT)
* changed datatypes in created_variables_table to be consistent with data generated by query. Ttenbergen 14:47, 2014 March 24 (CDT)
* changed created_variables and created_variables_table
** to get rid of MeanBP with was duplicate (but wrong) of MBP, which is still there, and correct. Ttenbergen 13:36, 2014 March 26 (CDT)
** changed ES field to be generated by ES: IIf(InStr([Ap_AdmitType],"Emerg")>0,"Y","N"); looked at "Elect" before. Ttenbergen 14:34, 2014 March 27 (CDT)
** eliminated column "AT" that was just set to "Y"; see [[Active Treatment]] - Ttenbergen 16:15, 2014 March 27 (CDT)
* fixed query primary_admit, it was trying to use rank instead of priority to determine primary. Ttenbergen 13:14, 2014 March 27 (CDT)
* updated Module "Apache_Scoring" to eliminate "holes" in Hemat, AaDO2 and PO2 scoring - Ttenbergen 15:25, 2014 March 27 (CDT)
===2014-03-19===
rolled to x: - Ttenbergen 16:13, 2014 March 21 (CDT)
* to get control over the data type of fields in Created_Variables_Table
** added [[Calc created variables button]]
*** empties table
*** runs query
** changed query "Created_Variables" to append query
** changed table "created_variables_table" fields MBP,  ApTotal_Physiological and ApTotal_Chronic to numeric
* changed module "Apache_Scoring" functions "ApTotal_Physiological" and "Ap_Chronic" to specifically return data type long. Ttenbergen 15:44, 2014 March 19 (CDT)
* changed forms mainpage, patientlist and viewer to have red background when not in proper edit window so that it will be clear that editing would cause version issues Ttenbergen 10:36, 2014 March 21 (CDT)
* deleted old table "tasks", no longer used, and fixed query "L_Tasks" to pull from L_Dxs instead. Ttenbergen 13:23, 2014 March 21 (CDT)
* added button between first and last name to sort by last, then first name Ttenbergen 13:50, 2014 March 21 (CDT)
* updated query "NDC_CLIinAcqDX_NoCLI_DateinTMPV2" to exclude patients discharged before project started (see QA Infection Audit Specs). Ttenbergen 14:07, 2014 March 21 (CDT)
* added query "NDC_unvetted" to allow filtering for patients who are only "complete" (ie something went wrong in sending, or "sent" or "questioned" (ie in process for vetting). Ttenbergen 14:16, 2014 March 21 (CDT)


===2014-03-18 ===
===2014-03-18 ===
Line 32: Line 417:
===2014-03-10===
===2014-03-10===
copied to x:\ earlier today Ttenbergen 13:58, 2014 March 12 (CDT)
copied to x:\ earlier today Ttenbergen 13:58, 2014 March 12 (CDT)
* imported code to module SHA256 to implement [[Hash]] as per email from Brad 2014-03-03. Not fully implemented yet, just wanted to make sure code is in there. Ttenbergen 10:56, 2014 March 10 (CDT)
* imported code to module SHA256 to implement Hash as per email from Brad 2014-03-03. Not fully implemented yet, just wanted to make sure code is in there. Ttenbergen 10:56, 2014 March 10 (CDT)
* updated Apache scoring module to  
* updated Apache scoring module to  
** re-introduce apache physiological function, chronic and ABG function which got lost somehow.
** re-introduce apache physiological function, chronic and ABG function which got lost somehow.
** update error message to only trigger when called from CCMDB.mdb (only WBC for now)
** update error message to only trigger when called from CCMDB.accdb (only WBC for now)
* added form TISS_Viewer, using query TISS_Connect, added tab to Patient Viewer form to view it
* added form TISS_Viewer, using query TISS_Connect, added tab to Patient Viewer form to view it


Line 79: Line 464:
* fixed location dropdown, it was still checking against settings - Ttenbergen 16:50, 2014 February 24 (CST)
* fixed location dropdown, it was still checking against settings - Ttenbergen 16:50, 2014 February 24 (CST)
* fixed var1-6 drop downs, were still checking against settings - Ttenbergen 16:59, 2014 February 24 (CST)
* fixed var1-6 drop downs, were still checking against settings - Ttenbergen 16:59, 2014 February 24 (CST)
* got rid of error listing box in viewer that had been used in ccmdb.mdb - Ttenbergen 17:03, 2014 February 24 (CST)
* got rid of error listing box in viewer that had been used in [[CCMDB.accdb]] - Ttenbergen 17:03, 2014 February 24 (CST)
* moved dx code to left in dx chooser, turns out it was already there but off the right off the screen due to Pagasa's small screen - Ttenbergen 17:08, 2014 February 24 (CST)
* moved dx code to left in dx chooser, turns out it was already there but off the right off the screen due to Pagasa's small screen - Ttenbergen 17:08, 2014 February 24 (CST)
* in PatientList, combined firstname and lastname in one field so they will sort together - Ttenbergen 17:18, 2014 February 24 (CST)
* in PatientList, combined firstname and lastname in one field so they will sort together - Ttenbergen 17:18, 2014 February 24 (CST)
Line 85: Line 470:
=== 2014-02-13 ===
=== 2014-02-13 ===
not rolled yet ( actually was rolled...)
not rolled yet ( actually was rolled...)
* imported query ''s_como'' (the como only subset from s_alldiagnoses) from ccmdb.mdb to fix listing for comos. Ttenbergen 14:12, 2014 February 13 (CST)
* imported query ''s_como'' (the como only subset from s_alldiagnoses) from [[CCMDB.accdb]] to fix listing for comos. Ttenbergen 14:12, 2014 February 13 (CST)
* changed form PatientList to Pagasa's specs Ttenbergen 18:09, 2014 February 13 (CST)
* changed form PatientList to Pagasa's specs Ttenbergen 18:09, 2014 February 13 (CST)


Line 134: Line 519:
* fixed query ''Primary_admit''
* fixed query ''Primary_admit''
* added query ''Charlson_Comorbid_Score''
* added query ''Charlson_Comorbid_Score''
** ''' preliminary for now, have questions on that one, see [[Charlson Comorbid coding]] Ttenbergen 22:21, 2014 January 15 (CST)
** ''' preliminary for now, have questions on that one, see [[ Charlson Comorbid coding (pre ICD10)]] Ttenbergen 22:21, 2014 January 15 (CST)
* added Module for MOST score, '''work in progress'''
* added Module for MOST score, '''work in progress'''
** see [[MOST Score Calculation]]
** see [[ALERT Scale Calculation]]
** see [[Created Variables in TMSX or Med TMS]]
** see [[Created Variables in TMSX or Med TMS]]


===2013-11-04===
===2013-11-04===
rolled out to X:\ on 2013-12-30
rolled out to {{S:\MED\MED_CCMED}} on 2013-12-30
* imported Viewer form and sub-forms from [[CCMDB.mdb]]Ttenbergen 15:59, 2013 November 7 (CST)
* imported Viewer form and sub-forms from [[CCMDB.accdb]]Ttenbergen 15:59, 2013 November 7 (CST)
* commenting out checkers
* commenting out checkers
* changing the expected data structure
* changing the expected data structure
Line 159: Line 544:
** ADL
** ADL
*** adds ADL plain-score fields ADL_(bathing/dressing/etc)_score
*** adds ADL plain-score fields ADL_(bathing/dressing/etc)_score
*** adds [[MOST]]-score fields ADL_(bathing/dressing/etc)_MOST Ttenbergen 16:17, 2013 December 30 (CST)
*** adds [[ALERT Scale]] fields ADL_(bathing/dressing/etc)_MOST Ttenbergen 16:17, 2013 December 30 (CST)
*** adds sums ADLs as ADL_Score_sum and ADL_MOST_sum Ttenbergen 16:17, 2013 December 30 (CST)
*** adds sums ADLs as ADL_Score_sum and ADL_MOST_sum Ttenbergen 16:17, 2013 December 30 (CST)
* added query SAS_L_Dxs:  
* added query SAS_L_Dxs:  
Line 167: Line 552:
** contains L_Dxs where adm_acqu = "Task"
** contains L_Dxs where adm_acqu = "Task"


[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category:Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.mdb_Change_Log_2014"