ALUM DISPLAY OPTION Table
Alumni table with display options (ie. whether to display a field) for specific fields in an alumni record. '1' in the specific field means to display the information, '0' not to display.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY |
XXX |
NUMBER |
|
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_CITY |
City of the business address |
NUMBER |
|
BUSINESS_COUNTRY |
Country of the Business address |
NUMBER |
|
BUSINESS_FAX |
Business fax |
NUMBER |
|
BUSINESS_PHONE |
Business phone number |
NUMBER |
|
BUSINESS_STATE |
State of the business address |
NUMBER |
|
BUSINESS_STREET |
Stree of the business address |
NUMBER |
|
BUSINESS_TITLE |
Business title |
NUMBER |
|
CAREER_FOCUS |
XXX |
NUMBER |
|
COMPANY_NAME |
Company name |
NUMBER |
|
DATE_ADDED |
Date the record was added to the table. |
DATE |
|
DATE_MODIFIED |
Date the record in the table was last modified. |
DATE |
|
EFL_ADDRESS |
XXX |
NUMBER |
|
FORMER_NAME |
The person's former name. |
NUMBER |
|
HOME_CITY |
The person's home city. |
NUMBER |
|
HOME_COUNTRY |
The person's home country. |
NUMBER |
|
HOME_FAX |
Fax number associated with the home address |
NUMBER |
|
HOME_PHONE |
The person's home telephone number. |
NUMBER |
|
HOME_STATE |
The person's home state. |
NUMBER |
|
HOME_STREET |
Street of home address |
NUMBER |
|
MIDDLE_NAME |
The person's middle name (where available). |
NUMBER |
|
MOBILE_PHONE |
XXX |
NUMBER |
|
NICKNAME |
XXX |
NUMBER |
|
OCCUPATION |
XXX |
NUMBER |
|
OPERATOR_NAME |
XXX |
VARCHAR2 |
32 |
PAST_EMPLOYMENT |
XXX |
NUMBER |
|
SIC |
XXX |
NUMBER |
|
SPORT |
XXX |
NUMBER |
|
SPOUSE_NAME |
XXX |
NUMBER |
|
STUDENT_ACTIVITY |
XXX |
NUMBER |
|
STUDENT_SEARCH |
XXX |
NUMBER |
|
USER_GROUP |
XXX |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |