Centralized data front end.mdb Change Log 2014: Difference between revisions

Line 16: Line 16:
* added query "NDC_CLIinAcqDX_NoCLI_DateinTMPV2"
* added query "NDC_CLIinAcqDX_NoCLI_DateinTMPV2"
* fixing query "Primary_Admit"; needs to have 201583, one for each in L_Log, but only has 188562, missing early ones...  
* fixing query "Primary_Admit"; needs to have 201583, one for each in L_Log, but only has 188562, missing early ones...  
** initially wasn't finding lowest rank if <> 1, but now does; I think the remaining problem is with the import, not the query. Need to look into... examples of missing records are HSC_MICU--10035 HSC_MICU--10037 HSC_MICU--10062
** initially wasn't finding lowest rank if <> 1, but now does; I think the remaining problem is with the import, not the query. Need to look into... examples of missing records are  
*** HSC_MICU--10035 stdy 10062 ad1 100-02 wittnessed cardiac
*** HSC_MICU--10037 HSC_MICU--10062


===2014-03-12 ===
===2014-03-12 ===