AA AWARD Table
Stores award and honor information associated with Academic Analytics (AA), including awarding organization details, award names, recipient details, and the year the award was received. Each row represents a single award received record.
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 |