Page content:
...
No. | Intrepid Column heading (V10) | TIS Column heading (Proposed) | Mandatory | Add/Update/Matching Criteria | Rules/Validation | Include in TIS Bulk Assessment template? Y/N | AR Comments- AB/JH/CL comments reviewed | 03/05 (Spike) | Create assessment | Match for create | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Person ID | Yes | Matching Criteria | Must match exactly the TIS ID of a current or Inactive person on TIS | Y | Suggested by James H and Alice B | Consideration here - speak to dev | Y | |||||||||||
1 | Surname * | Trainee Surname* | Yes | Matching Criteria | Must match exactly the Surname of a Current or Inactive person on TIS | Y | Y | Y | ||||||||||
Remove from template. This is the same on the Placement import template? Should we look at removing there too? | ||||||||||||||||||
3 | GMC Number | GMC Number | Either a GMC number, GDC number or Public Health number must be entered | Matching Criteria | Value must match exactly the GMC of a Current or Inactive existing Person record on TIS. The surname and GMC number for each row must match exactly a single TIS person record | Y | Value must (be 7 digits and) must match exactly the GMC of a Current or Inactive existing Person record on TIS. The surname and GMC number for each row must match exactly a single TIS person record. | Y | Y | |||||||||
4 | GDC Number | GDC Number | Either a GMC number, GDC number or Public Health number must be entered | Matching Criteria | Must match exactly the GDC of a Current or Inactive existing Person record on TIS. The surname and GDC number for each row must match exactly a single TIS person record | Y | Y | Y | ||||||||||
5 | Public Health Number | Public Health Number | Either a GMC number, GDC number or Public Health number must be entered | Matching Criteria | Must match exactly the PH number of a Current or Inactive existing Person record on TIS. The surname and PH number for each row must match exactly a single TIS person record | Y | S | Y | Y | |||||||||
6 | Type * | Type* | Yes | Add | Accepted values are those from the Assessment type reference table i.e. ACADEMIC ARCP FRCP FRCP (Stage 2) IRCP RITA | Y | Y | |||||||||||
7 | Review date * | Yes | Add | Accepted format is dd/mm/yyyy | Y | Make mandatory. Make Add/ Ashley Ransoo This field is the Review Date (not the Portfolio review date) from the TIS pages. But is indeed one of the matching criteria AR:Made it 'Review Date* and added a separate non-mandatory 'Portfolio review date'. | Y | Y | ||||||||||
This field has been removed from UI and Bulk following PAG | ||||||||||||||||||
Remove from template. | ||||||||||||||||||
10 | Outcome * | Outcome | No | Add | Accepted values are those from the Outcome Reference table i.e.: | Y | Made non-mandatory. | Y | N | |||||||||
11 | Under appeal | No | Add | Accepted values are 'Yes' or 'No'. | Y | Add to template. | Y | N | ||||||||||
12 | Reason(s) for unsatisfactory outcome | Unsatisfactory Outcome/Not Assessed Reason | Only Mandatory if Outcome is one of the following: 10.1 10.2 | Add | Accepted values should be one of those from the Outcome Reason reference table. e.g. 'N1 Trainee sick leave' etc. Allows multiple comma separated. | Y | Rename column from 'Reason' to ""Unsatisfactory Outcome / Not Assessed Reason", Joanne Watson (Unlicensed) - Whilst reviewing the template, data leads recommended a change to this field label on TIS Front End and also suggested that Outcome of 5 should also trigger the reason to be entered. Should be ticket this up for FE change? Ashley Ransoo the Assessment SMLs said that a reason for Outcome 5 was not required and there are not any Specific reasons provided in the Gold Guide for this - will follow up with data leads. AR: Outcome 5 not required confirmed | Y | N | |||||||||
13 | Reason for unsatisfactory outcome - other | Unsatisfactory Outcome/Not Assessed Reason (Other) |
Should be mandatory if 'Other reason (please specify)' is chosen as 'Not Assessed Reason' OR as 'Unsatisfactory Outcome Reason' | Add | If you enter Other reason (please specify) in the field Reason(s) for unsatisfactory outcome, enter the Other reason into this field. The reason must be less than 60 characters If you enter 'Other issues related to Covid-19 (please describe), enter the Other reason into this field. The reason must be less than 60 characters | Y | Make mandatory if 'N13 Other reason (please specify)' is chosen as 'Not Assessed Reason' OR if 'U8 Other reason (please specify) is chosen as 'Unsatisfactory Outcome Reason'
Ashley Ransoo we don't have a field on TIS called 'Reason for unsatisfactory outcome - other' AR: Field has been added, therefore confirmed to include for bullk | Y | N | |||||||||
14 | Academic Outcome | Yes - if academic curriculum assessed is populated. | Add | Accepted values can be one of the following: - Continue on academic component - Do not continue on academic component - Successfully completed academic component | Y | AB: Should not be mandatory as only a small number of trainees are academic trainees so the vast majority of trainees will not receive academic outcomes. There also needs to be a field added for Academic Curriculum Name. Joanne Watson (Unlicensed) 'Academic curriculum name'? Does the field exist on TIS? If not should it and how is it going to be used on the template? E.g. as a Update/Add/Matching Criteria. AR 02/05: There is a 'Curriculum name' under Pre-assessment detail. Is this used for both Academic and non-academic curriculum? Ashley Ransoo the Curriculum Name is always the name of the clinical curriculum. If the trainee has been following an academic curriculum in the assessment period the name of the academic curriculum will appear in the 'Academic Curriculum assessed' field in Post-assessment. | Y - need to add academic curriculum name also | N | ||||||||||
Remove from template. | ||||||||||||||||||
16 | Next Review date | Next review date | No | Add | Accepted format is dd/mm/yyyy | Y | Make non-mandatory. | Y | N | |||||||||
17 | Period from | Period covered from | No | Add | Accepted format is dd/mm/yyyy | Y | Y | N | ||||||||||
18 | Period to | Period covered to | No | Add | Accepted format is dd/mm/yyyy | Y | Y | N | ||||||||||
Remove from template. But populate in the same way as the Front End currently does. This is autopopulated from the trainee's placement grade on the Review Date | ||||||||||||||||||
20 | Programme Number | Programme number* | Yes | Add | Must match exactly to one of the Programme Numbers against the programme membership/s the trainee has. | Y | Making this Add
| S | Y | Y | ||||||||
21 | Programme Name | Programme name* | Yes | Add | Must match exactly to one of the Programme Names against the programme membership/s the trainee has. | Y | Making this Add | S | Y | Y | ||||||||
22 | Curriculum | Curriculum name* | Yes | Add | Muct match exactly to one of the curriculum of the Programme specified on Programme Name and Number combination columns. | Y | As discussed on #bulk_uploads, Claire pointed out that it was agreed with BMs and GMC that only one ARCP outcome can be given on a day. Reviewing how Assessments are created, suggest this should be an Add | S | Y | Y | ||||||||
Y | 12/02: This field has been removed from UI and Bulk following PAG | Y | N | |||||||||||||||
|
|
|
| N - pull from name of curriculum | N | |||||||||||||
? | N - pull from programme membership being assessed | N | ||||||||||||||||
25 | Form R Part B | ? | This is a potential requirement for Assessment considered post-mvp and would act as a Yes/No under 'Documents considered' of Pre-assessment details on TIS. AR 02/05: Assessment Field Validation:
Joanne Watson (Unlicensed) - can we remove this form the template for now? Ashley Ransoo Documents considered updated above and on ticket number TISDEV-3859 Can remove from template for now but to be added in when TISDEV-3859 is done | N | ||||||||||||||
26 | Months OOPR/OOPT counted towards training | No |
Add | Should contain a valid integer value | Y | 02/05: CL confirmed for this to be included as non-mandatory ' Made an Add as template is for Create only. | Y | N | ||||||||||
27 | PYA | No |
Add | Accepted values are currently 'YES' and 'NO' from the front end. | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
28 | Time Out Of Training(Days) | Days out of training | No |
Add | Should contain a valid integer value | Y | Keep on template as non-mandatory. | Y | N | |||||||||
29 | Known Concerns | Known concerns | No |
Add | 'YES' or 'NO' are the accepted values on TIS. | Y | Keep on template as non-mandatory. | Y | N | |||||||||
30 | Concern Summary | Concern summary | No |
Add | Freetext | Y | Keep on template as non-mandatory. | Y | N | |||||||||
31 | Responsible Officers Comments | Responsible Officers Comments | No | Add | Freetext | Y | Keep on template as non-mandatory. | Y | N | |||||||||
32 | Employers Report | ? | Data leads for other regions to confirm? AR 02/05: Assessment Field Validation: Joanne Watson (Unlicensed) - can we remove this form the template for now? Ashley Ransoo see no. 25 | N | ||||||||||||||
33 | Exception Report | ? | Data leads for other regions to confirm? AR 02/05: Assessment Field Validation: Joanne Watson (Unlicensed) - can we remove this form the template for now? Ashley Ransoo see no. 25 | N | ||||||||||||||
34 | Supervisors Report | ? | Data leads for other regions to confirm? AR 02/05: Assessment Field Validation: Joanne Watson (Unlicensed) - can we remove this form the template for now? Ashley Ransoo see no. 25 | N | ||||||||||||||
35 | Other | ? | Data leads for other regions to confirm? AR 02/05: Assessment Field Validation: Joanne Watson (Unlicensed) - can we remove this form the template for now? Ashley Ransoo see no. 25 | N | ||||||||||||||
36 | Grade at next rotation | Grade at next rotation | No |
Add | Must match exactly one of the grades associated with the placement being assessed | Y | Corrected. Ashley Ransoo also need to include in this dropdown the fields from the GMC ARCP list of allowed values. Will find this and go through it with you. | Y | N | |||||||||
37 | Comments | Comments | No | Add | Y | Y | N | |||||||||||
| N | |||||||||||||||||
N | ||||||||||||||||||
40 | Detailed reasons for recommended outcome | Detailed reason | No |
Add | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
41 | Mitigating circumstances | Mitigating circumstances | No |
Add | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
42 | Competences which need to be developed | Competences which need to be developed by next ARCP | No |
Add | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
43 | Recommended actions | Other recommended actions | No |
Add | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
44 | Recommended additional training time (if required) | Recommended additional training time (if required) | No |
Add | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
45 | Additional comments from the panel | Additional comments from the panel | No |
Add | Y | Keep on template as non-mandatory. Ashley Ransoo added this - on TIS now AR: Have now included on the template. | Y | N | ||||||||||
46 | External trainer | No |
Add | Accepted values are currently 'YES' and 'NO' from the front end. | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
47 | 10% audit - lay member | No |
Add | Accepted values are currently 'YES' and 'NO' from the front end. | Y | Keep on template as non-mandatory. | Y | N | ||||||||||
48 |
| Y | Keep on template as non-mandatory. 12/02: This field has been removed from UI and Bulk following PAG | Y | N |
...
No. | TIS Column heading (Proposed) | Mandatory | Add/Update/Matching Criteria | Rules/Validation | Comments |
---|---|---|---|---|---|
1 | TIS_Assessment_ID* | Yes | Matching Criteria | Must match exactly the TIS Assessment ID of a current or soft deleted Assessment record on TIS 13/02: Allow both Current and Soft deleted to be entered on the template | |
2 | Type | No | Update | Accepted values are those from the Assessment type reference table i.e. ACADEMIC ARCP FRCP FRCP (Stage 2) IRCP RITA | |
3 | Review date | No | Update | Accepted format is dd/mm/yyyy | |
Could TIS programme membership ID be an alternative and is this something that the people having access to this tool would have visibility of | |||||
Could TIS programme membership ID be an alternative and is this something that the people having access to this tool would have visibility of Yes - Go for Programme Membership ID attached to the Assessment instead of Programme name and number | |||||
4 | TIS Programme Curriculum Membership ID | No | Update | Must match exactly to one of the programme membership/s ID's the trainee has on TIS. | 25/10: Column remaned to include 'Curriculum' as it is more reflective of the curriculum membership ID. TIS does not have a proper programme membership ID. |
| Curriculum ID in Programme Membership. 14/10: This is not required on the template after discussing with the devs as it can be determined by programme membership ID. | ||||
5 | Period covered from | No | Update |
| |
6 | Period covered to | No | Update |
| |
7 | Months OOPR/OOPT counted towards training | No | Update | Should contain a valid integer value | |
8 | PYA | Accepted values are currently 'YES' and 'NO' from the front end. | |||
9 | Grade at time | No | Update | Is this required to be updated via bulk? This is normally pulled automatically if there is one at the time of updating/creating the assessment record else set to Not Provided. But can be overridden. 13/02: Yes, include on template. | |
10 | Days out of training | No | Update | Should contain a valid positive integer value | |
11 | Outcome | No | Update | Accepted values are those from the Outcome Reference table i.e.: | |
12 | Under appeal | No | Update | Accepted values are 'Yes' or 'No'. | |
13 | Unsatisfactory Outcome/Not Assessed Reason | Only Mandatory if Outcome is being updated to one of the following in #Outcome column :
| Update and replace all existing |
| |
14 | Unsatisfactory Outcome/Not Assessed Reason (Other) | Should be mandatory if 'Other reason (please specify)' is chosen as 'Not Assessed Reason' OR as 'Unsatisfactory Outcome Reason' | Update and replace all existing |
| |
15 | External trainer | No | Update | Accepted values are currently 'YES' and 'NO' from the front end. | |
16 | Next review date | No | Update | Accepted format is dd/mm/yyyy | |
17 | Grade at next rotation | No | Update | Must match exactly one of the grades associated with the placement being assessed | |
18 | Comments | No | Update and replace existing | Overwrite existing comments with the comments from the template | |
19 | 10% audit - lay member | No | Update | Accepted values are currently 'YES' and 'NO' from the front end. | |
20 | Academic Outcome | mandatory if academic curriculum assessed is populated on the template. | Update and replace existing | Accepted values can be one of the following: - Continue on academic component - Do not continue on academic component - Successfully completed academic component | |
21 | Detailed reason | No | Update and replace | Overwrite existing Detailed reason with the value from the template | |
22 | Mitigating circumstances | No | Update and replace | Overwrite existing value with the one from the template | |
23 | Competences which need to be developed by next ARCP | No | Update and replace | Overwrite existing competences with those from the template | |
24 | Other recommended actions | No | Update and replace | Overwrite existing value with the one from the template | |
25 | Recommended additional training time (if required) | No | Update and replace | Overwrite existing value with the one from the template | |
26 | Additional comments from the panel | No | Update and replace | Overwrite existing value with the one from the template | |
27 | Known concerns | No | Update | 'YES' or 'NO' are the accepted values on TIS. | |
28 | Concern summary | No | Update and replace | Freetext | |
30 | Responsible Officers Comments | No | Update and replace | Freetext | |
No | Update | Only Accepted value is 'YES' or left blank for no action. Entering 'YES' will result in the assessment record being marked as soft deleted, removed from the UI but can be accessed from the Backend, similar to the TIS FE behaviour trashcan interaction against Assessment. To avoid this field being incorrectly used, suggest that the only fields required for a soft-delete are the TIS_Assessemt_IDs and Soft Delete from UI? on the template and all other columns should be left unfilled. P.S: The option of undoing soft-deletion was considered, but no one has demonstrated a need for this yet. | 22/06/2021: This field is no longer needed as we are looking into a solution for Bulk Hard delete assessments which is the preference by Data Leads. |
...