TIS is using the [vwProgramme].ManagingDeanery field to determine the LocalOffice value in TIS, and will NI be using the Hicom [vwLocalOffice] data.
The data reported belowing has been taken from the Consolidated DR v1 on
For Discussion
# | Comment | Owner |
|---|---|---|
| 1 | Can HEYH resolve their current 33 programmes below without a ManagingDeanery value ? Without this information, TIS will not been able to filter the Programme data correctly. | |
| 2 | What should we do with the 16,892 Inactive Programmes without a Managing Deanery ? |
...
DR v2 Programmes with No ManagingDeanery.xlsx
...
| LocalOfficeName | ProgrammeNumber | ProgrammeName | ProgName |
|---|---|---|---|
| HEYH | CHESTERFIELD STGP 015 | CHERSTERFIELD ST1 PROGRAMME 15 | CHESTERFIELD |
| HEYH | Trent FP 047 | 047 - 2008 starters | Trent |
| HEYH | Trent FP 008 | 008 - 2009/10 starters | Trent |
| HEYH | Trent FP 090 | 090 - 2008/9/10 starters | Trent |
| HEYH | Trent FP 048 | 048 - 2008/9/10 starters | Trent |
| HEYH | Trent FP 010 | 010 - 2008/9/10 starters | Trent |
| HEYH | Trent FP SA2 - 2008 | SA2 - 2008 | Trent |
| HEYH | Trent FP 086 | 086 - 2008/9/10 starters | Trent |
| HEYH | Trent FP 029 | 029 - 2008/9/10 starters | Trent |
| HEYH | Trent FP 027 | 027 - 2008/9 starters | Trent |
| HEYH | Trent FP 068(Ac) | 068(Ac) - 2009/10 starters | Trent |
| HEYH | Trent FP 002 | 002 - 2009/10 starters | Trent |
| HEYH | Trent FP 013 | 013 - 2008 starters | Trent |
| HEYH | Trent FP 056 | 056 - 2008/9 starters | Trent |
| HEYH | Trent FP 031 | 031 - 2008/9 starters | Trent |
| HEYH | Trent FP 036 | 036 - 2008/9 starters | Trent |
| HEYH | Rotation 49 | NGH F1 | Rotation |
...
ManagingDeanery to TIS LocalOffice Mapping
Using the following ManagingDeanery value to TIS LocalOffice Mapping;
...