Purpose

This view supports row-level security / authorization by listing all of the potential users, linking their e-mail address to a UserID. Part of the Row-Level Security Collection.

SQL Object

analytics.rls_UserDim

Data Definition and Sources

The join to the StaffElectronicMail table needs to be further limited by looking at the ElectronicMailTypeId field and filtering on ElectronicMailType.CodeValue = 'Work'.