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. |