Rules for Setting Status Variables

Oracle Clinical maintains a Status field that reflects the validation status of each Response field. This field validation status consists of three characters: the first represents univariate validation; the second, multivariate; and the third, manual comments.

The rules for computing the univariate, multivariate, and manual validation statuses are listed below. These are listed in descending order of priority. Higher priority indicates that a rule is applied before another with lower priority. As soon as a rule for status determination is satisfied, the process of computing the validation status ends.

O - Outstanding

Indicates that the response has at least one unresolved discrepancy still under review. This condition applies to all three status variables.

I - Irresolvable

Indicates that the response does not have any outstanding system-generated or manual discrepancies, but has at least one resolved discrepancy with a status of Irresolvable. This condition applies to all three status variables.

K - Confirmed

Indicates that the response does not have any outstanding discrepancies, but has at least one resolved discrepancy with a status of Confirmed, that is, confirmed as a true verified value by a reviewer. This condition applies to all three status variables.

C - Clean

Indicates that the response has discrepancies that were resolved or made obsolete by either a data change or change in an edit check.

• Univariate status is C when a univariate discrepancy is eliminated by a change to the data or a change to an edit check so that the discrepancy is now Obsolete.
• Multivariate status is C when a multivariate discrepancy is eliminated by a change to the data or a change to the validation procedure so that the discrepancy is now Obsolete.
• Manual status is C when the response has at least one manual discrepancy that is manually resolved with a resolution status code having superseded long_value in the codelist.

N - None

Indicates no discrepancy ever existed for the response.

• Univariate status is N when a response has no univariate discrepancies.
• Multivariate status is N when a response has no multivariate discrepancies.
• Manual status is N when a response has no manual discrepancies, excluding those with a resolution status code having NON DISCREPANT long_value in the codelist.