Data Warehouse

ADVISOR1

Advisor1 associated with the record.

VARCHAR2

100

ADVISOR2

Advisor2 associated with the record.

VARCHAR2

100

ADVISOR3

Advisor3 associated with the record.

VARCHAR2

100

AGE

Age associated with the record.

NUMBER

CITIZENSHIP_INDICATOR

Indicator identifying whether citizenship (Y/N).

VARCHAR2

21

DATE_OF_BIRTH

Date of birth associated with the person.

DATE

DEPARTMENT

Department associated with the record.

VARCHAR2

6

DEPARTMENT_NAME

Department name associated with the record.

VARCHAR2

30

EC1_CITY

Ec1 city associated with the record.

VARCHAR2

40

EC1_EMAIL_ADDRESS

Ec1 email address associated with the record.

VARCHAR2

120

EC1_FULL_NAME

Ec1 full name associated with the record.

VARCHAR2

88

EC1_INTL_PHONE1

Ec1 intl phone1 associated with the record.

VARCHAR2

72

EC1_INTL_PHONE2

Ec1 intl phone2 associated with the record.

VARCHAR2

52

EC1_NATION

Ec1 nation associated with the record.

VARCHAR2

10

EC1_PHONE1

Ec1 phone1 associated with the record.

VARCHAR2

20

EC1_PHONE2

Ec1 phone2 associated with the record.

VARCHAR2

20

EC1_RELATIONSHIP

Ec1 relationship associated with the record.

VARCHAR2

5

EC1_STATE

Ec1 state associated with the record.

VARCHAR2

5

EC1_STREET1

Ec1 street1 associated with the record.

VARCHAR2

60

EC1_STREET2

Ec1 street2 associated with the record.

VARCHAR2

60

EC1_STREET3

Ec1 street3 associated with the record.

VARCHAR2

60

EC1_ZIP

Ec1 zip associated with the record.

VARCHAR2

10

EC2_CITY

Ec2 city associated with the record.

VARCHAR2

40

EC2_EMAIL_ADDRESS

Ec2 email address associated with the record.

VARCHAR2

120

EC2_FULL_NAME

Ec2 full name associated with the record.

VARCHAR2

88

EC2_INTL_PHONE1

Ec2 intl phone1 associated with the record.

VARCHAR2

72

EC2_INTL_PHONE2

Ec2 intl phone2 associated with the record.

VARCHAR2

52

EC2_NATION

Ec2 nation associated with the record.

VARCHAR2

5

EC2_PHONE1

Ec2 phone1 associated with the record.

VARCHAR2

20

EC2_PHONE2

Ec2 phone2 associated with the record.

VARCHAR2

20

EC2_RELATIONSHIP

Ec2 relationship associated with the record.

VARCHAR2

60

EC2_STATE

Ec2 state associated with the record.

VARCHAR2

2

EC2_STREET1

Ec2 street1 associated with the record.

VARCHAR2

60

EC2_STREET2

Ec2 street2 associated with the record.

VARCHAR2

60

EC2_STREET3

Ec2 street3 associated with the record.

VARCHAR2

60

EC2_ZIP

Ec2 zip associated with the record.

VARCHAR2

10

EMAIL_ADDRESS

Email address associated with the record.

VARCHAR2

60

ENROLLMENT_STATUS

Enrollment status associated with the record.

VARCHAR2

50

FULL_NAME

Full name associated with the person or organization.

VARCHAR2

93

GENDER

Gender associated with the record.

VARCHAR2

100

HOME_ADDRESS1

Home address1 associated with the record.

VARCHAR2

60

HOME_ADDRESS2

Home address2 associated with the record.

VARCHAR2

60

HOME_CITY

Home city associated with the record.

VARCHAR2

80

HOME_COUNTRY

Home country associated with the record.

VARCHAR2

100

HOME_PHONE

Home phone associated with the record.

VARCHAR2

12

HOME_STATE

Home state associated with the record.

VARCHAR2

2

HOME_ZIP_CODE

Home zip code associated with the record.

VARCHAR2

9

IS_BIRTHDATE_CONFIDENTIAL

Indicator identifying whether birthdate confidential (Y/N).

VARCHAR2

1

IS_DATES_ATTND_CONFIDENTIAL

Indicator identifying whether dates attnd confidential (Y/N).

VARCHAR2

1

IS_EMAIL_CONFIDENTIAL

Is email confidential associated with the record.

VARCHAR2

1

IS_HOME_ADDR_CONFIDENTIAL

Indicator identifying whether home addr confidential (Y/N).

VARCHAR2

1

IS_REGISTERED

Indicator identifying whether registered (Y/N).

VARCHAR2

1

IS_SERIOUS_CONFIDENTIAL

Indicator identifying whether serious confidential (Y/N).

VARCHAR2

1

IS_TERM_ADDR_CONFIDENTIAL

Indicator identifying whether term addr confidential (Y/N).

VARCHAR2

1

IS_YEAR_CONFIDENTIAL

Indicator identifying whether year confidential (Y/N).

VARCHAR2

1

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

MP1_ACTIVITY_DATE

Date associated with mp1 activity.

DATE

MP1_ATYP_CODE

Code identifying mp1 atyp.

VARCHAR2

2

MP1_CITY

Mp1 city associated with the record.

