Dim.Member
This feature is available in Enterprise and Ultimate editions.
This table contains Type 1 data for Members defined in your VersionOne instance.
Table Description
Column Name | Description | Datatype |
MemberKey | Datamart unique identifier for the Member | int |
MemberOid | VersionOne identifier for the Member | int |
MemberName | Member Name | nvarchar |
MemberUserName | Member User Name | nvarchar |
MemberShortName | Member Short Name | nvarchar |
MemberPhone | Phone Number on VersionOne Member Record | nvarchar |
MemberEMail | EMail address on VersionOne Member Record | nvarcahr |
MemberAssetState | Indicates if Member is active | varchar |
MemberCreateDateUTC | UTC Date the Member was created | datetime |
MemberLastModifiedDateUTC | UTC Date the Member was last modified | datetime |
MemberCreatedByKey | Foreign Key the the Member who created this Member | int |
MemberLastModifiedByKey | Foreign Key the the Member who last modified this Member | int |