Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PURCHASING GROUP Table


View exposing purchasing group reference records including buyer group identifiers and descriptions used in procurement organization.


Field Name

Description

Data Type

Length

PURCHASING_GROUP

Purchasing group associated with the record.

VARCHAR2

3

PURCHASING_GROUP_DESCRIPTION

Description of purchasing group.

VARCHAR2

18

PURCHASING_GROUP_KEY

Surrogate key identifying the purchasing group.

VARCHAR2

3

PURCHASING_GROUP_PHONE

Purchasing group phone associated with the record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE