ALUMNI ADDRESS Table
This table contains one record per person (alum). Each record contains the home, business, and email addresses of each person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUMNI_ID_NUMBER |
Alumni ID Number as generated by the Alumni's Advance System. |
VARCHAR2 |
10 |
BUSINESS_TITLE |
Business title |
VARCHAR2 |
35 |
BUS_ADDR_DATE_MODIFIED |
Date when the business address was lasat modified |
DATE |
8 |
BUS_ADDR_PREFER_IND |
XXX |
VARCHAR2 |
1 |
BUS_CITY |
City of the business address |
VARCHAR2 |
30 |
BUS_COUNTRY |
Country of the business address |
VARCHAR2 |
40 |
BUS_FAX_NUMBER |
Business fax number |
VARCHAR2 |
25 |
BUS_FOREIGN_CITY_ZIP |
The city and zip code of a foreign business address |
VARCHAR2 |
40 |
BUS_PHONE_NUMBER |
Business phone number |
VARCHAR2 |
25 |
BUS_STATE_CODE |
State code in business address |
VARCHAR2 |
3 |
BUS_STREET_1 |
Business street address, line 1 |
VARCHAR2 |
40 |
BUS_STREET_2 |
Business street address, line 2 |
VARCHAR2 |
40 |
BUS_STREET_3 |
Business street address, line 3 |
VARCHAR2 |
40 |
BUS_ZIPCODE |
Zip code of business address. |
VARCHAR2 |
10 |
COMPANY_NAME |
Company name |
VARCHAR2 |
60 |
DEATH_DATE |
Date of death. |
VARCHAR2 |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
EMAIL_ADDR_DATE_MODIFIED |
Date the email address in this record was last modified. |
DATE |
8 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
HOME_ADDR_DATE_MODIFIED |
Date when the home address was last modified |
DATE |
8 |
HOME_ADDR_PREFER_IND |
XXX |
VARCHAR2 |
1 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_FAX_NUMBER |
Home fax number |
VARCHAR2 |
25 |
HOME_FOREIGN_CITY_ZIP |
City and zip code for a foreign home address |
VARCHAR2 |
40 |
HOME_PHONE_NUMBER |
Home phone number |
VARCHAR2 |
25 |
HOME_STATE_CODE |
State code of home address. |
VARCHAR2 |
3 |
HOME_STREET_1 |
Line 1 of Street in home address |
VARCHAR2 |
30 |
HOME_STREET_2 |
Line 2 of Street in home address |
VARCHAR2 |
30 |
HOME_STREET_3 |
Line 3 of Street in home address |
VARCHAR2 |
40 |
HOME_ZIPCODE |
Zip Code of home address |
VARCHAR2 |
10 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PREFER_CLASS_YEAR |
The preferred graduating class year of the person. |
VARCHAR2 |
4 |
PREFER_NAME_SORT |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |