Instructions for importing a batch of DSM Data: Difference between revisions
No edit summary |
|||
| Line 5: | Line 5: | ||
The ACCESS Import program stopped working after Feb 9,2024 and a temporary solution using SAS was suggested. | The ACCESS Import program stopped working after Feb 9,2024 and a temporary solution using SAS was suggested. | ||
=== Step 1- done by Julie === | === Step 1- done by Julie === | ||
# In the batch folder of the current DSM data, create a subfolder labeled JM and save the SAS program labeled | # In the batch folder of the current DSM data, create a subfolder labeled JM and save the SAS program labeled DSM_import_version2.sas | ||
# Run the SAS program and the outputs are as follows: | # Run the SAS program and the outputs are as follows: | ||
## an excel file containing New labs is exported. The list has to be emailed to Allan Garland for confirmation. If new labs appear, Julie will add them to the SAS codes and re-run the SAS program. | ## an excel file containing New labs is exported. The list has to be emailed to Allan Garland for confirmation. If new labs appear, Julie will add them to the SAS codes and re-run the SAS program. | ||
| Line 14: | Line 14: | ||
### the worksheet nomatchDSMLab contains the D_ID present in the dumped but no LAB dttm or Collect dttm fall between the [[Admit date and time]] and [[Dispo DtTm]]. The file has the same columns with the requestor list plus the LOS sorted from highest to lowest. Shorter LOS (<=2days) may possibly have no lab requests but those with longer LOS may have just missed. Thus, those with longer LOS >= 3d is going to be included on the next batch of sending to confirm if really has no lab data. | ### the worksheet nomatchDSMLab contains the D_ID present in the dumped but no LAB dttm or Collect dttm fall between the [[Admit date and time]] and [[Dispo DtTm]]. The file has the same columns with the requestor list plus the LOS sorted from highest to lowest. Shorter LOS (<=2days) may possibly have no lab requests but those with longer LOS may have just missed. Thus, those with longer LOS >= 3d is going to be included on the next batch of sending to confirm if really has no lab data. | ||
=== Step 2 - done by Pagasa === | === Step 2 - done by Pagasa === | ||
# Open the DSM_Labs_data | |||
## Goto the External Data and click new datasource from file Excel | |||
## Choose the excel file where the final matchedDSM is saved and append to L_Labs_DSM | |||
## Update the Date imported and write comments if any to the WIKI https://ccmdb.kuality.ca/index.php?title=Instructions_for_requesting_a_batch_of_data_from_DSM | |||
== Instructions Using ACCESS == | == Instructions Using ACCESS == | ||