#	Discussion/Action	Responsible	Outcome	Status
1	Reports requested by each region have been submitted to JT, Alice and James for writing up in SQL. JT, AB and JH had a meeting on the 8/12 to identify themes in the reporting requirements to allow a suite of reports to be written but with filterable criteria to allow each local office/region to run the reports they need,	JW AB and JH - to write the reports	JW provided the initial list of reports for creation JH/AB: Pushed into Tableau as data sources. Completed 1 of the reports. JT to publish for users to test. Logins to be setup for users. To present what's done so far (Tuesday 16/01) with Reporting SMLs. JW/JT to coordinate the access to Tableau for the SMLs to test the reports. - In Progress with JT List of names sent to JW Quick guide to send to SMLs
2	Oriel Integration:	AR	Tasks created and summarised in the table here. Create an Oriel Integration Channel on Teams - Done To schedule a quick presentation of the Oriel trainees import process. - People SMLs, a message on General 05/02 AR: Will schedule on my return.
3	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. 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) TISDEV-3767 - Getting issue details... STATUS
4	ESR Integration Data Quality tasks. Some of the fields are mandatory for ESR to create records. TISDEV-3322 - Missing mandatory Person details: First Name, surname and DOB TO DO TISDEV-3330 - Investigate and fix trainee records missing email address. TO DO TISDEV-3324 - Fix data for missing address details TO DO	IO:	Discuss with Reubs on the next course of action. All tickets clarified, require the report to be looked at again to confirm there are still issues pending 3322: DS: Duplicate issues to be fixed to reduce the numbers of missing details. CL/IO: To identify which of those are current trainees records; who is in a current/future programme/placement? AB: Which of those have self-service access? IO to confirm - check whether there is a trainee is in a current or future programme membership or placement and re-do reports, update data leads
5	Fields comparison/review between TIS and Intrepid. Fields removed from Intrepid when coming across to TIS JW/AP/CL to review Next Monday (15/01).	JW/AP/CL	Separate spreadsheet reviewed - to be attached DR2 to TIS Field Mapping. with Actions_IO update.xlsx (now added to the able, see below items 10-32) AP/CL to provide an update.	CLOSED
6	ESR Integration - Data Quality TISDEV-3620 - Investigate the proportion of Dental trainees with/without GDC dates TO DO - Investigate the proportion of Dental trainees with/without GDC date - JH TISDEV-3663 - GDC Number of N/A - Investigate TO DO - GDC Number of N/A - Investigate - AB	JH/AB	TISDEV - 3620 - Done JH: Assumption: Dental trainees to be any person record that has a GDC number which is not Null, N/A or blank Total Number of Person Records: 13376 Number with a Start and Expiry Date: 622 Number with a Null Start or Expiry Date: 12754 % with valid dates: 4.65% % without valid dates: 95.35% TISDEV - 3363 - In Progress JH/AB/CL/DS - To get rid of the N/A for records that have a valid other registration number. We can only remove it for all if we are definitely not going to have person records which would not have an applicable reference number I think the validation rule should stay the same But what are we going to do with the practice manager records? AR: To find out with ESR how they handle a GMC/GDC number of 'N/A' - 05/02: If the professional body detail is provided in the applicant file, then ESR would expect to see the registration number and the expiry date in the subsequent fields. Where a value of N/A is being passed, the assumtion is no professional body is being passed therefore does not represent an issue for ESR. Next Steps: CL/JH: To be written down of what each means and share with SMLs? AB: PH numbers - what is the standard format? Not consistent across LOs. JH: 2 PH schools for assigning the numbers, also not mandatory to have one - make this a non-mandatory field?
7	Absence TISDEV-3529 - Absence - Review proposed Study Leave template for TIS bulk import TO DO - Absence - Review proposed Study Leave template for TIS bulk import	CL	AR/CL: To discuss and feed into the design work for Absence. 05/02: Matt/Ashley/Claire have met and discussed on the templates for recording Study leave and costs/expenses which will feed into the solution design for TIS.
8	Reference Data - Status of the values Intrepid Current reference values/tables - Can possibly be on DR2?	IO	Confirm with Paul what approach is being taken to update these - needs to be editable yes there is support on the BE but its not currently there in the FE [12:30 PM] will need to give Panos some support when it gets deploy [12:31 PM] in the time being, we can do manual updates to statuses via the migration scripts	CLOSED
9	JH - Report on Audit trails in the Datawarehouse. To start with Placements. What are the Criteria?	JW	JW to confirm, is it possible to report on audit information via data warehouse? Placements amended date field level change detail where the placement ID remains the same i.e. grade, start date, end date, specialty etc 02-Feb: it cannot currently be done, Audit is in elastic search and not directed at NDW (RN), and not being considered for MVP 05-Feb: adding new fields so that they can be reported as data, rather than audit data TISDEV-3830 - Getting issue details... STATUS	CLOSED
10	Role in Person- This is a comma separated field in the DR. Will this be a comma separated field pushed to the warehouse from TIS too?	AP	Ask John Thompson	OPEN
11	SecurityEmail in Person- This is missing from TIS. Will the email used for self-service / security be the normal EmailAddress?	IO	Consolidation issue fixed, so need to pull report again and confirm, there are some trainees who use different self service address v email address on their profile Security email address should be the primary email address for a trainee profile - they may have multiple addresses, so TIS needs to allow multiples - TISDEV-3809 - Getting issue details... STATUS	CLOSED
12	Associated Site, Associated Trust, Associated Specialty in Person- Have these fields not been developed yet? They are used to manage Supervisors.	IO	Ticketed and awaiting development	CLOSED
13	SiteID and GradeID in Placement- These fields are missing from the TIS placement table. Some posts are bucket posts so several different sites can be chosen for placements belonging to the same post so SiteID is needed against placements.. A specific placement grade is chosen from the other grade list in a post so the Grade ID is needed against placements.	IO	known issue that we are working on.	CLOSED
14	Added Date and amended date for placements- Added date and amended date fields are needed for audit purposes.	IO	Audit data needs to be reportable - add as a NFR	OPEN
15	Comments for Placements - A comments box is needed for placements.	IO	Add story for comments box - add ticket TISDEV-3810 - Getting issue details... STATUS	OPEN
16	SupervisorType for PlacementSupervisor- A SupervisorType field is needed in the PlacementSupervisor table as supervisors can be added to placements as Clinical Supervisors or Educational Supervisors. Personally, I think it would be better to just have an Educational Supervisor field and a Clinical Supervisor field directly in the placements table in order to restrict the recording of only a single Educational Supervisor and a single Clinical Supervisor against each placement record. It also simplifies the database table structure.	IO	Need to display both clinical supervisor and educational supervisor within a placement, with lables for each - there may be multiple for each type? Tickets created There is a need to simplify back end for supervisor allocation and reporting	CLOSED
17	OtherGrades in Posts - I'm assuming OtherGrades are being stored in the PostGrade table?	IO	Other grades can be selected from the same list at the main; they all come from the same table - it's essentially a multiadd feature	CLOSED
18	Added Date and amended date for posts - Added date and amended date fields are needed for audit purposes.	IO	These dates will be displayed within the record, also should be possible to extract it for reporting purpose from the data warehouse, but this is TBC (IO) See example in #9	OPEN
19	FundingBody in Post - Is this field being discontinued in TIS?	IO	How are we mapping the funding information. Funding Body & Funding Organisation should show in Posts against funding body - ticket created TISDEV-3755 - Getting issue details... STATUS	CLOSED
20	Comments for Posts - A comments box is needed for posts.	IO	NEW ticket - to be confirmed whether it is an should be possible to TISDEV-3811 - Getting issue details... STATUS	CLOSED
21	OtherSites for Posts - This is required in order to create "bucket" posts where several sites are against single posts so that specific site details can be chosen at placement level.	IO	Current functionality to add multiple sites to a post; also need to confirm what the max upper limit is on adding sites (needs to be v high) Review whether sites will allow whole site table to be associated with a post no max in either back end or front end	CLOSED
22	Comments for Programmes - A comments box is needed for programmes	IO	NEW ticket required TISDEV-3812 - Getting issue details... STATUS	CLOSED
23	CurriculumStartDate for ProgrammeMembership - Why in the TIS ProgrammeMembership table is there a CurriculumStartDate field? The minimum curriculum start date within the programme membership would always match the programme start date. The CurriculumCompletionDate field in ProgrammeMembership needs to match the maximum curriculum end date within the related programme membership as the ProgrammeCurriculumCompletionDate does in DR2.	IO	Do we need currciulum start date as well as programme start date? They should always be the same date in most scenarios - TBC with SMLs Display only curriculum start date as editable and Programme start date should be the same as the earliest curriculum start date + read only NEW TICKET TISDEV-3813 - Getting issue details... STATUS	CLOSED
24	Rotation in ProgrammeMembership - I don't understand what the rotation field is in the TIS ProgrammeMembership table.	IO	Field to display the rotation a trainee has been added to, must be amended to multiple	CLOSED
25	AddedDate in ProgrammeMembership - ProgrammeMembership already has an amended date field but it also needs an added date field	IO	To be reviewed (IO) - new field required TISDEV-3814 - Getting issue details... STATUS	CLOSED
26	ProgrammeNTN, ProgrammePost, Site, Trust, Administrator, Assessment, Course, CourseAttendance, CurriculumMembership, Entitlement, Grade, Leave, LeaveExpense, LocalOffice - Have these tables not been developed yet?	IO	Need an updated schema to be shared with Data Leads 02-Feb:	CLOSED
27	PostSpecialty, PlacementSpecialty, CurriculumSpecialty in Specialty - Are we no longer making a distinction between PostSpecialty, PlacementSpecialty, and CurriculumSpecialty? If so, why? Or are SpecialtyTypes related to this maybe?	IO	There is still distinction between specialty types, not contained in data schema shared - to be updated and shared (see #26)	CLOSED
28	Grades in Curriculum - We need a grade list for each curriculum.	IO	Check if grade can be added to curriculum in front end - NEW TICKET TISDEV-3815 - Getting issue details... STATUS	CLOSED
29	Slot Share in placements - Have this field been removed from TIS?		Yes it has been removed - TBC is required, check Teams No further comments on this	OPEN
30	Honorary for placements - Have this field been removed from TIS?		Yes it has been removed - TBC is required, check Teams No further comments on this	OPEN
31	ITP for placements - Have this field been removed from TIS?		For the teams that are using this field, check where the secondary sites are in the back end; check Teams for further feedback on usage To be discussed and agreed with all regions: what should the standard usage process be? how should it be recorded?	OPEN
32	SLA placements - Have this field been removed from TIS?		Yes it has been removed - TBC is required, check Teams No further comments on this	OPEN

Browser not supported