WGN_V_ISSUE_PARTPNT

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

WGN_V_ISSUE_PARTPNT_3

This view is the same has WGN_V_ISSUE_PARTPNT_2 but included the additional column 'DeletedFlag'.

View Stack


WGN_V_ISSUE_PARTPNT_3
→	WGN_V_m_ISSUE_PARTPNT_3
	→	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
DeletedFlag	BIT	1	Indicates whether the user account is deleted or not.

WGN_V_TRIGGER_1

This view returns all columns from Wgn3Trigger subject to RLS being applied. This view has been created to support policy based RLS. The view stack below show the Policy (standard) model as the management group model simply point to the underlying table.

View Stack


WGN_V_TRIGGER_1
→	WGN_V_m_TRIGGER_1
	→	WGN_V_PD_TRIGGER_1
		→	Wgn3Trigger
			WGN_V_rls_POLICY_1
			→	TMP_WGN3POLICYRLS

Column Details

Column	Data Type	Length	Description
eventuid	IDENTITYDEF	13	Key used to uniquely identify a captured or imported event.
TriggerIndex	INTEGER	4	Part-key used to uniquely identify this trigger.
eventtimestamp	TIMESTAMP	8	The time at which the event occurred.
TriggerType	INTEGER	4	The type of trigger.
TriggerName	VARCHAR	255	The name of the trigger.
TriggerAttributes	VARCHAR	255	Attributes of the trigger.
TriggerText1	LONGVARCHAR	13	Trigger type specific text. Contains the most significant definition from policy that matched
TriggerText2	LONGVARCHAR	13	Trigger type specific text. Contains the extracted data from the event that matched the policy definition of the trigger
ActionName	VARCHAR	255	Name of the action that the trigger fired.
ActionAttributes	VARCHAR	255	Attributes of the action fired by the trigger.
ActionType	VARCHAR	255	Type of action fired by the trigger.
PolicyID	INTEGER	4	Identifies the policy classification associated with the trigger.
Severity	INTEGER	4	Indicates the severity value of the trigger.

WGN_V_CURR_ISSUE_TRIGGER_1

This view returns all columns from Wgn3IssueTrigger and Wgn3Trigger subject to RLS being applied. Specifically it shows which trigger(s) the issue is associated to. This view has been created to support policy based RLS. The view stack below show the Policy (standard) model as the management group model simply point to the underlying tables.

View Stack


WGN_V_CURR_ISSUE_TRIGGER_1
→	WGN_V_m_CURR_ISSUE_TRIGGER_1
	→	WGN_V_PD_CURR_ISSUE_TRIGGER_1
		→	Wgn3IssueTrigger
			WGN_V_PD_TRIGGER_1
			→	Wgn3Trigger
				WGN_V_rls_POLICY_1
				→	TMP_WGN3POLICYRLS

Column Details

Column	Data Type	Length	Description
Issueuid	IDENTITYDEF	13	Key used to uniquely identify an event issue.
eventuid	IDENTITYDEF	13	Key used to uniquely identify a captured or imported event.
eventtimestamp	TIMESTAMP	8	The time at which the event occurred.
TriggerIndex	INTEGER	4	Part-key used to uniquely identify this trigger.
TriggerType	INTEGER	4	The type of trigger.
TriggerName	VARCHAR	255	The name of the trigger.
TriggerAttributes	VARCHAR	255	Attributes of the trigger.
TriggerText1	LONGVARCHAR	13	Trigger type specific text. Contains the most significant definition from policy that matched
TriggerText2	LONGVARCHAR	13	Trigger type specific text. Contains the extracted data from the event that matched the policy definition of the trigger
ActionName	VARCHAR	255	Name of the action that the trigger fired.
ActionAttributes	VARCHAR	255	Attributes of the action fired by the trigger.
ActionType	VARCHAR	255	Type of action fired by the trigger.
PolicyID	INTEGER	4	Identifies the policy classification associated with the trigger.
Severity	INTEGER	4	Indicates the severity value of the trigger.

WGN_V_POLICY_PICKER_1

This view returns NodeUID/ParentNodeUID pairs relating to Policies and classes from the Classification tables along with the associated Classname’s. It is primarily used for a policy picker where a policy based RLS user should not be able to choose policies they cannot review. While this view may not be extensively used in most report queries it could be used if, for example, a custom policy picker was required.

View Stack


WGN_V_POLICY_PICKER_1
→	WGN_V_m_POLICY_PICKER_1
	→	WGN_V_PD_POLICY_PICKER_1
		→	WGN_V_AD_POLICY_PICKER_1
			→	WGN_V_AD_POLICY_CLASS
				→	Wgn3ClassificationNode
					Wgn3Classification
			WGN_V_rls_POLICY_1
			→	TMP_WGN3POLICYRLS

Column Details

Column	Data Type	Length	Description
lvl	INTEGER	13	Hierarchy level of the policy-class hierarchy tree
policynodeuid	INTEGER	13	NodeUID of the policy-class hierarchy
parentpolicynodeuid	INTEGER	13	Parent NodeUID of policynodeuid
policyclassname	VARCHAR	255	Policy-class name relating to policynodeuid
parentpolicyclassname	VARCHAR	255	Policy-class name relating to parentpolicynodeuid