HR PERSON EMPLOYEE BASIC Table
View exposing a reduced set of employee master data including core identifiers, names, and essential workforce attributes used for lightweight workforce reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
Column APPOINTMENT_END_DATE. |
DATE |
|
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
40 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
40 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
FIRST_NAME |
Column FIRST_NAME. |
VARCHAR2 |
40 |
FIRST_NAME_UPPER |
Column FIRST_NAME_UPPER. |
VARCHAR2 |
40 |
FULL_NAME |
Column FULL_NAME. |
VARCHAR2 |
100 |
HAS_ADDL_APPOINTMENT |
Column HAS_ADDL_APPOINTMENT. |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
Column HAS_DUAL_APPOINTMENT. |
VARCHAR2 |
1 |
HR_ORG_UNIT_ID |
Column HR_ORG_UNIT_ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Column HR_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
IS_FORMER_EMP_CURRENT_STU |
Column IS_FORMER_EMP_CURRENT_STU. |
VARCHAR2 |
1 |
LAST_NAME |
Column LAST_NAME. |
VARCHAR2 |
40 |
LAST_NAME_UPPER |
Column LAST_NAME_UPPER. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Column MIDDLE_NAME. |
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 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
4 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
50 |
SAP_STATUS |
Column SAP_STATUS. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |