Centralized data.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) m link removed, article was deleted. |
Ttenbergen (talk | contribs) m link fixes |
||
| Line 142: | Line 142: | ||
== 2015-APR-01 == | == 2015-APR-01 == | ||
rolled Ttenbergen 17:10, 2015 April 1 (CDT) | rolled Ttenbergen 17:10, 2015 April 1 (CDT) | ||
* updated | * updated ''[[L_Person table]]'' | ||
** removed PHIN (long) - we can't be storing the PHIN in centralized, and it would result in update nightmare Ttenbergen 13:26, 2015 April 1 (CDT) | ** removed PHIN (long) - we can't be storing the PHIN in centralized, and it would result in update nightmare Ttenbergen 13:26, 2015 April 1 (CDT) | ||
== 2015-Jan-29 == | == 2015-Jan-29 == | ||
* updated table ''[[L_Person]]'' | * updated table ''[[L_Person table]]'' | ||
** added PHIN (long) | ** added PHIN (long) | ||
** added field last_update (date) | ** added field last_update (date) | ||
** updated indices | ** updated indices | ||
** made Person_ID random from incremental | ** made [[Person_ID]] random from incremental | ||
* updated table ''[[L_Log]]'' | * updated table ''[[L_Log]]'' | ||
** added field Person_ID (long) | ** added field [[Person_ID]] (long) | ||
** added field Hospitalization_ID (long) | ** added field Hospitalization_ID (long) | ||
** updated indices | ** updated indices | ||
| Line 159: | Line 159: | ||
** updated indices | ** updated indices | ||
* ran encounter_processing to populate [[L_Person]] | * ran encounter_processing to populate [[L_Person table]] | ||
* imported remaining HSC Labs from the old lab export process | * imported remaining HSC Labs from the old lab export process | ||
| Line 182: | Line 182: | ||
rolled out Ttenbergen 18:12, 2014 October 9 (CDT) | rolled out Ttenbergen 18:12, 2014 October 9 (CDT) | ||
* Eliminated s_ tables; will be pulled from ccmdb.mdb by [[CFE]] as of 18:12, 2014 October 9 (CDT) | * Eliminated s_ tables; will be pulled from ccmdb.mdb by [[CFE]] as of 18:12, 2014 October 9 (CDT) | ||
* added tables [[L_PCH]], [[L_Person]], [[L_Hospitalization]], [[S_PCH]], I will probably still need to tweak the structure, just wanted them there for now. Ttenbergen 18:12, 2014 October 9 (CDT) | * added tables [[L_PCH table]], [[L_Person table]], [[L_Hospitalization table]], [[S_PCH table]], I will probably still need to tweak the structure, just wanted them there for now. Ttenbergen 18:12, 2014 October 9 (CDT) | ||
==2014-Aug-12== | ==2014-Aug-12== | ||