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 |