SUBJECTVISITCOUNT

Always 1; indicates that the row represents one subject visit.

SUBJECTID (PK)

Numeric identifier for the subject.

SUBJECTSTATE

Numeric value for the subject state:

1 - Screened
2 - Screening Failure
3 - Enrollment Failure
4 - Enrolled
5 - Randomized
6 - Completed
7 - Dropped Out

SITEID

Numeric identifier for the site with which the subject and visit are associated.

STUDYVERSIONID

Numeric identifier for the current study version with which the subject and visit are associated.

VISITID (PK)

Numeric identifier for the visit with which the subject and visit are associated.

VISITREV

Revision number for the visit with which the subject and visit are associated.

VISITINDEX (PK)

Instance identifier for the visit with which the subject is associated. Population dependent on Visit Type:

Standard visit:

0 - expected visit

1 - started visit

Repeating visit:

0 - expected visit

<Repeating Visit Index> - started visit instance

VISITORDINAL

Visit ordinal (0, 1, 2, 3...n ordered by visit index).

SUBJECTVISITID

Subject visit numeric identifier.

VISITACTIVATED

Visit is started:

0 - No

1 - Yes

VISITINCURSV

Visit is in current study version:

0 - No

1 - Yes

VISITORDER

Order of the visit in the study.

STARTHOURSFROMPREVIOUS

Number of hours from enrollment to when the visit is scheduled to start.

STARTHOURSFROMENROLL

Number of hours from enrollment to when the visit is scheduled to start.

VISITTYPE

Numeric value for the type of visit:

1 - Visit
2 - Enrollment
3 - Screening
4 - Monitor
5 - Status
6 - Common CRF
7 - Regdocs
8 - Visitreports
9 - Conflict
16 - Relation

VTSUBJECTVISIT

Visit type is CRF:

0 - No

1 - Yes

VTCOMMONCRF

Visit type is Common CRF:

0 - No

1 - Yes

VISITPROPERTIES

Contains the same data as the VISITTYPE column. For internal Oracle use only.

VISITSCHEDULED

Visit is scheduled:

0 - No

1 - Yes

VISITSREPEATING

Visit can be repeated:

0 - No

1 - Yes

VISITDYNAMIC

Visit is dynamic:

0 - No

1 - Yes

EXPECTEDSTARTDATE

Visit expected start date:

(STARTHOURSFROMENROLL + subject enrolled date)

VISIT_FIRST_ENTRY

Date when data was first entered for the visit.

VISIT_LAST_ENTRY

Date when data was most recently modified for the visit.

PROJECTEDSTARTHOURS

Not used.

STARTDATETIME

Not used.

SUBJECTVISITREV

Revision number for the subject visit.

DOV

Date of visit, as entered in the InForm user interface.

DOVDTMASK

Indicates valid date components that comprise the DOV. Sum of the following values for each valid date part: Year (0x01) 1, Month (0x02) 2, Day (0x04) 4, Hour (0x08) 8, Minute (0x10) 16, Second (0x20) 32.

DELETED

Not used. The value for this column is always NULL.

USERID

Numeric identifier of the user who last modified the visit.

SVTIME

Time of last visit revision.

TRANSACTIONID

Transaction associated with last visit revision.

REASON

Reason for last visit revision.

VISITCOMPLETE

All expected forms in the visit are complete:

0 - No

1 - Yes

RDEVISITFROZEN

All expected forms in the visit are frozen:

0 - No

1 - Yes

VISITSDVCOMPLETE

All expected forms in the visit are Verified:

0 - No

1 - Yes

VISITSIGNED

All expected forms in the visit are signed:

0 - No

1 - Yes

VISITLOCKED

All expected forms in the visit are locked:

0 - No

1 - Yes

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.