IRV_AF_ROLLUP_SUBJECTS

This view contains form states summarized to the subject level.

Column Name (Key indicator) Column Description
SUBJECT Always 1; indicates that the row represents one subject.
SUBJECTID (PK) Numeric identifier for the subject numerical identifier
FORMSSTARTED Number of forms associated with the subject that are in the Started state.
FORMSSDVREADY Number of forms associated with the subject that are in the SV Ready state.
FORMSSDVPARTIAL Number of forms associated with the subject that are selected for source verification, and are in the Not Complete state.
FORMSSDVCOMPLETE Number of forms associated with the subject that are selected for source verification, and are in the Verified state.
FORMSLOCKED Number of forms associated with the subject that are in the Locked state.
FORMSFROZEN Number of forms associated with the subject that are in the Frozen state.
FORMSSIGNED Number of forms associated with the subject that are in the Signed state.
FORMSCOMPLETE Number of forms associated with the subject that are in the Complete state.
FORMSHAVEQUERIES Number of forms associated with the subject that have queries.
FORMSHAVECOMMENTS Number of forms associated with the subject that have comments.
FORMSHAVEDATA Number of forms associated with the subject that have data.
FORMSMISSINGITEMS Number of forms associated with the subject that are missing required items.
FORMSNOTDONE Number of forms associated with the subject that are not done.
FORMSDELETED Number of forms associated with the subject that have been removed.
FORMSDELETEDDYNAMICFORM Number of dynamic forms associated with the subject that have been removed.
FORMSBOOKSIGN Number of forms associated with the subject that represent a CRB signature form.