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 OCTOBER 18, 2022
Applies to:
Oracle Clinical - Version 5.2.0 and laterOracle 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.
Goal
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
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 |
References |