Sample script to spool a Batch Data Load file that will populate the new TMS Enterable Parent Question.
(Doc ID 2607190.1)
Last updated on NOVEMBER 12, 2019
Applies to:Oracle Clinical - Version 5.2.0 and later
Oracle Clinical Remote Data Capture Option - Version 5.2.0 and later
Oracle Thesaurus Management System - Version 5.2.0 and later
Information in this document applies to any platform.
The purpose of this script (createBDLFile.sql) is to spool a Batch Data Load file that populates the NEW TMS Parent question with the same data that was entered for the OLD TMS Parent. A standard PIPE (|) delimited load file will be spooled to 'c:\temp\bdl.txt' which can then be batch loaded via the Oracle Clinical 'Out Of Study' Batch Data Load menu options.
FYI: This note number is referenced in the TMS Users Guide => 'Using a New Version of a Dictionary for an Ongoing Study' => 'Upgrading to a New Dictionary Version with a New Structure' sub-section.
Note: Ensure the correct values are specified in the 'SPECIFY VALUES' section of the script before running it where:
vStudyName = Study name nOldTMSParentDcmQuestionID = OLD TMS Parent DCM_QUESTION_ID vDCM_QG_Name = Question Group name (contains both the OLD (uncollected) and NEW TMS Enterable question) vNewTMSParent_QName = New TMS Parent Question Name nDcm_ques_occurren_sn = Question Occurence SN .. this is usually zero
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