#711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data --------------------------+-------------------- Reporter: meiliu | Owner: xsong Type: task | Status: new Priority: major | Milestone: Component: data-sharing | Resolution: Keywords: aki cdm | Blocked By: Blocking: | --------------------------+--------------------
Comment (by xsong): Oops,I forgot that #AKI_onset was only a temporary table on sql server, which should be recreated every time we need to call it. However, I think we could confirm that the issue is caused by the low counts of records for the med table. May I know if that can possibly be caused by RXNORM_CUI not being well populated (since we are only collecting med with `RXNORM_CUI is not null`)?. Replying to [comment:24 lv]: > From Steffani (and I'm hoping a Trac account can be created for her): > > Collect_med.sql creates 54 records when I run just the SQL, but I’m returning this error when running the test code: > > Error during wrapup: Unable to retrieve JDBC result set for select distinct pat.PATID ,pat.ENCOUNTERID ,convert(datetime, convert(CHAR(8), p.RX_ORDER_DATE, 112)+ ' ' + CONVERT(CHAR(8), p.RX_ORDER_TIME, 108) ) RX_ORDER_DATE_TIME ,p.RX_START_DATE ,case when pat.DISCHARGE_DATE < p.RX_END_DATE THEN pat.DISCHARGE_DATE else p.RX_END_DATE end as RX_END_DATE ,p.RX_BASIS ,p.RXNORM_CUI /*,regexp_substr(p.RAW_RX_MED_NAME,'[^\[]+',1,1) RX_MED_NAME */ ,p.RX_QUANTITY /*,p.RX_QUANTITY_UNIT */ ,p.RX_REFILLS ,p.RX_DAYS_SUPPLY ,p.RX_FREQUENCY ,case when p.RX_DAYS_SUPPLY is not null and p.RX_DAYS_SUPPLY is not null then round(p.RX_QUANTITY/p.RX_DAYS_SUPPLY,0) else null end as RX_QUANTITY_DAILY ,datediff(dd,pat.ADMIT_DATE,p.RX_START_DATE) DAYS_SINCE_ADMIT from #AKI_onsets pat join [PopMedNet].[dbo].PRESCRIBING p on pat.ENCOUNTERID = p.ENCOUNTERID where p.RXNORM_CUI is not null and p.RX_START_DATE is not null and p.RX_ORDER_DATE is not null and p.RX_ORDER_TIME is not null and p.RX_ORDER_DATE between dateadd(day,-30,pat.ADMIT_DATE) and pat.DISCHARGE_DATE order by PATID, ENCOUNTERID, RXNORM_CUI, RX_START_DATE (Invalid object name '#AKI_onsets'.) > -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev