RT_NOTDONE_CONTROL

This view contains metadata that defines the possible values for the Not Done control (by default: Not Done, Unknown, Not Applicable).

Note: To accommodate international studies, the length of the Not Done control is set to varchar2(64), which accepts 64 multi-byte international characters, rather than 64 bytes of data.

Columns in the RT_NOTDONE_CONTROL view

RT_NOTDONE_CONTROL Column name (Key indicator)	RT_NOTDONE_CONTROL Column description
NDCONTROLID	Numerical identifier for the Not Done control.
NDVALUE	One of the following values for the Not Done control: Not Done Unknown Not Applicable
NDLABELRESOURCEID	Resource identifier that corresponds to the NDVALUE for the control.
NDLABEL	One of the following labels for the Not Done control: Not Done Unknown Not Applicable
CREATEDATETIME	Date and time when the Not Done control was started; that is, when a user entered data in the control or triggered a rule that entered data in the control. When the review schema is recreated, this column displays the date and time when the review schema was recreated.
CREATEDBYUSERID	User ID of the user who started the Not Done control by entering data in the control or triggering a rule that entered data in the control. When the review schema is recreated, this column displays the system user ID.
MODIFIEDDATE	Date and time when the Not Done control was most recently modified; that is, when a user most recently entered data in the control or triggered a rule that entered data in the control. When the review schema is recreated, this column displays the date and time when the review schema was recreated.
MODIFIEDBYUSERID	User ID of the user who most recently modified the Not Done control by entering data in the control or triggering a rule that entered data in the control. When the review schema is recreated, this column displays the system user ID.