Versions Compared

Version Old Version 3 New Version 4
Changes made by

Ashley Ransoo

Ashley Ransoo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This template is brought to you by Mural, a visual collaboration app.As discussed in the Teams chat, with the start of August 2025 onboarding in the not too distant future, we wanted to have a follow-up call on the state of the Oriel Workforce Extract, the NDW, etc. On this call we propose we would go through the following:

Participants

Date

Video conference link

On this page

Table of Contents

⏳ Items for Discussion

🖊️ Discussion Point Summary

💡 Details

(blue star) Actions / Decisions

1. A recap on the state of the options prioritised from yourselves previously

https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/4595941521/Oriel-TIS+Solution+Options+-+Phased+Approach#1.-Filter-and-Enrich-Oriel-Data-with-Timestamps

  •  

2. Additional Fields Requested

  1. Added Fields:

    1. DayToDayActivitiesLimited (yes/no) – PIDSpecial Schema

    2. MaritalStatus – PIDSpecial Schema

    3. OfferRoundName – PID Schema

    4. StaffGroups – PID Schema

    5. AllocationPreference – PIDSpecial Schema

  2. Still outstanding

    1. OfferPreference – Is this still required?

    2. AllocationCode – Is this different to AllocationPreference

    3. Public Health Application Type – Not sure what this is but assume it is Medic vs Non-Medic Public Health. Can this be derived from other fields?

  •  

3. Feedback on how you are using this data and any particular new pain points

  1. Andrew Horton tweaks to SQL script

    1. Marital Status values removed – couldn’t get uploads to work with them in.

    2. We’ve put a case statement in to make Nationality a Nationality – may have missed some but had everything we needed last year.

    3. Case statement for to match to the TIS Gender reference values as at April 2024 reference values.

    4. We put the provided OrielID’s into an IN statement to capture the records we want. – How are these known?

  2. Other pain points from Andy and team

    1. Move address 3 into address 2 where it is blank

    2. Check the telephone number looks correct as there is sometimes an issue with formatting (Convert the column to number, then remove the decimal places)

  3. Questions:

    1. Will the ‘tweaks’ above be useful for all and should they be applied?

    2. Do the Address[RT1]  and Phone Number pain points hold true for all? Should a fix be investigated for them?

  •  

4. An updated list of priorities from yourselves for us to develop going into the August 2025 onboarding process

  •  

5. Do we need to meet again regularly?

  •  

...