Instructions for importing a batch of DSM Data: Difference between revisions

JMojica (talk | contribs)
JMojica (talk | contribs)
Line 64: Line 64:
==== Duplicate RequestNo For Incomplete Profiles sent more than once ====
==== Duplicate RequestNo For Incomplete Profiles sent more than once ====
This is caused by patients having more than one D_ID because  
This is caused by patients having more than one D_ID because  
# The location portion of the D_ID has been changed after the requestor list has been sent to DSM   
# The location portion of the D_ID has been changed after the requestor list has been sent to DSM.  
# The D_ID format has been changed to include Laptop Identifier.  
# The D_ID format has been changed to include Laptop Identifier.  
Every time the batch of DSM data is uploaded, matches maybe be found for same patient but labeled with diff D_IDs.
==== Missing Lab data for Completes ====
==== Missing Lab data for Completes ====
This is also caused by the change in the D_ID after the requestor list has been sent to DSM. When uploading the DSM data, the new D_ID is being used for finding matches while the dumped Lab data is identified by the old D_ID. This resulted to missing lab dat in the DSM database although present in DSM dumped file.
This is also caused by the change in the D_ID after the requestor list has been sent to DSM.
# The location portion of the D_ID has been changed
# The location portion of the D_ID has been changed.
# The D_ID format has been changed to include Laptop Identifier.  
# The D_ID format has been changed to include Laptop Identifier.
When uploading the DSM data, the new D_ID is being used for finding matches while the dumped Lab data is identified by the old D_ID. While present in DSM dumped file, no match was found resulting to no lab data for that profile.
=== Missing some Lab Dates ===  
=== Missing some Lab Dates ===  
Found cases where the range of dates used is between Arrived_DtTm and Dispo_DtTm and not Accept_DtTm and Dispo_DtTm
Found cases where Lab dates between Accept and Arrived are missing.
# This may be due to the changes done in the dates.


== Known issues ==
== Known issues ==