Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PURCHASING ORG Table


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


Field Name

Description

Data Type

Length

PURCHASING_ORG

Purchasing org associated with the record.

VARCHAR2

4

PURCHASING_ORG_DESCRIPTION

Description of purchasing org.

VARCHAR2

20

PURCHASING_ORG_KEY

Surrogate key identifying the purchasing org.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE