| EDUCATIONALINVOLVEMENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EDUCATIONALINVOLVEMENT].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent address type dimension, derived using dbo.[EDUCATIONALINVOLVEMENT].[CONSTITUENTID] |
| 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 |