IRV_AF_ROLLUP_VISITS
This view contains form states summarized to the subject visit level.
Columns in the IRV_AF_ROLLUP_VISITS view
IRV_AF_ROLLUP_VISITS |
IRV_AF_ROLLUP_VISITS |
---|---|
SUBJECTVISIT |
Always 1; indicates that the row represents one subject visit. |
SUBJECTVISITID |
Numeric identifier for the subject visit. |
FORMSSTARTED |
Number of forms associated with the subject visit that are in the Started state. |
FORMSSDVREADY |
Number of forms associated with the subject visit that are in the SV Ready state. |
FORMSSDVPARTIAL |
Number of forms associated with the subject visit that are selected for source verification, and are in the Not Complete state. |
FORMSSDVCOMPLETE |
Number of forms associated with the subject visit that are selected for source verification, and are in the Verified state. |
FORMSLOCKED |
Number of forms associated with the subject visit that are in the Locked state. |
FORMSFROZEN |
Number of forms associated with the subject visit that are in the Frozen state. |
FORMSSIGNED |
Number of forms associated with the subject visit that are in the Signed state. |
FORMSCOMPLETE |
Number of forms associated with the subject visit that are in the Complete state. |
FORMSHAVEQUERIES |
Number of forms associated with the subject visit that have queries. |
FORMSHAVECOMMENTS |
Number of forms associated with the subject visit that have comments. |
FORMSHAVEDATA |
Number of forms associated with the subject visit that have data. |
FORMSMISSINGITEMS |
Number of forms associated with the subject visit that are missing required items. |
FORMSNOTDONE |
Number of forms associated with the subject visit that are not done. |
FORMSDELETED |
Number of forms associated with the subject visit that have been removed. |
FORMSDELETEDDYNAMICFORM |
Number of dynamic forms associated with the subject visit that have been removed. |
FORMSBOOKSIGN |
Number of forms associated with the subject visit that represent a CRB signature form. |