Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD AMOUNT INFO Table


XXX


Field Name

Description

Data Type

Length

ANTICIPATED_AMOUNT

XXX

NUMBER

12,2

ANTICIPATED_CHANGE

XXX

NUMBER

12,2

COMMENTS

Comments about the graduate appointment

VARCHAR2

300

EFFECTIVE_DATE

In the COST COLLECTOR table: this represents the effective date or starting date of the fund cost collector. In the ASA OFFICER DETAIL table this is the starting date of the tenure of the officer.

DATE

MODIFICATION_EFFECTIVE_DATE

XXX

DATE

MODIFICATION_NUMBER

XXX

VARCHAR2

50

OBLIGATED_AMOUNT

XXX

NUMBER

12,2

OBLIGATED_CHANGE

XXX

NUMBER

12,2

PERFORMANCE_END_DATE

XXX

DATE

PERFORMANCE_START_DATE

XXX

DATE

SUBAWARD_CODE

XXX

VARCHAR2

20

UPDATE_TIMESTAMP

Date that a record was last updated by OSP.

DATE

UPDATE_USER

Userid of the person who last updated this record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE