DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT_STAGE

Intermediate storage table for constituent employment.

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTRELATIONSHIPEMPLOYMENTSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIPJOBINFO].[ID]
CONSTITUENTRELATIONSHIPSETSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIPJOBINFO].[RELATIONSHIPSETID]
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.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.