Instructions for importing a batch of DSM Data: Difference between revisions
| Line 81: | Line 81: | ||
# 'Blood Gas Sodiu ' vs ’Blood Gas Sodium' | # 'Blood Gas Sodiu ' vs ’Blood Gas Sodium' | ||
=== Re-do the DSM matching 29Oct2020 === | === Re-do the DSM matching 29Oct2020 === | ||
Julie went back to the dumped DSM data file starting from batches 2019-01-23 to 2020-10-14. She did the following steps | Julie went back to the dumped DSM data file starting from '''batches 2019-01-23 to 2020-10-14'''. She did the following steps | ||
# For each batch of data, identify the profiles with D_ID changes by comparing the requestor list and CCMDB. | # For each batch of data, identify the profiles with D_ID changes by comparing the requestor list and CCMDB. | ||
## Make a new column adding the new D_ID. The old and new D_ID will be saved in CFE L_Problems_D_ID. | ## Make a new column adding the new D_ID. The old and new D_ID will be saved in CFE L_Problems_D_ID. | ||
| Line 91: | Line 91: | ||
# Check duplicates due to lab labels or changed D_IDs and remove them. | # Check duplicates due to lab labels or changed D_IDs and remove them. | ||
# Compare D_ID of the matched DSM dataset with L_log to determine the unmatched cases (and %). | # Compare D_ID of the matched DSM dataset with L_log to determine the unmatched cases (and %). | ||
# Get the lab data from the DSM before the batch 2019-1-23 and combine with the new matched dataset. | # Get the lab data from the DSM Database '''before the batch 2019-1-23''' and combine it with the new matched dataset. | ||
## check again for any duplication due to lab labels or changed D_IDs and remove duplicates. | ## check again for any duplication due to lab labels or changed D_IDs and remove duplicates. | ||
## Make sure the lab data is unique by D_ID, reqistry no, Lab DtTm, Lab Test and result. | ## Make sure the lab data is unique by D_ID, reqistry no, Lab DtTm, Lab Test and result. | ||
# Import the New_Lab_DSM to the DSM database. | # Import the New_Lab_DSM to the DSM database. | ||
Julie is still thinking to re-send those profiles found with no lab data to DSM. Julie will give Pagasa some more list of changed D_IDs to be added to the CFE L_Problems D_ID. | |||
== Known issues == | == Known issues == | ||