Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse CYBERSOURCE MERCHANT HIER Table


View exposing cybersource merchant hier data.


Field Name

Description

Data Type

Length

CYBER_MERCHANT_ID

Business identifier for the cyber merchant.

VARCHAR2

30

CYBER_MERCHANT_KEY

Surrogate key identifying the cyber merchant.

VARCHAR2

30

CYBER_MERCHANT_NAME

Cyber merchant name as provided by the source.

VARCHAR2

255

LEVEL1_ID

Business identifier for the level1.

VARCHAR2

30

LEVEL1_NAME

Level1 name as provided by the source.

VARCHAR2

255

LEVEL2_ID

Business identifier for the level2.

VARCHAR2

30

LEVEL2_NAME

Level2 name as provided by the source.

VARCHAR2

255

LEVEL3_ID

Business identifier for the level3.

VARCHAR2

30

LEVEL3_NAME

Level3 name as provided by the source.

VARCHAR2

255

LEVEL4_ID

Business identifier for the level4.

VARCHAR2

30

LEVEL4_NAME

Level4 name as provided by the source.

VARCHAR2

255

LEVEL5_ID

Business identifier for the level5.

VARCHAR2

30

LEVEL5_NAME

Level5 name as provided by the source.

VARCHAR2

255

LEVEL6_ID

Business identifier for the level6.

VARCHAR2

30

LEVEL6_NAME

Level6 name as provided by the source.

VARCHAR2

255

LEVEL7_ID

Business identifier for the level7.

VARCHAR2

30

LEVEL7_NAME

Level7 name as provided by the source.

VARCHAR2

255

LEVEL8_ID

Business identifier for the level8.

VARCHAR2

30

LEVEL8_NAME

Level8 name as provided by the source.

VARCHAR2

255

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE