Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP COSTSHARE COMMENT Table


View exposing comment records associated with cost-sharing commitments including narrative notes, approval comments, and administrative documentation used for cost-share tracking and audit trail maintenance.


Field Name

Description

Data Type

Length

COMMENT_TEXT

Comment text associated with the record.

VARCHAR2

4800

COMMENT_TYPE

Comment type associated with the record.

VARCHAR2

200

MIT_AWARD_KEY

Surrogate key identifying the mit award.

VARCHAR2

12

MIT_AWARD_NUMBER

Mit award number associated with the record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE