MAILING LABELS Table
MIT address view of the Employee table for use by Mail Services only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
This field is used in several HR tables. In HR_PERSON_EMPLOYEE and HR_PERSON_EMPLOYEE_LIMITED, it is the latest last date or expected last date of the person's appointments. If there are no appointment records for the person in SAP HR, this date is set to LAST_TERM_DATE (termination date). In HR_APPOINTMENT_DETAIL and HR_APPT_TX_DETAIL, it is the end date of an uninterrupted appointment to a specific MIT position. Changes to the appointment, such as salary increases, one-time payments, changes in effort etc. do not affect this date, but are reflected in appointment transactions: APPT_TX_BEGIN_DATE and APPT_TX_END_DATE in HR_APPT_TX_DETAIL. |
DATE |
8 |
DEPARTMENT_ID |
The 6-digit Institute-assigned identification number of a department, school, center, or lab. (Equivalent to the Profit Center ID in financial reports, but without the initial uppercase P.) |
VARCHAR2 |
6 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
50 |
DIRECTORY_TITLE |
A person's position title as listed in the MIT directory; this will be the person's "preferred" title if they specify a descriptive title that differs from their official MIT title (Primary_Title). |
VARCHAR2 |
50 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
30 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HR_ORG_LEVEL2_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
IS_FORMER_EMP_CURRENT_STU |
If the person used to be an MIT employee or is currently an MIT student, this field is set to "Y", otherwise it contains "N" |
VARCHAR2 |
4 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
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 |
NAME_SUFFIX |
Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc. |
VARCHAR2 |
15 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
20 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
30 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
4 |
RACE |
The person's race. |
VARCHAR2 |
30 |
WAREHOUSE_CLUSTER |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_CLUSTER_CODE |
XXX |
VARCHAR2 |
5 |