Page Content
- Background
- Diagram for Proposed Business Process to Import Trainees from Oriel into TIS
- Excel workbook with fields identified for Step 2 and Step 5
- Excel workbook with Reference Data mapping
- Immigration Statuses Reference data from Oriel for 2017 and 2018
- Discussion and Assumptions
1. Background:
The TIS-Oriel integration is a file based export from Oriel of Trainee details and the programmes they've been accepted on to. This will include Trainees that are new to TIS and those who have already been on TIS programmes. New Trainees will cause Trainee record creation and user on-boarding within Trainee User Management.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
2. MVP - Proposed Business Process to Import Trainees from Oriel into TIS:
3. Excel workbook with fields identified for Step 2 and Step 5
| View file | ||||
|---|---|---|---|---|
|
4. Excel workbook with Reference Data mapping
View file name Reference Data - Oriel to Intrepid mapping v2.xlsx height 150
5. Immigration Statuses Reference data from Oriel for 2017 and 2018
View file name Immigration Statuses Discrepancies - v3.0.xlsx height 150
6. Discussion and Assumptions:
| # | Question | Comment | Owner |
|---|---|---|---|
| 1 | In the workbook on sub heading 3, there are fields that are reference data from Oriel and require further data mapping to be done. | ||
| 2 | In the workbook on sub heading 3, there are fields that are not necessarily mandatory on Oriel and would therefore only pull through if the applicant/trainee has provided the information on their application form, e.g. National Insurance number, Religious belief, Sexual Orientation etc. | ||
| 3 | In the workbook on sub heading 3, there are fields that are on the Recruitment Import template but not Oriel. Which of these fields are required in the template and where would these be sourced from? | ||
| 4 | Workbook on sub heading 4 was put together with input provided by Claire Lehoux. There still need to have data tidied up in the DR. | ||
| 5 | Workbook on sub heading 5 has a list of Immigration statuses discrepancies that requires mapping. Oriel reference data for 2017 and 2018 have different list of values that will be passed on to TIS. | ||
| 6 | Reference data changes on Oriel will need to be coordinated with TIS going forward. | ||
| 7 | Custom report can be built on Oriel to extract a list of trainnes for specific programme/s where they have accepted an offer or withdrawn after accepting. | ||
| 8 | Documents will be generated as part of Step 2 of the Process Diagram. | ||