Batch Data Load Format and mandatory values
(Doc ID 2288030.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Clinical - Version 5.1.0 to 5.1.0 [Release 5.1]Information in this document applies to any platform.
Goal
Question 1:
Can we skip Mandatory fields (export a data without a DCI/DCM/CPE/DCM_que_occ_sn mentioned in OC) for Batch Data load ?
Example below format to OC:
"PROJECTCODE"|"PROTOCOLNO"|"SAMPLECOLLECTIONDATE"|"SAMPLECOLLECTIONTIME"|"SAMPLERECEIVEDDATE"|"SAMPLERECEIVEDTIME"|"SITENO"|"PATINITIAL"|"SUBJECTNO"|"DOB"|"AGE"|"SEX"|"FASTINGSTATUS"|"LABCODE"|"VISIT"|"DEPARTMENT"|"INVESTNO"|"INVESTIGATION"|"ISORESULTS"|"ISOUNITS"|"TESTFLAG"|"ISORANGELOW"|"ISORANGEHIGH"|"REPORTDATE"|"REPORTTIME"|"LABCOMMENTS
Question 2:
If all the mandatory fields are given, can we change the format of Date(22-06-2017),add special characters(/ ; ' ' ) in the batch data load.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |