How do I set up CIS data mapping 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. |
|
Entire date appears in a DATETIME database column. The DATETIME data type corresponds to the Oracle DATE database format. |
|
Entire date appears in a TEXT database column. The TEXT data type corresponds to the Oracle VARCHAR(n) format. |
|
Each date time part appears in a separate TEXT database column. The TEXT data type corresponds to the Oracle VARCHAR(n) format. |
|
Each date time part appears in a separate FIXED database column. The FIXED data type corresponds to the Oracle NUMBER(n) database format. |
|
Parent topic: CIS mappings