Modify CIS date time part data mappings

You can set up CIS data mappings for date time items so that either all data appears in a single database column in the Clintrial database or so each date time part appears in a separate database column in the Clintrial database.

To split data mappings for a date time item into date part components, you define a separate data series and mapping for each date part. The data mappings that the Oracle Central Designer application generates include the DATEPART attribute of the CTITEM tag.

1. In the Project Explorer, select a data series.
2. Right-click an item, and select Modify data point date part.
3. To change the data mapping from multiple columns to one column, select All in one column.

   Or:

   To change the data mapping from one column to a column for each date time part:

   1. Select Split Columns.
   2. In the CIS Date Part list, select the date time part to map.
4. Click OK.