OIP_IMMIGRATION STATUS HISTORY Table - Data Element Index . Tables and Data Elements . ISSS Data Home . Data Warehouse Home

OIP_IMMIGRATION_STATUS_HISTORY Table

(dwoip.oip_immigration_status_history)

Explanation

This table contains the immigration status (commonly referred to as visa) history for a person. When referring to ‘history’; this table does not maintain a record of multiple statuses for an immigration status but the current state for a particular visa status.

Recommendations

• When running reports on a person’s current immigration status; always use Oip_Person_Employee table.
• If you require a person’s immigration_status_end_date (commonly referred to as visa
• expiration date) for their current immigration status, there is a view available in the warehouse (available
• upon request; approval is required).

Common Uses

• This table allows for searches to be conducted for changes to a person’s immigration status, immigration start or end date, status category and/ or status information.

Cautions

• People can have multiple entries on this table.
• Records may not appear on this table due to the following:
• Historical record (this data did not exist prior to the new source system)
• The immigration status information is in ‘Initial’ state and has not progressed to ‘Active.’

OIP_IMMIGRATION STATUS HISTORY Table - Data Element Index . Tables and Data Elements . ISSS Data Home . Data Warehouse Home