Centralized data front end.mdb Change Log 2014: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (111 intermediate revisions by 2 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. | 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 === | === 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 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 ''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) | * 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 === | === 2014-08-13 === | ||
| Line 38: | Line 178: | ||
* 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) | * 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) | * 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 with version from | * 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 scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT) | ||
** Charlson_Comorbid_Score | ** Charlson_Comorbid_Score | ||
| Line 57: | Line 197: | ||
* 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) | * 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_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT) | ||
* updated query s_charlson_dxs to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses 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_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) | * updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT) | ||
| Line 88: | Line 228: | ||
copied to x: Ttenbergen 14:46, 2014 June 27 (CDT) | 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) | * 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'' 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) | * 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 === | === 2014-06-26-2 === | ||
| Line 107: | Line 247: | ||
=== 2014-06-16 === | === 2014-06-16 === | ||
copied to x: Ttenbergen 21:47, 2014 June 23 (CDT) | copied to x: Ttenbergen 21:47, 2014 June 23 (CDT) | ||
* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[ | * 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) | * 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 | * cleaning out temporary 1_ tables | ||
| Line 142: | Line 282: | ||
=== (same version as before because I forgot to update) === | === (same version as before because I forgot to update) === | ||
copied to | 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) | * fixed Function ApTotal_Physiological() to be able to output Nulls (changed data type) Ttenbergen 15:49, 2014 June 9 (CDT) | ||
| Line 149: | Line 289: | ||
* added ph to new variables details query | * 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) | * realized and messed with problem in 1run only saps clean up queryTtenbergen 16:30, 2014 May 29 (CDT) | ||
* fixed 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) | * 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, NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2, NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2, NDC_CLI_unacceptable_date'' - Ttenbergen 16:04, 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) | * 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_Creat'' to properly double Creat score if ARF. Ttenbergen 09:47, 2014 June 4 (CDT) | ||
| Line 160: | Line 300: | ||
* 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_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 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 | * 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 === | === 2014-05-19 === | ||
copied to x: Ttenbergen 19:27, 2014 May 28 (CDT) | copied to x: Ttenbergen 19:27, 2014 May 28 (CDT) | ||
* query ''link_suspect_negative_transit_time'' to implement checks against | * 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_to_med_no_partner'' | ||
* query ''link_suspect_medicine_from_med_no_partner'' | * query ''link_suspect_medicine_from_med_no_partner'' | ||
| Line 170: | Line 310: | ||
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT) | * 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) | * added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT) | ||
* updated query NDC_Orphans to reflect [[ | * 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) | * 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) | * added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT) | ||
| Line 197: | Line 337: | ||
* added column "is_ICU" to [[S_AdmitDischarge]] Ttenbergen 13:57, 2014 May 12 (CDT) | * added column "is_ICU" to [[S_AdmitDischarge]] Ttenbergen 13:57, 2014 May 12 (CDT) | ||
* working on NDC queries | * working on NDC queries | ||
** | ** VAP Dx vs Tmp checking | ||
*** renamed related queries to start with NDC_VAP | *** 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) | *** 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 | *** renamed related queries to start with NDC_CLI | ||
*** added query NDC_CLI_unacceptable_date to check for tmp date > discharge date or < admit date | *** added query NDC_CLI_unacceptable_date to check for tmp date > discharge date or < admit date | ||
| Line 214: | Line 354: | ||
===2014-05-05=== | ===2014-05-05=== | ||
copied to x:\ - Ttenbergen 10:20, 2014 May 5 (CDT) | 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. | * 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=== | ===2014-05-01=== | ||
copied to x: Ttenbergen 20:30, 2014 May 1 (CDT) | copied to x: Ttenbergen 20:30, 2014 May 1 (CDT) | ||
* imported updated module Apache_Scoring from CCMDB. | * 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) | * updated P_Outstanding_Admits to include a "has_discharge_date" field Ttenbergen 20:09, 2014 May 1 (CDT) | ||
| Line 238: | Line 378: | ||
rolled to x: - Ttenbergen 16:13, 2014 March 21 (CDT) | rolled to x: - Ttenbergen 16:13, 2014 March 21 (CDT) | ||
* to get control over the data type of fields in Created_Variables_Table | * to get control over the data type of fields in Created_Variables_Table | ||
** added | ** added [[Calc created variables button]] | ||
*** empties table | *** empties table | ||
*** runs query | *** runs query | ||
| Line 247: | Line 387: | ||
* 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) | * 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) | * 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 | * 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) | * 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) | ||
| Line 277: | 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 | * 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. | ** 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 324: | 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 | * 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 330: | 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 | * 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 379: | 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 [[ | ** 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 | rolled out to {{S:\MED\MED_CCMED}} on 2013-12-30 | ||
* imported Viewer form and sub-forms from [[CCMDB. | * 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 404: | 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 [[ | *** 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 412: | 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. | [[Category:Centralized data front end.accdb]] | ||