We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Double Data Entry

Hi everyone,

When you have a double data entry study, can you tell me what I have to do to see which of my CRF have DDE completed and those who don't ?

Do I have to click on each event of each patient to see if IDE and DDE are filled ? Tell me I'm wrong, please !

Thank you,



  • lkeitalkeita Posts: 50
    Hi Romain,

    One way to view this information is to change your Subject Matrix view to view by Event. You can then filter to view by status. See screen shot attached, and I hope this helps!

  • RCHENURCHENU Posts: 207 ✭✭
    That means that I have to do it for each event which is not a solution.
    I'll try to query the database I think to see what I can get.
    Thank you anyway.

    If you think of something else or already have a sql query...

  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    via Email
    datamart has a query for this, if you want to either set it up or just use
    the queries as hoc.
  • RCHENURCHENU Posts: 207 ✭✭
    From what I see, I need MS Access which I have not. I'm interrested by the sql query though !
  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    via Email
    Try sqldatamart, its postgres only
This discussion has been closed.