ALUM DISPLAY OPTION Table

ACTIVITY

XXX

NUMBER

1

ALUM_BIOGRAPHIC_KEY

XXX

VARCHAR2

10

BUSINESS_CITY

'1'=to display city in business address, '0'=not to display city in business address.

NUMBER

1

BUSINESS_COUNTRY

'1'=to display country in business address, '0'=not to display country in business address.

NUMBER

1

BUSINESS_FAX

'1'=to display fax number in business address, '0'=not to display fax number in business address.

NUMBER

1

BUSINESS_PHONE

'1'=to display business phone number, '0'=not to display business phone number.

NUMBER

1

BUSINESS_STATE

'1'=to display state in business address, '0'=not to display state in business address.

NUMBER

1

BUSINESS_STREET

'1'=to display street in business address,'0'=not to display street in business address.

NUMBER

1

BUSINESS_TITLE

Business title

VARCHAR2

35

CAREER_FOCUS

XXX

NUMBER

1

COMPANY_NAME

Company name

VARCHAR2

60

DATE_ADDED

XXX

DATE

8

DATE_MODIFIED

XXX

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

XXX

NUMBER

1

HOME_PHONE

The person's home telephone number.

VARCHAR2

20

HOME_STATE

The person's home state.

VARCHAR2

2

HOME_STREET

XXX

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