AA ID CROSSWALK Table
Stores crosswalk mappings between Academic Analytics client identifiers and MIT person identifiers, including source system and name attributes. Each row represents an identifier mapping record.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AA_CLIENT_ID |
Identifier for the Academic Analytics client institution or organization. |
VARCHAR2 |
4 |
FULL_NAME |
Full name of the person associated with the identifier mapping as provided by the source. |
VARCHAR2 |
100 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SOURCE |
Name of the source system or feed providing the identifier mapping. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |