Show/Hide Toolbars

Navigation: Data Warehouse Help > Data Warehouse Structure

Categories, Currencies, and Lookup Tables

Scroll Prev Top Next More

Many of the standard object definitions have a category table associated with them - for example, WH_CONTACT_CATEGORIES. These tables are documented together with the other tables related to the object definition.

Similarly, the design categories that are applicable to a specific custom object definition are found in table WH_PROJECT_CATEGORIES, documented with the other Project tables.

The category values that are actually assigned to specific records are found in table WH_CATEGEORIES, shown below. That table "flattens" the category tree structure by providing a single row containing up to 10 levels of nesting for a given category.

WH_CATEGORIES

Column Name

Oracle Data Type

MSSQL Data Type

OBJECT_PRIMARY_KEY

NUMBER

INT

OBJECT_ENTITY_CODE

VARCHAR2(4)

VARCHAR(4)

OBJECT_IS_EMBEDDED

VARCHAR2(5)

VARCHAR(5)

OBJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

CATEGORY_PRIMARY_KEY

NUMBER

INT

CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

CATEGORY_DISPLAY_ORDER

NUMBER)

INT

CATEGORY_TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

CATEGORY_IS_ACTIVE

NUMBER

INT

CATEGORY_FULL_NAME

VARCHAR2(1000)

VARCHAR(1000)

CATEGORY_LEVEL_01

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_02

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_03

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_04

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_05

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_06

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_07

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_08

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_09

VARCHAR2(50)

VARCHAR(50)

CATEGORY_LEVEL_10

VARCHAR2(50)

VARCHAR(50)

WH_CURRENCIES

Column Name

Oracle Data Type

MSSQL Data Type

CURRENCY_CODE

VARCHAR2(3)

VARCHAR(3)

CURRENCY_EXCHANGE_RATE

NUMBER

INT

CURRENCY_NAME

VARCHAR2(50)

VARCHAR(50)

CURRENCY_SYMBOL

VARCHAR2(2)

VARCHAR(2)

LAST_MODIFIED_ON

DATE

DATETIME

WH_LOOKUP_TABLE_ITEMS

Column Name

Oracle Data Type

MSSQL Data Type

TABLE_PRIMARY_KEY

NUMBER

INT

TABLE_NAME

VARCHAR2(50)

VARCHAR(50)

TABLE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

TABLE_VERSION

NUMBER

INT

ITEM_PRIMARY_KEY

NUMBER

INT

ITEM_NAME

VARCHAR2(50)

VARCHAR(50)

ITEM_DISPLAY_ORDER

NUMBER

INT

ITEM_TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

ITEM_IS_ACTIVE

VARCHAR2(10)

VARCHAR(10)

ITEM_PARENT_PRIMARY_KEY

NUMBER

INT

ITEM_NAME_FULL

VARCHAR2(700)

VARCHAR(700)

ITEM_LEVEL_01

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_02

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_03

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_04

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_05

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_06

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_07

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_08

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_09

VARCHAR2(50)

VARCHAR(50)

ITEM_LEVEL_10

VARCHAR2(50)

VARCHAR(50)