Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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;

...