Previous Topic: BLOBAttributesNext Topic: Wgn3UserPropertyValue

Database Schema and Views Reference Guide › Database Tables › Wgn3UserGroup

Wgn3UserGroup

This table stores a user's association with groups in the CA DataMinder user hierarchy. Inevitably, users will move between different groups in an organization. When they change groups, they are subjected to different CA DataMinder policies and different levels of review. This table retains a user's group context as it applied when data was captured, rather than applying the context of the group that the user currently belongs to.

Note: For the current release, this table enforces a constraint that a user can only have a single 'current' group. Potentially, in future releases this table may permit a user to belong to multiple groups concurrently.

Column

Primary Key

Datatype

Length

Notes

UserGroupUID

System-generated key that uniquely identifies a user group

Yes

INTEGER

4

 

UserIDM

Part-key that uniquely identifies a CA DataMinder user.

 

INTEGER

4

Foreign key: Wgn3User

UserID

Part-key that uniquely identifies a CA DataMinder user.

 

INTEGER

4

Foreign key: Wgn3User

GroupIDM

Part-key identifying the group that the user belongs to.

 

INTEGER

4

Foreign key: WgnGroup

GroupID

Part-key identifying the group that the user belongs to.

 

INTEGER

4

Foreign key: WgnGroup

StartDate

The date at which the user became a member of the group.

 

TIMESTAMP

 

 

NextGroupHistoryUID

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.

 

INTEGER

 

This column is optional. A null value indicates a current group context for the specified user.

EffectiveStartDate

A denormalized value so that the date at which a user started in a group does not need to be re computed continually.

 

TIMESTAMP

 

If this is the first row for a User then this takes the value of 01-Jan-1753 , which is the earliest possible date that oracle and sqlserver support. For all other entries effective startdate will equal startdate.

EffectiveEndDate

A denormalised value so that the date at which a user ended in a group does not need to be re computed continually.

 

TIMESTAMP

 

If this is the last row for a User then this takes the value of 31-Dec-9999 , which is the highest possible date that oracle and sqlserver support. For all other entries effective enddate will equal startdate of the next row in the sequence for that user.