HR SECONDMENT Table
View exposing employee secondment data including secondment dates, domestic or international status, host organization, agreement details, modified benefits, and visa information used for mobility and assignment reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGREEMENT_ENTITY |
Column AGREEMENT_ENTITY. |
VARCHAR2 |
60 |
AGREEMENT_EXISTS |
Column AGREEMENT_EXISTS. |
VARCHAR2 |
1 |
COUNTRY |
Column COUNTRY. |
VARCHAR2 |
2 |
DOMESTIC_INTERNATIONAL_CODE |
Column DOMESTIC_INTERNATIONAL_CODE. |
VARCHAR2 |
1 |
DOMESTIC_INTERNATIONAL_DESC |
Column DOMESTIC_INTERNATIONAL_DESC. |
VARCHAR2 |
13 |
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 |
MODIFIED_BENEFITS_CODE |
Column MODIFIED_BENEFITS_CODE. |
VARCHAR2 |
1 |
MODIFIED_BENEFITS_DESC |
Column MODIFIED_BENEFITS_DESC. |
VARCHAR2 |
8 |
ORGANIZATION |
Column ORGANIZATION. |
VARCHAR2 |
60 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
SECONDMENT_BEGIN_DATE |
Column SECONDMENT_BEGIN_DATE. |
DATE |
|
SECONDMENT_END_DATE |
Column SECONDMENT_END_DATE. |
DATE |
|
VISA1_COUNTRY_KEY |
Column VISA1_COUNTRY_KEY. |
VARCHAR2 |
3 |
VISA1_END_DATE |
Column VISA1_END_DATE. |
DATE |
|
VISA1_NUMBER |
Column VISA1_NUMBER. |
VARCHAR2 |
30 |
VISA1_START_DATE |
Column VISA1_START_DATE. |
DATE |
|
VISA1_TYPE |
Column VISA1_TYPE. |
VARCHAR2 |
30 |
VISA2_COUNTRY_KEY |
Column VISA2_COUNTRY_KEY. |
VARCHAR2 |
3 |
VISA2_END_DATE |
Column VISA2_END_DATE. |
DATE |
|
VISA2_NUMBER |
Column VISA2_NUMBER. |
VARCHAR2 |
30 |
VISA2_START_DATE |
Column VISA2_START_DATE. |
DATE |
|
VISA2_TYPE |
Column VISA2_TYPE. |
VARCHAR2 |
30 |
VISA3_COUNTRY_KEY |
Column VISA3_COUNTRY_KEY. |
VARCHAR2 |
3 |
VISA3_END_DATE |
Column VISA3_END_DATE. |
DATE |
|
VISA3_NUMBER |
Column VISA3_NUMBER. |
VARCHAR2 |
30 |
VISA3_START_DATE |
Column VISA3_START_DATE. |
DATE |
|
VISA3_TYPE |
Column VISA3_TYPE. |
VARCHAR2 |
30 |
VISA4_COUNTRY_KEY |
Column VISA4_COUNTRY_KEY. |
VARCHAR2 |
3 |
VISA4_END_DATE |
Column VISA4_END_DATE. |
DATE |
|
VISA4_NUMBER |
Column VISA4_NUMBER. |
VARCHAR2 |
30 |
VISA4_START_DATE |
Column VISA4_START_DATE. |
DATE |
|
VISA4_TYPE |
Column VISA4_TYPE. |
VARCHAR2 |
30 |
VISA5_COUNTRY_KEY |
Column VISA5_COUNTRY_KEY. |
VARCHAR2 |
3 |
VISA5_END_DATE |
Column VISA5_END_DATE. |
DATE |
|
VISA5_NUMBER |
Column VISA5_NUMBER. |
VARCHAR2 |
30 |
VISA5_START_DATE |
Column VISA5_START_DATE. |
DATE |
|
VISA5_TYPE |
Column VISA5_TYPE. |
VARCHAR2 |
30 |
WAREHOUSE_CURRENT_TIMESTAMP |
Column WAREHOUSE_CURRENT_TIMESTAMP. |
DATE |