Dim.Member
This table contains Type 1 data for Members defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| MemberKey | Data Mart unique identifier for the Member | int |
| MemberOid | Identifier for the Member | int |
| MemberName | Member Name | nvarchar |
| MemberUserName | Member User Name | nvarchar |
| MemberShortName | Member Short Name | nvarchar |
| MemberPhone | Phone Number on Member Record | nvarchar |
| MemberEmail | Email address on Member Record | nvarchar |
| MemberAssetState | Indicates if the Member is active | varchar |
| MemberCreateDateUTC | UTC Date the Member was created | datetime |
| MemberLastModifiedDateUTC | UTC Date the Member was last modified | datetime |
| MemberCreatedByKey | Foreign Key to the Member who created this Member | int |
| MemberLastModifiedByKey | Foreign Key to the Member who last modified this Member | int |