...
TIS is using the [vwPost].ManagingDeanery field to determine the LocalOffice Post Owner value in TIS, and will NOT be using the Hicom [vwLocalOffice] data derived via the
...
The data reported below has been taken from the Consolidated DR v1 on
Posts to ManagingDeanery by Status
There are 19,303 Current Post rows where the ManagingDeaneryLETB field is NOT populated
Posts to ManagingDeanery by Status
Posts to ManagingDeanery and LocalOffice by Status
Of these 19,303 Posts, the NULL ManagingDeanery are assigned to the following LocalOffices;
...
Posts to ManagingDeanery and LocalOffice by Status
Posts to ManagingDeanery and Mapped LocalOffice by Status
Using the same ManagingDeanery mapping logic as for Programmes
...
Posts to ManagingDeanery and Mapped LocalOffice by Status
Posts to ManagingDeanery, LocalOffice and Mapped LocalOffice by Status
Breaking down the Current mapped UNKOWN LocalOffice values further using the LocalOffice;
...
Posts to ManagingDeanery, LocalOffice and Mapped LocalOffice by Status
Posts with a NULL vwPost.MainSiteID value
How to identify the LocalOffice for Posts with a NULL MainSiteID field;
...