CCMDB Wiki

Centralized data front end.mdb Change Log 2015

Revision as of 10:10, 2 April 2015 by Ttenbergen (talk | contribs) (→2015-APR-01: u)

see the 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.

Change Log

2015-APR-02

not rolled yet

  • added index L_Log for Person_ID Ttenbergen 11:10, 2015 April 2 (CDT)
  • set L_Person.death to null for all since it will only be used for PCH deaths now Ttenbergen 11:10, 2015 April 2 (CDT)

2015-APR-01

rolled Ttenbergen 17:07, 2015 April 1 (CDT)

  • added Person_ID field to query L_Log_PHI Ttenbergen 15:05, 2015 April 1 (CDT)
  • changing encounter_processing module Sub Encounter_processor() to delete inconsistend linkages and then replace with clean ones Ttenbergen 17:07, 2015 April 1 (CDT)

2015-Feb-11

rolled to x:\

  • updated Encounter processing and hooked it up to button in main form.
  • updated the count test on re-connecting that warns if the numbers in L_Log and L_PHI are not same; had wrong order of precedence

2015-Jan-22

rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)

  • setting up for Encounter processing
    • added tables L_Person and L_Hospitalization to Function confirm_files_and_links() that is triggered by the "Re-connect data" button
    • added query encounter_lister
    • added module Encounter_processing with Sub Encounter_processor()
    • inf query L_Log_PHI_time_hm added fields Person_ID and Hospitalization_ID
  • added Report R_CompletePt
    • created query L_Pharm_total
    • created query L_Labs_total
    • created table R_CompletePtList
    • created query r_completePtFilter to subset the report
    • created report R_completePT
    • created sub-report R_CompletePt_Comos
    • created sub-report R_CompletePT_Dxs
    • created sub-report R_CompletePT_Pharm_total
    • created sub-report R_CompletePT_Labs_total
  • clean-up
    • deleted old query Labs_Flowsheet_sum_fungins
  • updated query link_suspect_medicine_to_med_no_partner to eliminate false-positives for H4H; actually was a complete re-write, Pagasa please test

2015-Jan-20

rolled but with old version number I think Ttenbergen 15:30, 2015 January 20 (CST)

  • updated query created_varibles_CC to calculate neuropoints properly. Ttenbergen 15:30, 2015 January 20 (CST)

2015-Jan-05

copied to x:\ Ttenbergen 21:34, 2015 January 19 (CST)

  • added queries to move legacy BRR Entries from Var2 into Tmp
    • 1_Var2_BRR_1_to_Tmp
    • 1_Var2_BRR_2_cleanout_Var2
  • updated query created_Apache_details to be 15-(GCS) (was just GCS).
  • changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.mdb) Ttenbergen 18:01, 2015 January 19 (CST)
  • added query L_Dxs_w_primary which includes a field "is_primary" to allow easy searching for primary_dxs. uses query Primary_admit Ttenbergen 18:24, 2015 January 19 (CST)
  • deleted old legacy query 1_time_only_set_3000_tr_date_to_null Ttenbergen 20:18, 2015 January 19 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.mdb_Change_Log_2015&oldid=42744"