MIT IS&T - MIT Data Warehouse

ALUMNI BY COURSE Table

This table contains MIT Alumni's biographic, degree, address, and employment data. Access to records in this table is granted according to the course(s) of major of the Alumni. There is one record per person in this table.

Field Name	Description	Data Type	Length
ALLOW_STUDENT_SEARCH	XXX	VARCHAR2	1
ALUMNI_ID_NUMBER	Alumni ID Number as generated by the Alumni's Advance System.	VARCHAR2	10
BUSINESS_TITLE	Business title	VARCHAR2	35
BUS_ADDR_DATE_MODIFIED	Date when the business address was lasat modified	DATE	8
BUS_ADDR_PREF_IND	Flag indicates whether busines address is the preferred address: Y, N	VARCHAR2	1
BUS_CITY	City of the business address	VARCHAR2	30
BUS_COUNTRY	Country of the business address	VARCHAR2	40
BUS_FAX_NUMBER	Business fax number	VARCHAR2	25
BUS_FOREIGN_CITY_ZIP	The city and zip code of a foreign business address	VARCHAR2	40
BUS_GEO_CODE	Geographic code for business address	VARCHAR2	5
BUS_PHONE_NUMBER	Business phone number	VARCHAR2	25
BUS_STATE	State of the business address	VARCHAR2	3
BUS_STREET1	Business address	VARCHAR2	40
BUS_STREET2	Business address	VARCHAR2	40
BUS_STREET3	Business address	VARCHAR2	40
BUS_ZIP_CODE	Zip code of the business address	VARCHAR2	10
COMPANY_NAME	Company name	VARCHAR2	60
DEGREE_CODE1	Degree code (Primary)	VARCHAR2	5
DEGREE_CODE2	Degree code (second degree).	VARCHAR2	5
DEGREE_CODE3	Degree code (third degree).	VARCHAR2	5
DEGREE_CODE4	Degree code (fourth degree).	VARCHAR2	5
DEGREE_CODE5	Degree code (fifth degree).	VARCHAR2	5
DEGREE_COMB_CODE	The value that indicates which combination of degrees an alum has, i.e. BS and MS or BS and Phd.	VARCHAR2	2
DEGREE_YEAR1	Degree year (Primary)	VARCHAR2	4
DEGREE_YEAR2	Degree year (for the second degree)	VARCHAR2	4
DEGREE_YEAR3	Degree year (for the third degree)	VARCHAR2	4
DEGREE_YEAR4	Degree year (for the fourth degree)	VARCHAR2	4
DEGREE_YEAR5	Degree year (for the fifth degree)	VARCHAR2	4
DEPT1	Department 1 (Primary)	VARCHAR2	7
DEPT2	Department 2	VARCHAR2	7
DEPT3	Department 3	VARCHAR2	7
DEPT4	Department 4	VARCHAR2	7
DEPT5	Department 5	VARCHAR2	4
EMAIL_ADDRESS	A person's complete electronic mail address including user name and node name, for example, username@school.edu.	VARCHAR2	60
EMAIL_DATE_MODIFIED	XXX	DATE	7
FIRST_NAME	The person's first name.	VARCHAR2	30
FORMER_NAME	The person's former name.	VARCHAR2	60
HOME_ADDR_DATE_MODIFIED	Date when the home address was last modified	DATE	8
HOME_ADDR_PREF_IND	Flag indicates whether home address is the preferred address: Y, N	VARCHAR2	1
HOME_CITY	The person's home city.	VARCHAR2	30
HOME_COUNTRY	The person's home country.	VARCHAR2	30
HOME_FAX_NUMBER	Home fax number	VARCHAR2	25
HOME_FOREIGN_CITY_ZIP	City and zip code for a foreign home address	VARCHAR2	40
HOME_GEO_CODE	Geographic code for home address	VARCHAR2	5
HOME_PHONE_NUMBER	Home phone number	VARCHAR2	25
HOME_STATE	The person's home state.	VARCHAR2	2
HOME_STREET1	Home address	VARCHAR2	40
HOME_STREET2	Home address	VARCHAR2	40
HOME_STREET3	Home address	VARCHAR2	40
HOME_ZIP_CODE	The person's home zip code.	VARCHAR2	9
LAST_NAME	The person's last name.	VARCHAR2	30
LIVING_GROUP	Living group	VARCHAR2	5
MAIL_NAME	The person's name used for mailing.	VARCHAR2	60
MAJOR1	Course of major (Primary)	VARCHAR2	6
MAJOR2	Course of major 2	VARCHAR2	6
MAJOR3	Course of major 3	VARCHAR2	6
MAJOR4	Course of major 4	VARCHAR2	6
MAJOR5	Course of major 5	VARCHAR2	6
MAJOR_AFFIL_CODE	Major affiliation code	VARCHAR2	5
MIDDLE_NAME	The person's middle name (where available).	VARCHAR2	30
MINOR_AFFIL_CODE	Minor affilation code	VARCHAR2	5
MIT_ID	MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.	VARCHAR2	9
MIT_OCCUPATION_CODE1	MIT Occupation Code 1	VARCHAR2	5
MIT_OCCUPATION_CODE2	MIT Occupation Code 2	VARCHAR2	5
MIT_OCCUPATION_CODE3	MIT Occupation Code 3	VARCHAR2	5
MIT_OCCUPATION_CODE4	MIT Occupation Code 4	VARCHAR2	5
MIT_OCCUPATION_DESC1	Description of the MIT Occupation Code 1	VARCHAR2	150
MIT_OCCUPATION_DESC2	Description of the MIT Occupation Code 2	VARCHAR2	150
MIT_OCCUPATION_DESC3	Description of the MIT Occupation Code 3	VARCHAR2	150
MIT_OCCUPATION_DESC4	Description of the MIT Occupation Code 4	VARCHAR2	150
MIT_SIC_CODE1	MIT Standard Industrial Code 1	VARCHAR2	5
MIT_SIC_CODE2	MIT Standard Industrial Code 2	VARCHAR2	5
MIT_SIC_CODE3	MIT Standard Industrial Code 3	VARCHAR2	5
MIT_SIC_CODE4	MIT Standard Industrial Code 4	VARCHAR2	5
MIT_SIC_CODE5	MIT Standard Industrial Code 5	VARCHAR2	5
MIT_SIC_DESC1	Description of the MIT Standard Industrial Code 1	VARCHAR2	150
MIT_SIC_DESC2	Description of the MIT Standard Industrial Code 2	VARCHAR2	150
MIT_SIC_DESC3	Description of the MIT Standard Industrial Code 3	VARCHAR2	150
MIT_SIC_DESC4	Description of the MIT Standard Industrial Code 4	VARCHAR2	150
MIT_SIC_DESC5	Description of the MIT Standard Industrial Code 5	VARCHAR2	150
MOBILE_PHONE	XXX	NUMBER	1
MOBILE_PHONE_COUNTRY_CODE	XXX	VARCHAR2	5
MOBILE_PHONE_DATE	XXX	DATE	7
PREFER_CLASS_YEAR	The preferred graduating class year of the person.	VARCHAR2	4
PREFIX	Prefix to a name, e.g. Mr., Mrs, Ms, Prof, Dr.	VARCHAR2	25
SALUTATION	In HR tables, this field is used for salary review letters only, a person's salutation may appear as Mary, Fred, etc. In ALUMNI tables, this field contains the salutation of the alumnus/alumnae, eg. "The Rev MacCormick", "Dr Smith", "Ms Wood", "Prof Walker", "Mary Jones".	VARCHAR2	30
STATUS	In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae.	VARCHAR2	40
SUPPRESS_EMAIL	Whether the person's e-mail address is suppressed: Y, N	VARCHAR2	1
SUPPRESS_HOME	Whether the person's home address is suppressed: Y, N	VARCHAR2	1
SUPPRESS_HOME_PHONE	Whether the person's home phone number is suppressed: Y, N	VARCHAR2	1
SUPPRESS_MOBILE_PHONE	XXX	VARCHAR2	1
SUPPRESS_WORK	Whether the person's work address is suppressed: Y, N	VARCHAR2	1
SUPPRESS_WORK_PHONE	Whether the person's work phone number is suppressed: Y, N	VARCHAR2	1
TEXT_MESSAGE_IND	XXX	VARCHAR2	1
WAREHOUSE_LOAD_DATE	The date the record was loaded into the Data Warehouse from the source system.	DATE	8