WGN_V_GROUP_HIST

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

WGN_V_GROUP_HIST_1

This view returns all rows and most of the columns from Wgn3UserGroup. Additionally, this also returns the end date that this user is part of this group and the effective start date. This Effective start date is set to approximately the start date minus 100 years if this is the first group a user has belonged to or the actual start date otherwise.

It is possible on large databases, in both Oracle and SQL Server, that this view can produce poor query plans. In some of these cases it may be better to use WGN_V_RLS_ADDR_1 (see description of this view below) as it contains similar information and this is created once when the iConsole is started so it does not need to search through several tables. This view as now been superceded by the view WGN_V_GROUP_HIST_2 due to a schema change which as added the columns EffectStartDate and EffectEndDate to the underlying table to help improve performance. WGN_V_GROUP_HIST_2 should now be used.

View Stack


WGN_V_GROUP_HIST_1
→	WGN_V_CM_GROUP_HIST_1
	→	WGN_V_GROUP_HIST_NULL_END_1
		→	WGN_V_CM_GROUP_HIST_NULL_END_1
			→	WGN3USERGROUP

Column Details

Column	Data Type	Length	Description
UserGroupUID	INTEGER	4	System-generated key that uniquely identifies a user group
StartDate	TIMESTAMP	8	The date at which the user became a member of the group.
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.
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.
NextGroupHistoryUID	INTEGER	4	Used to explicitly link the group history in chronological order, so that an 'end date' can be derived from the start date of the next entry.
EndDate	TIMESTAMP	8	End date when a particular reviewer can view a particular user's CA DataMinder events.
EffectiveStartDate	TIMESTAMP	8	Start date when a particular reviewer can view a particular user's CA DataMinder events.

WGN_V_GROUP_HIST_2

This view returns all rows and columns from Wgn3UserGroup. Additionally, this also returns the end date that this user is part of this group.

View Stack


WGN_V_GROUP_HIST_2
→	WGN_V_CM_GROUP_HIST_2
	→	WGN3USERGROUP

Column Details

Column	Data Type	Length	Description
UserGroupUID	INTEGER	4	System-generated key that uniquely identifies a user group
StartDate	TIMESTAMP	8	The date at which the user became a member of the group.
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.
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.
NextGroupHistoryUID	INTEGER	4	Used to explicitly link the group history in chronological order, so that an 'end date' can be derived from the start date of the next entry.
EndDate	TIMESTAMP	8	End date when a particular reviewer can view a particular user's CA DataMinder events.
EffectiveStartDate	TIMESTAMP	8	Start date when a particular reviewer can view a particular user's CA DataMinder events.
EffectiveEndDate	TIMESTAMP	8	Effective end date when a particular reviewer can view a particular user's CA DataMinder events.