Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP AWARD PAYMENT SCHEDULE Table


View exposing planned payment schedules for sponsored awards including scheduled receipt dates, planned payment amounts, disbursement milestones, payment conditions, and payment contingencies used for cash flow management and budget forecasting.


Field Name

Description

Data Type

Length

AMOUNT

Amount associated with the record.

NUMBER

12,2

DUE_DATE

Date associated with due.

DATE

MIT_AWARD_KEY

Surrogate key identifying the mit award.

VARCHAR2

12

MIT_AWARD_NUMBER

Mit award number associated with the record.

VARCHAR2

12

PAYMENT_COMMENTS

Payment comments associated with the record.

VARCHAR2

50

SEQUENCE_NUMBER

Sequence number associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE