WGN_V_INTPARTPNTUSER

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

WGN_V_INTPARTPNTUSER_1

This view provides a link from the participant table to the users. RLS is not applied to this view but can be achieved by an appropriate join to another RLS view. It was developed as a performance improvement to WGN_V_PARTPNTUSER_1 which returns all participants by use of an outer join. This view uses an inner join and only returns internal participants (users). As with WGN_V_PARTPNTUSER_1 it was not designed as a top level view but was used as a lower level view to link other tables or views to avoid multiple applications of RLS.

View Stack


WGN_V_INTPARTPNTUSER_1
→	WGN_V_CM_INTPARTPNTUSER_1
	→	wgn3eventparticipant
		WGN_V_USER_ADDRESS_1
		→	WGN_V_CM_USER_ADDRESS_1
			→	WGN3USERADDRESSEX

Column Details

Column	Data Type	Length	Description
eventuid	IDENTITYDEF	13	Key used to uniquely identify a captured or imported event.
ParticipantIndex	INTEGER	4	Part-key used to identify an event participant.
eventtimestamp	TIMESTAMP	8	The time at which the event occurred.
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.
ParticipantNodeUID	INTEGER	4	The classification of the participant.
InterventionNodeUID	INTEGER	4	The classification that CA DataMinder assigns to the participant.
LoginIDM	INTEGER	4	Part-key that indicates the participant who generated the event.
LoginID	INTEGER	4	Part-key that indicates the participant who generated the event.
NativeUser	VARCHAR	128	Name of the OS user that the CA DataMinder is logged on as.
LoginState	INTEGER	4	The state of the user login, that is, logged in or out.
LastLogonTime	TIMESTAMP	8	The time the user last logged in or out.
PolicyVersion	VARCHAR	255	The version of user policy that is being used.
SourceMachine	VARCHAR	255	The name of the machine on which the user logged in.
DefaultLoginFlag	BIT	1	This is the 'default' login record for the OS user. This is used to control automatic logins.
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.