IRV_AF_ROLLUP_STUDYVERSIONS

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

Column Name (Key indicator)	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.