v_DIM_EDUCATION
The education dimension contains education information about constituents
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONDIMID | int | BBDW.[DIM_EDUCATION].[EDUCATIONDIMID] | |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_EDUCATION].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EDUCATION].[CONSTITUENTSYSTEMID] |
| EDUCATIONINSTITUTION | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONINSTITUTION] |
| EDUCATIONINSTITUTIONISAFFLIATED | bit | yes | BBDW.[DIM_EDUCATION].[EDUCATIONINSTITUTIONISAFFLIATED] |
| EDUCATIONINSTITUTIONFICECODE | nvarchar(50) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONINSTITUTIONFICECODE] |
| ISPRIMARYRECORD | bit | yes | BBDW.[DIM_EDUCATION].[ISPRIMARYRECORD] |
| EDUCATIONTYPE | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONTYPE] |
| EDUCATIONSTATUS | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONSTATUS] |
| EDUCATIONCONSTITUENCYSTATUS | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONCONSTITUENCYSTATUS] |
| CLASSOF | int | yes | BBDW.[DIM_EDUCATION].[CLASSOF] |
| EDUCATIONDEGREE | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONDEGREE] |
| EDUCATIONPROGRAM | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONPROGRAM] |
| ACADEMICCATALOGDEGREE | nvarchar(150) | yes | BBDW.[DIM_EDUCATION].[ACADEMICCATALOGDEGREE] |
| ACADEMICCATALOGPROGRAM | nvarchar(50) | yes | BBDW.[DIM_EDUCATION].[ACADEMICCATALOGPROGRAM] |
| EDUCATIONAWARD | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONAWARD] |
| PREFERREDCLASSYEAR | int | yes | BBDW.[DIM_EDUCATION].[PREFERREDCLASSYEAR] |
| EDUCATIONINFORMATIONSOURCE | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONINFORMATIONSOURCE] |
| EDUCATIONLEVEL | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONLEVEL] |
| EDUCATIONREASON | nvarchar(100) | yes | BBDW.[DIM_EDUCATION].[EDUCATIONREASON] |
Definition
Copy
create view [BBDW].[v_DIM_EDUCATION] as
select
[EDUCATIONDIMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[EDUCATIONINSTITUTION],
[EDUCATIONINSTITUTIONISAFFLIATED],
[EDUCATIONINSTITUTIONFICECODE],
[ISPRIMARYRECORD],
[EDUCATIONTYPE],
[EDUCATIONSTATUS],
[EDUCATIONCONSTITUENCYSTATUS],
[CLASSOF],
[EDUCATIONDEGREE],
[EDUCATIONPROGRAM],
[ACADEMICCATALOGDEGREE],
[ACADEMICCATALOGPROGRAM],
[EDUCATIONAWARD],
[PREFERREDCLASSYEAR],
[EDUCATIONINFORMATIONSOURCE],
[EDUCATIONLEVEL],
[EDUCATIONREASON]
from BBDW.[DIM_EDUCATION]