V_QUERY_BBDW_EDUCATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONSYSTEMID | uniqueidentifier | yes | |
| EDUCATIONDIMID | int | ||
| CONSTITUENTDIMID | int | yes | |
| EDUCATIONINSTITUTION | nvarchar(100) | yes | |
| EDUCATIONINSTITUTIONISAFFLIATED | bit | yes | |
| ISPRIMARYRECORD | bit | yes | |
| EDUCATIONTYPE | nvarchar(100) | yes | |
| EDUCATIONSTATUS | nvarchar(100) | yes | |
| CLASSOF | int | yes | |
| EDUCATIONDEGREE | nvarchar(100) | yes | |
| EDUCATIONPROGRAM | nvarchar(100) | yes | |
| ACADEMICCATALOGDEGREE | nvarchar(150) | yes | |
| ACADEMICCATALOGPROGRAM | nvarchar(50) | yes | |
| EDUCATIONAWARD | nvarchar(100) | yes | |
| PREFERREDCLASSYEAR | int | yes | |
| EDUCATIONLEVEL | nvarchar(100) | yes | |
| EDUCATIONREASON | nvarchar(100) | yes | |
| EDUCATIONGRADUATEFUZZYDATE | UDT_FUZZYDATE | ||
| EDUCATIONLEFTFUZZYDATE | UDT_FUZZYDATE | ||
| EDUCATIONSTARTFUZZYDATE | UDT_FUZZYDATE | ||
| EDUCATIONENDFUZZYDATE | UDT_FUZZYDATE |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EDUCATION] as
select
e.[EDUCATIONSYSTEMID],
e.[EDUCATIONDIMID],
e.[CONSTITUENTDIMID],
e.[EDUCATIONINSTITUTION],
e.[EDUCATIONINSTITUTIONISAFFLIATED],
e.[ISPRIMARYRECORD],
e.[EDUCATIONTYPE],
case
when (e.[EDUCATIONSTATUS] = 'No Education Status' and e.[EDUCATIONCONSTITUENCYSTATUS] <> 'No Education Constituency Status') then e.[EDUCATIONCONSTITUENCYSTATUS]
else e.[EDUCATIONSTATUS]
end as [EDUCATIONSTATUS],
e.[CLASSOF],
e.[EDUCATIONDEGREE],
e.[EDUCATIONPROGRAM],
e.[ACADEMICCATALOGDEGREE],
e.[ACADEMICCATALOGPROGRAM],
e.[EDUCATIONAWARD],
e.[PREFERREDCLASSYEAR],
e.[EDUCATIONLEVEL],
e.[EDUCATIONREASON],
e.[EDUCATIONGRADUATEFUZZYDATE],
e.[EDUCATIONLEFTFUZZYDATE],
e.[EDUCATIONSTARTFUZZYDATE],
e.[EDUCATIONENDFUZZYDATE]
from BBDW.[DIM_EDUCATION] e
where e.[EDUCATIONDIMID] > 0