Dim.MemberGroup
This feature is available in Enterprise and Ultimate editions.
MemberGroups are a collection of Dim.Members members that can be used for convenience to group sets of system users. For example, "Contractors"," DBA's", "Technical Writers", or "Building 43" might be helpful member group definitions in certain organizations. This table contains Type 1 data for MemberGroups defined in your VersionOne instance.
Table Description
Column Name | Description | Datatype |
MemberGroupKey | Datamart identifier | int |
MemberGroupOID | VersionOne identifier | int |
MemberGroupCreateDate | Date created | datetime |
MemberGroupLastModifiedDate | Date last modified | datetime |
MemberGroupName | Name | nvarchar |
MemberGroupCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
MemberGroupLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |