v_DIM_EDUCATIONADDITIONALINFORMATION
The education additional information dimension contains additional education information about constituents.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONADDITIONALINFORMATIONDIMID | int | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONADDITIONALINFORMATIONDIMID] | |
| EDUCATIONADDITIONALINFORMATIONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONADDITIONALINFORMATIONSYSTEMID] |
| EDUCATIONDIMID | int | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[CONSTITUENTSYSTEMID] |
| ACADEMICCATALOGCOLLEGE | nvarchar(150) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[ACADEMICCATALOGCOLLEGE] |
| ACADEMICCATALOGDEPARTMENT | nvarchar(150) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[ACADEMICCATALOGDEPARTMENT] |
| ACADEMICCATALOGDEGREETYPE | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[ACADEMICCATALOGDEGREETYPE] |
| EDUCATIONALCOLLEGE | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONALCOLLEGE] |
| EDUCATIONALDEPARTMENT | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONALDEPARTMENT] |
| EDUCATIONALDEGREETYPE | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONALDEGREETYPE] |
| ACADEMICCATALOGDIVISION | nvarchar(150) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[ACADEMICCATALOGDIVISION] |
| ACADEMICCATALOGSUBDEPARTMENT | nvarchar(150) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[ACADEMICCATALOGSUBDEPARTMENT] |
| EDUCATIONALDIVISION | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONALDIVISION] |
| EDUCATIONALSUBDEPARTMENT | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONADDITIONALINFORMATION].[EDUCATIONALSUBDEPARTMENT] |
Definition
Copy
create view [BBDW].[v_DIM_EDUCATIONADDITIONALINFORMATION] as
select
[EDUCATIONADDITIONALINFORMATIONDIMID],
[EDUCATIONADDITIONALINFORMATIONSYSTEMID],
[EDUCATIONDIMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[ACADEMICCATALOGCOLLEGE],
[ACADEMICCATALOGDEPARTMENT],
[ACADEMICCATALOGDEGREETYPE],
[EDUCATIONALCOLLEGE],
[EDUCATIONALDEPARTMENT],
[EDUCATIONALDEGREETYPE],
[ACADEMICCATALOGDIVISION],
[ACADEMICCATALOGSUBDEPARTMENT],
[EDUCATIONALDIVISION],
[EDUCATIONALSUBDEPARTMENT]
from BBDW.[DIM_EDUCATIONADDITIONALINFORMATION]