DIM_CONSTITUENT_STAGE
The Constituent dimension contains information about the constituent including primary address
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENT].[ID] | |
| CONSTITUENTLOOKUPID | nvarchar(100) | yes | dbo.[CONSTITUENT].[LOOKUPID] | |
| FULLNAME | nvarchar(154) | yes | dbo.[CONSTITUENT].[NAME] | |
| TITLE | nvarchar(100) | yes | dbo.[TITLECODE].[DESCRIPTION] | |
| FIRSTNAME | nvarchar(50) | yes | dbo.[CONSTITUENT].[FIRSTNAME] | |
| MIDDLENAME | nvarchar(50) | yes | dbo.[CONSTITUENT].[MIDDLENAME] | |
| NICKNAME | nvarchar(50) | yes | dbo.[CONSTITUENT].[NICKNAME] | |
| KEYNAMEPREFIX | nvarchar(50) | yes | dbo.[CONSTITUENT].[KEYNAMEPREFIX] | |
| KEYNAME | nvarchar(100) | yes | dbo.[CONSTITUENT].[KEYNAME] | |
| SUFFIX | nvarchar(100) | yes | dbo.[SUFFIXCODE].[DESCRIPTION] | |
| WEBADDRESS | UDT_WEBADDRESS | yes | dbo.[CONSTITUENT].[WEBADDRESS] | |
| BIRTHDATE | UDT_FUZZYDATE | yes | dbo.[CONSTITUENT].[BIRTHDATE] | |
| AGE | int | yes | dbo.[CONSTITUENT].[AGE] | |
| MARITALSTATUS | nvarchar(100) | yes | dbo.[MARITALSTATUSCODE].[DESCRIPTION] | |
| ORIGINATION | nvarchar(100) | yes | dbo.[INFOSOURCECODE].[DESCRIPTION] | |
| 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] | |
| ISORGANIZATION | bit | yes | dbo.[CONSTITUENT].[ISORGANIZATION] | |
| ISNETCOMMUNITYMEMBER | bit | yes | dbo.[CONSTITUENT].[NETCOMMUNITYMEMBER] | |
| RELIGION | nvarchar(100) | yes | dbo.[RELIGIONCODE].[DESCRIPTION] | |
| TARGET | nvarchar(100) | yes | dbo.[TARGETCODE].[DESCRIPTION] | |
| INCOME | nvarchar(100) | yes | dbo.[INCOMECODE].[DESCRIPTION] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SOURCEDIMID | int | yes | Source system used. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| CONSTITUENTRELIGIONCODESYSTEMID | uniqueidentifier | yes | dbo.[DEMOGRAPHIC].[RELIGIONCODEID] | |
| CONSTITUENTINCOMECODESYSTEMID | uniqueidentifier | yes | dbo.[DEMOGRAPHIC].[INCOMECODEID] | |
| CONSTITUENTTARGETCODESYSTEMID | uniqueidentifier | yes | dbo.[DEMOGRAPHIC].[TARGETCODEID] | |
| MARITALSTATUSCODESYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENT].[MARITALSTATUSCODEID] | |
| ORIGINATIONCODESYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENTORIGINATION].[INFOSOURCECODEID] | |
| GENDERCODE | tinyint | yes | dbo.[CONSTITUENT].[GENDERCODE] | |
| ISINDIVIDUAL | bit | yes | If the constituent is not a group or an organization then this will be true | |
| ISHOUSEHOLD | bit | yes | [dbo].[CONSTITUENTHOUSEHOLD].[ISHOUSEHOLD] | |
| SUFFIX2 | nvarchar(100) | yes | [dbo].[SUFFIXCODE].[DESCRIPTION] | |
| TITLE2 | nvarchar(100) | yes | [dbo].[TITLECODE].[DESCRIPTION] | |
| MAIDENNAME | nvarchar(100) | yes | [dbo].[CONSTITUENT].[MAIDENNAME] | |
| ADDEDDATE | datetime | yes | [dbo].[CONSTITUENT].[DATEADDED] | |
| ADDEDDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[CONSTITUENT].[DATEADDED] | |
| CHANGEDDATE | datetime | yes | [dbo].[CONSTITUENT].[DATECHANGED] | |
| CHANGEDDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[CONSTITUENT].[CHANGEDDATEDIMID] | |
| GENDERDESCRIPTION | nvarchar(100) | yes | [dbo].[GENDERCODE].[DESCRIPTION] |