Add or modify a table manually

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

2. Select the Development lifecycle.

3. Select the model and click Check Out.

   If the Check Out option is not active, either the model is already checked out or you do not have the required privileges. To see who checked it out, see the Checked Out By value near the top right of the page. You may need to click the >> double arrow icon.

   Note:

   Do not make structural changes to tables in InForm models; see Modify an InForm input model for information on the changes that are and are not allowed.

4. In the Tables tab, click the Add Table icon or select a table and click the Modify Table icon.

5. Enter values in the following fields:

   • Enter a name and description for the column; see Naming restrictions for restrictions.

   • Oracle Name: The system enters the value you entered for the name, truncated at 30 characters. See Automatic name truncation.

   • SAS Name: The system enters the value you entered for the name, truncated at 32 characters.

   • SAS Label: (Optional) The system enters the value you entered for the name. It can be up to 256 characters.

   • Aliases: Enter one or more aliases, or alternate names for the table. If you want more than one alias, enter a comma-separated list with no spaces—for example: dm,demo,demog,demography.

     The system uses these in automapping transformations.

   • SDTM Identifier: If this table corresponds to an SDTM standard Subject or Subject Visit table, select its identifier from the list. See Add Subject Visit and Subject tables for information about requirements. Using SDTM identifiers makes automapping more accurate.

     Tip:

     The SDTM Identifier field is available only when modifying a table.

   • UOW (Unit of Work) Processing Type: See Set up Unit of Work data processing for tables.

6. Set blinding attributes; see Set up data blinding in tables.

7. Click OK.

8. Finish table details:

   • All clinical data tables must have columns and a primary key. See Add columns to a table manually and Add constraints to tables.

   • You must select a data processing type. See Set up Unit of Work data processing for tables.

   • You can change the way the table columns are displayed in the Listings pages.

   • To mask data, see Set up data blinding in tables.

Back to Set up clinical data models