How do I set up CIS data mapping for date time items?
The following table describes how to set up a CIS data mapping.
CIS data mapping setup for date time items
Clintrial database result
|
Data series and data mapping setup
|
Entire date appears in a DATE database column. The DATE data type corresponds to the Oracle DATE database format.
|
- In the Item Editor for the date time item, select the Required and Allowed checkboxes for each date part.
- Map the date time item to a data series with a type of Date Time.
|
Entire date appears in a DATETIME database column. The DATETIME data type corresponds to the Oracle DATE database format.
|
- In the Item Editor for the date time item, select the Required and Allowed checkboxes for each date and time part.
- Map the date time item to a data series with a type of Date Time.
|
Entire date appears in a TEXT database column. The TEXT data type corresponds to the Oracle VARCHAR(n) format.
|
- Map the date time item to a data series with a type of Text.
- In the Date-Time Data Point dialog box, select All in one column, and click OK.
|
Each date time part appears in a separate TEXT database column. The TEXT data type corresponds to the Oracle VARCHAR(n) format.
|
- Map the date time item to a data series with a type of Text.
- In the Date-Time Data Point dialog box, select Split columns.
- In the CIS Date Part list, select the date time part to map, and click OK.
- Repeat these steps for each date time part. Place each date time part in a different data series.
|
Each date time part appears in a separate FIXED database column. The FIXED data type corresponds to the Oracle NUMBER(n) database format.
|
- Map the date time item to a data series with a type of Integer.
- In the Date-Time Data Point dialog box, select Split columns.
- In the CIS Date Part list, select the date time part to map, and click OK.
- Repeat these steps for each date time part. Place each date time part in a different data series.
|