ALUMNI ADDRESS Table
View exposing alumni address records including mailing address attributes associated with alumni constituents.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUMNI_ID_NUMBER |
Alumni id number as provided by the source. |
VARCHAR2 |
10 |
BUSINESS_TITLE |
Business title as provided by the source. |
VARCHAR2 |
60 |
BUS_ADDR_DATE_MODIFIED |
Bus addr date modified as provided by the source. |
DATE |
|
BUS_ADDR_PREFER_IND |
Bus addr prefer ind as provided by the source. |
VARCHAR2 |
1 |
BUS_CITY |
Bus city as provided by the source. |
VARCHAR2 |
50 |
BUS_COUNTRY |
Bus country as provided by the source. |
VARCHAR2 |
40 |
BUS_FAX_NUMBER |
Bus fax number as provided by the source. |
VARCHAR2 |
22 |
BUS_FOREIGN_CITY_ZIP |
Bus foreign city zip as provided by the source. |
VARCHAR2 |
75 |
BUS_PHONE_NUMBER |
Bus phone number as provided by the source. |
VARCHAR2 |
32 |
BUS_STATE_CODE |
Code identifying bus state. |
VARCHAR2 |
3 |
BUS_STREET_1 |
Bus street 1 as provided by the source. |
VARCHAR2 |
75 |
BUS_STREET_2 |
Bus street 2 as provided by the source. |
VARCHAR2 |
75 |
BUS_STREET_3 |
Bus street 3 as provided by the source. |
VARCHAR2 |
75 |
BUS_ZIPCODE |
Bus zipcode as provided by the source. |
VARCHAR2 |
30 |
COMPANY_NAME |
Company name as provided by the source. |
VARCHAR2 |
60 |
DEATH_DATE |
Date associated with death. |
VARCHAR2 |
8 |
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
320 |
EMAIL_ADDR_DATE_MODIFIED |
Email addr date modified as provided by the source. |
DATE |
|
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
25 |
HOME_ADDR_DATE_MODIFIED |
Home addr date modified as provided by the source. |
DATE |
|
HOME_ADDR_PREFER_IND |
Home addr prefer ind as provided by the source. |
VARCHAR2 |
1 |
HOME_CITY |
Home city as provided by the source. |
VARCHAR2 |
50 |
HOME_COUNTRY |
Home country as provided by the source. |
VARCHAR2 |
40 |
HOME_FAX_NUMBER |
Home fax number as provided by the source. |
VARCHAR2 |
22 |
HOME_FOREIGN_CITY_ZIP |
Home foreign city zip as provided by the source. |
VARCHAR2 |
75 |
HOME_PHONE_NUMBER |
Home phone number as provided by the source. |
VARCHAR2 |
32 |
HOME_STATE_CODE |
Code identifying home state. |
VARCHAR2 |
3 |
HOME_STREET_1 |
Home street 1 as provided by the source. |
VARCHAR2 |
75 |
HOME_STREET_2 |
Home street 2 as provided by the source. |
VARCHAR2 |
75 |
HOME_STREET_3 |
Home street 3 as provided by the source. |
VARCHAR2 |
75 |
HOME_ZIPCODE |
Home zipcode as provided by the source. |
VARCHAR2 |
30 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
25 |
MIDDLE_NAME |
Middle name as provided by the source. |
VARCHAR2 |
25 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
20 |
PREFER_CLASS_YEAR |
Prefer class year as provided by the source. |
VARCHAR2 |
4 |
PREFER_NAME_SORT |
Prefer name sort as provided by the source. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |