Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD AMT RELEASED Table


View exposing released subaward amount records including disbursement history, payment dates, and payment amounts used for subaward cash management.


Field Name

Description

Data Type

Length

AMOUNT_RELEASED

Amount released associated with the record.

NUMBER

12,2

APPROVAL_COMMENTS

Approval comments associated with the record.

VARCHAR2

2000

APPROVAL_DATE

Date associated with approval.

DATE

APPROVED_BY_USER

Approved by user associated with the record.

VARCHAR2

8

COMMENTS

Comments associated with the record.

VARCHAR2

300

CREATED_BY

Created by associated with the record.

VARCHAR2

60

CREATED_DATE

Date associated with created.

DATE

EFFECTIVE_DATE

Date associated with effective.

DATE

END_DATE

Date associated with end.

DATE

INVOICE_NUMBER

Invoice number associated with the record.

VARCHAR2

50

START_DATE

Date associated with 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