WGN_V_ISSUE_PARTPNT

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

WGN_V_ISSUE_PARTPNT_2

This view returns most of the columns from Wgn3EventParticipant along with AddressName, UserName and the user's Full Name, subject to RLS. This view was not specifically designed for searching, but for determining which participants can be seen by a user when auditing events. So this view can be used when you want to see which participants a user has access to. This view gives some extra information (such as FullName) but apart from that you can obtain the same information from WGN_V_PNTUSER_1.

View stack


WGN_V_ISSUE_PARTPNT_2
→	WGN_V_m_ISSUE_PARTPNT_2
	→	WGN_V_MD_ISSUE_PARTPNT_2
		→	WGN_V_MD_ISSUE_PARTPNT_3
			→	wgn3address
				WGN_V_CURR_PROP_VAL_1
				→	WGN_V_CM_CURR_PROP_VAL_1
					→	WGN3USERPROPERTYVALUE
				WGN_V_MD_PNTUSER_1
				→	wgn3eventparticipant
					WGN_V_RLS_ADDR_1
					→	TMP_WGN3ADDRRLS
				Wgn3User

Column Details

Column	Data Type	Length	Description
eventuid	IDENTITYDEF	13	Key used to uniquely identify a captured or imported event.
eventtimestamp	TIMESTAMP	8	The time at which the event occurred.
participantindex	INTEGER	4	Part-key used to identify an event participant.
participanttype	INTEGER	4	The classification of the participant.
interventiontype	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.
address	VARCHAR	255	The actual email address or 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.
username	VARCHAR	64	The name of the CA DataMinder user. The naming convention (if any) depends on the user creation policy settings.
userfullname	VARCHAR	255	User's Full Name