OSP AWARD PAYMENT SCHEDULE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
12,2 |
DUE_DATE |
XXX |
DATE |
|
MIT_AWARD_KEY |
Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
12 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
12 |
PAYMENT_COMMENTS |
XXX |
VARCHAR2 |
50 |
SEQUENCE_NUMBER |
Numerical value identifying the position of this record for the person. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |