ALUM ADDRESS TYPE Table
This table contains information about the different address types stored in the ALUM ADDRESS DETAIL table. Some of the Address Types are: Business, Home, Season, Student Term Address, Past Home, Alternate Business, and MIT Employee Campus Address.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_STATUS |
XXX |
VARCHAR2 |
40 |
ADDRESS_TYPE |
XXX |
VARCHAR2 |
40 |
ALUM_ADDRESS_TYPE_KEY |
Use this field to join together the ALUM ADDRESS DETAIL and the ALUM ADDRESS TYPE tables. |
VARCHAR2 |
6 |
IS_PREFERRED_ADDRESS |
Flag indicating whether this is the preferred mailing address of the alum: Y, N. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |