AA AWARD Table
View exposing academic awards and honors associated with MIT faculty, including governing societies, award details, award year, recipient attributes, and faculty linkage identifiers used for scholarly recognition reporting and research analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AA_AWARD_ID |
Identifier for the award within the Academic Analytics system. |
VARCHAR2 |
6 |
AA_AWARD_NAME |
Name of the award or honor. |
VARCHAR2 |
255 |
AA_AWARD_RECEIVED_AWARD_YEAR |
Four-digit year in which the award was received. |
VARCHAR2 |
4 |
AA_AWARD_RECEIVED_ID |
Unique identifier for the award received record within the Academic Analytics system. Primary key for the table. |
VARCHAR2 |
10 |
AA_AWARD_RECEIVED_NAME |
Name of the award received record as provided by the source (may duplicate award name or include additional qualifiers). |
VARCHAR2 |
128 |
AA_CLIENT_ID |
Identifier for the Academic Analytics client institution or organization. |
VARCHAR2 |
10 |
AA_FACULTY_ID |
Unique identifier for the faculty member within the Academic Analytics system. |
VARCHAR2 |
40 |
AWARD_GOVERNING_SOCIETY_ID |
Identifier for the governing society or organization associated with the award in the source data. |
VARCHAR2 |
5 |
AWARD_GOVERNING_SOCIETY_NAME |
Name of the governing society or organization associated with the award. |
VARCHAR2 |
1024 |
FULL_NAME |
Full name of the associated faculty member or award recipient as represented in Academic Analytics records. |
VARCHAR2 |
128 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |