Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP PROPOSAL TO AWARD MAP Table


XXX


Field Name

Description

Data Type

Length

MIT_AWARD_KEY

Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting.

VARCHAR2

10

OSP_PROPOSAL_KEY

XXX

VARCHAR2

8

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

WAREHOUSE_LOAD_DATE

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

DATE

8