IRV_CUR_VISIT

This view contains the current (latest revision) visit information.

Column Name (Key indicator) Description
VISITID Visit ID
VISITREV Visit revision number
VISITTYPE

Visit type.

1: patient visit

2: enrollment visit

3: screening visit

4: monitoring visit

5: status visit

6: comment visit

7: reg doc visit

8: report visit

9: conflict visit

16: relation visit

VTSUBJECTVISIT If visit is a patient visit. 1 yes, 0 no
VTENROLLMENT If visit is an enrollment visit. 1 yes, 0 no
VTSCREENING If visit is a screening visit. 1 yes 0 no
VTMONITOR If visit is a monitor visit. 1 yes, 0 no
VTSTATUS If visit is a status visit. 1 yes, 0 no
VTCOMMONCRF If visit is a common visit. 1 yes, 0 no
VTREGDOCS If visit is a reg doc visit. 1 yes, 0 no
VTVISITREPORT If visit is a report visit. 1 yes, 0 no
VTCONFLICT If visit is a conflict visit. 1 yes, 0 no
VISITREFNAME Visit Refname
VISITNAME Visit name
VISITMNEMONIC Visit mnemonic
HELPTEXT Help text
DESIGNNOTE Design note
CREATEDDATETIME Date and time when the view row was created.
CREATEDBYUSERID User ID of the user whose action resulted in the given view row being created.
MODIFIEDDATETIME Date and time when the data in the view row was most recently updated.
MODIFIEDBYUSERID User ID of the user whose action resulted in the most recent change to data in the given view row.