AD_FormStatus

SITENAME

Name of the site as displayed in the user interface.

SITENUMBER

Number of the site as displayed in the user interface.

PATIENTID

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

VISITNAME

Name of the visit as displayed in the user interface.

VISIT_ID

Database identifier of the visit.

VISITINDEX

Index indicating the order in which the visit occurs in the study.

VISITTYPE

Type of visit:

• System
• Unscheduled

FORMNAME

Name of the form.

FORMINDEX

Index indicating the order in which the form occurs in the visit.

REPEATINGFORM

Repeating form: Yes or No.

DYANMICFORM

Dynamic form: Yes or No.

FORMSYSTEMSTATUS

System status of the form:

• Not Started.
• Incomplete with queries.
• Complete.

FORMFROZEN

Yes or blank, indicating whether the form status is Frozen.

FORMLOCKED

Yes or blank, indicating whether the form status is Locked.

FORMDMREVIEWED

Yes or blank, indicating whether the form status is DM Reviewed.

FORMSDV

Yes or blank, indicating whether the form status is Source Verified.

FORMSIGNED

Yes or blank, indicating whether the form status is Signed.

FORMREMOTEREVIEW

Yes or blank, indicating whether the form status is Remote Reviewed.

FORMHASOPENQUERIES

Form has open queries: Yes or No.

FORMFIRSTUPDATEDATE

Date and time when the form was first updated.

FORMLASTUPDATEDATE

Date and time when the form was last updated.

SITEID

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

LAN_ID

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