HR VISA STATUS HISTORY Table
View exposing historical visa status data including visa-related status changes and effective periods used for international employee compliance and workforce reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_RESIDENCY_STATUS_ADDL_KEY |
Column HR_RESIDENCY_STATUS_ADDL_KEY. |
VARCHAR2 |
20 |
HR_VISA_TYPE_KEY |
Column HR_VISA_TYPE_KEY. |
VARCHAR2 |
4 |
LAST_UPDATE_DATE |
Column LAST_UPDATE_DATE. |
DATE |
|
LAST_UPDATE_USER |
Column LAST_UPDATE_USER. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
VISA_EXPIRATION_DATE |
Column VISA_EXPIRATION_DATE. |
DATE |
|
VISA_ISSUE_DATE |
Column VISA_ISSUE_DATE. |
DATE |
|
VISA_STATUS_BEGIN_DATE |
Column VISA_STATUS_BEGIN_DATE. |
DATE |
|
VISA_STATUS_END_DATE |
Column VISA_STATUS_END_DATE. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |