Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR VISA TYPE Table


This table contains the different types of visas.


Field Name

Description

Data Type

Length

HR_VISA_TYPE_KEY

Use this field to join together a fact table with visa information about a person and a dimension table with more detail information about Visa Type.

VARCHAR2

4

VISA_TYPE

A description of the type of visa a person holds.

VARCHAR2

30

VISA_TYPE_CODE

The code relating to Visa Type.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8