Previous Topic: WGN3USERADDRESSNext Topic: WGN_V_ADDRESS_1

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

WGN_V_USER_ADDRESS_1

This view provides an interface to the new table Wgn3UserAddressEx. Use this view in preference to Wgn3UserAddress. RLS is not applied to this view.

View Stack

WGN_V_USER_ADDRESS_1

→

WGN_V_CM_USER_ADDRESS_1

 

→

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.

AddressType

INTEGER

4

This is the address type which differentiates the address become the original normal addresses and the new auto generated addresses