OSP AWARD TERMS DETAIL Table
Contains the different OSP award terms and conditions from COEUS. For each award, there are one or multiple award terms and conditions.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
10 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
10 |
OSP_AWARD_TERMS_TYPE_KEY |
Use this field to join the OSP_AWARD_TERMS_DETAIL and the OSP_AWARD_TERMS_TYPE tables for the information of OSP award terms and conditions. |
VARCHAR2 |
6 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
8 |
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |