CCMDB Wiki

DSM Labs Consistency check.accdb: Difference between revisions

← Older edit
m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED"
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
The program  
The program  
:: '''X:\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb'''
:: '''{{S:\MED\MED_CCMED}}CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb'''
generates request extracts and imports lab data as provided by DSM.  
generates request extracts and imports lab data as provided by DSM.  


Line 19: Line 19:
}}
}}
end of comment-->
end of comment-->
=== version 2023-09-27 ===
copied to server, notified Pagasa
* removed Trish from email and added Herman
=== version 2023-05-17 ===
not rolled yet
* removed re-connect for PHI, shouldn't be needed any more and was causing error.


=== version 2023-01-12 ===
=== version 2023-01-12 ===
copied to server
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates


Line 67: Line 76:


=== version 2020-05-06 ===
=== version 2020-05-06 ===
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error]
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [https://web.archive.org/web/20200224033850/http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error] (archived version)
* changed query ''2_dedupe_appender_group'' to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error
* changed query ''2_dedupe_appender_group'' to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error


Retrieved from "https://ccmdb.kuality.ca/index.php?title=DSM_Labs_Consistency_check.accdb"