HR STUDENT EMPLOYEE Table
View exposing student employee data including identifiers, names, employment status, appointment attributes, location information, visa attributes, and residency status used for student employment reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMAIL_ADDRESS |
Column EMAIL_ADDRESS. |
VARCHAR2 |
100 |
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
30 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
30 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
2 |
EMPLOYMENT_STATUS |
Column EMPLOYMENT_STATUS. |
VARCHAR2 |
30 |
EMPLOYMENT_STATUS_CODE |
Column EMPLOYMENT_STATUS_CODE. |
VARCHAR2 |
1 |
FIRST_NAME |
Column FIRST_NAME. |
VARCHAR2 |
40 |
FIRST_NAME_SEARCH |
Column FIRST_NAME_SEARCH. |
VARCHAR2 |
40 |
FULL_NAME |
Column FULL_NAME. |
VARCHAR2 |
100 |
HAS_FUTURE_STUDENT_APPOINTMENT |
Column HAS_FUTURE_STUDENT_APPOINTMENT. |
VARCHAR2 |
1 |
I9_FORM_EXPIRATION_DATE |
Column I9_FORM_EXPIRATION_DATE. |
DATE |
|
I9_FORM_LOCATION |
Column I9_FORM_LOCATION. |
VARCHAR2 |
100 |
I9_FORM_LOCATION_CODE |
Column I9_FORM_LOCATION_CODE. |
VARCHAR2 |
1 |
INITIAL_HIRE_DATE |
Column INITIAL_HIRE_DATE. |
DATE |
|
IS_CURRENTLY_EMPLOYED_STUDENT |
Column IS_CURRENTLY_EMPLOYED_STUDENT. |
VARCHAR2 |
1 |
JOB_ID |
Column JOB_ID. |
VARCHAR2 |
8 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
75 |
KRB_NAME_UPPERCASE |
Column KRB_NAME_UPPERCASE. |
VARCHAR2 |
30 |
LAST_NAME |
Column LAST_NAME. |
VARCHAR2 |
40 |
LAST_NAME_SEARCH |
Column LAST_NAME_SEARCH. |
VARCHAR2 |
40 |
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_SUFFIX |
Column NAME_SUFFIX. |
VARCHAR2 |
15 |
OFFICE_ADDR_BUILDING |
Column OFFICE_ADDR_BUILDING. |
VARCHAR2 |
60 |
OFFICE_ADDR_ROOM |
Column OFFICE_ADDR_ROOM. |
VARCHAR2 |
20 |
OFFICE_ADDR_SITE |
Column OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Column OFFICE_PHONE. |
VARCHAR2 |
15 |
ORG_UNIT_ID |
Column ORG_UNIT_ID. |
VARCHAR2 |
8 |
ORG_UNIT_TITLE |
Column ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
30 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
30 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
4 |
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
8 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
75 |
RESIDENCY_STATUS |
Column RESIDENCY_STATUS. |
VARCHAR2 |
30 |
RESIDENCY_STATUS_CODE |
Column RESIDENCY_STATUS_CODE. |
VARCHAR2 |
1 |
SAP_STATUS |
Column SAP_STATUS. |
VARCHAR2 |
30 |
SAP_STATUS_CODE |
Column SAP_STATUS_CODE. |
VARCHAR2 |
1 |
SSN_EXISTS_FLAG |
Column SSN_EXISTS_FLAG. |
VARCHAR2 |
1 |
VISA_EXPIRATION_DATE |
Column VISA_EXPIRATION_DATE. |
DATE |
|
VISA_ISSUE_DATE |
Column VISA_ISSUE_DATE. |
DATE |
|
VISA_TYPE |
Column VISA_TYPE. |
VARCHAR2 |
40 |
VISA_TYPE_CODE |
Column VISA_TYPE_CODE. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |