When using DataDirect, it is possible build a query for a specific set of patients using the Upload List feature. The list can be the single source of your data, or you can apply rules and filters to narrow your query. The [DeID] PatientID is the only required column in the spreadsheet that you upload. [DeID] EncounterID and [DeID] AdmitDate can also be included.
Within DataDirect, there is an example spreadsheet to user as a guide when formatting your data for upload. After you have prepared your spreadsheet for upload, upload it using the Choose File button. If the file is password protected, enter the password and then select Preview your upload file.
The uploaded list will preview. The Validation column will indicate if the the Patient ID has found a match in DataDirect. Select Update to submit the upload file. Continue building your query in DataDirect.
