Setting Integration Reference Codelist Values

You must set values in four reference codelists in Oracle Clinical that determine aspects of the TMS-Oracle Clinical interaction:

• OCL_OPTIONS_TYPE_CODE
  
• TMS_OPTIONS
  
• DISCREPANCY REV STATUS CODE
  
• OCL_STATE
  

OCL_OPTIONS_TYPE_CODE

The OCL_OPTIONS_TYPE_CODE installation reference codelist contains entries for optional subsystems that may be available to Oracle Clinical. To use TMS with Oracle Clinical, the short value TMS_INSTALLED must be set to Y. This value is set by a script during installation.

TMS_OPTIONS

This local reference codelist contains TMS-specific options. Currently the only option defined is FIRST_REVIEW. If the Long Value for this option is set to Y, and the Review Before TMS setting is also set to Y in the question set, then the First Review for a thesaurus omission happens in the Oracle Clinical Discrepancy Management System, rather than in TMS. For more information on the interaction between the Oracle Clinical Discrepancy Management System and TMS, see Setting First Review.

DISCREPANCY REV STATUS CODE

This installation reference codelist provides the codes used by the Oracle Clinical Discrepancy Management System. Three are used in processing TMS omissions:

• TMS EVALUATION

• UNREVIEWED

• TMS IN PROGRESS

UNREVIEWED is active by default, but you must activate the two TMS-specific values before you begin using TMS.

For more information on the interaction between the Oracle Clinical Discrepancy Management System and TMS, see Managing the TMS/Oracle Clinical Workflow.

OCL_STATE

This local reference codelist includes one TMS-related short value: TMS_FAIL_BV_ACT. If it is active and its Long Value is set to Warn, then if Batch Validation encounters a serious error during its TMS processing, it will give a warning but will not cause the entire Batch Validation job to fail.

If the Long Value is inactive or set to anything other than Warn, Batch Validation will fail if it encounters a serious error during TMS processing.

If Batch Validation encounters a less serious error during TMS processing, it will issue a warning but not fail, regardless of the long value set for TMS_FAIL_BV_ACT.

See Effect of TMS Errors on Batch Validation for more information.