V_QUERY_BBDW_EDUCATIONALINVOLVEMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONALINVOLVEMENTDIMID | int | ||
| EDUCATIONALINVOLVEMENTSYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| EDUCATIONALINVOLVEMENTCOMMENT | nvarchar(500) | yes | |
| EDUCATIONALINVOLVEMENTPOSITION | nvarchar(256) | yes | |
| EDUCATIONALINVOLVEMENTTYPEDESCRIPTION | nvarchar(100) | yes | |
| EDUCATIONALINVOLVEMENTNAME | nvarchar(150) | yes | |
| EDUCATIONALINVOLVEMENTFROMDATE | UDT_FUZZYDATE | ||
| EDUCATIONALINVOLVEMENTTODATE | UDT_FUZZYDATE | ||
| EDUCATIONALINVOLVEMENTAWARDDESCRIPTION | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EDUCATIONALINVOLVEMENT] as
select
e.[EDUCATIONALINVOLVEMENTDIMID],
e.[EDUCATIONALINVOLVEMENTSYSTEMID],
e.[CONSTITUENTDIMID],
e.[EDUCATIONALINVOLVEMENTCOMMENT],
e.[EDUCATIONALINVOLVEMENTPOSITION],
e.[EDUCATIONALINVOLVEMENTTYPEDESCRIPTION],
e.[EDUCATIONALINVOLVEMENTNAME],
e.[EDUCATIONALINVOLVEMENTFROMDATE],
e.[EDUCATIONALINVOLVEMENTTODATE],
e.[EDUCATIONALINVOLVEMENTAWARDDESCRIPTION]
from [BBDW].[DIM_EDUCATIONALINVOLVEMENT] e
where e.[EDUCATIONALINVOLVEMENTDIMID] > 0