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

m changed to .accdb, replaced: Centralized data front end.mdb → Centralized data front end.accdb (3)
m link fixes
Line 77: Line 77:
rolled Ttenbergen 12:09, 2015 April 2 (CDT)
rolled Ttenbergen 12:09, 2015 April 2 (CDT)
* added index L_Log for Person_ID Ttenbergen 11:10, 2015 April 2 (CDT)
* 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)
* set [[L_Person table|L_Person]].death to null for all since it will only be used for PCH deaths now Ttenbergen 11:10, 2015 April 2 (CDT)
* added code to Form View to blank out Person_ID when PHIN is edited or PseudoPHIN button is pushed. Ttenbergen 12:09, 2015 April 2 (CDT)
* added code to Form View to blank out [[Person_ID]] when PHIN is edited or [[PseudoPHIN]] button is pushed. Ttenbergen 12:09, 2015 April 2 (CDT)


=== 2015-APR-01 ===
=== 2015-APR-01 ===
rolled Ttenbergen 17:07, 2015 April 1 (CDT)
rolled Ttenbergen 17:07, 2015 April 1 (CDT)
* added Person_ID field to query [[L_Log_PHI]] Ttenbergen 15:05, 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)
* changing encounter_processing module Sub Encounter_processor() to delete inconsistent linkages and then replace with clean ones Ttenbergen 17:07, 2015 April 1 (CDT)


=== 2015-Feb-11 ===
=== 2015-Feb-11 ===
Line 93: Line 93:
rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)
rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)
* setting up for [[Encounter processing]]
* 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 tables [[L_Person table]] and [[L_Hospitalization]] to Function ''confirm_files_and_links()'' that is triggered by the "Re-connect data" button
** added query ''encounter_lister''
** added query ''encounter_lister''
** added module ''Encounter_processing'' with Sub ''Encounter_processor()''
** added module ''Encounter_processing'' with Sub ''Encounter_processor()''
** inf query ''L_Log_PHI_time_hm'' added fields Person_ID and Hospitalization_ID
** inf query ''L_Log_PHI_time_hm'' added fields [[Person_ID]] and Hospitalization_ID


* added Report R_CompletePt
* added Report R_CompletePt