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: 7
    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: 388 ✭✭
    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.