ALUM BIOGRAPHIC Table
Biographic information of MIT Alumni - there is one record per person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUMNI_RECORD_ADDED_DATE |
The date when the record was created. |
DATE |
8 |
ALUMNI_RECORD_MODIFIED_DATE |
The date when the record was last modified. |
DATE |
8 |
ALUMNI_STATUS |
Current status of the person in the Alumni record: Active, Deceased, etc. |
VARCHAR2 |
40 |
ALUMNI_STATUS_CHANGE_DATE |
The date when the status of an alum changed. |
DATE |
8 |
ALUM_BIOGRAPHIC_KEY |
Use this field to join together the ALUM_BIOGRAPHIC table to another Alumni fact table with this field to get specific information about a person. |
VARCHAR2 |
10 |
ALUM_ID_NUMBER |
A person identifer in the Alumni's database |
VARCHAR2 |
10 |
CITIZENSHIP |
Citizenship status: International, US Citizen, US Permanent Resident. |
VARCHAR2 |
30 |
DEGREE_COMB_CODE |
The value that indicates which combination of degrees an alum has, i.e. BS and MS or BS and Phd. |
VARCHAR2 |
2 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FORMER_NAME |
The person's former name. |
VARCHAR2 |
60 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LIVING_GROUP_CODE |
XXX |
VARCHAR2 |
5 |
MAJOR_AFFIL_CODE |
Major affiliation code |
VARCHAR2 |
5 |
MARITAL_STATUS |
XXX |
VARCHAR2 |
40 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MINOR_AFFIL_CODE |
Minor affilation code |
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 |
9 |
PERSONAL_SUFFIX |
XXX |
VARCHAR2 |
25 |
PREFER_CLASS_YEAR |
The preferred graduating class year of the person. |
VARCHAR2 |
4 |
PREFER_MAIL_NAME |
XXX |
VARCHAR2 |
60 |
PREFER_SCHOOL |
XXX |
VARCHAR2 |
40 |
PREFIX |
Prefix to a name, e.g. Mr., Mrs, Ms, Prof, Dr. |
VARCHAR2 |
25 |
PROFESSIONAL_SUFFIX |
XXX |
VARCHAR2 |
25 |
SALUTATION |
In HR tables, this field is used for salary review letters only, a person's salutation may appear as Mary, Fred, etc. In ALUMNI tables, this field contains the salutation of the alumnus/alumnae, eg. "The Rev MacCormick", "Dr Smith", "Ms Wood", "Prof Walker", "Mary Jones". |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |