WGN_V_PARTPNTUSER

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

WGN_V_PARTPNTUSER_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 Wgn_V_User_1 or Wgn_V_User_Group_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. However most of the views which use this view have now been re-written to use WGN_V_PNTUSER_1 instead.

View Stack


WGN_V_PARTPNTUSER_1
→	WGN_V_m_PARTPNTUSER_1
	→	WGN_V_MD_PARTPNTUSER_1
		→	WGN_V_CM_PARTPNTUSER_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.
IsRLSCandidate	INTEGER	4	This is always set to 1