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.