Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Alumni Addresses


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

ALUM_ADDRESS_TYPE

This table contains information about the different address types stored in the ALUM ADDRESS DETAIL table. Some of the Address Types are: Business, Home, Season, Student Term Address, Past Home, Alternate Business, and MIT Employee Campus Address.

Dimension

Alumni Office

SENSITIVE

Weekly

03-JAN-2020

ALUM_ADDRESS_DETAIL

This is a fact table which contains address information of MIT Alumni. Join this table to the ALUM_ADDRESS_TYPE table using the ALUM_ADDRESS_TYPE_KEY field to get the specific types of address for the person.

Fact

Alumni Office

SENSITIVE

Weekly

03-JAN-2020

ALUM_BIOGRAPHIC

Biographic information of MIT Alumni - there is one record per person.

Dimension

Alumni Office

SENSITIVE

Weekly

03-JAN-2020