WGN_V_GROUP

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

WGN_V_GROUP_1

This view returns all columns from the table WgnGroup along with the Parent Group ID's subject to RLS. This view should always be used when a search wants to retrieve information from WgnGroup. If a search attempts to retrieve rows directly from WgnGroup the search will fail as the search user will not have permission to select data from this table directly.

View Stack


wgn_v_group_1
→	wgn_v_mgroup_1
	→	wgn_v_md_group_1
		→	WGNGROUP
		→	WGN_V_RLS_1
			→	TMP_WGN3RLS

Column Details

Column	Data Type	Length	Description
GroupIDM	INTEGER	4	Part-key used to uniquely identify a group within the installation.
GroupID	INTEGER	4	Part-key used to uniquely identify a group within the installation.
GroupName	VARCHAR	64	The group name.
PolicyIDM	INTEGER	4	Part-key identifying the policy document for this user.
PolicyID	INTEGER	4	Part-key identifying the policy document for this user.
DeletedFlag	BIT	1	Indicates whether the user/group is deleted or not.
GroupCreateTime	TIMESTAMP	8	The time that the CA DataMinder group was created.
parentgroupidm	INTEGER	4	Part-key identifying the child groups parent
parentgroupid	INTEGER	4	Part-key identifying the child groups parent