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 |