Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD AMOUNT INFO Table


View exposing subaward amount information including subaward funding amounts, escalation amounts, and budget details used for subcontract financial tracking.


Field Name

Description

Data Type

Length

ANTICIPATED_AMOUNT

Anticipated amount associated with the record.

NUMBER

12,2

ANTICIPATED_CHANGE

Anticipated change associated with the record.

NUMBER

12,2

COMMENTS

Comments associated with the record.

VARCHAR2

300

EFFECTIVE_DATE

Date associated with effective.

DATE

MODIFICATION_EFFECTIVE_DATE

Date associated with modification effective.

DATE

MODIFICATION_NUMBER

Modification number associated with the record.

VARCHAR2

50

OBLIGATED_AMOUNT

Obligated amount associated with the record.

NUMBER

12,2

OBLIGATED_CHANGE

Obligated change associated with the record.

NUMBER

12,2

PERFORMANCE_END_DATE

Date associated with performance end.

DATE

PERFORMANCE_START_DATE

Date associated with performance start.

DATE

SUBAWARD_CODE

Code identifying subaward.

VARCHAR2

20

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE