AA GRANT Table
Stores grant and funding records associated with Academic Analytics (AA), including agency identifiers, grant identifiers, project details, date ranges, dollar amounts, research indicator, and associated faculty identifiers. Each row represents a single grant record.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
AGENCY_GRANT_ID |
Grant identifier assigned by the granting agency (agency award number). |
VARCHAR2 |
200 |
DOLLARS_PER_YEAR |
Annual funding amount for the grant. |
NUMBER |
|
DURATION_IN_YEARS |
Duration of the grant expressed in years as provided by the source. |
VARCHAR2 |
10 |
END_DATE |
Grant end date as provided by the source, stored as text to preserve original formatting. |
VARCHAR2 |
50 |
FULL_NAME |
Full name of the associated faculty member as represented in Academic Analytics records. |
VARCHAR2 |
128 |
GRANT_AGENCY |
Name of the granting agency or sponsor. |
VARCHAR2 |
60 |
GRANT_ID |
Unique identifier for the grant record within the Academic Analytics system. |
VARCHAR2 |
10 |
GRANT_NAME |
Name or title of the grant or sponsored project. |
VARCHAR2 |
500 |
IS_RESEARCH |
Flag indicating whether the grant is classified as research (Y/N or similar). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
50 |
PI_FULL_NAME |
Full name of the principal investigator (PI) associated with the grant as provided by the source. |
VARCHAR2 |
100 |
START_DATE |
Grant start date as provided by the source, stored as text to preserve original formatting. |
VARCHAR2 |
50 |
TOTAL_DOLLARS |
Total funded amount for the grant across the full grant duration. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |