Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM DISPLAY OPTION Table


View exposing display preference options associated with alumni constituent records.


Field Name

Description

Data Type

Length

ACTIVITY

Activity as provided by the source.

NUMBER

ALUM_BIOGRAPHIC_KEY

Surrogate key identifying the alum biographic.

VARCHAR2

10

BUSINESS_CITY

Business city as provided by the source.

NUMBER

BUSINESS_COUNTRY

Business country as provided by the source.

NUMBER

BUSINESS_FAX

Business fax as provided by the source.

NUMBER

BUSINESS_PHONE

Business phone as provided by the source.

NUMBER

BUSINESS_STATE

Business state as provided by the source.

NUMBER

BUSINESS_STREET

Business street as provided by the source.

NUMBER

BUSINESS_TITLE

Business title as provided by the source.

NUMBER

CAREER_FOCUS

Career focus as provided by the source.

NUMBER

COMPANY_NAME

Company name as provided by the source.

NUMBER

DATE_ADDED

Date added as provided by the source.

DATE

DATE_MODIFIED

Date modified as provided by the source.

DATE

EFL_ADDRESS

Efl address as provided by the source.

NUMBER

FORMER_NAME

Former name as provided by the source.

NUMBER

HOME_CITY

Home city as provided by the source.

NUMBER

HOME_COUNTRY

Home country as provided by the source.

NUMBER

HOME_FAX

Home fax as provided by the source.

NUMBER

HOME_PHONE

Home phone as provided by the source.

NUMBER

HOME_STATE

Home state as provided by the source.

NUMBER

HOME_STREET

Home street as provided by the source.

NUMBER

MIDDLE_NAME

Middle name as provided by the source.

NUMBER

MOBILE_PHONE

Mobile phone as provided by the source.

NUMBER

NICKNAME

Nickname as provided by the source.

NUMBER

OCCUPATION

Occupation as provided by the source.

NUMBER

OPERATOR_NAME

Operator name as provided by the source.

VARCHAR2

32

PAST_EMPLOYMENT

Past employment as provided by the source.

NUMBER

SIC

Sic as provided by the source.

NUMBER

SPORT

Sport as provided by the source.

NUMBER

SPOUSE_NAME

Spouse name as provided by the source.

NUMBER

STUDENT_ACTIVITY

Student activity as provided by the source.

NUMBER

STUDENT_SEARCH

Student search as provided by the source.

NUMBER

USER_GROUP

User group as provided by the source.

VARCHAR2

2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE