HR PERSON EMPLOYEE LIMITED Table
View exposing a limited set of employee master data including core identifiers, names, and selected workforce attributes used for restricted or simplified reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTED_SERVICE_DATE |
Column ADJUSTED_SERVICE_DATE. |
DATE |
|
ADMIN_EMPLOYEE_TYPE |
Column ADMIN_EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
ADMIN_JOB_ID |
Column ADMIN_JOB_ID. |
VARCHAR2 |
8 |
ADMIN_JOB_TITLE |
Column ADMIN_JOB_TITLE. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
Column ADMIN_ORG_UNIT_ID. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
Column ADMIN_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
ADMIN_POSITION_ID |
Column ADMIN_POSITION_ID. |
VARCHAR2 |
8 |
ADMIN_POSITION_TITLE |
Column ADMIN_POSITION_TITLE. |
VARCHAR2 |
50 |
ALT_INTEROFFICE_MAIL_FLAG |
Column ALT_INTEROFFICE_MAIL_FLAG. |
VARCHAR2 |
1 |
ALT_OFFICE_ADDRESS |
Column ALT_OFFICE_ADDRESS. |
VARCHAR2 |
40 |
ALT_OFFICE_ADDR_BUILDING |
Column ALT_OFFICE_ADDR_BUILDING. |
VARCHAR2 |
15 |
ALT_OFFICE_ADDR_ROOM |
Column ALT_OFFICE_ADDR_ROOM. |
VARCHAR2 |
20 |
ALT_OFFICE_ADDR_SITE |
Column ALT_OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
ALT_OFFICE_PHONE |
Column ALT_OFFICE_PHONE. |
VARCHAR2 |
15 |
APPOINTMENT_END_DATE |
Column APPOINTMENT_END_DATE. |
DATE |
|
CURRENT_EMPLOYMENT_DATE |
Column CURRENT_EMPLOYMENT_DATE. |
DATE |
|
DATE_OF_DEATH |
Column DATE_OF_DEATH. |
DATE |
|
DATE_TO_FACULTY |
Column DATE_TO_FACULTY. |
DATE |
|
DATE_TO_STAFF |
Column DATE_TO_STAFF. |
DATE |
|
DIRECTORY_ORG_UNIT_ID |
Column DIRECTORY_ORG_UNIT_ID. |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_TITLE |
Column DIRECTORY_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
DIRECTORY_SUPPRESS_FLAG |
Column DIRECTORY_SUPPRESS_FLAG. |
VARCHAR2 |
1 |
DIRECTORY_TITLE |
Column DIRECTORY_TITLE. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Column EMAIL_ADDRESS. |
VARCHAR2 |
100 |
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 |
EMPLOYMENT_STATUS |
Column EMPLOYMENT_STATUS. |
VARCHAR2 |
40 |
ETHNIC_ORIGIN |
Column ETHNIC_ORIGIN. |
VARCHAR2 |
100 |
ETHNIC_ORIGIN_INTERNAL |
Column ETHNIC_ORIGIN_INTERNAL. |
VARCHAR2 |
100 |
ETHNIC_ORIGIN_INTERNAL_CODE |
Column ETHNIC_ORIGIN_INTERNAL_CODE. |
VARCHAR2 |
2 |
FIRST_NAME |
Column FIRST_NAME. |
VARCHAR2 |
40 |
FIRST_NAME_UPPER |
Column FIRST_NAME_UPPER. |
VARCHAR2 |
40 |
FORM_OF_ADDRESS_LONG |
Column FORM_OF_ADDRESS_LONG. |
VARCHAR2 |
100 |
FORM_OF_ADDRESS_SHORT |
Column FORM_OF_ADDRESS_SHORT. |
VARCHAR2 |
5 |
FULL_NAME |
Column FULL_NAME. |
VARCHAR2 |
100 |
FULL_NAME_UPPERCASE |
Column FULL_NAME_UPPERCASE. |
VARCHAR2 |
100 |
GENDER |
Column GENDER. |
VARCHAR2 |
15 |
HAS_ADDL_APPOINTMENT |
Column HAS_ADDL_APPOINTMENT. |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
Column HAS_DUAL_APPOINTMENT. |
VARCHAR2 |
1 |
HIGHEST_DEGREE_TYPE |
Column HIGHEST_DEGREE_TYPE. |
VARCHAR2 |
20 |
HIGHEST_DEGREE_TYPE_CODE |
Column HIGHEST_DEGREE_TYPE_CODE. |
VARCHAR2 |
2 |
HR_ORG_UNIT_ID |
Column HR_ORG_UNIT_ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Column HR_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
INTEROFFICE_MAIL_FLAG |
Column INTEROFFICE_MAIL_FLAG. |
VARCHAR2 |
1 |
IS_FORMER_EMP_CURRENT_STU |
Column IS_FORMER_EMP_CURRENT_STU. |
VARCHAR2 |
1 |
JOB_ID |
Column JOB_ID. |
VARCHAR2 |
8 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
40 |
KRB_NAME_UPPERCASE |
Column KRB_NAME_UPPERCASE. |
VARCHAR2 |
30 |
LAST_NAME |
Column LAST_NAME. |
VARCHAR2 |
40 |
LAST_NAME_UPPER |
Column LAST_NAME_UPPER. |
VARCHAR2 |
40 |
LAST_TERM_DATE |
Column LAST_TERM_DATE. |
DATE |
|
LOA_RETURN_DATE |
Column LOA_RETURN_DATE. |
DATE |
|
LOA_START_DATE |
Column LOA_START_DATE. |
DATE |
|
MIDDLE_INITIAL |
Column MIDDLE_INITIAL. |
VARCHAR2 |
10 |
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 |
NAME_KNOWN_BY |
Column NAME_KNOWN_BY. |
VARCHAR2 |
40 |
NAME_PREFIX |
Column NAME_PREFIX. |
VARCHAR2 |
15 |
NAME_SUFFIX |
Column NAME_SUFFIX. |
VARCHAR2 |
15 |
OFFICE_ADDRESS |
Column OFFICE_ADDRESS. |
VARCHAR2 |
40 |
OFFICE_ADDR_BUILDING |
Column OFFICE_ADDR_BUILDING. |
VARCHAR2 |
15 |
OFFICE_ADDR_ROOM |
Column OFFICE_ADDR_ROOM. |
VARCHAR2 |
15 |
OFFICE_ADDR_SITE |
Column OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Column OFFICE_PHONE. |
VARCHAR2 |
15 |
ORIGINAL_HIRE_DATE |
Column ORIGINAL_HIRE_DATE. |
DATE |
|
PERSONAL_URL |
Column PERSONAL_URL. |
VARCHAR2 |
150 |
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_ID |
Column POSITION_ID. |
VARCHAR2 |
8 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
50 |
PREFERRED_FIRST_NAME |
Column PREFERRED_FIRST_NAME. |
VARCHAR2 |
40 |
PREFERRED_LAST_NAME |
Column PREFERRED_LAST_NAME. |
VARCHAR2 |
40 |
PREFERRED_MIDDLE_NAME |
Column PREFERRED_MIDDLE_NAME. |
VARCHAR2 |
40 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
SALUTATION |
Column SALUTATION. |
VARCHAR2 |
1 |
SAP_STATUS |
Column SAP_STATUS. |
VARCHAR2 |
40 |
SIGNATURE_NAME |
Column SIGNATURE_NAME. |
VARCHAR2 |
80 |
UNION_SENIORITY_DATE |
Column UNION_SENIORITY_DATE. |
DATE |
|
VACATION_ELIG_DATE |
Column VACATION_ELIG_DATE. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
WI_GENOME_HIRE_DATE |
Column WI_GENOME_HIRE_DATE. |
DATE |