Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IR AWARD PERSON Table


Recipients of awards and honors.


Field Name

Description

Data Type

Length

ALUMNI_ID

XXX

VARCHAR2

10

FULL_NAME

The full name of the person.

VARCHAR2

90

HAS_EVER_BEEN_MIT_FACULTY

Has the award recipient ever been a faculty member at MIT: Y (Yes), N (No).

VARCHAR2

1

IR_AWARD_PERSON_KEY

Use this field to join together tables IR_AWARD_HONOR_DETAIL and IR_AWARD_PERSON.

VARCHAR2

20

IS_ALUMNI

Whether the award recipient is MIT Alumni: Y (Yes), N (No).

VARCHAR2

1

IS_CURRENT_MIT_EMPLOYEE

Whether the award recipient is current MIT Employee: Y (Yes), N (No).

VARCHAR2

1

IS_DECEASED

An indicator that the person is deceased: Yes or No.

VARCHAR2

5

MIT_EMPLOYEE_TYPE

Employee Type - Faculty, Admin Staff, Sponsored Research Staff, etc.

VARCHAR2

40

MIT_EMPLOYMENT_STATUS

Employment Status - Active, Deceased, Retired, Terminated, etc.

VARCHAR2

30

MIT_HR_ORG_UNIT_TITLE

Department or Organization Unit of the award recipient.

VARCHAR2

75

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_ORG_HIER_SCHOOL_AREA

One of the five MIT schools.

VARCHAR2

75

MIT_POSITION_TITLE

Position title of the award recipient.

VARCHAR2

60

ORG_UNIT_TITLE

XXX

VARCHAR2

100

PERSONAL_URL

The employee's personal URL.

VARCHAR2

241

PERSON_TYPE

In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member.

VARCHAR2

60

STATUS_GENERAL

General status of the award recipient: Current, Former, Retired, Deceased.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

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

DATE

8

WAS_MIT_STUDENT

Was the award recipient ever a MIT student? Y (Yes), N (No)

VARCHAR2

1