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 |
IRV_AF_ROLLUP_STUDYVERSIONS |
---|---|
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. |