POSTDOC ALUMNI Table
View exposing postdoctoral alumni records including person attributes and affiliation history.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
Date associated with appointment end. |
DATE |
|
APPT_BEGIN_DATE |
Date associated with appt begin. |
DATE |
|
APPT_END_DATE |
Date associated with appt end. |
DATE |
|
CURRENT_EMPLOYMENT_DATE |
Date associated with current employment. |
DATE |
|
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
EMPLOYMENT_PERCENT |
Employment percent associated with the record. |
NUMBER |
17,8 |
EMPLOYMENT_STATUS |
Employment status associated with the record. |
VARCHAR2 |
30 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
15 |
HOME_ADDR_CITY |
Home addr city associated with the record. |
VARCHAR2 |
0 |
HOME_ADDR_COUNTRY |
Home addr country associated with the record. |
VARCHAR2 |
0 |
HOME_ADDR_STREET |
Home addr street associated with the record. |
VARCHAR2 |
0 |
HOME_ADDR_ZIP |
Home addr zip associated with the record. |
VARCHAR2 |
0 |
HR_ORG_UNIT_TITLE |
Hr org unit title associated with the record. |
VARCHAR2 |
75 |
IS_CURRENT_APPOINTMENT |
Indicator identifying whether current appointment (Y/N). |
VARCHAR2 |
1 |
IS_MOST_RECENT_APPT |
Indicator identifying whether most recent appt (Y/N). |
VARCHAR2 |
1 |
JOB_TITLE |
Job title associated with the record. |
VARCHAR2 |
50 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
40 |
MIDDLE_INITIAL |
Middle initial associated with the record. |
VARCHAR2 |
10 |
MIDDLE_NAME |
Middle name associated with the person. |
VARCHAR2 |
40 |
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_STUDENT_FLAG |
Indicator identifying whether mit student (Y/N). |
VARCHAR2 |
1 |
OFFICE_ADDR_BUILDING |
Office addr building associated with the record. |
VARCHAR2 |
15 |
OFFICE_ADDR_CITY |
Office addr city associated with the record. |
VARCHAR2 |
16 |
OFFICE_ADDR_ROOM |
Office addr room associated with the record. |
VARCHAR2 |
15 |
OFFICE_ADDR_SATE |
Office addr sate associated with the record. |
VARCHAR2 |
4 |
OFFICE_ADDR_SITE |
Office addr site associated with the record. |
VARCHAR2 |
2 |
OFFICE_ADDR_STREET |
Office addr street associated with the record. |
VARCHAR2 |
82 |
OFFICE_ADDR_ZIP |
Office addr zip associated with the record. |
VARCHAR2 |
10 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
15 |
POSITION_ID |
Business identifier for the position. |
VARCHAR2 |
8 |
POSITION_TITLE |
Position title associated with the record. |
VARCHAR2 |
45 |
SALUTATION |
Salutation associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |