1

Moving from current XML based files to the Leave Manager/Accent ETL extension of by Mid March 2021

2

Additional views will be provided by Hicom on the ETL, pulled in the NDW nightly.

3

The assumption is the nightly refresh from Hicom will provide additional rows to the DR rather than only new Offer Accepted applicants on subsequent refresh.

NDW will pull the full set of rows from Hicom DR into the NDW.

Discuss with JT.

4

The data will be kept beyond 13 months of trainees being appointed in their programmes in the NDW.

5

These could be used as a basis to then convert into the TIS bulk upload format

6

Upload and Maintain Oriel Applicant ID’s (Oriel PIN) on TIS

https://hee-tis.atlassian.net/browse/TIS21-1179

• This will be needed for Foundation applicants without a registration number

• For potential future linking of Oriel Data in the NDW with TIS data.

• To link Oriel documents to be pulled across to TIS

7

There would be some level of comparison and tracking of what applicants have/have not been uploaded in the NDW

8

Documents - the links/paths to the files will be provided in the views but not the actual files from Hicom - Further discussion on how to provide the files, might be an S3 bucket that TIS give access to Hicom.

9

Following recent discussions with Hicom, Programme name and number are not going to be mandatory fields on Oriel, therefore leaving scope for potentially unfilled programme info.

10

Current process of onboard Oriel Trainees to TIS is an industry – It needs to be changed but needs careful planning 

Phased approach (Time Frames dependent on Hicom development) 

• Phase 1: Work in parallel with current process (August intake) 
  - Construct data outputs to exactly match the input requirements of the TIS Person Bulk Upload including Programme Membership Data 
  - Compare outputs of the above to what local teams are adding on to TIS. What is the cause of any difference? Is there anyone ‘missing’ from TIS? 
  - What do we do when the Programme information wasn’t completed in Oriel? How do we decrease this? 

• Phase 2: Semi-automation (Round 2 Applicants) 
  - Use the lessons learnt above: 
  - Produce an output that can be copied directly into the TIS bulk upload 
  - Produce reports to look at gaps, edge cases, data quality 

• Phase 3: To be determined by stakeholders 
  - Further integration? 
  - Oriel – TIS API?