AD_AllVisitStatus

PATIENTID

Unique identifier for the patient. (Can be NULL.)

SITEID

Database identifier of the site. (Can be NULL.)

SITENUMBER

Number of the site as displayed in the user interface.

VISITNAME

Name of the visit as displayed in the user interface.

VISIT_ID

Database identifier of the visit.

VISITSYSTEMSTATUS

System status of the visit:

• Not Started
• Incomplete
• Complete

VISITCOMPLETIONDATE

Date that the visit was completed.

VISITFROZEN

Code indicating whether the visit is frozen:

• 0—No
• 1—Yes

VISITLOCKED

Code indicating whether the visit is locked:

• 0—No
• 1—Yes

VISITDMREVIEWED

Code indicating whether the visit has been reviewed by a Data Manager:

• 0—No
• 1—Yes

VISITSDV

Code indicating whether the visit has been source verified:

• 0—No
• 1—Yes

VISITSIGNED

Code indicating whether the visit has been signed:

• 0—No
• 1—Yes

VISITREMOTEREVIEW

Code indicating whether the visit has been reviewed remotely:

• 0—No
• 1—Yes

VISITHASOPENQUERY

Code indicating whether the visit has open queries:

• 0—No
• 1—Yes

SITENAME

Name of the site as displayed in the user interface.

LAN_ID

Identifier of the language, enabling you to filter the view by language.