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

CRF's templates v/s databases

Hi Yufang,
Having the concept of database design in mind wanted to some quick
clarification and your advice on this.
1. Is the CRF equivalent to a database, and if so
2. Are the Section_Label's equivalent to tables
My Case Scenario.
I have a single source document and out of it i have managed to come up
with 3 tables. What is the recommended way of doing this in open
clinical. A new CRF for each table or one CRF with the tables defined
in the Section Labels.
e.g
Database name: fim
Tables contained in the fim database: fim_clinical, fim_observation,
fim_lab_results.
Tony Iha Kazungu
Kemri/WTRL
ICT Data Coordinator
[email protected], [email protected]
254-041-522063, 0735-716747

Comments

  • Without knowing the purpose of your database design and the schema of
    your tables, I feel hard to give you any suggestion for your case.
    In order to service clinical data management, sophisticated database has
    been designed for our OpenClinica application.
    Good luck.
    Yufang

    -----Original Message-----
    [mailto:[email protected]] On Behalf Of Tony Kazungu
    Sent: Thursday, February 08, 2007 4:50 AM
    To: [email protected]
    Subject: [Users] CRF's templates v/s databases
    Hi Yufang,
    Having the concept of database design in mind wanted to some quick
    clarification and your advice on this.
    1. Is the CRF equivalent to a database, and if so
    2. Are the Section_Label's equivalent to tables
    My Case Scenario.
    I have a single source document and out of it i have managed to come up
    with 3 tables. What is the recommended way of doing this in open
    clinical. A new CRF for each table or one CRF with the tables defined
    in the Section Labels.
    e.g
    Database name: fim
    Tables contained in the fim database: fim_clinical, fim_observation,
    fim_lab_results.
    Tony Iha Kazungu
    Kemri/WTRL
    ICT Data Coordinator
    [email protected], [email protected]
    254-041-522063, 0735-716747
  • mcoynemcoyne Posts: 20
    Hi Tony,
    In short the answers to both of your questions are no.
    In Openclinica, a form is an indepedent entity that has its own
    presentation (its display to end users), its own behavior. Behavior such
    as an input data to a field is incorrect, what error would be generated,
    whether or not users be allowed to move on to the next step with incorrect
    data, what other options that the Openclinica can aid if there is missing
    data item, etc. Or skip pattern behavior (if answer to question a is no,
    skip all questions to the end of the section, for example). Both
    presentation and behavior are "coded" into the CRF template.
    Openclinica maintains its own database to manage the information that is
    "coded" into the CRF template. And in Openclica database, there is NOT
    one table for each form (or crf). So, in your scenario, the information
    for each of the form (CRF) fim_clinical, fim_observation, fim_lab_results
    are not in 3 different tables; the information is organized differently
    (or rather dispersed) into different tables that are related to each other
    in different relations.
    Hope this helps.
    > > Hi Yufang,
    > > Having the concept of database design in mind wanted to some quick
    > > clarification and your advice on this.
    > >
    > > 1. Is the CRF equivalent to a database, and if so
    > > 2. Are the Section_Label's equivalent to tables
    > >
    > > My Case Scenario.
    > > I have a single source document and out of it i have managed to come up
    > > with 3 tables. What is the recommended way of doing this in open
    > > clinical. A new CRF for each table or one CRF with the tables defined
    > > in the Section Labels.
    > >
    > > e.g
    > > Database name: fim
    > > Tables contained in the fim database: fim_clinical, fim_observation,
    > > fim_lab_results.
    > >
    > > Tony Iha Kazungu
    > > Kemri/WTRL
    > > ICT Data Coordinator
    > > [email protected], [email protected]
    > > 254-041-522063, 0735-716747
    > >
    > >
This discussion has been closed.