The Education Additional Information dimension contains additional information about a constituents educational history.
Primary Key
| Primary Key |
Field Type |
| EDUCATIONADDITIONALINFORMATIONDIMID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| EDUCATIONADDITIONALINFORMATIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EDUCATIONADDITIONALINFORMATION].[ID] |
| EDUCATIONDIMID |
int |
yes |
|
Reference key to the education dimension, derived from dbo.[EDUCATIONADDITIONALINFORMATION].[EDUCATIONALHISTORYID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[EDUCATIONALHISTORY].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EDUCATIONALHISTORY].[CONSTITUENTID] |
| ACADEMICCATALOGCOLLEGE |
nvarchar(150) |
yes |
|
dbo.[ACADEMICCATALOGCOLLEGE].[NAME] |
| ACADEMICCATALOGDEPARTMENT |
nvarchar(150) |
yes |
|
dbo.[ACADEMICCATALOGDEPARTMENT].[NAME] |
| ACADEMICCATALOGDEGREETYPE |
nvarchar(100) |
yes |
|
dbo.[ACADEMICCATALOGDEGREETYPECODE].[DESCRIPTION] |
| EDUCATIONALCOLLEGE |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALCOLLEGECODE].[DESCRIPTION] |
| EDUCATIONALDEPARTMENT |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALDEPARTMENTCODE].[DESCRIPTION] |
| EDUCATIONALDEGREETYPE |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALDEGREETYPECODE].[DESCRIPTION] |
| 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 |
| ACADEMICCATALOGDIVISION |
nvarchar(150) |
yes |
|
dbo.[ACADEMICCATALOGDIVISION].[NAME] |
| ACADEMICCATALOGSUBDEPARTMENT |
nvarchar(150) |
yes |
|
dbo.[ACADEMICCATALOGSUBDEPARTMENT].[NAME] |
| EDUCATIONALDIVISION |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALDIVISIONCODE].[DESCRIPTION] |
| EDUCATIONALSUBDEPARTMENT |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALSUBDEPARTMENTCODE].[DESCRIPTION] |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_DIM_EDUCATIONADDITIONALINFORMATION_CONSTITUENTDIMID |
CONSTITUENTDIMID |
|
|
|
| IX_DIM_EDUCATIONADDITIONALINFORMATION_EDUCATIONDIMID |
EDUCATIONDIMID |
|
|
|
| PK_DIM_EDUCATIONADDITIONALINFORMATION |
EDUCATIONADDITIONALINFORMATIONDIMID |
yes |
yes |
yes |