Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse AA ID CROSSWALK Table


View exposing identity crosswalk mappings between Academic Analytics client identifiers and MIT identity records, enabling integration of scholarly activity data with institutional MIT person identifiers.


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