v_DIM_CONSTITUENTINFORMATION
The constituent information dimension contains additional information about constituents.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTINFORMATIONDIMID | int | BBDW.[DIM_CONSTITUENTINFORMATION].[CONSTITUENTINFORMATIONDIMID] | |
| MARITALSTATUSCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[MARITALSTATUSCODESYSTEMID] |
| MARITALSTATUS | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[MARITALSTATUS] |
| ORIGINATIONCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ORIGINATIONCODESYSTEMID] |
| ORIGINATION | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ORIGINATION] |
| GENDERCODE | tinyint | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[GENDERCODE] |
| GENDER | nvarchar(10) | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[GENDER] |
| GIVESANONYMOUSLY | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[GIVESANONYMOUSLY] |
| ISACTIVE | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISACTIVE] |
| ISCONSTITUENT | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISCONSTITUENT] |
| ISDECEASED | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISDECEASED] |
| ISGROUP | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISGROUP] |
| ISNETCOMMUNITYMEMBER | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISNETCOMMUNITYMEMBER] |
| ISORGANIZATION | bit | yes | BBDW.[DIM_CONSTITUENTINFORMATION].[ISORGANIZATION] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CONSTITUENTINFORMATION] as
select
[CONSTITUENTINFORMATIONDIMID],
[MARITALSTATUSCODESYSTEMID],
[MARITALSTATUS],
[ORIGINATIONCODESYSTEMID],
[ORIGINATION],
[GENDERCODE],
[GENDER],
[GIVESANONYMOUSLY],
[ISACTIVE],
[ISCONSTITUENT],
[ISDECEASED],
[ISGROUP],
[ISNETCOMMUNITYMEMBER],
[ISORGANIZATION]
from BBDW.[DIM_CONSTITUENTINFORMATION];