What's New

This section describes the changes and additions to the stable interface in recent releases.

New in Release 5.0

No changes were made to the stable interface in Release 5.0.

New in Release 4.6.2

The only change to the stable interface in Oracle Clinical 4.6.2 is that a column, INFORMED_CONSENT_DATE, was added to PATIENT_POSITIONS and PATIENT_POSITIONS_HISTORY.

New in Release 4.6

This section describes the changes to the Oracle Clinical Stable Interface for Release 4.6. It includes these topics:

Changes to Synonym RDCI_HISTORY_V45
New Synonyms Introduced in Release 4.6
"New Columns Added to Existing Tables in Release 4.6"

Changes to Synonym RDCI_HISTORY_V45

The RDCI_HISTORY_V45 synonym changed in release 4.6. The data it queries excludes records where TRANS_TYPE = AUDIT (see Bug 10176208) or TRANS_TYPE is like SYS%, RETAIN%, REVERSE%. The synonym should include AUDIT records and should exclude SYS%, RETAIN% and REVERSE% records only if you have not applied patches 4.5.3.11 and 4.5.3.12 before upgrading to Release 4.6.

New Synonyms Introduced in Release 4.6

The Oracle Clinical Release 4.6 Stable Interface adds the new DCI and Patient Position tables that support flexible study design. This is the list of new tables and corresponding synonyms. See Chapter 3, "Flexible Studies Tables" for details.

SYNONYM_NAME	TABLE_NAME
DCI_BOOK_RULES_V46	DCI_BOOK_RULES
DCI_BOOK_RULE_TGT_DCIS_V46	DCI_BOOK_RULE_TGT_DCIS
DCI_BOOK_RULE_TGT_INTERVAL_V46	DCI_BOOK_RULE_TGT_INTERVALS
PP_EXPECTED_CPEST_V46	PP_EXPECTED_CPEST
PP_EXPECTED_CPES_V46	PP_EXPECTED_CPES
PP_EXPECTED_DCIST_V46	PP_EXPECTED_DCIST
PP_EXPECTED_DCIS_V46	PP_EXPECTED_DCIS
PP_EXPECTED_INTERVALST_V46	PP_EXPECTED_INTERVALST
PP_EXPECTED_INTERVALS_V46	PP_EXPECTED_INTERVALS

New Columns Added to Existing Tables in Release 4.6

Oracle modified the following stable interface tables and their synonyms for Release 4.6, and their synonyms for previous releases in a 4.6 database.

DCI_BOOKS

VALIDATION_STATUS NOT NULL VARCHAR2(20)

Indicates whether the DCI Book needs validating to ensure its rules and pages are consistent with each other. The value defaults to NOT APPLICABLE.

VALIDATION_RESULTS NULL CLOB

The results from the current Validate DCI Book run for this DCI Book.

VALIDATION_TS NULL DATE

The timestamp of the last successful Validate DCI Book run.

REVISION_SN NULL NUMBER(3)

The revision sequence number of the DCI Book at the last successful Validate DCI Book run.

DISCREPANCY_ENTRIES and DISCREPANCY_ENTRIEST

LAST_CHANGE_TS NULL DATE

Indicates the last time that the multivariate discrepancy was modified. Used for inclusion in data replication. The value defaults to TO_DATE (19000101000000,'YYYYMMDDHH24MISS').

LAST_VRV_CHANGE_TS NULL DATE

Indicates the last time the Validation Reported Values associated with this multivariate discrepancy were modified. Used for inclusion in data replication. The value defaults to TO_DATE (19000101000000,'YYYYMMDDHH24MISS').

DCM_QUESTIONS

HAS_GRAPHIC_BLOCKS_FLAG NULL VARCHAR2(10)

Indicates whether target blocks are defined for the DCM question in the graphic layout. The value CB denotes a conditional block is defined for the question, and a value TB denotes that an indicator block is defined for the question.

PATIENT_POSITIONST and PATIENT_POSITIONS

DISC_ENTRY_DEL_LAST_BATCH_TS NULL DATE

The timestamp of the last batch validation on the source location at which multivariate discrepancies for a procedure version were deleted. This is used in patient data replication.