Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at https://openclinica.com/insight-webinar

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

ordinal and study_event_definition

ordinal and study_event_definition
Hi,
In the table study_event_definition, there's a column named 'ordinal'. What's this used for?
Is it used to order the display of the events (from left to right) in the patient x event matrix?
Thanks

Comments

  • jschererjscherer Posts: 60
    Re: [Developers] ordinal and study_event_definition That’s used all over the place with repeating events to basically specify the row number/position/ordinal of the record..
    On 6/25/09 12:06 PM, "Colton Smith" wrote:
    Hi,
    In the table study_event_definition, there's a column named 'ordinal'. What's this used for?
    Is it used to order the display of the events (from left to right) in the patient x event matrix?
    Thanks
  • jskillings07jskillings07 Posts: 8
    Hi,

    Can someone add clarity to this statement please:

    "ordinal is use for repeating events to basically specify the row number/position/ordinal of the record.."?

    Is it "ordinal" same as a "sequential order"?




  • lindsay.stevenslindsay.stevens Posts: 403 ✭✭✭
    via Email
    There are 2 ordinals to find, one is for study events, the other is for
    item data.

    For study events, it means the order if event creation, per subject, per
    repeating event. For example a repeatable treatment event. First instance
    for a participant is 1, the next is 2, and so on.

    For item data, it means the row number of the item instance within the item
    group instance. For example in a concomitant medication form with
    medications in a repeating grid group, the first row is 1, then 2 and so
    on. For non repeating groups, the ordinal is always 1.

    You'll notice that the event CRF table foreign key is in the item data
    table, with no intermediate item group instance table. This is normal,
    albeit a tad inconvenient since it means the item group name has to be
    looked up via the item group metadata, then item group table, for the
    correct CRF version.
Sign In or Register to comment.