VARCHAR2

20

MP1_EMAIL_ADDRESS_P1

Mp1 email address p1 associated with the record.

VARCHAR2

60

MP1_FIRST_NAME

Mp1 first name associated with the record.

VARCHAR2

15

MP1_LAST_NAME

Mp1 last name associated with the record.

VARCHAR2

25

MP1_MI

Mp1 mi associated with the record.

VARCHAR2

1

MP1_NATN_CODE

Code identifying mp1 natn.

VARCHAR2

5

MP1_PHONE_AREA

Mp1 phone area associated with the record.

VARCHAR2

3

MP1_PHONE_AREA_2

Mp1 phone area 2 associated with the record.

VARCHAR2

3

MP1_PHONE_EXT

Mp1 phone ext associated with the record.

VARCHAR2

4

MP1_PHONE_EXT2

Mp1 phone ext2 associated with the record.

VARCHAR2

4

MP1_PHONE_INTL1

Mp1 phone intl1 associated with the record.

VARCHAR2

36

MP1_PHONE_INTL2_P1

Mp1 phone intl2 p1 associated with the record.

VARCHAR2

36

MP1_PHONE_NUMBER

Mp1 phone number associated with the record.

VARCHAR2

7

MP1_PHONE_NUMBER2

Mp1 phone number2 associated with the record.

VARCHAR2

7

MP1_PRIORITY

Mp1 priority associated with the record.

VARCHAR2

1

MP1_RELT_CODE

Code identifying mp1 relt.

VARCHAR2

1

MP1_STAT_CODE

Code identifying mp1 stat.

VARCHAR2

2

MP1_STREET_LINE1

Mp1 street line1 associated with the record.

VARCHAR2

30

MP1_STREET_LINE2

Mp1 street line2 associated with the record.

VARCHAR2

30

MP1_STREET_LINE3

Mp1 street line3 associated with the record.

VARCHAR2

30

MP1_ZIP

Mp1 zip associated with the record.

VARCHAR2

10

MP2_ACTIVITY_DATE

Date associated with mp2 activity.

DATE

MP2_ATYP_CODE

Code identifying mp2 atyp.

VARCHAR2

2

MP2_CITY

Mp2 city associated with the record.

VARCHAR2

20

MP2_EMAIL_ADDRESS

Mp2 email address associated with the record.

VARCHAR2

60

MP2_FIRST_NAME

Mp2 first name associated with the record.

VARCHAR2

15

MP2_LAST_NAME

Mp2 last name associated with the record.

VARCHAR2

25

MP2_MI

Mp2 mi associated with the record.

VARCHAR2

1

MP2_NATN_CODE

Code identifying mp2 natn.

VARCHAR2

5

MP2_PHONE_AREA

Mp2 phone area associated with the record.

VARCHAR2

3

MP2_PHONE_AREA_2

Mp2 phone area 2 associated with the record.

VARCHAR2

3

MP2_PHONE_EXT

Mp2 phone ext associated with the record.

VARCHAR2

4

MP2_PHONE_EXT2

Mp2 phone ext2 associated with the record.

VARCHAR2

4

MP2_PHONE_INTL1

Mp2 phone intl1 associated with the record.

VARCHAR2

36

MP2_PHONE_INTL2

Mp2 phone intl2 associated with the record.

VARCHAR2

36

MP2_PHONE_NUMBER

Mp2 phone number associated with the record.

VARCHAR2

7

MP2_PHONE_NUMBER2

Mp2 phone number2 associated with the record.

VARCHAR2

7

MP2_PRIORITY

Mp2 priority associated with the record.

VARCHAR2

1

MP2_RELT_CODE

Code identifying mp2 relt.

VARCHAR2

1

MP2_STAT_CODE

Code identifying mp2 stat.

VARCHAR2

2

MP2_STREET_LINE1

Mp2 street line1 associated with the record.

VARCHAR2

30

MP2_STREET_LINE2

Mp2 street line2 associated with the record.

VARCHAR2

30

MP2_STREET_LINE3

Mp2 street line3 associated with the record.

VARCHAR2

30

MP2_ZIP

Mp2 zip associated with the record.

VARCHAR2

10

PRONOUNS

Pronouns associated with the record.

VARCHAR2

100

STUDENT_RELIGIOUS_TRADITION

Student religious tradition associated with the record.

VARCHAR2

50

STUDENT_YEAR

Student year associated with the record.

VARCHAR2

1

TERM_ADDR_CATEGORY

Term addr category associated with the record.

VARCHAR2

3

TERM_CITY

Term city associated with the record.

VARCHAR2

80

TERM_PHONE1

Term phone1 associated with the record.

VARCHAR2

12

TERM_PHONE2

Term phone2 associated with the record.

VARCHAR2

1

TERM_STATE

Term state associated with the record.

VARCHAR2

2

TERM_STREET1

Term street1 associated with the record.

VARCHAR2

60

TERM_STREET2

Term street2 associated with the record.

VARCHAR2

60

TERM_STREET3

Term street3 associated with the record.

VARCHAR2

60

TERM_ZIP_CODE

Term zip code associated with the record.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WITHDRAW_DATE

Date associated with withdraw.

DATE

WITHDRAW_REASON

Withdraw reason associated with the record.

VARCHAR2

21