ALUM ADDRESS DETAIL Table
View exposing detailed address attributes associated with alumni constituents including mailing and location information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_ADDED_DATE |
Date associated with address added. |
DATE |
|
ADDRESS_MODIFIED_DATE |
Date associated with address modified. |
DATE |
|
ADDRESS_SEQUENCE_NUMBER |
Address sequence number as provided by the source. |
NUMBER |
|
ADDRESS_START_DATE |
Date associated with address start. |
DATE |
|
ADDRESS_STOP_DATE |
Date associated with address stop. |
DATE |
|
ALUM_ADDRESS_GEO_KEY |
Surrogate key identifying the alum address geo. |
VARCHAR2 |
16 |
ALUM_ADDRESS_TYPE_KEY |
Surrogate key identifying the alum address type. |
VARCHAR2 |
4 |
ALUM_BIOGRAPHIC_KEY |
Surrogate key identifying the alum biographic. |
VARCHAR2 |
10 |
BUSINESS_TITLE |
Business title as provided by the source. |
VARCHAR2 |
60 |
CARE_OF |
Care of as provided by the source. |
VARCHAR2 |
45 |
CITY |
City as provided by the source. |
VARCHAR2 |
50 |
COMPANY_NAME1 |
Company name1 as provided by the source. |
VARCHAR2 |
60 |
COMPANY_NAME2 |
Company name2 as provided by the source. |
VARCHAR2 |
60 |
COUNTRY |
Country as provided by the source. |
VARCHAR2 |
40 |
FAX_AREA_CODE |
Code identifying fax area. |
VARCHAR2 |
3 |
FAX_NUMBER |
Fax number as provided by the source. |
VARCHAR2 |
22 |
FOREIGN_CITY_ZIP |
Foreign city zip as provided by the source. |
VARCHAR2 |
75 |
FOREIGN_FAX |
Foreign fax as provided by the source. |
VARCHAR2 |
22 |
FOREIGN_PHONE |
Foreign phone as provided by the source. |
VARCHAR2 |
22 |
GEO_CODE |
Code identifying geo. |
VARCHAR2 |
5 |
IS_PHONE_UNLISTED |
Indicator identifying whether phone unlisted (Y/N). |
VARCHAR2 |
1 |
PHONE_AREA_CODE |
Code identifying phone area. |
VARCHAR2 |
3 |
PHONE_EXTENSION |
Phone extension as provided by the source. |
VARCHAR2 |
10 |
PHONE_MODIFIED_DATE |
Date associated with phone modified. |
DATE |
|
PHONE_NUMBER |
Phone number as provided by the source. |
VARCHAR2 |
22 |
POSTNET_ZIP |
Postnet zip as provided by the source. |
VARCHAR2 |
12 |
STATE |
State as provided by the source. |
VARCHAR2 |
3 |
STATE_NAME |
State name as provided by the source. |
VARCHAR2 |
40 |
STREET1 |
Street1 as provided by the source. |
VARCHAR2 |
75 |
STREET2 |
Street2 as provided by the source. |
VARCHAR2 |
75 |
STREET3 |
Street3 as provided by the source. |
VARCHAR2 |
75 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
ZIP_CODE |
Code identifying zip. |
VARCHAR2 |
30 |
ZIP_SUFFIX |
Zip suffix as provided by the source. |
VARCHAR2 |
3 |