Related to this topic: OBSERVATION_FACT.NVAL_NUM is defined as NUMBER(18,5). However, the CDM V3.1 LAB_RESULT_CM.RESULT_NUM is defined as NUMBER(15,8). How have the sites handled this discrepancy? Or perhaps the data has largely fit without any issues?
Thanks, Tony Tony French | Interim Assistant Director of Technical Services Center for Biomedical Informatics 1101 West Tenth Street Indianapolis, IN, 46202 Tel 317-274-9087 | Fax: 317-274-9305 Twitter: @Regenstrief | Facebook.com/regenstriefinstitute <http://facebook.com/regenstriefinstitute> www.regenstrief.org <http://www.regenstrief.org/> Confidentiality Notice: The contents of this message and any files transmitted with it may contain confidential and/or privileged information and are intended solely for the use of the named addressee(s). Additionally, the information contained herein may have been disclosed to you from medical records with confidentiality protected by federal and state laws. Federal regulations and State laws prohibit you from making further disclosure of such information without the specific written consent of the person to whom the information pertains or as otherwise permitted by such regulations. A general authorization for the release of medical or other information is not sufficient for this purpose. If you have received this message in error, please notify the sender by return e-mail and delete the original message. Any retention, disclosure, copying, distribution or use of this information by anyone other than the intended recipient is strictly prohibited. On 7/11/17, 11:34 AM, "Gpc-dev on behalf of Michael Prittie" <[email protected] on behalf of [email protected]> wrote: >I can verify that the RESULT_NUM data type conversion in >data_step_view_prep.sas was the source of the data check exception being >thrown in the EDC mentioned as Alex mentioned. I have updated the code, >which is available at >https://github.com/kumc-bmi/i2p-transform/blob/master/SAS/data_step_view_p >r >ep.sas. If anyone else is using this code to generate data step views use >the updated code to regenerate them. > >Best, >Michael > >On 7/11/17, 9:36 AM, "Stoddard, Alexander" <[email protected]> wrote: > >> >>MCW had the exact same problem with RESULT_NUM being seen by SAS as a >>character field despite being numeric in our source RDMS table (Oracle). >> >>For us this was caused by the data_step_view_prep.sas code which >>explicitly forces the RESULT_NUM field to character (which was how it was >>originally mis-specified in the first CDM3.0 design). Deleting that >>explicit conversion from the data_step_view_prep.sas fixed the issue for >>us. >> >>Best regards, >>Alex Stoddard >>Biomedical Informatics Software Engineer >>CTSI >> >> >>Date: Tue, 11 Jul 2017 13:52:42 +0000 >>From: Michael Prittie <[email protected]<mailto:[email protected]>> >>To: Steger Donald A >><[email protected]<mailto:[email protected]>>, >> "[email protected]<mailto:[email protected]>" >><[email protected]<mailto:[email protected]>> >>Cc: Mish Thomas F <[email protected]<mailto:[email protected]>> >>Subject: Re: Question on CDM v3.1 Run >>Message-ID: >><d58a4031.27e40%[email protected]<mailto:D58A4031.27E40%[email protected] >>d >>u>> >>Content-Type: text/plain; charset="us-ascii" >> >>Hi Don, >>We are getting the same error here at KUMC. Are you using data step >>views? I am currently testing whether a small change to our >>data_step_view_prep.sas will fix this. >> >>Best, >>Michael >> >>From: Gpc-dev >><[email protected]<mailto:[email protected] >>d >>u><mailto:[email protected]><mailto:gpc-dev-bounces@lists >>e >>rv.kumc.edu%3e>> on behalf of Steger Donald A >><[email protected]<mailto:[email protected]><mailto:DSteger2@uwhe >>a >>lth.org><mailto:[email protected]%3e>> >>Date: Tuesday, July 11, 2017 at 7:41 AM >>To: >>"[email protected]<mailto:[email protected]><mailto:gpc-d >>e >>[email protected]><mailto:[email protected]%3e>" >><[email protected]<mailto:[email protected]><mailto:gpc-d >>e >>[email protected]><mailto:[email protected]%3e>> >>Cc: Mish Thomas F >><[email protected]<mailto:[email protected]><mailto:[email protected]> >>< >>mailto:[email protected]%3e>> >>Subject: Question on CDM v3.1 Run >> >>Hello: >> >>When running CDM 3.1, the EDC is reporting an error: Required Numeric >>field is character: LAB_RESULT_CM RESULT_NUM >> >>However, LAB_RESULT_CM.RESULT_NUM is already defined as numeric(15,8) >> >>Is this a possible error in the EDC Report? How can we fix this error? >> >>Thanks, >>Don >> >>Don Steger >>Senior Data Management Developer >>Enterprise Analytics (EA) >>UWHealth >>(608) 720-6612 >>[email protected]<mailto:[email protected]><mailto:dsteger2@uwhea >>l >>th.org> >> >> > >_______________________________________________ >Gpc-dev mailing list >[email protected] >http://listserv.kumc.edu/mailman/listinfo/gpc-dev _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
