RR TRAINEE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
40 |
EMPLOYMENT_STATUS |
Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
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 |
OFFICE_ADDRESS |
Employee's primary office address, for example, W92-101, LL-B 341 |
VARCHAR2 |
40 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
15 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
40 |
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 |
40 |
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 |
18 |
RR_TRAINEE_KEY |
XXX |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |