Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PRICING ELEMENT Table


View exposing pricing element reference records including pricing conditions and calculation components used in procurement processes.


Field Name

Description

Data Type

Length

PRICING_ELEMENT_CODE

Code identifying pricing element.

VARCHAR2

4

PRICING_ELEMENT_DESCRIPTION

Description of pricing element.

VARCHAR2

20

PRICING_ELEMENT_KEY

Surrogate key identifying the pricing element.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE