IRV_VISIT_REVS

This view contains Visit revision information.

Column Name (Key indicator)	Description
VISITID	Visit ID
VISITREV	Visit revision number
FIRSTREV	If VISITREV equals to the first revision number. 1 yes, 0 no
CURRENTREV	If VISITREV equals the current revision (latest). 1 yes, 0 no.
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.