Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WTW OLD INSTRUCTOR Table


This table contains all instructors in the OLD Who-is-Teaching-What data model.


Field Name

Description

Data Type

Length

DEPARTMENT_1

The department where the position is held.

VARCHAR2

4

DEPARTMENT_2

The department where position #2 is held, if applicable.

VARCHAR2

4

DEPARTMENT_3

The department where position #3 is held, if applicable.

VARCHAR2

4

DEPARTMENT_4

The department where position #4 is held, if applicable.

VARCHAR2

4

ELIGIBLE_TO_REG

A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise.

VARCHAR2

1

EMAIL_ADDRESS

A person's complete electronic mail address including user name and node name, for example, username@school.edu.

VARCHAR2

60

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

IS_FIRST_YEAR_GRAD

Flag indicates whether the instructor is a first year graduate student for the academic term. Y=yes, N=no.

VARCHAR2

1

IS_REGISTERED

"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year.

VARCHAR2

1

IS_STUDENT

In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period).

VARCHAR2

1

KERBEROS_NAME

The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system.

VARCHAR2

8

LAST_NAME

The person's last name.

VARCHAR2

30

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

MIT_ID

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

VARCHAR2

9

PAYROLL_RANK

Rank of instructors. Eg.: Professor, Teaching Assistant, Lecturer, Assistant Professor, Associate Professor with tenure, Research Assistant, Grad Student Fellow, Associate Professor w/o tenure, Instructor, senior Lecturer, Technical Instructor, etc.

VARCHAR2

30

POSITION_TITLE_1

Position title.

VARCHAR2

50

POSITION_TITLE_2

Position title #2, if applicable.

VARCHAR2

50

POSITION_TITLE_3

Position title #3, if applicable.

VARCHAR2

50

POSITION_TITLE_4

Position title #4, if applicable.

VARCHAR2

50

STUDENT_HOME_DEPARTMENT

The student's home department

VARCHAR2

4

STUDENT_YEAR

The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable.

VARCHAR2

1

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8

WTW_OLD_INSTRUCTOR_KEY

Use this field to join together tables WTW_OLD_TEACHING_DETAIL and WTW_OLD_INSTRUCTOR to get the information about the instructors for the teaching data in the OLD Who-is-Teaching-What data model.

VARCHAR2

15