Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR RESIDENCY STATUS Table


View exposing residency status reference data including residency status codes and descriptions used for HR reporting and classification.


Field Name

Description

Data Type

Length

HR_RESIDENCY_STATUS

Column HR_RESIDENCY_STATUS.

VARCHAR2

100

HR_RESIDENCY_STATUS_CODE

Column HR_RESIDENCY_STATUS_CODE.

VARCHAR2

20

HR_RESIDENCY_STATUS_KEY

Column HR_RESIDENCY_STATUS_KEY.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Column WAREHOUSE_LOAD_DATE.

DATE