CDS Criteria Syntax

For each line, include the following information:

Crit Type

Criterion Type. From the LOV choose one of the following values for each line: RDCI or RDCM Key Criteria, Response Criteria, or Discrepancy Criteria.

If you include statements for more than one criterion type, you must sort them in key, resp, and then disc order, and you must include an AND in the And/Or column between each different criterion type set of statements.

(

If you are using more than one criterion, or statement, and you need parentheses in your SQL statement to override default precedence such as ORs, then enter an opening parenthesis here and a closing one at the end of the statement.

Key/Ques Grp Ques

The value you enter here is either a key column or a question group question, depending on whether the Criterion Type is RDCI or RDCM Key Criteria, Response Criteria, or Discrepancy Criteria. An LOV is available.

This field is required, but the system does not validate your entry until you save your criteria.

• For criteria of type RDCI Key or RDCM Key, enter a key column whose value you want to use as a filter to specify which records to change:

  You can choose columns not in the LOV as long as they are of the format table_alias.column_name

  where:

  table_alias is one of the table aliases in the LOV.

  column_name is any column in the table_alias table.

• For Response criteria, enter a question group question whose response value you want to use as a filter to specify which records to change:

  <question_group_name-n.question$X>

  Where:

  question_group_name specifies a Question Group Name, if applicable.

  A period (.) separates Question Group Name from Question Name, if you state both parameters.

  question specifies Question Name, if applicable.

  -n (where n is a non-zero occurrence) If the question has multiple occurrences, you can specify a specific occurrence. You can obtain this number from the field's LOV. This parameter is optional.

  A dollar symbol separates question values from column occurrence values.

  X specifies a column occurrence with one of the following values:

  • v specifies value text (Use for numeric comparisons.)

  • e specifies exception value text

  • d specifies data comment text

  • f exception_value_text (If present; otherwise value text. Use for character string comparisons.)

• For Discrepancy criteria, choose a discrepancy attribute from the LOV. The choices vary, depending on the type of discrepancy you specified in the top panel of the MCS. They include:

  • For Manual, Indicator, and Manual Header discrepancies: comment text, creation timestamp, discrepancy review status code, internal comment text, and irresolvable flag.

  • For univariate discrepancies, you have all the choices listed above, plus discrepancy type code.

  • For multivariate discrepancies you have all the choices listed above plus Procedure name and Procedure detail test order sequence.

  All attributes have the prefix "DE" for the DISCREPANCY_ENTRIES table.

Expr

Choose a standard SQL expression from the LOV. Choices include: In, Not in, Is, Is not, Like, Not like, <, <=, =, <>, !=, >=, >.

Value

Enter a valid value for the key or question you entered in the Key/Ques Grp Ques field. Depending on the type of mass change, the LOV shows valid keys or column names. You can manually enter contextually valid entries not in the LOV. Enclose character data values in single quotes ('value').

Note:

If you enclose numeric values in single quotes, the system treats the value as a character string, so '15' is greater than '1234' for strings but not for numerics.

Do not enclose column names in quotes.

)

If you used an opening parenthesis at the beginning of the statement, use a closing parenthesis here.

AND/OR

If you are using more than one criterion, you must enter a Boolean relationship between each sequential pair: either AND or OR. Only the final statement should not be followed by either AND or OR.