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 NULL value indicates this row contains the current information.

UserEndDateKey

smallint

Null values allowed

End of the time period that this row was known to be valid. A NULL value indicates this row contains the current information.

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