|
Immigration_Status_Hist_Id
|
Each status’ unique identifier.
|
|
Oip_Id_Number
|
The unique identifier for a record (use this value to map records in this
data collection).
|
| Immigration_Status |
Represents the immigrations status code (use OIP_IMMIGRATION_STATUS_CODE
to map immigration status description). For example:
· F-1 (F1 Student)
· H1B (Temp Worker) |
| Immigration_Status_Start_Date |
Immigration status start date |
| Immigration_Status_End_Date |
Immigration status end date (commonly referred to as visa expiration date) |
| Immigration_Status_Category |
Represents the immigrations status category. For example:
· Student
· Scholar |
| Immigration_Status_Info |
Immigration_Status_Info - Represents the immigration status information.
For example:
• Active
• Completed
• Terminated
• Pending
• PR/I-485 Pending
• Approved
|
| Immigration_Addtl_Info |
Additional information pertaining to the record. |
| Last_Activity_Date |
Date the record was last modified by source system. |
| Last_Extract_Date |
Date the record was last imported into the data warehouse. |
