WGN_V_RLS_EX_ADDR

Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN_V_RLS_EX_ADDR_1

WGN_V_RLS_EX_ADDR_1

This view references to one of the underlying RLS tables. When a search user connects to the CA DataMinder database it populates this table with users and their addresses that the logged on user is excluded from reviewing. This is primarily used with the 'Self Excluded' RLS models which have been designed so that a reviewer cannot review events that they are a participant in.

Note: This table is not populated for admin users and can return zero rows in a report if used by an admin user.

View Stack


WGN_V_RLS_EX_ADDR_1
→	TMP_WGN3EXADDRRLS

Column Details

Column	Data Type	Length	Description
AddressUID1	DECIMAL	13	Part-key used to uniquely identify an email address or the address of an IM participant.
AddressUID2	DECIMAL	13	Part-key used to uniquely identify an email address or the address of an IM participant.
UserIDM	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.
UserID	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.