TIS is using the [vwProgramme].ManagingDeanery field to determine the LocalOffice value in TIS, and will NI NOT be using the Hicom [vwLocalOffice] data.
...
Using the above logic, leaves the following Programmes unable to determine the TIS LocalOffice
| status | LocalOfficeName | ManagingDeanery | mapped_lo | rc |
|---|---|---|---|---|
| Current | HEEOE | London | UNKNOWN | 1 |
| Current | HEWM | Defence Postgraduate Medical Deanery | UNKNOWN | 1 |
| Current | HEYH | NULL | UNKNOWN | 33 |
| Inactive | HEEM | NULL | UNKNOWN | 363 |
| Inactive | HELASE | NULL | UNKNOWN | 15698 |
| Inactive | HESW | NULL | UNKNOWN | 637 |
| Inactive | HEWTV | NULL | UNKNOWN | 52 |
| Inactive | HEYH | NULL | UNKNOWN | 142 |
vwLocalOffice to vwProgramme MD.xlsx
...