Contains information about constituents.
Primary Key
| Primary Key |
Field Type |
| CONSTITUENTINFORMATIONDIMID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| MARITALSTATUSCODESYSTEMID |
uniqueidentifier |
yes |
|
dbo.[CONSTITUENT].[MARITALSTATUSCODEID] |
| MARITALSTATUS |
nvarchar(100) |
yes |
|
dbo.[MARITALSTATUSCODE].[DESCRIPTION] |
| ORIGINATIONCODESYSTEMID |
uniqueidentifier |
yes |
|
dbo.[CONSTITUENTORIGINATION].[INFOSOURCECODEID] |
| ORIGINATION |
nvarchar(100) |
yes |
|
dbo.[INFOSOURCECODE].[DESCRIPTION] |
| GENDERCODE |
tinyint |
yes |
|
dbo.[CONSTITUENT].[GENDERCODE] |
| GENDER |
nvarchar(10) |
yes |
|
dbo.[CONSTITUENT].[GENDER] |
| GIVESANONYMOUSLY |
bit |
yes |
|
dbo.[CONSTITUENT].[GIVESANONYMOUSLY] |
| ISACTIVE |
bit |
yes |
|
case when dbo.[CONSTITUENT].[ISINACTIVE] is 1 then 0 else 1 end |
| ISCONSTITUENT |
bit |
yes |
|
dbo.[CONSTITUENT].[ISCONSTITUENT] |
| ISDECEASED |
bit |
yes |
|
A record for the constituent exists in dbo.[DECEASEDCONSTITUENT] |
| ISGROUP |
bit |
yes |
|
dbo.[CONSTITUENT].[ISGROUP] |
| ISNETCOMMUNITYMEMBER |
bit |
yes |
|
dbo.[CONSTITUENT].[NETCOMMUNITYMEMBER] |
| ISORGANIZATION |
bit |
yes |
|
dbo.[CONSTITUENT].[ISORGANIZATION] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
|
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_DIM_CONSTITUENTINFORMATION |
CONSTITUENTINFORMATIONDIMID |
yes |
yes |
yes |