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. |
See Also
Other Resources
SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures