DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT

Contains information about constituent employment.

Primary Key

Primary Key	Field Type
CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID	int

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIPJOBINFO].[ID]
CONSTITUENTRELATIONSHIPSETDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[RELATIONSHIPJOBINFO].[RELATIONSHIPSETID]. Use this column to relate to BBDW.[FACT_CONSTITUENTRELATIONSHIP].
JOBTITLE	nvarchar(100)	yes		[dbo].[RELATIONSHIPJOBINFO].[JOBTITLE]
JOBCATEGORY	nvarchar(100)	yes		[dbo].[JOBCATEGORYCODE].[DESCRIPTION]
CAREERLEVEL	nvarchar(100)	yes		[dbo].[CAREERLEVELCODE].[DESCRIPTION]
JOBSCHEDULE	nvarchar(100)	yes		[dbo].[JOBSCHEDULECODE].[DESCRIPTION]
JOBDIVISION	nvarchar(100)	yes		[dbo].[RELATIONSHIPJOBINFO].[JOBDIVISION]
JOBDEPARTMENT	nvarchar(100)	yes		[dbo].[RELATIONSHIPJOBINFO].[JOBDEPARTMENT]
JOBRESPONSIBILITY	nvarchar(250)	yes		[dbo].[RELATIONSHIPJOBINFO].[JOBRESPONSIBILITY]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[RELATIONSHIPJOBINFO].[STARTDATE]
STARTDATE	datetime	yes		[dbo].[RELATIONSHIPJOBINFO].[STARTDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[RELATIONSHIPJOBINFO].[ENDDATE]
ENDDATE	datetime	yes		[dbo].[RELATIONSHIPJOBINFO].[ENDDATE]
ISPRIVATERECORD	bit	yes		[dbo].[RELATIONSHIPJOBINFO].[ISPRIVATERECORD]
ISCURRENTEMPLOYMENT	bit	yes		Flag indicating if the constituent employment record is current based on [dbo].[RELATIONSHIPJOBINFO].[STARTDATE] and [dbo].[RELATIONSHIPJOBINFO].[ENDDATE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT	CONSTITUENTRELATIONSHIPEMPLOYMENTDIMID	yes	yes	yes