Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PRICING ELEMENT Table


Pricing elements codes and descriptions -- used by Tech Review


Field Name

Description

Data Type

Length

PRICING_ELEMENT_CODE

XXX

VARCHAR2

4

PRICING_ELEMENT_DESCRIPTION

XXX

VARCHAR2

20

PRICING_ELEMENT_KEY

Key field used to join to the PRICING_ELEMENT table. This field should only be used for joining data, NOT for reporting

VARCHAR2

10

WAREHOUSE_LOAD_DATE

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

DATE

8