Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PURCHASING ORG Table


Contains codes and descriptions for all MIT's Purchasing Organizations


Field Name

Description

Data Type

Length

PURCHASING_ORG

Code identifying a Purchasing Organization.

VARCHAR2

3

PURCHASING_ORG_DESCRIPTION

Long name for purchasing organization

VARCHAR2

20

PURCHASING_ORG_KEY

Key identifying a Purchasing Organization. This field should only be used for linking tables together, not for reporting.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE

8