Versions Compared

Key

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

Data leads:

Claire Le Houx (Unlicensed)

Alice Thompson

David Short (Unlicensed)

James Harris


#
Discussion/Action
Responsible
Outcome
Status
1

Programme names/numbers aren’t provided for Dental trainees, they’re created by Admins

JH, AP, IO


Proposed Solution (JH)

  • 3 letter use the prefix of the local office + 3 digit acronym based on specialty
  • 3 digit specialty acronym should be consistent across all


Action: AP/IO to impact assess

JH: Done mapping and need to do some more work and send to AP.

AP has received James ssheet.

More generally, we should look to standardise naming conventions around programmes (not just Dental) to be discussed separately

Next to put on Microsoft Teams and get SMLs feedback - AP

JH/AP - Setup call to briefly explain next week. - Was decided that it should be postponed for the moment on advice from James.

IO/AP: Recommendation: show a concatenated display of the programme name in the dropdown list with the Local Office name? To check with DEV on the possible solutions. (P1) Image AddedTISDEV-3767 - Add indicator to drop downs to highlight "ownership" of values to the user TO DO

19/02: AP/JH: Field limit for programme number? Check field validation (Alistair Pringle (Unlicensed))  Max number of characters is 20 including spaces / special characters

09/04: Sent to Andy, Programme number being changed as this was too long. 

30/04: Leave on for next 2-3 data leads call. 


ON HOLD till post MVP launch

Revisit in July 2018.

2Start post funding discussion with local offices (Amending)JW/JH

Place holder

AP/JH/IO: IO To update with ticket numbers and post on DQ channel.

21/05: CL: London needs this 2 weeks after go-live. 

IO: There is a task to review how post funding works. Tickets progress?


ON HOLD till post MVP

Revisit in July 2018.

3

Update on data issues (James/Claire) flagged on DQ channel - Data not pulling through rather than missing placements. 

Progress update on the checks between Intrepid and TIS UI (Claire)
JH/CL/IOCL: Spreadsheet uploaded with feedback - Qualifications, Assessments and Placements issues identified.

CL/IO

IO to review the feedback from Claire

09/04: Claire Shared with other Data leads to test the UI and feedback - JH, AB & DS

15/04: Update?

19/04:  Go through BAU tickets

30/04: Check status of those tickets and review . IO to cite the tickets here for CL to review when ready.

08/05: Former user (Deleted) to update. 

14/05: CLH to re test  and update spreadsheet - share on DQ channel

21/05: Tickets raised for the feedback posted on DQ. Placements and Assessments tickets prioritized higher. 

04/06: Dev looking at Assessment BAU tickets. Once the ETL has worked, we should start seeing better results and re-prioritise what's left of the tickets.


4

Bulk Assessment template to be reviewed.

Assessment - Bulk Upload (DRAFT)

Data leads

CL/JH/AB/DS

AR: Share on DQ Slack channel

AR 23/04: Alice has added her recommendations and shared on DQ channel, can other data leads review and confirm?

AR: 30/04: To review comments from Alice and James

AR: 08/05:

  • We had a spike session, outcome of this was this is work 3 weeks of DEV work and the time for this to go into a sprint is to be decided by the business.
  • Reviewed data leads comments and outstanding comments in red on the confluence page. 
  • 08/05 Joanne Watson (Unlicensed) to review DQ conversation and remaining outstanding items on the confluence page.
  • 14/05 JW updated assessments bulk upload page Assessment - Bulk Upload (DRAFT)
  • JW to request call for field validation/template agreement 
  • Joanne Watson (Unlicensed) to send the invite out for next week.



5Reports on Deleted records requested from Hicom. (Status of 'Delete' on Hicom but still 'Current' on TIS).  (#intrepid_Integration slack channel conversation).AP/IO

08/05: Alistair Pringle (Unlicensed): Chase up with Martin.

DS: In Intrepid, Programme is a hard delete, whereas Programme membership is soft delete. 

14/05: AB sent details of report criteria to the Intrepid Analysis team. No response from them yet

JW to set up meeting with Data Leads, BAs, POs and Reubs on how to manage deleted records on TIS in future. 

JH/AB: Checked the deleted records. Next step to flag what records on TIS are to be deleted. Send to CL/DS to check. 

Hicom has not provided the full requested set of deleted records but will follow. 

04/06: Programme, Posts and Prog. memberships Id's send and TIS to action the delete next. Tickets are on Jira. 

Former user (Deleted) - check the priorities of those.


6 Data/Field level analysisAll

IO: Suggested approach:

1. Sit with Chris and review the output he shared with DQ leads + delete report
2. identify areas of concern
3. coordinate through Reubs/Ashley to fix areas of concern
4. re-test later on versus DQ analyses

04/06: Tickets being created 


7Resolve Duplicates - TISDEV-4841: Resolve the duplicate invalid GMC numbers, such as 'Retired,' and make them 'UNKNOWN'Data leads

Discussed on DQ on 04/06:

  • Agreement re changing '0', 'Retired', 'TBC' or 'u' to UNKNOWN in the GMC/GDC/PH number
  • Changing blank to UNKNOWN not recommended as it may legitimately be blank because they have a GDC or PH number


  • What we should do to those with blank/null in all 3?
  • JH: Among those none have programmes and very few have placements. There are Staff, Both, Contact, Admin.
  • JW: 
    • Admin and Contact = N/A ?
    • Staff and Both = UNKNOWN ?
      is that the agreement?

04/06: The following has been agreed:

  • GMC for Contacts, Staff and Both = UNKNOWN
  • GMC for Admin = N/A

DS: List of persons with same GMC's, check the DW to see if some of those have been resolved?

TISDEV-4841 to be paused from releasing to Prod until David Short (Unlicensed) has done his investigation of the ones that could potentially be merged. Merge Rules to be shared. To create tickets following that.



8

TISDEV-4711

vwProgrammeCurriculum:CurriculumGMCReferenceNumber missing from NDW

JH

Progress?

04/06: JH was on leave, will progress next.


New NTN format workAP/JHDaniel Smith and Angela tasked me with speaking to you guys about what we can do about NTN format.