B Data Management Workbench (DMW) extract data dictionary

Browse field descriptions of the DMW extract data by DMW version.

Note:

The data types listed in this data dictionary reflect the definitions in Oracle Life Sciences Data Hub. When loaded into DMW, the following data type changes are applied:

Table B-1 Data type conversion

Data type	Conversion details
NUMBER	A numeric precision specified in Data Hub (e.g., NUMBER(30)) is not carried over to DMW; instead, the column is displayed as NUMBER only (no precision).
RAW	In DMW, RAW is converted to VARCHAR2.
DATE and TIMESTAMP	In DMW, DATE and TIMESTAMP appear as DATE (DMW default format).

• Oracle DMW 3.4
  Browse field descriptions of the Oracle DMW 3.4 extract data by table.
• Oracle DMW 3.4.2
  Browse field descriptions of the Oracle DMW 3.4.2 extract data by table.
• Oracle DMW 3.5
  Browse field descriptions of the Oracle DMW 3.5 extract data by table.