Versions Compared

Key

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

...


#
Comment
Owner
1How should the NULL MainSiteID post rows be associated with a LocalOfifce, using ManagingDeanery, Site, Trust or NationlaPostNumber prefixJoanne Watson (Unlicensed)
2Of the 19,303 Current Posts with a NULL ManagingDeanery, 436 have a IsTrainingPost = Unknown, 8,907 have a IsTrainingPost  = Yes and the remaining 9,960 have a IsTrainingPost = No, can these Posts be ignored in TIS as they are Trust and not trainee posts.Joanne Watson (Unlicensed)


TIS is using the [vwPost].ManagingDeanery field to determine the LocalOffice value in TIS, and will NOT be using the Hicom [vwLocalOffice] data derived via the 

...