Currently

There are multiple ways of making a field or record unavailable within the TIS UI, the uses have not been applied consistently across the front end/back end, however the general summary is as follows:



Type Functional description Where used Warning/error messages Comments
1 Delete (status)

Users can apply a status of "delete" to a particular record, which would mean that the record would be deleted from the front end

  • applied at both record and field level
  • this acts as a soft delete
    • removed the field from the front end
    • does not de-link where applied
    • removes link ability for new scenarios

Example: People (Sensitive Data / Manage Record / Status)

  • People
  • Programmes
  • Posts
No error message displayed TBC: In intrepid, this flagged the applicable field or record for archiving in the back end but kept it in view on the UI?
2 Inactive (status)

Users can apply a status of "Inactive" to a particular record or reference data field, which would mean that the record or field is made temporarily unavailable

  • can be applied at both record and field level
  • impact of applying this to a field being used in a current record, is
    • filtering may need to be applied to view the record in a list page i.e. To show both current and inactive records
    • drop downs for reference tables will not display anything that has been made with an inactive status
    • records containing inactive data will not be flagged, but editing may present errors to the user
    • assessment records may become legacy, and no editing will no longer be possible

Example: People records (People / Sensitive Data / Manage Record / Status)

  • People
  • Programmes
  • Posts
No error message displayed TBC In Intrepid, this meant the applicable field/record would need to be activated before it could be used in TIS
3 Trash can

Users can click on the trash can next to a field and permanently remove data from TIS

  • this functions as a hard delete
  • removes existing linkages with records and other fields
  • No audit trail is kept of record/field

Example: Placement record (People / Placements / Placement list)

  • People: Placement
  • People: Programme Membership
"Are you sure you want to delete?" displayed
4 Minus

Users can click on the minus sign next to a field and permanently remove it from TIS

  • this functions as a hard delete
  • removes existing linkages with records and other fields
  • No audit trail is kept of record/field

Example: Curricula (Programme / Curricula)

  • People: Qualifications
  • People: Programme Membership
  • Posts: Other specialties
  • Posts: Sub-specialties
  • Posts: Other grades
  • Posts: Other sites
  • Posts: Programme names
  • Programme: Curricula
No error message displayed
5 X button

Users can click on the X sign next to a field and permanently remove it from TIS

  • this functions as a hard delete
  • removes existing linkages with records and other fields

Example: Roles field (People / Sensitive Data / Manage Records / Roles)

  • People: Roles
No error message displayed
6 Dates from/to

Users can specify an end date, which would make the related record or fields Inactive after that date has elapsed

  • this functions as a hard delete
  • removes existing linkages with records and other fields

Example: Post funding (Posts / Post record / Funding)

  • People: Registration dates
  • People: Inactive date
  • People: Programme membership
No error message displayed
7 Archive Not currently implemented in TIS
N/A


Data implications
In terms of data being passed down to NDW, it is assumed that hard delete data is not passed on, but soft delete data is.


To Be << to be discussed and agreed with data leads

In order to consolidate the way that the concept of deletion is used across TIS, the following rules should be applied:


Delete status

Applicable scenarios

N/A - see Trash Can

Conversation

- need back end reporting function for deleted records


Inactive status

Applicable scenarios



Trash can (button)

Applicable scenarios



Minus

Applicable Scenarios



X (button)

Applicable scenarios



Dates From/To

Applicable scearios



Archive

Applicable scenarios


<data flows>



# Question Comments
1 Other than reference date and records (forms), is there anywhere else, or data type, that it should be possible to apply inactive as a status?
2 Other than within record, are there other scenarios you might want to delete (trashcan) a data entity? for example, particular fields?
3

Deleting programme membership or curriculum membership current behaviour. Think these are hard deletes too, should they be? If so, do we currently audit the deletion of these? Requires technical design guidance as to what a consistent delete on TIS should be.


4 What are archiving rules regarding elapsed time and what can/cannot be stored?
5 What data will need to be accesible (GDPR) and for how long?
6 Are there any notifications we need to provide to users / trainees regarding the editing/deleting/archiving of their data?