HR RESIDENCY STATUS ADDL Table
View exposing additional residency status reference data including supplemental residency status codes and descriptions used for HR reporting and classification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_RESIDENCY_STATUS_ADDL_KEY |
Column HR_RESIDENCY_STATUS_ADDL_KEY. |
VARCHAR2 |
20 |
INCOME_CODE |
Column INCOME_CODE. |
VARCHAR2 |
2 |
INCOME_CODE_DESCRIPTION |
Column INCOME_CODE_DESCRIPTION. |
VARCHAR2 |
7 |
IS_IMMIGRANT |
Column IS_IMMIGRANT. |
VARCHAR2 |
1 |
IS_NON_RESIDENT |
Column IS_NON_RESIDENT. |
VARCHAR2 |
1 |
IS_WITHOUT_TAX_TREATY |
Column IS_WITHOUT_TAX_TREATY. |
VARCHAR2 |
1 |
IS_WITH_TAX_TREATY |
Column IS_WITH_TAX_TREATY. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |