vwBackOfficeLinkedUsers
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BackOfficeSystemID | int | ||
| BackOfficeGuid | uniqueidentifier | ||
| UserID | int | ||
| BackofficeRecordID | int | ||
| BackofficePeopleID | int | ||
| BackOfficeSystemName | nvarchar(50) |
Definition
Copy
CREATE VIEW [dbo].[vwBackOfficeLinkedUsers]
AS
SELECT bos.ID AS BackOfficeSystemID,
bos.Guid AS BackOfficeGuid,
u.ID AS UserID,
bosp.BackofficeRecordID,
bosp.ID AS BackofficePeopleID,
bos.Name AS BackOfficeSystemName
FROM dbo.BackOfficeSystemPeople bosp
INNER JOIN dbo.BackOfficeSystems bos ON bosp.BackOfficeSystemID = bos.ID
INNER JOIN dbo.BackOfficeSystemUsers bosu ON bosp.ID = bosu.BackofficePeopleID and bosu.[current] = 1
INNER JOIN dbo.ClientUsers u ON bosu.ClientUsersID = u.ID