OPA PERSON Table
OPA Person Information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_EMPLOYEE_TYPE |
This field contains employee type (Faculty, Support Staff, etc.) as defined by their position in their admin department. For people with only one position, this is always the same as EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
The SAP 8-digit object id assigned to the employee's administrative org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
The title of employee's administrative org unit. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
EMPLOYMENT_PERCENT |
XXX |
NUMBER |
22 |
EXCEPTION_FLAG |
XXX |
CHAR |
1 |
EXCEPTION_JUSTIFICATION |
XXX |
VARCHAR2 |
200 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FORM_OF_ADDRESS_SHORT |
The short form of the honorific used to address the person, e.g., Dr.,Mr., Prof., Sir |
VARCHAR2 |
5 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HR_DEPARTMENT_CODE_OLD |
Prior department number |
VARCHAR2 |
6 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
IS_CONSULT_PRIV |
XXX |
VARCHAR2 |
1 |
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
5 |
IS_PAID_APPT |
Is this a paid appointment? Y or N. |
VARCHAR2 |
1 |
IS_SABBATICAL |
XXX |
VARCHAR2 |
1 |
IS_SUMMER_SESSION_APPT |
XXX |
VARCHAR2 |
1 |
JOB_ID |
The SAP 8-digit object id assigned to the job. |
VARCHAR2 |
8 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
50 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_NOTIFICATION_DATE |
XXX |
TIMESTAMP(6) |
11 |
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 |
OPA_CYCLE_NUMBER |
XXX |
NUMBER |
22 |
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 |
SABBATICAL_BEGIN_DATE |
XXX |
DATE |
7 |
SABBATICAL_END_DATE |
XXX |
DATE |
7 |
SCHOOL |
The name of the school from which the person earned the highest or most recent degree. |
VARCHAR2 |
50 |
SUMMER_SESSION_MONTHS |
XXX |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |