Instructions for requesting a batch of data from DSM

Preliminary information, this is not active yet

see Instructions for importing a batch of DSM Data for counterpart

We extract data to provide to DSM so they can provide us with labs that they have for those patients.

Instructions

If we want to include all patients with Aliases, we will need to 
do something to reconcile with Alias ID collection.

1. copy files to local, they are large and won't work well on a share.
   • make a new local directory
   • Put the following into the directory
     • Centralized_data.mdb
     • DSM_Labs_Consistency_check.accdb
     • PHI.mdb
     • CCMDB.mdb
2. open DSM_Labs_Consistency_check.accdb
3. pick the SentDtTms for which you want to export
   • starting should be the day after the last end date as per log below
   • ending date should be at least 28 days ago
4. click the "Export requestor file" button
5. follow the wizard
6. close Access and delete files you had copied
7. enter at the top of the log below when you requested data, and for what range

Log

eg copy/paste and fill in the following: 
* ~~~~~ - requested labs for SendDtTm from ... until ...

Pagasa, for next test let's request 2016-05-01 - 2016-05-31

• 2015-12-?? - Discharge date 2015-04-01 - 2015-04-30