		Home About IS&T Contact IS&T Site Map	Search Advanced Search

	Related Links:
	Data and Reporting Services

ALUM ADDRESS DETAIL Table

This is a fact table which contains address information of MIT Alumni.

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	XXX	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	XXX	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


		Home \| Getting Started \| Getting Services \| Getting Help \| About IS&T \| Accessibility Ask a technology question or send a comment about this web page.