|
| |
Related Links: |
|---|---|
| |
ALUM BIOGRAPHIC Table
Biographic information of MIT Alumni - there is one record per person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUMNI_ID_NUMBER |
Alumni ID Number as generated by the Alumni's Advance System. |
VARCHAR2 |
10 |
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 |
XXX |
VARCHAR2 |
40 |
ALUMNI_STATUS_CHANGE_DATE |
XXX |
DATE |
8 |
ALUM_BIOGRAPHIC_KEY |
XXX |
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 |
MAIL_NAME |
The person's name used for mailing. |
VARCHAR2 |
60 |
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_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 |
