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

46

Upload and Maintain Oriel Applicant ID’s (Oriel PIN) on TIS - ticket? Ashley Ransoo

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

68

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.