OSP ACTIVE AWARDS Table
View exposing active OSP award personnel detail including award, sponsor, prime sponsor, role, effort, award status and type, project account, title, lead-unit, and principal-investigator attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR_EFFORT |
Academic year effort associated with the record. |
NUMBER |
5,2 |
ACCOUNT_NUMBER |
Account number associated with the record. |
VARCHAR2 |
7 |
ANT_DISTRIBUTABLE_AMOUNT |
Ant distributable amount associated with the record. |
NUMBER |
12,2 |
ANT_TOTAL_AMOUNT |
Ant total amount associated with the record. |
NUMBER |
12,2 |
AWARD_EFFECTIVE_DATE |
Date associated with award effective. |
DATE |
|
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
100 |
AWARD_STATUS_CODE |
Code identifying award status. |
VARCHAR2 |
12 |
AWARD_TYPE |
Award type associated with the record. |
VARCHAR2 |
100 |
AWARD_TYPE_CODE |
Code identifying award type. |
VARCHAR2 |
12 |
CALENDAR_YEAR_EFFORT |
Calendar year effort associated with the record. |
NUMBER |
5,2 |
FACULTY_FLAG |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
FINAL_EXPIRATION_DATE |
Date associated with final expiration. |
DATE |
|
HOME_UNIT |
Home unit associated with the record. |
VARCHAR2 |
8 |
HOME_UNIT_NAME |
Home unit name associated with the record. |
VARCHAR2 |
60 |
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
12 |
OBLI_DISTRIBUTABLE_AMOUNT |
Obli distributable amount associated with the record. |
NUMBER |
12,2 |
OBLI_TOTAL_AMOUNT |
Obli total amount associated with the record. |
NUMBER |
12,2 |
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
PERSON_NAME |
Person name associated with the record. |
VARCHAR2 |
90 |
PERSON_PROJECT_ROLE |
Person project role associated with the record. |
VARCHAR2 |
60 |
PERSON_ROLE |
Person role associated with the record. |
VARCHAR2 |
12 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_COUNTRY_CODE |
Code identifying prime sponsor country. |
VARCHAR2 |
3 |
PRIME_SPONSOR_COUNTRY_NAME |
Prime sponsor country name associated with the record. |
VARCHAR2 |
255 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
60 |
PRIME_SPONSOR_TYPE |
Prime sponsor type associated with the record. |
VARCHAR2 |
100 |
SPONSOR_AWARD_NUMBER |
Sponsor award number associated with the record. |
VARCHAR2 |
70 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_COUNTRY_CODE |
Code identifying sponsor country. |
VARCHAR2 |
3 |
SPONSOR_COUNTRY_NAME |
Sponsor country name associated with the record. |
VARCHAR2 |
255 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
100 |
SUMMER_EFFORT |
Summer effort associated with the record. |
NUMBER |
5,2 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
TOTAL_EFFORT |
Total effort associated with the record. |
NUMBER |
5,2 |
USER_NAME |
User name associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_INSERT_TIMESTAMP |
Timestamp associated with warehouse insert. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |