DIM_EDUCATIONALINVOLVEMENT_STAGE

Educational involvement, based on the EDUCATIONALINVOLVEMENT table.

Fields

Field	Field Type	Null	Notes	Description
EDUCATIONALINVOLVEMENTSYSTEMID	uniqueidentifier	yes		dbo.[EDUCATIONALINVOLVEMENT].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[EDUCATIONALINVOLVEMENT].[CONSTITUENTID]
EDUCATIONALINVOLVEMENTCOMMENT	nvarchar(500)	yes		dbo.[EDUCATIONALINVOLVEMENT].[COMMENT]
EDUCATIONALINVOLVEMENTPOSITION	nvarchar(256)	yes		dbo.[EDUCATIONALINVOLVEMENT].[POSITION]
EDUCATIONALINVOLVEMENTTYPEDESCRIPTION	nvarchar(100)	yes		dbo.[EDUCATIONALINVOLVEMENTTYPECODE].[DESCRIPTION]
EDUCATIONALINVOLVEMENTNAME	nvarchar(150)	yes		dbo.[EDUCATIONALINVOLVEMENTNAME].[NAME]
EDUCATIONALINVOLVEMENTFROMDATE	UDT_FUZZYDATE			dbo.[EDUCATIONALINVOLVEMENT].[FROMDATE]
EDUCATIONALINVOLVEMENTTODATE	UDT_FUZZYDATE			dbo.[EDUCATIONALINVOLVEMENT].[TODATE]
EDUCATIONALINVOLVEMENTAWARDDESCRIPTION	nvarchar(100)	yes		dbo.[EDUCATIONINVOLVEMENTAWARDCODE].[DESCRIPTION]
ADDEDBYSYSTEMID	uniqueidentifier	yes		dbo.[EDUCATIONALINVOLVEMENT].[ADDEDBYID]
CHANGEDBYSYSTEMID	uniqueidentifier	yes		dbo.[EDUCATIONALINVOLVEMENT].[CHANGEDBYID]
ADDEDDATE	datetime	yes		dbo.[EDUCATIONALINVOLVEMENT].[DATEADDED]
ADDEDDATEDIMID	int	yes		Reference key to the constituent address type dimension, derived using dbo.[EDUCATIONALINVOLVEMENT].[DATEADDED].
CHANGEDDATE	datetime	yes		dbo.[EDUCATIONALINVOLVEMENT].[DATECHANGED]
CHANGEDDATEDIMID	int	yes		Reference key to the constituent address type dimension, derived using dbo.[EDUCATIONALINVOLVEMENT].[DATECHANGED].
ISINCLUDED	int	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	smallint	yes		Foreign Key to DIM_SOURCE