V_DIM_EDUCATIONALINVOLVEMENT
Educational involvement View, based on the EDUCATIONALINVOLVEMENT dimension.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EDUCATIONALINVOLVEMENTDIMID | int | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTDIMID] | |
| EDUCATIONALINVOLVEMENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[CONSTITUENTSYSTEMID] |
| EDUCATIONALINVOLVEMENTCOMMENT | nvarchar(500) | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTCOMMENT] |
| EDUCATIONALINVOLVEMENTPOSITION | nvarchar(256) | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTPOSITION] |
| EDUCATIONALINVOLVEMENTTYPEDESCRIPTION | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTTYPEDESCRIPTION] |
| EDUCATIONALINVOLVEMENTNAME | nvarchar(150) | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTNAME] |
| EDUCATIONALINVOLVEMENTFROMDATE | UDT_FUZZYDATE | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTFROMDATE] | |
| EDUCATIONALINVOLVEMENTTODATE | UDT_FUZZYDATE | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTTODATE] | |
| EDUCATIONALINVOLVEMENTAWARDDESCRIPTION | nvarchar(100) | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[EDUCATIONALINVOLVEMENTAWARDDESCRIPTION] |
| ISINCLUDED | int | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[ISINCLUDED] |
| SOURCEDIMID | smallint | yes | BBDW.[DIM_EDUCATIONALINVOLVEMENT].[SOURCEDIMID] |
Definition
Copy
create view BBDW.[V_DIM_EDUCATIONALINVOLVEMENT]
as
select
e.[EDUCATIONALINVOLVEMENTDIMID],
e.[EDUCATIONALINVOLVEMENTSYSTEMID],
e.[CONSTITUENTDIMID],
e.[CONSTITUENTSYSTEMID],
e.[EDUCATIONALINVOLVEMENTCOMMENT],
e.[EDUCATIONALINVOLVEMENTPOSITION],
e.[EDUCATIONALINVOLVEMENTTYPEDESCRIPTION],
e.[EDUCATIONALINVOLVEMENTNAME],
e.[EDUCATIONALINVOLVEMENTFROMDATE],
e.[EDUCATIONALINVOLVEMENTTODATE],
e.[EDUCATIONALINVOLVEMENTAWARDDESCRIPTION],
e.[ISINCLUDED],
e.[SOURCEDIMID]
from BBDW.[DIM_EDUCATIONALINVOLVEMENT] e