...
| 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 Site reference table | Y |
| 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-44584458 Accepted value is the registration numbers of the Educational Supervisors. | Y |
| Comments | Update | No | TISDEV-4692 Freetext accepted. | Y |