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

← Older edit Newer edit →

@@ Line 2: / Line 2: @@
 We receive data from DSM that needs to be imported into our main repository.
-{{DJ |
-* The old process used [[ L_Problems_D_ID table]]. Does the new process still use and populate it? If so, can we update this with details? If not, can we retire it? Or, in any case, update the data on [[ L_Problems_D_ID table]]? [[User:Ttenbergen|Ttenbergen]] 15:15, 2024 October 17 (CDT)
-}}
 == Instructions Using SAS ==
@@ Line 15: / Line 13: @@
 ## an excel file containing the unmatched D_IDs
 ### the worksheet '''DSM_NoDID''' contains the D_ID where PHIN or chart number are not present in the dumped DSM data file.
-### the worksheet '''Log_NoDID''' contains the D_ID in the requestor list but not found in the L_LOG table of CFE.  This happens when the D_ID has been changed for some reason after the request has been sent already. if no D_ID label changing happens, then the worksheet will be empty. If not empty, then the SAS program must be modified to incorporate the D_ID label change.
+### the worksheet '''Log_NoDID''' contains the D_ID in the requestor list but not found in the L_LOG table of CFE.  This happens when the D_ID has been changed for some reason after the request has been sent already. if no D_ID label changing happens, then the worksheet will be empty. If not empty, then the SAS program must be modified to incorporate the D_ID label change  and  also they are to be written in the [[ L_Problems_D_ID table]].
 ### 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.
 ### the worksheet '''LOSgt2_resend''' contains the D_IDs with  LOS > 2d to be resent on the '''next batch''' of sending to confirm if really has no lab data.