Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MERCHANT CATEGORY Table


XXX


Field Name

Description

Data Type

Length

IS_ACTIVE_MERCHANT

XXX

VARCHAR2

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

MERCHANT_CATEGORY

The category of the merchant relevant to this particular credit card transaction. Example: Retail Food, Home Supply, General Retail, etc.

VARCHAR2

60

MERCHANT_CATEGORY_CODE

XXX

VARCHAR2

4

MERCHANT_CATEGORY_KEY

XXX

VARCHAR2

4

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE