Page Content:
| Table of Contents |
|---|
...
| Column Heading | Add/Update/Matching Criteria | Mandatory | Rules | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Surname* | Matching Criteria | Yes | Must match exactly the Surname a Current or Inactive Person record on TIS | ||||||||
| GMC Number | Matching Criteria | Yes (unless GDC number or Public Health number has been entered) | Accepted value is 7 digits. Must match exactly the GMC Number of a Current or Inactive Person record on TIS. The Surname, Forenames and GMC number for each row must match exactly a single TIS person record | ||||||||
| GDC Number | Matching Criteria | Either a GMC number, GDC number or Public Health number must be entered | Must match exactly the GDC Number of a Current or Inactive Person record on TIS. The Surname, Forenames and GDC number for each row must match exactly a single TIS person record | ||||||||
| Public Health Number | Matching Criteria | Either a GMC number, GDC number or Public Health number must be entered | Must match exactly the Public Health Number of a Current or Inactive Person record on TIS. The Surname, Forenames and Public Health number for each row must match exactly a single TIS person record | ||||||||
| National Post Number* | Matching Criteria | Yes | Must match exactly the National Post Number of a Current or Inactive Post on TIS. Ingore Post with a status of DELETE In an placement update scenario, Date From and Date to should match to the dates on the person record against the existing matching NPN. You can't update dates using the placement import. Dates can only be updated manually in the system. If you take dates out of the matching criteria then there is no way of knowing which placement you want to update as people can have many placements in the same site. In an Add scenario, i.e. where a placement is being added to a person, the values on the template will be inserted to person records. | ||||||||
| Date From* | Matching Criteria/Add | Yes | Format must be dd/mm/yyyy. Date from must be before date to | ||||||||
| Date To* | Matching Criteria/Add | Yes | Format must be dd/mm/yyyy. Date from must be before date to | ||||||||
| Placement Type* | Update | Yes | Accepted values should match to one of the Placement type reference table | ||||||||
| Placement Status* | Update | Remove as this get automatically populated based on the dates entered | |||||||||
| Site* | Update | Yes | Accepted values should match to one of the CURRENT SiteKnownAs values Site reference table | ||||||||
| Other Sites | Update (replace all existing values) | No |
| ||||||||
| WTE* | Update | Yes | Accepted values should match to those that are deemed valid from the FE i.e. any number between 0 and 1 inclusve. | ||||||||
| Grade* | Update | Yes | Accepted values should match to one of the Grade reference table | ||||||||
| Specialty1* | Update | Yes -
| Accepted values should match to one of the Specialty reference table | ||||||||
| Specialty2 | Update | Accepted values should match to one of the Specialty reference table | |||||||||
| Specialty3 | Update | Accepted values should match to one of the Specialty reference table | |||||||||
| Clinical Supervisor | Update | No | TISDEV-4458 | ||||||||
| Educational Supervisor | Update | No | TISDEV-4458 | ||||||||
| Comments | Update | No | TISDEV-4692 |
...
| Column Heading | Add/Update/Matching Criteria | Mandatory | Rules | Applicable for Update (Y/N) | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TIS_Placement_ID* | Matching Criteria | Yes | Must match exactly to an Existing PlacementID on TIS. | Y | ||||||||
| Intrepid_Placement_ID | Update | No | Must match an existing Intrepid_Placement_ID in Intrepid. (Extraction process handled outside of TIS) If there is an Intrepid_Placement_ID value already held on TIS, but a value has been specified on the template, then the import should ignore and throw an error. | Y | ||||||||
| N | ||||||||||||
| N | ||||||||||||
| N | ||||||||||||
| N | ||||||||||||
| N | ||||||||||||
| National Post Number | Update | No | Must match exactly the National Post Number of a Current or Inactive Post on TIS. | Y | ||||||||
| Date From | Update | No | Format must be dd/mm/yyyy. Date from must be before date to | Y | ||||||||
| Date To | Update | No | Format must be dd/mm/yyyy. Date from must be before date to | Y | ||||||||
| Placement Type | Update | No | Accepted values should match to one of the Placement type reference table | Y | ||||||||
| Site | Update | No | Accepted values should match to one of the CURRENT SiteKnownAs values from Site reference table | Y | ||||||||
| Other Sites | Update (replace all existing values) | No |
| |||||||||
| WTE | Update | No | Accepted values should match to those that are deemed valid from the FE i.e. any number between 0 and 1 inclusve. | Y | ||||||||
| Grade | Update | No | Accepted values should match to one of the Grade reference table | Y | ||||||||
| Specialty1 | Update | No | Accepted values should match to one of the Specialty reference table | Y | ||||||||
| Specialty2 | Update | No | Accepted values should match to one of the Specialty reference table | Y | ||||||||
| Specialty3 | Update | No | Accepted values should match to one of the Specialty reference table | Y | ||||||||
| Clinical Supervisor | Update | No | TISDEV-4458 Accepted value is the registration numbers of the Clinical Supervisors. | Y | ||||||||
| Educational Supervisor | Update | No | TISDEV-4458 Accepted value is the registration numbers of the Educational Supervisors. | Y | ||||||||
| Comments | Update | No | TISDEV-4692 Freetext accepted. | Y |
...