ALUMNI BY COURSE Table
View exposing alumni records grouped by MIT course or program of study used for academic and alumni analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALLOW_STUDENT_SEARCH |
Allow student search as provided by the source. |
VARCHAR2 |
1 |
ALUMNI_ID_NUMBER |
Alumni id number as provided by the source. |
VARCHAR2 |
10 |
BUSINESS_TITLE |
Business title as provided by the source. |
VARCHAR2 |
60 |
BUS_ADDR_DATE_MODIFIED |
Bus addr date modified as provided by the source. |
DATE |
|
BUS_ADDR_PREF_IND |
Bus addr pref ind as provided by the source. |
VARCHAR2 |
1 |
BUS_CITY |
Bus city as provided by the source. |
VARCHAR2 |
50 |
BUS_COUNTRY |
Bus country as provided by the source. |
VARCHAR2 |
40 |
BUS_FAX_NUMBER |
Bus fax number as provided by the source. |
VARCHAR2 |
22 |
BUS_FOREIGN_CITY_ZIP |
Bus foreign city zip as provided by the source. |
VARCHAR2 |
75 |
BUS_GEO_CODE |
Code identifying bus geo. |
VARCHAR2 |
1 |
BUS_PHONE_NUMBER |
Bus phone number as provided by the source. |
VARCHAR2 |
25 |
BUS_STATE |
Bus state as provided by the source. |
VARCHAR2 |
3 |
BUS_STREET1 |
Bus street1 as provided by the source. |
VARCHAR2 |
75 |
BUS_STREET2 |
Bus street2 as provided by the source. |
VARCHAR2 |
75 |
BUS_STREET3 |
Bus street3 as provided by the source. |
VARCHAR2 |
75 |
BUS_ZIP_CODE |
Code identifying bus zip. |
VARCHAR2 |
30 |
COMPANY_NAME |
Company name as provided by the source. |
VARCHAR2 |
60 |
DEGREE_CODE1 |
Degree code1 as provided by the source. |
VARCHAR2 |
5 |
DEGREE_CODE2 |
Degree code2 as provided by the source. |
VARCHAR2 |
5 |
DEGREE_CODE3 |
Degree code3 as provided by the source. |
VARCHAR2 |
5 |
DEGREE_CODE4 |
Degree code4 as provided by the source. |
VARCHAR2 |
5 |
DEGREE_CODE5 |
Degree code5 as provided by the source. |
VARCHAR2 |
5 |
DEGREE_COMB_CODE |
Code identifying degree comb. |
VARCHAR2 |
2 |
DEGREE_YEAR1 |
Degree year1 as provided by the source. |
VARCHAR2 |
4 |
DEGREE_YEAR2 |
Degree year2 as provided by the source. |
VARCHAR2 |
4 |
DEGREE_YEAR3 |
Degree year3 as provided by the source. |
VARCHAR2 |
4 |
DEGREE_YEAR4 |
Degree year4 as provided by the source. |
VARCHAR2 |
4 |
DEGREE_YEAR5 |
Degree year5 as provided by the source. |
VARCHAR2 |
4 |
DEPT1 |
Dept1 as provided by the source. |
VARCHAR2 |
7 |
DEPT2 |
Dept2 as provided by the source. |
VARCHAR2 |
7 |
DEPT3 |
Dept3 as provided by the source. |
VARCHAR2 |
7 |
DEPT4 |
Dept4 as provided by the source. |
VARCHAR2 |
7 |
DEPT5 |
Dept5 as provided by the source. |
VARCHAR2 |
7 |
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
60 |
EMAIL_DATE_MODIFIED |
Email date modified as provided by the source. |
DATE |
|
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
25 |
FORMER_NAME |
Former name as provided by the source. |
VARCHAR2 |
60 |
HOME_ADDR_DATE_MODIFIED |
Home addr date modified as provided by the source. |
DATE |
|
HOME_ADDR_PREF_IND |
Home addr pref ind as provided by the source. |
VARCHAR2 |
1 |
HOME_CITY |
Home city as provided by the source. |
VARCHAR2 |
50 |
HOME_COUNTRY |
Home country as provided by the source. |
VARCHAR2 |
40 |
HOME_FAX_NUMBER |
Home fax number as provided by the source. |
VARCHAR2 |
22 |
HOME_FOREIGN_CITY_ZIP |
Home foreign city zip as provided by the source. |
VARCHAR2 |
75 |
HOME_GEO_CODE |
Code identifying home geo. |
VARCHAR2 |
1 |
HOME_PHONE_NUMBER |
Home phone number as provided by the source. |
VARCHAR2 |
25 |
HOME_STATE |
Home state as provided by the source. |
VARCHAR2 |
3 |
HOME_STREET1 |
Home street1 as provided by the source. |
VARCHAR2 |
75 |
HOME_STREET2 |
Home street2 as provided by the source. |
VARCHAR2 |
75 |
HOME_STREET3 |
Home street3 as provided by the source. |
VARCHAR2 |
75 |
HOME_ZIP_CODE |
Code identifying home zip. |
VARCHAR2 |
30 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
25 |
LIVING_GROUP |
Living group as provided by the source. |
VARCHAR2 |
5 |
MAIL_NAME |
Mail name as provided by the source. |
VARCHAR2 |
60 |
MAJOR1 |
Major1 as provided by the source. |
VARCHAR2 |
12 |
MAJOR2 |
Major2 as provided by the source. |
VARCHAR2 |
12 |
MAJOR3 |
Major3 as provided by the source. |
VARCHAR2 |
12 |
MAJOR4 |
Major4 as provided by the source. |
VARCHAR2 |
12 |
MAJOR5 |
Major5 as provided by the source. |
VARCHAR2 |
12 |
MAJOR_AFFIL_CODE |
Code identifying major affil. |
VARCHAR2 |
5 |
MIDDLE_NAME |
Middle name as provided by the source. |
VARCHAR2 |
25 |
MINOR_AFFIL_CODE |
Code identifying minor affil. |
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 code1 as provided by the source. |
VARCHAR2 |
6 |
MIT_OCCUPATION_CODE2 |
Mit occupation code2 as provided by the source. |
VARCHAR2 |
6 |
MIT_OCCUPATION_CODE3 |
Mit occupation code3 as provided by the source. |
VARCHAR2 |
6 |
MIT_OCCUPATION_CODE4 |
Mit occupation code4 as provided by the source. |
VARCHAR2 |
6 |
MIT_OCCUPATION_DESC1 |
Mit occupation desc1 as provided by the source. |
VARCHAR2 |
150 |
MIT_OCCUPATION_DESC2 |
Mit occupation desc2 as provided by the source. |
VARCHAR2 |
150 |
MIT_OCCUPATION_DESC3 |
Mit occupation desc3 as provided by the source. |
VARCHAR2 |
150 |
MIT_OCCUPATION_DESC4 |
Mit occupation desc4 as provided by the source. |
VARCHAR2 |
150 |
MIT_SIC_CODE1 |
Mit sic code1 as provided by the source. |
VARCHAR2 |
6 |
MIT_SIC_CODE2 |
Mit sic code2 as provided by the source. |
VARCHAR2 |
6 |
MIT_SIC_CODE3 |
Mit sic code3 as provided by the source. |
VARCHAR2 |
6 |
MIT_SIC_CODE4 |
Mit sic code4 as provided by the source. |
VARCHAR2 |
6 |
MIT_SIC_CODE5 |
Mit sic code5 as provided by the source. |
VARCHAR2 |
6 |
MIT_SIC_DESC1 |
Mit sic desc1 as provided by the source. |
VARCHAR2 |
150 |
MIT_SIC_DESC2 |
Mit sic desc2 as provided by the source. |
VARCHAR2 |
150 |
MIT_SIC_DESC3 |
Mit sic desc3 as provided by the source. |
VARCHAR2 |
150 |
MIT_SIC_DESC4 |
Mit sic desc4 as provided by the source. |
VARCHAR2 |
150 |
MIT_SIC_DESC5 |
Mit sic desc5 as provided by the source. |
VARCHAR2 |
150 |
MOBILE_PHONE |
Mobile phone as provided by the source. |
VARCHAR2 |
26 |
MOBILE_PHONE_COUNTRY_CODE |
Code identifying mobile phone country. |
VARCHAR2 |
5 |
MOBILE_PHONE_DATE |
Date associated with mobile phone. |
DATE |
|
PREFER_CLASS_YEAR |
Prefer class year as provided by the source. |
VARCHAR2 |
4 |
PREFIX |
Prefix as provided by the source. |
VARCHAR2 |
25 |
SALUTATION |
Salutation as provided by the source. |
VARCHAR2 |
40 |
STATUS |
Status as provided by the source. |
VARCHAR2 |
40 |
SUPPRESS_EMAIL |
Suppress email as provided by the source. |
VARCHAR2 |
1 |
SUPPRESS_HOME |
Suppress home as provided by the source. |
VARCHAR2 |
1 |
SUPPRESS_HOME_PHONE |
Suppress home phone as provided by the source. |
VARCHAR2 |
1 |
SUPPRESS_MOBILE_PHONE |
Suppress mobile phone as provided by the source. |
VARCHAR2 |
1 |
SUPPRESS_WORK |
Suppress work as provided by the source. |
VARCHAR2 |
1 |
SUPPRESS_WORK_PHONE |
Suppress work phone as provided by the source. |
VARCHAR2 |
1 |
TEXT_MESSAGE_IND |
Text message ind as provided by the source. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |