Notes:
TIS will align with Oriel Reference Table and HCS Reference Table should align too.
Work done so far:
Workshop completed and user stories/feedbacks captured- Link in confluence shared with Alex
https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/1320747082/HCS+TIS+Collaboration
Fields mapping completed on TIS side and link in confluence shared with Alex
https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/1345814631/HCS+TIS+-+Field+Validation
Still to be discussed and agreed:
Suggested MVP from TIS team: Data Migration and Reporting
TIS team Fields validation findings : TIS team to do a demo of thoughts on fields validation findings with HCS (Alex and HCS programme directors)
Suggested approach for Data Migration:
Phase 1- Migration as test:: 3-4 HCS Admin to be granted access to use TIS for their daily work and other HCS Admin will continue to use HCS system. This is to ensure stability and avoid big-bang. Duration might be 2-4 weeks ( to be agreed by both parties)
Phase 2- Full migration: All HCS Admin moved to TIS. All data from HCS system to be migrated to TIS
Suggested Reporting on Tableau and Metabase
Tableau:Reporting Access given to all HCS Admin and Alex to be able to report on all data captured
Matabase:Alex to have access via SQL server Management Studio (SSMS)
Way forward after 09/04/2020 meeting:
TIS team to come up with proposal on where HCS fields will go on TIS.
TIS organised a presentation of findings in a future date with HCS
Fields from HCS
No. | Features | TIS FE Field name | HCS FE Field Name | TIS Reference table | HCS Reference table | TIS - Mandatory (Y/N) | TIS Current FE Validation & Rules | Reporting - NDW/Tableau (Y/N) | TIS BE Table name | TIS BE Field name | HCS BE Table name | HCS BE field name | NDW BE Table Name | NDW BE Field name | Comments |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Personal Details | Full Name | Should go with TIS field | N/A | N/A | Y |
| ? | ? | tblRegistration | RGFNAME RGSNAME | ? | ? | TIS Question: Anywhere this is captured in BE? | |
2 | Personal Details | PersonID Oriel Applicant ID - To be added - Future development work for TIS | Trainee ID This ID is issued in Oriel application. Person Application Code: RGSCID field in HCS. They are given when they start programme. Not system generated. From England. it is the applicant (trainee) oriel number. This is different for other part of UK. | NA | N/A | Y |
| N at the moment | Person | ID | tblRegistration | RGSCID | Vwperson | Persontisid | 02/04 TIS to align with Oriel; |
3 | PERSONAL DETAILS: Personal | Title TIS List: Mx | Title | Dr Master Miss Mr Mrs Ms Mx Prof | N |
| Contactdetails | Title | tblRegistration | RGTITLE | Vwperson | Title | 02/04 TIS to align with Oriel; | ||
4 | PERSONAL DETAILS: Personal | Forename | Forenames | N/A | N/A | Y |
| Contactdetails | Forenames | tblRegistration | RGFNAME | Vwperson | Forenames | ||
5 | PERSONAL DETAILS: Personal | Legal forenames | Not Required | N/A | N/A | N |
| Contactdetails: | Legalforenames | N/A | N/A | Vwperson | Legalforenames | ||
6 | PERSONAL DETAILS: Personal | Initials | Not required | N/A | N/A | Y |
| Contactdetails | Initials | N/A | N/A | Vwperson | Initials | ||
7 | PERSONAL DETAILS: Personal | Surname | Surname | N/A | N/A | Y |
| Contactdetails | Surname | tblRegistration | RGSNAME | Vwperson | Surname | ||
8 | PERSONAL DETAILS: Personal | Legal surname | Not Required | N/A | N/A | N |
| Contactdetails | Legalsurname | N/A | N/A | Vwperson | Legalsurname | ||
9 | PERSONAL DETAILS: Personal | Known as | Not required | N/A | N/A | N |
| Contactdetails | Knownas | N/A | N/A | Vwperson | Knownas | ||
10 | PERSONAL DETAILS: Personal | Maiden name | required | N/A | N/A | N |
| Contactdetails | Maidenname | N/A | N/A | Vwperson | Maidenname | ||
11 | PERSONAL DETAILS: Contact | Telephone number | Should go with TIS field HCS got Personal Phone or Work Phone (Go with TIS Field ) | N/A | N/A | N |
| Contactdetails | Telephonenumber | tblRegistration | RGPSPHN RGWKPHN | Vwperson | Telephonenumber |
| |
12 | PERSONAL DETAILS: Contact | Mobile number | Mobile number HCS got Personal Phone or Work Phone (Go with TIS Field ) | N/A | N/A | N |
| Contactdetails | Mobilenumber | tblRegistration | RGPSPHN??? | Vwperson:Mobilenumber | Question for HCS: Can tblRegistration.RGPSPHN be used for mobile? | ||
13 | PERSONAL DETAILS: Contact | Email address TIS keeps the preferred contact email | Email pref HCS sees it as a set back for them if they don't have the 3 email addresses Work Email or Academic or Email or Personal Email HCS will use the preferred email as the email address on TIS May need to create the 3 emails fields (professional, Personal and academic) and also preferred email field with the following drop down: Professional Personal Academic | N/A | Professional Personal Academic Above for preferred email drop down | N |
| Contactdetails | tblRegistration | RGWKEML RGPSEML ACEML | Vwperson | Emailaddress | Question for HCS: tblRegistration.RGWKEML- Personal email tblRegistration.RGPSEML - Professional email tblRegistration.ACEML - Personal email How do we work this out to know which to capture? 02/04: HCS to look into email address and decide. Might have to go with single email. 06/04: Preferred email is derived from a query. (AL) | ||
13 | PERSONAL DETAILS: Contact | Address line 1 | Address 1 | N/A | N/A | N |
| Contactdetails | Address1 | tblRegistration | RGADD1 | Vwperson | Addressline1 | ||
14 | PERSONAL DETAILS: Contact | Address line 2 | Address 2 | N/A | N/A | N |
| Contactdetails | Address2 | tblRegistration | RGADD2 | Vwperson | Addressline2 | ||
15 | PERSONAL DETAILS: Contact | Address line 3 | Address 3 | N/A | N/A | N |
| Contactdetails | Address3 | tblRegistration | RGADD3 | Vwperson | Addressline3 | ||
16 | PERSONAL DETAILS: Contact | Address line 4 | Not required | N/A | N/A | N |
| Contactdetails | Address4 | N/A | N/A | Vwperson | Addressline4 | ||
17 | PERSONAL DETAILS: Contact | Postcode | Postcode HCS receive this information from Trainee when they are starting using the Request for Information form. | N/A | N/A | N |
| Contactdetails | Postcode | tblRegistration | RGPCODE | Vwperson | Addresspostcode | ||
18 | PERSONAL DETAILS: HCPC Details | TIS to add a field | HCPC Registration number | It is only for HSST programme | ? | ? | tblRegistration | RGHCPC | ? | ? | Questions for TIS on Field and table 02/04:
| ||||
19 | PERSONAL DETAILS: HCPC Details | TIS to add a field | HCPC Status | ? | ? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table | |||||
20 | PERSONAL DETAILS: HCPC Details | TIS to add a field | HCPC start date | ? | ? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table Should it be the start date of the programme? | |||||
21 | PERSONAL DETAILS: HCPC Details | TIS to add a field | HCPC end date | ? | ? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table Should it be the end date of the programme? | |||||
22 | PERSONAL DETAILS: GMC Details | GMC | Not Required | N/A | N/A | Y |
| Gmcdetails | Gmcnumber | N/A | N/A | Vwperson | Gmcnumber | ||
23 | PERSONAL DETAILS: GMC Details | GMC status | Not Required | N/A | N |
| Gmcdetails | Gmcstatus | N/A | N/A | Vwperson | Gmcstatus | |||
24 | PERSONAL DETAILS: GMC Details | GMC start date | Not Required | N/A | N/A | N |
| Gmcdetails | Gmcstartdate | N/A | N/A | Vwperson | Gmcstartdate | ||
25 | PERSONAL DETAILS: GMC Details | GMC end date | Not Required | N/A | N/A | N |
| Gmcdetails | Gmcenddate | N/A | N/A | Vwperson | Gmcexpirydate | ||
26 | PERSONAL DETAILS: GDC Details | GDC | Should go with TIS field | N/A | N/A | Y |
| Gdcdetails | Gdcnumber | ? | ? | Vwperson | Gdcnumber | Questions for HCS on Field and table | |
27 | PERSONAL DETAILS: GDC Details | GDC status | Should go with TIS field | N/A | N |
| Gdcdetails | Gdcstatus | ? | ? | Vwperson | Gdcstatus | Questions for HCS on Field and table | ||
28 | PERSONAL DETAILS: GDC Details | GDC start date | Should go with TIS field | N/A | N/A | N |
| Gdcdetails | Gdcstartdate | ? | ? | Vwperson | Gdcstartdate | Questions for HCS on Field and table Should it be the end date of the programme? | |
29 | PERSONAL DETAILS: GDC Details | GDC end date | Should go with TIS field | N/A | N/A | N |
| Gdcdetails | Gdcenddate | ? | ? | Vwperson | Gdcexpirydate | Questions for HCS on Field and table Should it be the end date of the programme? | |
30 | PERSONAL DETAILS: PH Details | PH Public health number | Not Required | N/A | N/A |
| Person | Publichealthnumber | N/A | N/A | Vwperson | Publichealthnumber | |||
31 | PERSONAL DETAILS: | College Not display in TIS FE | Not Required | In TIS ref.table | N/A | N |
| College | Name | N/A | N/A | ? | ? | Questions for TIS on Field and table | |
32 | PERSONAL DETAILS: Sensitive Data | EEA Resident TIS List: YES NO UNKNOWN | Should go with TIS field | Need to see how it's display in HCS front end | N |
| Righttowork | Eearesident | ? | ? | Vwperson | Eearesident | Questions for HCS on Field and table 02/04 To use Oriel Reference table for these fields Right to work - TIS/HCS (pulls from Oriel) To use Oriel Reference table for these fields | ||
33 | PERSONAL DETAILS: Sensitive Data | Permit to work TIS List:
| Should go with TIS field | Need to see how it's display in HCS front end | N |
| Righttowork | Permittowork | ? | ? | Vwperson | Permittowork | Questions for HCS on Field and table 02/04 To use Oriel Reference table for these fields | ||
30 | PERSONAL DETAILS: Sensitive Data | Settled TIS List: YES NO | Should go with TIS field | Need to see how it's display in HCS front end | N |
| Righttowork | Settled | ? | ? | Vwperson | Settled | Questions for HCS on Field and table 02/04 To use Oriel Reference table for these fields | ||
34 | PERSONAL DETAILS: Sensitive Data | Visa issued | Should go with TIS field | N/A | Need to see how it's display in HCS front end | N |
| Righttowork | Visaissued | ? | ? | Vwperson | Visaissued |
| |
35 | PERSONAL DETAILS: Sensitive Data | Visa valid to | Should go with TIS field | N/A | Need to see how it's display in HCS front end | N |
| Righttowork | Visavalidto | ? | ? | Vwperson | Visavalidto | Questions for HCS on Field and table | |
36 | PERSONAL DETAILS: Sensitive Data | Visa details | Should go with TIS field | N/A | Need to see how it's display in HCS front end | N |
| Righttowork | Visadetails | ? | ? | Vwperson | Visadetails |
| |
37 | PERSONAL DETAILS: Sensitive Data | NI number Not display in TIS FE | Not Required | N/A | Need to see how it's display in HCS front end | N |
| Personaldetails | Nationalinsurancenumber | N/A | N/A | ? | ? | Questions for TIS on Field and table | |
38 | PERSONAL DETAILS: Sensitive Data: Diversity | Date of birth | Date of Birth | N/A | N/A | N |
| Personaldetails | Dateofbirth | tblRegistration | RGDOB | Vwperson | Dateofbirth | TIS pull from Oriel (to workout for non-English trainees) | |
39 | PERSONAL DETAILS: Sensitive Data: Diversity | Age | Not required | N/A | N/A | N |
| ? | Not captured in BE? | N/A | N/A | ? | ? | Questions for TIS on Field and table | |
40 | PERSONAL DETAILS: Sensitive Data: Diversity | Gender TIS List: Male | Gender | Male Female Other Not Stated Non-Binary | N |
| Personaldetails | Gender | tblRegistration | RGGEN | Vwperson | Gender | 02/04 To use Oriel Reference table for these fields | ||
41 | PERSONAL DETAILS: Sensitive Data: Diversity | Nationality | Countries | See list of Countries in the HCS reference table spreadsheet | N |
| Personaldetails | Nationality | tblRegistration | RGNAT | Vwperson | Nationality | |||
42 | PERSONAL DETAILS: Sensitive Data: Diversity | Dual nationality | Not Required | N/A | N |
| Personaldetails | Dualnationality | N/A | N/A | Vwperson | Nationalitydual | |||
43 | PERSONAL DETAILS: Sensitive Data: Diversity | Ethnic origin TIS List: Not stated | Ethnicity | White - British | N |
| Personaldetails | Ethnicorigin | tblRegistration | RGETH | Vwperson | Ethnicorigin | 02/04 Aligning to Oriel Ref. Table | ||
44 | PERSONAL DETAILS: Sensitive Data: Diversity | Marital status | Not Required | N/A | N |
| Personaldetails | Maritalstatus | N/A | N/A | Vwperson | Maritalstatus | |||
45 | PERSONAL DETAILS: Sensitive Data: Diversity | Sexual orientation | Not Required | N/A | N |
| Personaldetails | Sexualorientation | N/A | N/A | Vwperson | Sexualorientation | |||
46 | PERSONAL DETAILS: Sensitive Data: Diversity | Religious belief TIS List: Atheism | Religion | Atheism Baha'i | N |
| Personaldetails | Religiousbelief | tblRegistration | RGREL | Vwperson | Religiousbelief | 02/04 To use Oriel Reference table for these fields | ||
47 | PERSONAL DETAILS: Sensitive Data: Diversity | Disability TIS List: YES NO | Disability | Yes, limited a little | N |
| Personaldetails | Disability | tblRegistration | RGDISAB | Vwperson | Disability | 02/04 To use Oriel Reference table for these fields | ||
48 | PERSONAL DETAILS: Sensitive Data: Diversity | Disability details comes from Oriel and free text | Should go with TIS field Captured only when trainee is registering | N/A | N/A | N |
| Personaldetails | Disabilitydetails | tblRegistration | RGDSDET | Vwperson | Disabilitydetails | ||
49 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | Roles | Should go with TIS field | Contact Type: Training Coordinator This to also include 'Training Officer' | N |
| Person | Role | tblTraineeContacts | CNTYPE | Vwperson | Role | |||
50 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | Comments | Comments
| N/A | N/A | N |
| Person | Comments | ? | ? | Vwperson | Comments | Questions for HCS on Field and table | |
51 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | Training Status This can be captured on TIS placement. Current/Inactive | Status | Some can be captured in Placement and Programme status? Active - FT | Y |
NB: leave "Delete" as a status within the drop downs (as long as it is soft delete) | Person | Status | tblRegistration | RGSTAT | Vwperson | Status | 02/04: TIS: Some to go into placement type, leaving reasons etc . TIS to decide where to place each. | ||
52 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | TIS: why HCS needs this? | AFC Band | Alex response: HCS Post-training Data AFC Grade can be added to placement? Band 1 | ? | TIS to create? | tblRegistration | RGFJBAND | ? | ? | Questions for TIS on Field and table TIS to decide under what heading this will go HCS to confirm if it also comes from Oriel 02/04: This is HCS outcome data. Post -Training - Destination data. Critical to HCS TIS: To look at best way to do this e.g maybe leaving destination | ||||
53 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | TIS: why HCS needs this? | First Job Type | Alex response: HCS Post- training Data Healthcare: NHS | ? | TIS to create? | tblRegistration | RGFJTP | ? | ? | Questions for TIS on Field and table TIS to decide under what heading this will go e.g Personal details/sensitive data... HCS to confirm if it also comes from Oriel 02/04 Critical to HCS TIS: To look at best way to do this e.g maybe leaving destination | ||||
54 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | TIS: why HCS needs this? Why do you need Salary if you've got AFC bands? | Salary | Alex response: HCS Post- training Data < £20,000 | ? | TIS to create? | tblRegistration | RGFJSAL | ? | ? | Questions for TIS on Field and table TIS to decide under what heading this will go e.g Personal details/sensitive data... HCS to confirm if it also comes from Oriel 02/04 HCS: Potentially out? HCS to confirm If not, TIS: To look at best way to do this e.g maybe leaving destination | ||||
55 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | TIS: why HCS needs this? TIS already record WTE (Whole Time Equivalent) in placement. What do you need to report here? | Contract Type | Alex response: HCS Post -training Data Permanent (Full Time) | ? | TIS to create? | tblRegistration | RGFRCNT | ? | ? | Questions for TIS on Field and table TIS WTE is represented with numbers e.g 0.3 - 3 months, 0.8 - 8 months, 1 - 1 year HCS WTE ???? TIS to decide under what heading this will go e.g Personal details/sensitive data/Placement/Programme membership HCS to confirm if it also comes from Oriel 02/04: TIS: To look at best way to do this e.g maybe leaving destination | ||||
56 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | Inactive from date Not display in TIS FE | Not required | N/A | N/A | N |
| Person | Inactivefromdate | N/A | N/A | Vwperson | Inactivedate | ||
57 | PERSONAL DETAILS: Sensitive Data: Manage Record Function | Inactive notes Not display in TIS FE | Not required | N/A | N/A | N |
| Person | Inactivenotes | N/A | N/A | Vwperson | Inactivenotes | ||
59 | PERSONAL DETAILS: QUALIFICATIONS | Qualification | Should this be Qualification Subjects for HCS? | To speak to Alex on this | N | Free text | Qualification | Qualification | tblPrevQual | QUSUBJ | Vwpersonqualification | Qualification | Qualification - TIS pull from Oriel (to workout for non-English trainees) Free text on TIS and there is reference table for HCS | ||
60 | PERSONAL DETAILS: QUALIFICATIONS | Qualification type TIS List: Bachelors Degree | Qualification type | BEng BA | N |
| Qualification | Qualificationtype | tblPrevQual | QUNAME | Vwpersonqualification | Qualificationtype | Align with Oriel | ||
61 | PERSONAL DETAILS: QUALIFICATIONS | This comes from Oriel for TIS | Qualification Mark | 1st | ? | TIS to create? | tblPrevQual | QUMARK | ? | ? | Questions for TIS on Field and table Align with Oriel | ||||
62 | PERSONAL DETAILS: QUALIFICATIONS | Qualification for TIS which is free text? | Qualification Subject Quite a large list of subjects | See long list in HCS Reference table. About 523 subjects on the list | ? | TIS to create? | tblPrevQual | QUSUBJ | ? | ? | Questions for TIS on Field and table Align with Oriel 06/04 How is this diff than line 54? | ||||
63 | PERSONAL DETAILS: QUALIFICATIONS | Certification Type | Attainment Equivalence | ? | ? | N/A | N/A | ? | ? | 02/04 No longer required | |||||
64 | PERSONAL DETAILS: QUALIFICATIONS | Date attained | Qualification Year | N/A | N/A | N |
| Qualification | Qualificationattaineddate | ? | ? | Vwpersonqualification | Dateattained | Questions for HCS on Field and table | |
65 | PERSONAL DETAILS: QUALIFICATIONS | Month attained Not display in TIS FE | Not Required | N/A | N/A | N |
| ? | Not in BE | N/A | N/A | Vwpersonqualification | Monthattained | ||
66 | PERSONAL DETAILS: QUALIFICATIONS | Year attained Not display in TIS FE | Not Required | N/A | N/A | N |
| ? | Not in BE | N/A | N/A | Vwpersonqualification | Yearattained | TIS question | |
67 | PERSONAL DETAILS: QUALIFICATIONS | Medical school | University | See long list of universities in HCS reference table | N |
| Qualification | Medicalschool | ? | ? | Vwpersonqualification | Medicalschool | Questions for HCS on Field and table 02/04 University trainee got degree Two different fields to be considered:
| ||
68 | PERSONAL DETAILS: QUALIFICATIONS | Country of qualification | Not Required | See long list of countries in HCS reference table | N |
| Qualification | Countryofqualification | N/A | N/A | Vwpersonqualification | Country | |||
69 | PERSONAL DETAILS: QUALIFICATIONS | TIS: why HCS needs this? | Qualification Verified By School? | Alex Response: TBC Yes No | N/A | N/A | N/A | N/A | N/A | N/A | 02/04: No longer required | ||||
70 | PROGRAMME MEMBERSHIP : Programme | Programme name | Should go with TIS field | List of Programme types | Y |
| Programme | Programmename | ? | ? | Vwprogramme | Programmename | Questions for HCS on Field and table Might be required if specialism will be listed under a programme 02/04: Programmes are: STP Apprenticeships???? | ||
71 | PROGRAMME MEMBERSHIP : Programme | Can add their Specialism to our programme | Specialism TIS curriculum fields be use for HCS specialism? Let us test and see how it will look like? No, as curriculum will be required | See long list of specialism in HCS reference table | ? Specialty | TIS to create? Name | ? | ? | ? Vwspecialty | ? Specialtyname | Questions for HCS and TIS on Field and table Curriculum is also required as it will be linked to specialism both linked to a programme 02/04 add to curriculum specialty table | ||||
72 | PROGRAMME MEMBERSHIP : Programme | add to the list of drop down in membership type in Programme membership type or be created as a filed? TIS List: Programmemembershiptype: SUBSTANTIVE | Program Type | STP HSST PTP ASP Apprenticeships???? | ? Programmemembership | TIS to create? Programmemembershiptype | ? | ? | ? Vwprogrammerotationmembership | ? Membershiptype | Questions for HCS and TIS on Field and table
02/04:
| ||||
73 | PROGRAMME MEMBERSHIP : Programme | Professional Leads | ? | TIS to create? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table | ||||||
74 | PROGRAMME MEMBERSHIP : Programme | Can go under academic curricula | ASP Type | Alex Response: dependent on Program Type being chosen as "ASP" Upper GI Physiology (STP) Lower GI Physiology Upper & Lower GI Physiology Lower GI Physiology (no rotation) Upper GI Phyiology (UGI Only) | ? | TIS to create? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table Do you have other types for other programmes that TIS need to capture? 02/04
| ||||
75 | PROGRAMME MEMBERSHIP : Programme | Need to know how to display this Might be added to programme type | Entry Type | Direct Entry In-Service | ? | TIS to create? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table 02/04 TIS: add to programme type. TIS to look at
| ||||
76 | PROGRAMME MEMBERSHIP : Programme | Programme number. TIS example: EOE922 | HCS might need to come up with the unique code for their programmes | Alex Response: What is a programme number? Programmes are STP, ASP, PTP, PGDip, HSST Ade: Is there any sub-programme associated to each programme? N/A | Y |
| Programme | Programmenumber | ? | ? | Vwprogramme | Programmenumber | Questions for HCS on Field and table What are the programmes and sub-programmes HCS has got so that TIS can help to come up with Programme Number for them? 02/04
| ||
77 | PROGRAMME MEMBERSHIP : Programme | Owner This is programme owner on TIS | Should go with TIS field | Should be pre-populated with HCS???? | Y |
| Programme | Owner | ? | ? | Vwprogramme | Managingdeanery | Questions for HCS on Field and table For TIS - the HEE local offices owns the programmes 02/04 Pre-populated with NSHCS | ||
78 | PROGRAMME MEMBERSHIP : Programme | Programme start date | Should go with TIS field | N/A | N/A | Y |
| Programmemembership | Programmestartdate | ? | ? | Vwprogrammerotationmembership | Programmestartdate | Questions for HCS on Field and table HCS need to have both curriculum and programme | |
79 | PROGRAMME MEMBERSHIP : Programme | Programme end date | Should go with TIS field | N/A | N/A | Y |
| Programmemembership | Programmeenddate | ? | ? | Vwprogrammerotationmembership | Programmeenddatewithprog | Questions for HCS on Field and table HCS need to have both curriculum and programme | |
80 | PROGRAMME MEMBERSHIP : Programme | Programme membership type TIS List:
| Should go with TIS field | Alex Response: I don't think this is necessary Ade: If not required, we might have to look at the impact on other fields from our end. Pre- populated as 'Substantive' | Y |
| Programmemembership | Programmemembershiptype | ? | ? | Vwprogrammerotationmembership | Membershiptype | Questions for HCS on Field and table 02/04 Required for HCS
| ||
81 | PROGRAMME MEMBERSHIP : Programme | Rotation name | Not Required | See: TIS UI Fields - Dropdowns & Programmes - Rotations - Solution Design, Field Validation & Scenarios | Alex Response: We don't do rotations like medical N/A It is managed in the work place | N |
| Programmemembership | Rotation | N/A | N/A | Vwprogrammerotationmembership | Rotation | ||
82 | PROGRAMME MEMBERSHIP : Programme | Leaving reason Leaving Reason on TIS should do the job for HCS rather than destination. Leaving Reason: TIS List: SUBSTANTIVE | Leaving Destination or Leaving Reason? This is after training finish programme. | Alex Response: When trainee finishes programme Healthcare: NHS Healthcare: Non-NHS Not Employed HSST Other/Non-Healthcare | N |
| Programmemembership | Leavingdestination | ? | ? | Vwcurriculummembership | Leavingdestination | Questions for HCS on Field and table 02/04 TIS/HCS still need to look at how to manage this. Leave in-between programme - Falls under absence issue field in HCS system ( need a place to capture this also)? Should leave in-between programme be added to the list or a separate field be created?
| ||
83 | PROGRAMME MEMBERSHIP : Programme | Should be part of TIS placement/Assessment | Status |
Current Passed Incomplete (Extension) Incomplete (Fail) Leaver Suspended | ? | TIS to create? | ? | ? | ? | ? | Questions for TIS and HCS on Field and table 09/04 OLAT Status - legacy data to be decided by HCS where they go. TS: Can help to add the OLAT into NDW. Is OLAT status required? Is part of completion requirement which needs to be reported | ||||
84 | PROGRAMME MEMBERSHIP : Programme | Training pathway This must be related to the curriculum/Programme TIS List: CCT CESR N/A | HSST Pathway | LS1FRCPath LS2FRCPath & PGDip LS3FRCPath & DClinSci PS1DClinSci PS2DClinSci & CEng PS3PGDip PS4PGDip & CEng | ? | ? | ? | ? | Vwcurriculummembership | Trainingpathway | Questions for HCS and TIS on Field and table
These are different programme pathways which are the requirement to meet in HSST. TIS: Specialty/sub-specialty…? | ||||
85 | PROGRAMME MEMBERSHIP : Programme | Training number | Not required | N/A | Alex Response: Dependent on Program Type being chosen as "HSST" Ade: Don't think it is required since it might be covered in Programm number- 70 |
| Trainingnumber | Trainingnumber | N/A | N/A | Vwcurriculummembership | Trainingnumber | 09/04 | ||
86 | PROGRAMME MEMBERSHIP - Curriculum | Curriculum | HCS needs to keep curriculum Alex: There are codes in HCS of how they log their curriculum. Unique identifier. Alex to supply the code if there is need for it | Y |
| Curriculum | Name | ? | ? | Vwcurriculum | Name | Questions for HCS on Field and table (HCS are stored on a separate website called Curriculum library - HCS want to keep this) | |||
87 | PROGRAMME MEMBERSHIP - Curriculum | Why do HCS need this? | HSST Cohort | Alex Response: To determine timing of completion and assessments
| ? | TIS to create? | ? | ? | ? | ? | Questions for HCS and TIS on Field and table 09/04 Trainee goes into cohort that meets their completion dates. TIS uses trainee completion date. | ||||
88 | PROGRAMME MEMBERSHIP - Curriculum | Curriculum start date | Required for HCS | N/A | Alex Response: Not needed as start dates will always be programme start date. Not sure if these are needed as curriculum does not change during training Ade: we'll look at the impact from our end N/A | Y |
| Programmemembership | Curriculumstartdate | ? | ? | Vwcurriculummembership | Curriculumstartdate | Questions for HCS on Field and table | |
89 | PROGRAMME MEMBERSHIP - Curriculum | Curriculum end date | Required for HCS | N/A | Alex Response: Not sure if these are needed as curriculum does not change during training Ade: we'll look at the impact from our end N/A | Y |
| Programmemembership | Curriculumenddate | ? | ? | Vwcurriculummembership | Curriculumenddate | Questions for HCS on Field and table
| |
90 | PROGRAMME MEMBERSHIP - Curriculum | Curriculum sub-type Not display in TIS FE | Go with TIS field | Alex Response: This is useful for some of our specialities where they branch off - can provide a list at later date | N | N/A | Curriculum | Curriculumsubtype | N/A | N/A | Vwcurriculummembership | Curriculumsubtype |
HCS Curriculum sub-type | ||
91 | PROGRAMME MEMBERSHIP - Curriculum | Curriculum specialty Not display in TIS FE | Can specialism comes here? | Alex Response: Not sure if these are needed as curriculum does not change during training Ade: we'll look at the impact from our end N/A | N | N/A | ? | ? | ? | ? | ? | ? | Questions for HCS and TIS on Field and table 09/04 HCS specialism comes in here | ||
92 | PLACEMENTS: Post | National post number | HCS need post number - they need to come up with algorithm. TIS to share their Algorithm | N/A (Refer to Post list) | Alex Response: May take post number from ORIEL - not sure yet if this is necessary TIS: NPN derived from the deanery, Site, Specialty and Grade tables e.g. NTH/RTD01/080/STR/005 N/A | Y |
| Post | Nationalpostnumber | ? | ? | Vwpost | Nationalpostnumber | Questions for HCS on Field and table 09/04 HCS Posts - will be assigned npn | |
93 | PLACEMENTS: Post | Why do HCS need this? Because placement history will be available in TIS | Previous Post | Healthcare: NHS If other - Another field create? | ? | TIS to create? | ? | ? | ? | ? | Questions for HCS and TIS on Field and table 09/04 This explains what trainee was doing before coming on the programme. TIS: this may go into NDW but not FE | ||||
94 | PLACEMENTS: Post | Specialty | Not Required | Alex Response: Not needed Check list of specialism from HCS reference table | Y |
| Specialty | Name | N/A | N/A | Vwspecialty | Specialtyname | 09/04 | ||
95 | PLACEMENTS: Post | Other specialties | Not required | Alex Response: Not needed N/A | N |
| ? | ? | N/A | N/A | ? | ? | Questions for TIS on Field and table | ||
96 | PLACEMENTS: Post | Sub specialty | Not Required | ? | ? | N/A | N/A | Vwspecialty | Subspecialty | ||||||
97 | PLACEMENTS: Post | Site | Hospital/Trainee Sites . | See list in HCS Ref. for Hospital exact site trainee work at Need a list to use from the reference table (HEI, Trusts, university or Hospital?) | Y |
| Site | Sitename/Siteknownas? | ? | ? | Vwsite | Sitename/Siteknownas? | Question for TIS and HCS on Field and table Hospital/Trainee Sites? 09/04 List from ODS and private providers for HCS Employers - Hospital Trainee sites- training site | ||
98 | PLACEMENTS: Post | Other sites | ? | ? | ? | ? | ? | Vwpostothersite | Sitename/Siteknownas? | Question for TIS and HCS on Field and table | |||||
99 | PLACEMENTS: Post | TIS to explain how the post funding works and how HCS will set this up. TIS post funding | Trusts | Is the employer Need a list to use from the reference table (HEI, Trusts, university or Hospital?) TIS need to cover non-nhs/ODS list employer. Hcs to provide TIS the list of this TIS to capture employer and the exact site trainee work at. They are separate fields | Trust | Trustname/Trustknownas? | ? | ? | Vwtrust | Trustname/Trustknownas? | Question for TIS and HCS on Field and table | ||||
100 | PLACEMENTS: Post | Why do HCS need this? TIS Already got UK universities TIS - All TIS academic training goes through HEI | HEI | Aston University | ? | TIS to create? | ? | ? | ? | ? | Question for TIS and HCS on Field and table
Certain programme associated to certain universities. TIS: Future work on academic curricular | ||||
101 | PLACEMENTS: Post | Local post number | Not required | N/A | N/A | N |
| Post | Localpostnumber | N/A | N/A | Vwpost | Localpostnumber | ||
102 | PLACEMENTS: Post | Grade | Not Required?? We can add the band grade here ? | Alex Resonse: All trainees are on the same band. | Y |
| Grade | Name | ? | ? | Vwgrade | Gradename | Question for HCS on Field and table 09/04 This is collected at the end of programme for HCS. - Progression within curriculum | ||
103 | PLACEMENTS: Post | Owner | LETB | Alex response: Need a freetext addition in case 'Split Funding, 'Private funding' or 'Employer-funded' are selected Pre-populated with NSHCS LETB: HEE East Midlands | N |
| Post | Owner | ? | ? | ? | ? | Question for TIS and HCS on Field and table 09/04 TIS- Local Office HCS - Funding provider. this might not be region based. | ||
104 | PLACEMENTS: Post | Training description | ? | Post | Trainingdescription | ? | ? | Vwpost | Trainingdescription | Question for HCS on Field and table | |||||
105 | PLACEMENT: Placement, Supervisor and Approval | Placement type TIS list: OOPC | Placement type | Alex Response: What is a placement type? Ade: Shows the current situation of trainee; In post, In Post- Acting Up, In post - Extension, Long- term sick,OOPC, OOPE…. Check Status | Y |
| Placement | Placementtype | ? | ? | Vwplacement | Placementtype | Question for HCS on Field and table 09/04 HCS - record programme maternity might be cover here | ||
106 | PLACEMENT: Placement, Supervisor and Approval | Date from | Should go with TIS field | N/A | N/A | Y |
| Placement | Datefrom | ? | ? | Vwplacement | Startdate | Question for HCS on Field and table | |
107 | PLACEMENT: Placement, Supervisor and Approval | Date to | Should go with TIS field | N/A | N/A | Y |
| Placement | Dateto | ? | ? | Vwplacement | Enddate | Question for HCS on Field and table | |
108 | PLACEMENT: Placement, Supervisor and Approval | Comment | Not required | N/A | Alex Response: Not Required N/A |
| ? | ? | N/A | N/A | Vwplacement | Comments | Question for TIS on Field and table | ||
109 | PLACEMENT: Placement, Supervisor and Approval | Whole time equivalent | To be captured especially for HSST | N/A | N/A | Y |
| Placement | Placementwholetimeequivalent | ? | ? | Vwplacement | Wholetimeequivalent | Question for HCS on Field and table | |
110 | PLACEMENT: Placement, Supervisor and Approval | Status TIS list: CURRENT PAST FUTURE | Should go with TIS field | Alex Response: Same as Field 48? Ade: This status is about Placement status; Past, Current and Future in TIS | N |
| Placement | Status | ? | ? | Vwplacement | Status | Question for HCS on Field and table | ||
111 | PLACEMENT: Placement, Supervisor and Approval | Educational Supervisor | Covered under Placement supervisor in TIS | N/A | N/A | N |
| ? | ? | ? | ? | Vwplacementsupervisor | Supervisorforenames Supervisorsurname | Question for TIS and HCS on Field and table | |
112 | PLACEMENT: Placement, Supervisor and Approval | Clinical Supervisor | Covered under Placement supervisor in TIS | N/A | N/A | N |
| ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |
113 | PLACEMENT: Placement, Supervisor and Approval | Approval TIS List: APPROVED DRAFT | Is this required? | ? | ? | ? | ? | Vwplacement | Lifecyclestate | Question for TIS and HCS on Field and table | |||||
114 | ASSESSMENT : Event | Trainee First Name | Should go with TIS field | Assessment | Firstname | ? | ? | Vwassessment | Forenames | Question for HCS on Field and table | |||||
115 | ASSESSMENT : Event | Trainee Surname | Should go with TIS field | Assessment | Lastname | ? | ? | Vwassessment | Surname | Question for HCS on Field and table | |||||
116 | ASSESSMENT : Event | Type TIS List: ACADEMIC | Should go with TIS field | Assessment | Type | ? | ? | Vwassessment | Assessmenttype | Question for HCS on Field and table
| |||||
117 | ASSESSMENT : Event | Review Date | Should go with TIS field | Assessment | Reviewdate | ? | ? | Vwassessment | Reviewdate | Question for HCS on Field and table | |||||
118 | ASSESSMENT : Event | Programme Number | Should go with TIS field | Assessment | Programmenumber | ? | ? | Vwassessment | Programmenumber | Question for HCS on Field and table | |||||
119 | ASSESSMENT : Event | Programme name | Should go with TIS field | Assessment | Programmename | ? | ? | Vwassessment | Programmename | Question for HCS on Field and table | |||||
120 | ASSESSMENT : Pre-Assessment Detail | Curriculum name | Should go with TIS field | Assessmentdetail | Curriculumname | ? | ? | Vwassessment | Curriculumname | Question for HCS on Field and table | |||||
121 | ASSESSMENT : Pre-Assessment Detail | Curriculum specialty | Should go with TIS field | Assessmentdetail | Curriculumspecialty | ? | ? | Vwassessment | Specialtyname?? | Question for HCS on Field and table | |||||
122 | ASSESSMENT : Pre-Assessment Detail | Curriculum sub-type | Should go with TIS field | Assessmentdetail | Curriculumsubtype | ? | ? | Vwassessment | Curriculumsubtype | Question for HCS on Field and table | |||||
123 | ASSESSMENT : Pre-Assessment Detail | WTE months OOPR/T during period (out of programme research or training) | Should go with TIS field | Assessmentdetail | Monthswteduringperiod | ? | ? | Vwassessment | Wtemonthsooprt | Question for HCS on Field and table | |||||
124 | ASSESSMENT : Pre-Assessment Detail | PYA (penultimate year assessment) TIS list: YES NO | Should go with TIS field | Assessmentdetail | Pya | ? | ? | Vwassessment | pya | Question for HCS on Field and table | |||||
125 | ASSESSMENT : Pre-Assessment Detail | Days out of training | Should go with TIS field | Assessmentdetail | Daysoutoftraining | ? | ? | Vwassessment | Timeoutoftrainingdays | Question for HCS on Field and table | |||||
126 | ASSESSMENT : Pre-Assessment Detail | Curriculum start date | Should go with TIS field | Assessmentdetail | Curriculumstartdate | ? | ? | Vwassessment | Curriculumstartdate | Question for HCS on Field and table | |||||
127 | ASSESSMENT : Pre-Assessment Detail | Curriculum end date | Should go with TIS field | Assessmentdetail | Curriculumenddate | ? | ? | Vwassessment | Curriculumenddate | Question for HCS on Field and table | |||||
128 | ASSESSMENT : Pre-Assessment Detail | Membership type | Should go with TIS field | Assessmentdetail | Membershiptype | ? | ? | Vwcurriculummembership | Membershiptype | Question for HCS on Field and table | |||||
129 | ASSESSMENT : Pre-Assessment Detail | Period covered from | Should go with TIS field | Assessmentdetail | Periodcoveredfrom | ? | ? | Vwassessment | Periodcoveredfrom | Question for HCS on Field and table | |||||
130 | ASSESSMENT : Pre-Assessment Detail | Period covered to | Should go with TIS field | Assessmentdetail | Periodcoveredto | ? | ? | Vwassessment | Periodcoveredto | Question for HCS on Field and table | |||||
131 | ASSESSMENT : Pre-Assessment Detail | Months OOPR/OOPT counted towards training | Should go with TIS field | Assessmentdetail | Monthscountedtotraining | ? | ? | Vwassessment | Trainingmonthsooprt | Question for HCS on Field and table | |||||
132 | ASSESSMENT : Pre-Assessment Detail | Grade at time | Should go with TIS field | Assessmentdetail | Gradename | ? | ? | Vwdrade | Gradename | Question for HCS on Field and table Not sure if Gradename is the BE for TIS | |||||
133 | ASSESSMENT : Post- Assessment- Outcome | Outcome TIS List: Not ASSESSED 1 | Review Outcome | N/A | N | Read only - derived from assessment | Assessmentoutcome | Outcome | ? | ? | Vwassessment | Outcome | 09/04 HCS - don’t use code Question for HCS on Field and table Question for HCS on Field and table See different outcomes in Reference table for STP and HSST | ||
134 | ASSESSMENT : Post- Assessment- Outcome | Why do you need this? | MSc Outcome | Post- Assessment- Outcome Pass Merit Distinction Fail Alex Response: We manage the training programme, of which MSc is part. | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | ||||
135 | ASSESSMENT : Post- Assessment- Outcome | Why do you need this? | OSFA Result - Must have | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
136 | ASSESSMENT : Post- Assessment- Outcome | Why do you need this? | OSFA Type - Must have | Post- Assessment- Outcome Full Mock Resit Alex Response: This is the trainees' final assessments. Absolutely must have. | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | ||||
137 | ASSESSMENT : Post- Assessment- Outcome | Why do you need this? | OSFA Result - Must have | Post- Assessment- Outcome Pass Fail Alex Response: This is the trainees' final assessments. Absolutely must have. | Read only - derived from assessment | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||
138 | ASSESSMENT : Post- Assessment- Outcome | Under Appeal TIS List: YES NO | Should go with TIS field | Read only - derived from assessment | Assessmentoutcome | Underappeal | ? | ? | Vwassessment | Appealed | Question for HCS on Field and table | ||||
139 | ASSESSMENT : Post- Assessment- Reason | Reason | Should go with TIS field | Assessmentoutcome | Reason | ? | ? | Vwassessment | Detailedreasonforrecommendedoutcome | Question for HCS on Field and table | |||||
140 | ASSESSMENT : Post- Assessment- Reason | Other | Should go with TIS field | Assessmentoutcomereason | Other | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
141 | ASSESSMENT : Post-assessment - Details | External trainer TIS List: YES NO | Should go with TIS field | N/A | Post-assessment - Details N/A Alex Response: What is this? Ade: External trainer is a trainer who has not been supervising the trainee as part of their training.It is a YES or NO dropdown in TIS | N | Read only - derived from assessment | Assessmentoutcome | Externaltrainer | ? | ? | Vwassessment | Externaltrainer | Question for HCS on Field and table | |
142 | ASSESSMENT : Post-assessment - Details | Next review date | Should go with TIS field | Assessmentoutcome | Nextreviewdate | ? | ? | Vwassessment | Nextreviewdate | Question for HCS on Field and table | |||||
143 | ASSESSMENT : Post-assessment - Details | Completion of training date (prior to review) | Should go with TIS field | Assessmentoutcome | Trainingcompletiondate | ? | ? | Vwassessment | Trainingcompletiondateprereview | Question for HCS on Field and table | |||||
144 | ASSESSMENT : Post-assessment - Details | Grade at next rotation | Should go with TIS field | Assessmentoutcome | Nextrotationgradename | ? | ? | Vwassessment | Gradeatnextrotationgradename | Question for HCS on Field and table | |||||
145 | ASSESSMENT : Post-assessment - Details | Comments | Should go with TIS field | Assessmentoutcome | Comments | ? | ? | Vwassessment | Comments | Question for HCS on Field and table | |||||
146 | ASSESSMENT : Post-assessment - Academic Progression | Academic curriculum assessed | Should go with TIS field | Assessmentoutcome | Academiccurriculumassessed | ? | ? | Vwassessment | Academiccurriculumassessed | Question for HCS on Field and table | |||||
147 | ASSESSMENT : Post-assessment - Academic Progression | Academic outcome TIS list: Continue on academic component Do not Continue on academic component Successfully completed academic component | Should go with TIS field | Assessmentoutcome | Academicoutcome | ? | ? | Vwassessment | Academicoutcome | Question for HCS on Field and table | |||||
148 | ASSESSMENT : Post-assessment - Supplementary Details | Detailed reason | Should go with TIS field | Assessmentoutcome | Detailedreasons | ? | ? | Vwassessment | Detailedreasonsforrecommendedoutcome | Question for HCS on Field and table | |||||
149 | ASSESSMENT : Post-assessment - Supplementary Details | Competences which need to be developed by next ARCP | Should go with TIS field | Assessmentoutcome | Competencestobedeveloped | ? | ? | Vwassessment | Competenceswhichneedtobedeveloped | Question for HCS on Field and table | |||||
150 | ASSESSMENT : Post-assessment - Supplementary Details | Recommended additional training time (if required) | Should go with TIS field | Assessmentoutcome | Recommendedaddtnltrainingtime | ? | ? | Vwassessment | Recommendedadditionaltrainingtime | Question for HCS on Field and table | |||||
151 | ASSESSMENT : Post-assessment - Supplementary Details | Mitigating circumstances | Should go with TIS field | Assessmentoutcome | Mitigatingcircumstances | ? | ? | Recommended additional training time | Mitigatingcircumstances | Question for HCS on Field and table | |||||
152 | ASSESSMENT : Post-assessment - Supplementary Details | Other recommended actions | Should go with TIS field | Assessmentoutcome | Otherrecommendedactions | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
153 | ASSESSMENT : Post-assessment - Supplementary Details | Additional comments from the panel | Should go with TIS field | Assessmentoutcome | Addcommentsfrompanel | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
154 | Documents | Add documents | Should go with TIS field | ? | ? | ? | ? | ? | ? | TIS/HCS to think of bulk upload document from SharePoint Question for TIS and HCS on Field and table | |||||
155 | Documents | Filter by tag | Should go with TIS field | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
156 | Documents | Search documents | Should go with TIS field | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||
157 | Link to Trainee e-portfolio's document on TIS- HCS to provide codes. | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table | |||||||
158 | Link to Trainee e-portfolio's document on TIS- HCS to provide codes. | ? | ? | ? | ? | ? | ? | Question for TIS and HCS on Field and table |
Add Comment