CCMDB Wiki

DSM Labs Consistency check.accdb: Difference between revisions

← Older edit
m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED"
 
(20 intermediate revisions by 2 users 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 20: Line 20:
end of comment-->
end of comment-->


=== version 2021-09-15 ===
=== version 2023-09-27 ===
Not rolled out yet  
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 ===
copied to server
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
 
=== version 2022-11-03 ===
* added some labs to mappings as per email from Allan. [[User:Ttenbergen|Ttenbergen]] 10:22, 2022 November 3 (CDT)
 
=== version 2022-08-29 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 15:48, 2022 August 29 (CDT)
* fixed error that was introduced into an SQL statement in the most recent update. [[User:Ttenbergen|Ttenbergen]] 15:48, 2022 August 29 (CDT)
** specifically, a previous change to query 1_C_requester_cc_maker had added a "where" clause to that query, and VBA code in Sub Export_requestor_file() was trying to add another where clause; changed that to "and" and it fixed it. [[User:Ttenbergen|Ttenbergen]] 12:11, 2022 August 31 (CDT)
 
=== version 2022-07-07 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 11:49, 2022 July 12 (CDT)
* added queryRunner to get better error management for queries
* updated compact_runner that wasn't working at all
* updated the command in VBA that generates the 1_D_format_limit data to use the new Admit_DtTm, it was still using the old format.
 
=== version 2022-06-09 ===
copied to server
* updated query ''import_request_matcher'' to do counts and filter to only 0s
* updated query ''1_cc_request_maker'' to only list vetted records
 
=== version 2022-06-01 ===
copied to server
* cleanup: deleted table ''TEMP'' and queries ''tmp_DSM_D_ID_fix_2020-10-01'', ''s_mapping_lab_updater1'' and ''s_group_updater''; renamed ''s_group_updater1'' to ''s_group_updater''
* cleanup: deleted table ''TEMP'' and queries ''tmp_DSM_D_ID_fix_2020-10-01'', ''s_mapping_lab_updater1'' and ''s_group_updater''; renamed ''s_group_updater1'' to ''s_group_updater''
* Julie had raised a scenario where duplicate data might arrive in the file; confirmed that import process de-duplicates against import file rather than deleting duplicates after
* Julie had raised a scenario where duplicate data might arrive in the file; confirmed that import process de-duplicates against import file rather than deleting duplicates after
* [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]:  
* [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]:  
** updated DB_Connect to also connect [[L TmpV2 table]], since we now need [[Boarding Loc]] and [[Service tmp entry]] to make [[Admit DtTm]]
** General:
** copied in [[created_AdmitDtTm query]] and [[created_FirstService query]] from [[CFE]]
*** updated DB_Connect to also connect [[L TmpV2 table]], since we now need [[Boarding Loc]] and [[Service tmp entry]] to make [[Admit DtTm]]
*** copied in [[created_AdmitDtTm query]] and [[created_FirstService query]] from [[CFE]]
** requester:
*** updated query ''1_C_requester_cc_maker'' to use new Admit_DtTm instead of old Arrive_DtTm
*** confirmed that VBA for sending request doesn't need modification
** importer:
*** confirmed no changes should be required to importer


=== version 2020-09-30 ===
=== version 2020-09-30 ===
Line 39: 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"