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