Centralized data.mdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
This is the change log for [[Centralized_data.mdb]].  
This is the change log for [[Centralized_data.mdb]].  


==changes requested IMPORTANT==
==changes requested ==
=== date and time sent ===
=== IMPORTANT: date and time sent ===
*PRIORITY PLEASE: add columns to centralized mdb for date and time sent. This is important, will allow me to better check for error by being able to group latest sent files into centralized. -[[Pagasa Torres]]-[[User:TOstryzniuk|Trish Ostryzniuk]] 11:28, 2013 September 20 (CDT)
*PRIORITY PLEASE: add columns to centralized mdb for date and time sent. This is important, will allow me to better check for error by being able to group latest sent files into centralized. -[[Pagasa Torres]]-[[User:TOstryzniuk|Trish Ostryzniuk]] 11:28, 2013 September 20 (CDT)


== changes needed ==
=== changes needed ===
* clean out of centralized unused fields  
* clean out of centralized unused fields  
** log completes, final check
** log completes, final check
** dxs rank
** dxs rank
== Ver 2013-09-25 ==
* added Serial field to accomodate import from Ed's
* added field SentDtTm; won't get populated until after it is also implemented in ccmdb Ttenbergen 16:07, 2013 September 25 (CDT)


== Ver 2013-08-12 ==
== Ver 2013-08-12 ==

Revision as of 15:07, 2013 September 25

This is the change log for Centralized_data.mdb.

changes requested

IMPORTANT: date and time sent

  • PRIORITY PLEASE: add columns to centralized mdb for date and time sent. This is important, will allow me to better check for error by being able to group latest sent files into centralized. -Pagasa Torres-Trish Ostryzniuk 11:28, 2013 September 20 (CDT)

changes needed

  • clean out of centralized unused fields
    • log completes, final check
    • dxs rank

Ver 2013-09-25

  • added Serial field to accomodate import from Ed's
  • added field SentDtTm; won't get populated until after it is also implemented in ccmdb Ttenbergen 16:07, 2013 September 25 (CDT)

Ver 2013-08-12

Changes need to be timed with CCMDB_data.mdb_Change_Log#2013-08-12 and CCMDB.mdb_Change_Log_2013#ver_2013-08-12

  • change L_Como and others to proper format (d_id(txt 18) and d_*_id(txt 30)) and changed indices and keys
    • l_como
    • L_Labs_Flowsheet
    • L_Pharm_Flowsheet
    • L_TmpV2
      • added D_Tmp_ID;
  • added relationships