SCRM 2006 SCRS_User_Dimension_View
SCRS_User_Dimension_View lists information about each user and each user group.
SCRS_User_Dimension_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| UserKey | int | Not Null | Foreign key that uniquely identifies each end user in the SC_UserDimension_Table. |
| UserEndTimeKey | int | Null values allowed | End of the time period that this row was known to be valid. A |
| UserEndDateKey | smallint | Null values allowed | End of the time period that this row was known to be valid. A |
| UserEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this user entry. This is a foreign key into SC_LineageDimension_Table. |
| UserStartTimeKey | int | Not Null | Start of the time period that this row was known to be valid. Indicates time that item was first imported into the data warehouse. |
| UserStartDateKey | smallint | Not Null | Start of the time period that this row was known to be valid. Indicates time that item was first imported into the data warehouse. |
| UserStartDateLineageKey | int | Not Null | Key that identifies lineage of the DTS package that first identified this user entry. This is a foreign key into SC_LineageDimension_Table. |
| FirstName | nvarchar | Not Null | End user first name. |
| MiddleName | nvarchar | Null values allowed | End user middle name. |
| LastName | nvarchar | Not Null | End user last name. |
| FullName | nvarchar | Not Null | End user full name, first followed by last. |
| PreferredName | nvarchar | Not Null | End user preferred name. |
| UserAccountNTDomain | nvarchar | Not Null | NT domain of end user account. |
| UserAccountName | nvarchar | Not Null | End user account name. |
| UserAccountADDomain | nvarchar | Not Null | Active Directory domain of end user account. |
| UserAccountFullADName | nvarchar | Not Null | Full Active Directory name of end user account. |
| UserAccountFullNTName | nvarchar | Not Null | Full NT name for end user account. |
| EmailAddress | nvarchar | Not Null | End user e-mail address. |
| HomeTelephoneNumber | nvarchar | Not Null | End user home telephone number. |
| OfficeTelephoneNumber | nvarchar | Not Null | End user office telephone number. |
| OfficeExtension | smallint | Null values allowed | End user office extension. |
| MobileTelephoneNumber | nvarchar | Not Null | End user mobile telephone number. |
| Address1 | nvarchar | Not Null | End user address, part 1. |
| Address2 | nvarchar | Not Null | End user address, part 2. |
| Building | nvarchar | Not Null | End user building. |
| Campus | nvarchar | Not Null | End user campus. |
| City | nvarchar | Not Null | End user city. |
| Country | nvarchar | Not Null | End user country. |
| CountryCode | nvarchar | Not Null | End user country code. |
| Comment | nvarchar | Not Null | Comment pertaining to end user. |
| FacsimileTelephoneNumber | nvarchar | Not Null | End user FAX number. |
| Floor | nvarchar | Not Null | End user floor. |
| Office | nvarchar | Not Null | End user office. |
| Region | nvarchar | Not Null | End user region. |
| StateProvince | nvarchar | Not Null | End user state province. |
| WorldRegion | nvarchar | Not Null | End user world region. |
| PostalCode | nvarchar | Not Null | End user postal code. |
| Manager | nvarchar | Not Null | End user manager. |
| Division | nvarchar | Not Null | End user division. |
| Department | nvarchar | Not Null | End user department. |
| Title | nvarchar | Not Null | End user professional title. |
| EmployeeId | nvarchar | Not Null | End user employee ID. |
| JobLevel | nvarchar | Not Null | End user job level. |
| CostCenter | nvarchar | Not Null | End user cost center. |
| IsGroup | smallint | Not Null | Indicator for whether or not the end user is actually a group of users. |