IRV_FORM_ASSOC

This view contains data from associated forms.

Column Name (Key indicator) Column Description
SUBJECTID Numeric identifier for the patient associated with the forms.
SITEID Numeric identifier for the site associated with the forms.
VISITID Numeric identifier for the visit in which the associated forms exist.
VISITINDEX Instance identifier for the visit in which the associated forms exist.
STATUS Status of the associated forms.
FORMASSOCID Numeric identifier for the form association instance.
FORMID Numeric identifier for one of the associated forms.
FORMINDEX Instance identifier for one of the associated forms.
ASSOCFORMID Numeric identifier for one of the associated forms.
ASSOCFORMINDEX Instance identifier for one of the associated forms.
CREATEDBYUSERID User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME Date and time when the view row was created.
MODIFIEDBYUSERID User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME Date and time when the data in the view row was most recently updated.