Set up Unit of Work data processing for tables

Using Unit of Work (UOW) processing can speed up data loading and transformation execution. See Data processing types and modes for more information.

Tip:

We recommend always defining tables as Subject Visit UOW if both Subject and Visit are part of the primary key and as Subject UOW if the Subject column is part of the primary key but Visit is not.

1. Click the Study Configuration icon from the navigation bar. Then click the Clinical Data Models tab.

2. Select the model and click Check Out.

3. Select the table.

4. Define a primary key in the Columns pane, Constraints tab, if there is not already a primary key defined. See Add constraints to tables for details.

   Tip:

   To quickly see if there is a primary key defined, check the value of the Process Type (not UOW Process Type) attribute in the Tables pane. If there is no primary key, the value is Staging with Audit. When you define a primary key, the value changes to Reload.

5. Click the Modify Table icon to modify the UOW Processing Type attribute.

6. In the Modify Clinical Data Model Table pop-up, select one of the following values from the UOW Processing Type drop-down:

   • Non UOW: Jobs writing to the table will use Reload processing.

   • Subject: Jobs writing to the table will use try to use UOW processing with Subject as the unit of work.

     The table must have a column designated with the USUBJID (Unique Subject ID) SDTM Identifier, and must have a primary key that includes that column.

   • Subject Visit: Jobs writing to the table will try to use UOW processing with Subject Visit as the unit of work.

     The table must have one column designated with the USUBJID (Unique Subject ID) SDTM Identifier and another with the VISITNUM (Visit Number) SDTM Identifier, and both columns must be included in the primary key.

7. Click OK.

Back to Set up clinical data models