Previous Topic: WGN_V_USER_ADDRESS_1Next Topic: WGN_V_RLS_1

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

WGN_V_ADDRESS_1

This view provides an interface to the new table Wgn3Address with the userid's also included. The view only returns addresses for event types that have a natural address (email, IM, file). It does not return artificial auto generated addresses or addresses with no associated user. RLS is not applied to this view.

View Stack

WGN_V_ADDRESS_1

→

WGN_V_CM_ADDRESS_1

 

→

wgn3address

 

 

wgn3useraddressex

Column Details

Column

Data Type

Length

Description

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.

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.

AddressName

VARCHAR

255

The actual email address or IM participant.