Previous Topic

Next Topic

Book Contents

IRV_VISIT_REVS

This view contains Visit revision information.

Columns in the IRV_VISIT_REVS table

IRV_VISIT_REVS

 

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.

Send Feedback