Previous Topic: WGN_V_RLS_1Next Topic: WGN_V_RLS_EX_ADDR_1


WGN_V_RLS_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; their addresses and groups that a particular user is allowed to view events for and review; and the start and end dates that each user was part of a particular group.

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_ADDR_1

TMP_WGN3ADDRRLS

Column Details

Column

Data Type

Length

Description

EffectiveStartDate

TIMESTAMP

8

End date when a particular reviewer can view a particular user's CA DataMinder events.

EndDate

TIMESTAMP

8

Start date when a particular reviewer can view a particular user's CA DataMinder events.

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.

groupidm

INTEGER

4

Part-key used to uniquely identify a group within the installation.

groupid

INTEGER

4

Part-key used to uniquely identify a group within the installation.