Base View idvRegisteredOffice

Description

This view exposes the rows in ISOL1008 that represent registered offices and their owners

This view encapsulates logic to cope with inadvertent multiple entries for a single owner. When queried for a single owner it is guaranteed to return a singleton and is intended to behave in the same way as the practice suite does in these circumstances.

Type = Base view suitable for advanced end user use

 

Columns

Inherits columns from view idvAddress plus

OwnerObjectType The object type of the owning object
OwnerInternalId The internal identifier of the owning object
MappingId The unique internal identifier of the selected mapping