Centralized data.mdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
TOstryzniuk (talk | contribs)
Line 2: Line 2:


==changes requested ==
==changes requested ==
=== IMPORTANT: date and time sent ===
===APACHE SCORE calculation in centralized===
*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)
*This may be in your phase II of centralized?  Need APACHE score to be calculated in centralized otherwise Julie must write SAS program for score.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:38, 2013 October 21 (CDT)
** a darn, I need to update that file as well to get the new field in there... doing that now...Ttenbergen 14:34, 2013 October 3 (CDT)


=== changes needed ===
=== changes needed ===

Revision as of 12:38, 2013 October 21

This is the change log for Centralized_data.mdb.

changes requested

APACHE SCORE calculation in centralized

  • This may be in your phase II of centralized? Need APACHE score to be calculated in centralized otherwise Julie must write SAS program for score.Trish Ostryzniuk 13:38, 2013 October 21 (CDT)

changes needed

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

Ver 2013-10-03

  • added sentdttm field to accomodate new data from Log#ver_2013-10-03 - Ttenbergen 15:00, 2013 October 3 (CDT)

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