Previous Topic

Next Topic

Book Contents

IRV_AF_ROLLUP_STUDYVERSIONS

This view contains form states summarized to the study version level.

Columns in the IRV_AF_ROLLUP_STUDYVERSIONS view

IRV_AF_ROLLUP_STUDYVERSIONS
Column Name (Key indicator)

IRV_AF_ROLLUP_STUDYVERSIONS
Column Description

STUDYVERSION

Always 1; indicates that the row represents one study version.

STUDYVERSIONID (PK)

Numeric identifier for the study version.

FORMSSTARTED

Number of forms associated with the study version that are in the Started state.

FORMSSDVREADY

Number of forms associated with the study version that are in the SV Ready state.

FORMSSDVPARTIAL

Number of forms associated with the study version that are selected for source verification, and are in the Not Complete state.

FORMSSDVCOMPLETE

Number of forms associated with the study version that are selected for source verification, and are in the Verified state.

FORMSLOCKED

Number of forms associated with the study version that are in the Locked state.

FORMSFROZEN

Number of forms associated with the study version that are in the Frozen state.

FORMSSIGNED

Number of forms associated with the study version that are in the Signed state.

FORMSCOMPLETE

Number of forms associated with the study version that are in the Complete state.

FORMSHAVEQUERIES

Number of forms associated with the study version that have queries.

FORMSHAVECOMMENTS

Number of forms associated with the study version that have comments.

FORMSHAVEDATA

Number of forms associated with the study version that have data.

FORMSMISSINGITEMS

Number of forms associated with the study version that are missing required items.

FORMSNOTDONE

Number of forms associated with the study version that are not done.

FORMSDELETED

Number of forms associated with the study version that have been removed.

FORMSDELETEDDYNAMICFORM

Number of dynamic forms associated with the study version that have been removed.

FORMSBOOKSIGN

Number of forms associated with the study version that represent a CRB signature form.

Send Feedback