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 |
1 |
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 |
1 |
BUSINESS_COUNTRY |
Country of the Business address |
NUMBER |
1 |
BUSINESS_FAX |
Business fax |
NUMBER |
1 |
BUSINESS_PHONE |
Business phone number |
NUMBER |
1 |
BUSINESS_STATE |
State of the business address |
NUMBER |
1 |
BUSINESS_STREET |
Stree of the business address |
NUMBER |
1 |
BUSINESS_TITLE |
Business title |
VARCHAR2 |
35 |
CAREER_FOCUS |
XXX |
NUMBER |
1 |
COMPANY_NAME |
Company name |
VARCHAR2 |
60 |
DATE_ADDED |
Date the record was added to the table. |
DATE |
8 |
DATE_MODIFIED |
Date the record in the table was last modified. |
DATE |
8 |
EFL_ADDRESS |
XXX |
NUMBER |
1 |
FORMER_NAME |
The person's former name. |
VARCHAR2 |
60 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_FAX |
Fax number associated with the home address |
NUMBER |
1 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_STREET |
Street of home address |
NUMBER |
1 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MOBILE_PHONE |
XXX |
NUMBER |
1 |
NICKNAME |
XXX |
NUMBER |
1 |
OCCUPATION |
XXX |
NUMBER |
1 |
OPERATOR_NAME |
XXX |
VARCHAR2 |
32 |
PAST_EMPLOYMENT |
XXX |
NUMBER |
1 |
SIC |
XXX |
NUMBER |
1 |
SPORT |
XXX |
NUMBER |
1 |
SPOUSE_NAME |
XXX |
NUMBER |
1 |
STUDENT_ACTIVITY |
XXX |
NUMBER |
1 |
STUDENT_SEARCH |
XXX |
NUMBER |
1 |
USER_GROUP |
XXX |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |