Data Warehouse

APPOINTMENT_END_DATE

Date associated with appointment end.

DATE

APPOINTMENT_START_DATE

Date associated with appointment start.

DATE

APPOINTMENT_TYPE

Appointment type as provided by the source.

VARCHAR2

30

DEPARTMENT_ID

Business identifier for the department.

VARCHAR2

6

DEPARTMENT_NAME

Department name as provided by the source.

VARCHAR2

50

DOL_JOB_GROUP

Dol job group as provided by the source.

VARCHAR2

30

FULL_NAME

Full name as provided by the source.

VARCHAR2

90

IS_ADMINISTRATIVE_STAFF

Indicator identifying whether administrative staff (Y/N).

VARCHAR2

5

IS_FACULTY

Indicator identifying whether faculty (Y/N).

VARCHAR2

5

IS_GRADUATE_STUDENT_STAFF

Indicator identifying whether graduate student staff (Y/N).

VARCHAR2

5

IS_MEDICAL_STAFF

Indicator identifying whether medical staff (Y/N).

VARCHAR2

5

IS_OTHER_ACADEMIC_GROUP

Indicator identifying whether other academic group (Y/N).

VARCHAR2

5

IS_SERVICE_STAFF

Indicator identifying whether service staff (Y/N).

VARCHAR2

5

IS_SPONSORED_RESEARCH_STAFF

Indicator identifying whether sponsored research staff (Y/N).

VARCHAR2

5

IS_SUPPORT_STAFF

Indicator identifying whether support staff (Y/N).

VARCHAR2

5

JOB_TITLE

Job title as provided by the source.

VARCHAR2

50

MIT_ID

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

VARCHAR2

9

PERCENT_EFFORT

Percent effort as provided by the source.

NUMBER

4,1

PREFERRED_JOB_TITLE

Preferred job title as provided by the source.

VARCHAR2

51

PRIMARY_SECONDARY_INDICATOR

Primary secondary indicator as provided by the source.

VARCHAR2

30

RANK_TYPE

Rank type as provided by the source.

VARCHAR2

50

SALARY_REVIEW_CATEGORY

Salary review category as provided by the source.

VARCHAR2

30

UNION_JOB_CODE

Code identifying union job.

VARCHAR2

30

WORK_HOURS

Work hours as provided by the source.

NUMBER

4,2