CCMDB.mdb Change Log 2008: Difference between revisions
Ttenbergen (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 18: | Line 18: | ||
**a. Handibase has two lab tables: s_labs & s_allLabs. Apparently the table that the PDA is using is the s_allLabs table. Voluven was added to s_labs instead of s_allLabs and this is why sites cannot find this item on their PDA Lab drop down list. | **a. Handibase has two lab tables: s_labs & s_allLabs. Apparently the table that the PDA is using is the s_allLabs table. Voluven was added to s_labs instead of s_allLabs and this is why sites cannot find this item on their PDA Lab drop down list. | ||
**b. HSC_MICU folder on regional server was relabelled to HSC_MICU1 after Crash July 11.08 and updateALL batch file was not updated along with this change. | **b. HSC_MICU folder on regional server was relabelled to HSC_MICU1 after Crash July 11.08 and updateALL batch file was not updated along with this change. | ||
**c. Problem after | **c. Problem after adding the lab item Voluven. When you log into CCMDB and tried EDITING you would get an OVERFLOW error message. | ||
*'''Solution:''' | *'''Solution:''' | ||
**a. Blank out the s_labs table, not used. Add Voluven to the s_AllLab table only. '''DONE''' | **a. Blank out the s_labs table, not used. Add Voluven to the s_AllLab table only. '''DONE''' | ||
*** extra blank rows and second troponin code in s_allLABS. Clean out.''' DONE''' | *** extra blank rows and second troponin code in s_allLABS. Clean out.''' DONE''' | ||
**b. Fix HSC_MICU to HSC_MICU1 in the updateall batch file | **b. Fix HSC_MICU to HSC_MICU1 in the updateall batch file and other clean up''' DONE.''' | ||
**c. ACCESS - EDIT - OVERFLOW problem labs. Voluven upper limit amount automatically set to 9999 when you add it to the s-alllab table. Should only be 999. '''Fix DONE.''' | **c. ACCESS - EDIT - OVERFLOW problem labs. Voluven upper limit amount automatically set to 9999 when you add it to the s-alllab table. Should only be 999. '''Fix DONE.''' | ||