1. Study Setup Guide
  2. Create validation checks
  3. Secondary columns
  4. Add or remove a secondary column

Add or remove a secondary column

After you create a batch and a validation check with or without a custom program, you can modify it at any time (after checking it out). For example, you may want to add one or more secondary columns to the validation check or remove them.

Note:

If you created a validation check using a custom program in Oracle LSH, do not follow the steps in this procedure. Instead, locate the custom program in Oracle LSH, check it out, locate the target column you want to use as the secondary column and add $DMWVCSECONDARYVAR$ to the end of any text included in the Description field (to add it to the validation check). If you want to remove a secondary column from the custom program, remove the $DMWVCSECONDARYVAR$ text from the Description field of the target table column. Then update the custom validation check to point to the latest version of the custom program to include the updated secondary columns list.

  1. After you select a study, click the Study Configuration main menu icon Shows gear and pencil iconfrom the navigation bar.

  2. From the Clinical Data Model tab, select the model with the batch and validation check you want to modify. Then, click the Validation Checks tab.

  3. Select a validation check batch from the Validation Check Batches for Model table, then do one of the following:

    • If you selected a checked in batch, click Check Out to check them out. Then select one validation check from the Validation Checks for Batch table.
    • If you selected a checked out batch, select one validation check from the Validation Checks for Batch table.
  4. Click the Shows pencil and paper icon Modify Validation Check icon.
  5. Do one of the following:
    • To add secondary columns, select the Secondary Column check box next to the columns that you want to use. Do not select the column already used as the discrepant column as a secondary column.
    • To remove secondary columns, clear the Secondary Column check box next to the columns you do not want to use.
  6. Click OK.
  7. If ready to install the batch, see Install a validation check batch.

    Note:

    Discrepant columns appear with a single asterisk in the column header. Secondary columns appear with two asterisks in the column header. This helps you identify them when viewing VC listings.

Parent topic: Secondary columns