Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP PROPOSAL STATUS Table


View exposing proposal status reference and tracking records including submitted, under review, awarded, declined status indicators used for proposal lifecycle tracking.


Field Name

Description

Data Type

Length

OSP_PROPOSAL_STATUS

Osp proposal status associated with the record.

VARCHAR2

200

OSP_PROPOSAL_STATUS_CODE

Code identifying osp proposal status.

NUMBER

OSP_PROPOSAL_STATUS_KEY

Surrogate key identifying the osp proposal status.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE