ALUM ADDRESS DETAIL Table
This is a fact table which contains address information of MIT Alumni. Join this table to the ALUM_ADDRESS_TYPE table using the ALUM_ADDRESS_TYPE_KEY field to get the specific types of address for the person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_ADDED_DATE |
XXX |
DATE |
8 |
ADDRESS_MODIFIED_DATE |
XXX |
DATE |
8 |
ADDRESS_SEQUENCE_NUMBER |
XXX |
NUMBER |
22 |
ADDRESS_START_DATE |
XXX |
DATE |
8 |
ADDRESS_STOP_DATE |
XXX |
DATE |
8 |
ALUM_ADDRESS_GEO_KEY |
XXX |
VARCHAR2 |
12 |
ALUM_ADDRESS_TYPE_KEY |
Use this field to join together the ALUM ADDRESS DETAIL and the ALUM ADDRESS TYPE tables. |
VARCHAR2 |
6 |
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 |
BUSINESS_TITLE |
Business title |
VARCHAR2 |
35 |
CARE_OF |
XXX |
VARCHAR2 |
45 |
CITY |
City. |
VARCHAR2 |
35 |
COMPANY_NAME1 |
XXX |
VARCHAR2 |
60 |
COMPANY_NAME2 |
XXX |
VARCHAR2 |
60 |
COUNTRY |
XXX |
VARCHAR2 |
40 |
FAX_AREA_CODE |
Area code of the FAX number. |
VARCHAR2 |
3 |
FAX_NUMBER |
The employee's FAX number. |
VARCHAR2 |
31 |
FOREIGN_CITY_ZIP |
XXX |
VARCHAR2 |
40 |
FOREIGN_FAX |
XXX |
VARCHAR2 |
22 |
FOREIGN_PHONE |
XXX |
VARCHAR2 |
22 |
GEO_CODE |
XXX |
VARCHAR2 |
3 |
IS_PHONE_UNLISTED |
XXX |
VARCHAR2 |
1 |
PHONE_AREA_CODE |
XXX |
VARCHAR2 |
3 |
PHONE_EXTENSION |
XXX |
VARCHAR2 |
5 |
PHONE_MODIFIED_DATE |
XXX |
DATE |
8 |
PHONE_NUMBER |
Phone number of the credit card holder or verifier. |
VARCHAR2 |
8 |
POSTNET_ZIP |
XXX |
VARCHAR2 |
12 |
STATE |
State. |
VARCHAR2 |
30 |
STATE_NAME |
state name |
VARCHAR2 |
40 |
STREET1 |
Street address |
VARCHAR2 |
30 |
STREET2 |
Street address |
VARCHAR2 |
30 |
STREET3 |
Street address |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
ZIP_CODE |
The zip code. |
VARCHAR2 |
10 |
ZIP_SUFFIX |
XXX |
VARCHAR2 |
3 |