ordinal and study_event_definition

smith

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

jscherer

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

jskillings07

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.stevens

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.