ALUM BIOGRAPHIC Table
View exposing alumni biographic attributes including personal and demographic information used for constituent reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUMNI_RECORD_ADDED_DATE |
Date associated with alumni record added. |
DATE |
|
ALUMNI_RECORD_MODIFIED_DATE |
Date associated with alumni record modified. |
DATE |
|
ALUMNI_STATUS |
Alumni status as provided by the source. |
VARCHAR2 |
40 |
ALUMNI_STATUS_CHANGE_DATE |
Date associated with alumni status change. |
DATE |
|
ALUM_BIOGRAPHIC_KEY |
Surrogate key identifying the alum biographic. |
VARCHAR2 |
10 |
ALUM_ID_NUMBER |
Alum id number as provided by the source. |
VARCHAR2 |
10 |
CITIZENSHIP |
Citizenship as provided by the source. |
VARCHAR2 |
40 |
DEGREE_COMB_CODE |
Code identifying degree comb. |
VARCHAR2 |
2 |
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
320 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
25 |
FORMER_NAME |
Former name as provided by the source. |
VARCHAR2 |
60 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
78 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
1 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
25 |
LIVING_GROUP_CODE |
Code identifying living group. |
VARCHAR2 |
5 |
MAJOR_AFFIL_CODE |
Code identifying major affil. |
VARCHAR2 |
5 |
MARITAL_STATUS |
Marital status as provided by the source. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name as provided by the source. |
VARCHAR2 |
25 |
MINOR_AFFIL_CODE |
Code identifying minor affil. |
VARCHAR2 |
5 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
20 |
PERSONAL_SUFFIX |
Personal suffix as provided by the source. |
VARCHAR2 |
25 |
PREFER_CLASS_YEAR |
Prefer class year as provided by the source. |
VARCHAR2 |
4 |
PREFER_MAIL_NAME |
Prefer mail name as provided by the source. |
VARCHAR2 |
60 |
PREFER_SCHOOL |
Prefer school as provided by the source. |
VARCHAR2 |
40 |
PREFIX |
Prefix as provided by the source. |
VARCHAR2 |
25 |
PROFESSIONAL_SUFFIX |
Professional suffix as provided by the source. |
VARCHAR2 |
25 |
SALUTATION |
Salutation as provided by the source. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |