User dimension table

Table Name	Column Name	Column Type	Primary Key
Bi_Dimuser_s3	userid	NVARCHAR(144)	PK
Bi_Dimuser_s3	firstname	NVARCHAR(160)
Bi_Dimuser_s3	lastname	NVARCHAR(256)
Bi_Dimuser_s3	middlename	NVARCHAR(128)
Bi_Dimuser_s3	address1	NVARCHAR(2048)
Bi_Dimuser_s3	address2	NVARCHAR(2048)
Bi_Dimuser_s3	city	NVARCHAR(128)
Bi_Dimuser_s3	StateOther	NVARCHAR(128)
Bi_Dimuser_s3	ZipCode	NVARCHAR(128)
Bi_Dimuser_s3	UserTypeID	VARCHAR(36)
Bi_Dimuser_s3	UserTypeName	NVARCHAR(128)
Bi_Dimuser_s3	CreationDt	TIMESTAMP
Bi_Dimuser_s3	CenterID	VARCHAR(36)
Bi_Dimuser_s3	Email	NVARCHAR(256)
Bi_Dimuser_s3	homephone	NVARCHAR(64)
Bi_Dimuser_s3	mobilephone	NVARCHAR(64)
Bi_Dimuser_s3	workphone	NVARCHAR(64)
Bi_Dimuser_s3	username	NVARCHAR(256)
Bi_Dimuser_s3	usercode	NVARCHAR(512)
Bi_Dimuser_s3	lastlogin	TIMESTAMP
Bi_Dimuser_s3	gender	INT
Bi_Dimuser_s3	dob	TIMESTAMP
Bi_Dimuser_s3	preferredTherapist	VARCHAR(36)
Bi_Dimuser_s3	preferredRoom	VARCHAR(36)
Bi_Dimuser_s3	otherpreferences	NVARCHAR(65535)
Bi_Dimuser_s3	referralsourceid	VARCHAR(36)
Bi_Dimuser_s3	roomno	NVARCHAR(80)
Bi_Dimuser_s3	referredby	VARCHAR(36)
Bi_Dimuser_s3	anniversarydate	TIMESTAMP
Bi_Dimuser_s3	PreferedCenerId	VARCHAR(36)
Bi_Dimuser_s3	registrationsource	INT
Bi_Dimuser_s3	customerapplogin	INT
Bi_Dimuser_s3	mobilecountrydname	NVARCHAR(4096)
Bi_Dimuser_s3	mobilecountrysname	NVARCHAR(4096)
Bi_Dimuser_s3	stateDispName	NVARCHAR(4096)
Bi_Dimuser_s3	stateShortName	NVARCHAR(4096)
Bi_Dimuser_s3	statecode	NVARCHAR(40)
Bi_Dimuser_s3	CountryDName	NVARCHAR(4096)
Bi_Dimuser_s3	CountrySName	NVARCHAR(4096)
Bi_Dimuser_s3	ReceiveTransactionalSMS	BOOLEAN
Bi_Dimuser_s3	ReceiveMarketingSMS	BOOLEAN
Bi_Dimuser_s3	UserPK	DECIMAL(19,0)
Bi_Dimuser_s3	UnSubscribeToTransactionalEmail	BOOLEAN
Bi_Dimuser_s3	UnSubscribeToMarketingEmail	BOOLEAN
Bi_Dimuser_s3	PasswordUpdatedOn	TIMESTAMP
Bi_Dimuser_s3	ReceiveTransactionalEMail	BOOLEAN
Bi_Dimuser_s3	ReceiveMarketingEMail	BOOLEAN
Bi_Dimuser_s3	AcceptedTAndC	INT
Bi_Dimuser_s3	NationalityFK	INT
Bi_Dimuser_s3	DOB_IncompleteYear	NVARCHAR(20)
Bi_Dimuser_s3	organizationid	VARCHAR(36)
Bi_Dimuser_s3	Void	BOOLEAN
Bi_Dimuser_s3	employeetags	VARCHAR(MAX)
Bi_Dimuser_s3	usertags	VARCHAR(MAX)
Bi_Dimuser_s3	JobName	NVARCHAR(1020)
Bi_Dimuser_s3	JobCode	NVARCHAR(8000)
Bi_Dimuser_s3	GuestReferralSource	NVARCHAR(1600)
Bi_Dimuser_s3	EmailState	INT
Bi_Dimuser_s3	MandatoryBreakTimePerDay	INT
Bi_Dimuser_s3	PhoneCode	INT
Bi_Dimuser_s3	StartDate	TIMESTAMP
Bi_Dimuser_s3	LastDate	TIMESTAMP
Bi_Dimuser_s3	NoSaleComments	VARCHAR(MAX)
Bi_Dimuser_s3	AdditionalField1	NVARCHAR(4096)
Bi_Dimuser_s3	AdditionalField2	NVARCHAR(4096)
Bi_Dimuser_s3	EmployeeCode	NVARCHAR(512)
Bi_Dimuser_s3	RelationshipManager	VARCHAR(36)
Bi_Dimuser_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_Dimuser_s3	EtlLastUpdatedBy	NVARCHAR(512)
Bi_Dimuser_s3	Date1	TIMESTAMP
Bi_Dimuser_s3	Date2	TIMESTAMP
Bi_Dimuser_s3	PodName	VARCHAR(20)
Bi_DimUser_s3	CTEtlLastUpdatedOn	TIMESTAMP
Bi_DimUser_s3	groupid	BIGINT
Bi_DimUser_s3	TenureStartDate	TIMESTAMP
Bi_DimUser_s3	nationality	VARCHAR(4096)

In this section:

User dimension table

Search results