V_QUERY_BBDW_EDUCATIONADDITIONALINFORMATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONADDITIONALINFORMATIONSYSTEMID | uniqueidentifier | yes | |
| EDUCATIONDIMID | int | yes | |
| ACADEMICCATALOGCOLLEGE | nvarchar(150) | yes | |
| ACADEMICCATALOGDEGREETYPE | nvarchar(100) | yes | |
| ACADEMICCATALOGDEPARTMENT | nvarchar(150) | yes | |
| ACADEMICCATALOGDIVISION | nvarchar(150) | yes | |
| ACADEMICCATALOGSUBDEPARTMENT | nvarchar(150) | yes | |
| EDUCATIONALCOLLEGE | nvarchar(100) | yes | |
| EDUCATIONALDEPARTMENT | nvarchar(100) | yes | |
| EDUCATIONALDEGREETYPE | nvarchar(100) | yes | |
| EDUCATIONALDIVISION | nvarchar(100) | yes | |
| EDUCATIONALSUBDEPARTMENT | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EDUCATIONADDITIONALINFORMATION] as
select
ea.[EDUCATIONADDITIONALINFORMATIONSYSTEMID],
ea.[EDUCATIONDIMID],
ea.[ACADEMICCATALOGCOLLEGE],
ea.[ACADEMICCATALOGDEGREETYPE],
ea.[ACADEMICCATALOGDEPARTMENT],
ea.[ACADEMICCATALOGDIVISION],
ea.[ACADEMICCATALOGSUBDEPARTMENT],
ea.[EDUCATIONALCOLLEGE],
ea.[EDUCATIONALDEPARTMENT],
ea.[EDUCATIONALDEGREETYPE],
ea.[EDUCATIONALDIVISION],
ea.[EDUCATIONALSUBDEPARTMENT]
from BBDW.[DIM_EDUCATIONADDITIONALINFORMATION] ea
where ea.[EDUCATIONADDITIONALINFORMATIONDIMID] > 0