| FUNDRAISERSYSTEMID |
uniqueidentifier |
yes |
|
BBDW.[DIM_CONSTITUENT].[CONSTITUENTSYSTEMID] |
| CONSTITUENTLOOKUPID |
nvarchar(100) |
yes |
|
BBDW.[DIM_CONSTITUENT].[CONSTITUENTLOOKUPID] |
| FULLNAME |
nvarchar(154) |
yes |
|
BBDW.[DIM_CONSTITUENT].[FULLNAME] |
| STAFFFUNDRAISERNAME |
nvarchar(154) |
yes |
|
BBDW.[DIM_CONSTITUENT].[FULLNAME]. Displays the FULLNAME where ISSTAFFFUNDRAISER is true, set as "Other" where it is false |
| PREFERREDFUNDRAISERNAME |
nvarchar(154) |
yes |
|
BBDW.[DIM_CONSTITUENT].[FULLNAME]. This field is available for custom names. |
| ISACTIVE |
bit |
yes |
|
BBDW.[DIM_CONSTITUENT].[ISACTIVE] |
| ISACTIVESTAFF |
bit |
yes |
|
BBDW.[DIM_CONSTITUENT].[ISACTIVESTAFF] |
| ISACTIVEFUNDRAISER |
bit |
yes |
|
BBDW.[DIM_CONSTITUENT].[ISACTIVEFUNDRAISER] |
| ISPREFERREDFUNDRAISER |
bit |
yes |
|
BBDW.[DIM_CONSTITUENT].[ISACTIVESTAFF]. This field is available for custom flagging. |
| ISDECEASED |
bit |
yes |
|
BBDW.[DIM_CONSTITUENT].[ISDECEASED] |
| HASREVENUE |
bit |
yes |
|
Set to true if there is at least one revenue from dbo.[REVENUESOLICITOR] |
| LASTFUNDRAISERREVENUEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from Fundraiser's last [REVENUESOLICITOR].[DATE] |
| TOTALFUNDRAISERREVENUEAMOUNT |
money |
yes |
|
Total revenue derived from dbo.[REVENUESOLICITOR].[AMOUNT] |
| TOTALFUNDRAISERREVENUECOUNT |
int |
yes |
|
Total counts of all revenue applications from dbo.[FINANCIALTRANSACTIONLINEITEM] |
| HASINTERACTION |
bit |
yes |
|
Set to true if there is at least one interaction from dbo.[INTERACTION] |
| LASTINTERACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from Fundraiser's last [INTERACTION].[DATE] |
| TOTALINTERACTIONCOUNT |
int |
yes |
|
Total count of all interactions from dbo.[INTERACTION] |
| HASPROSPECTPLAN |
bit |
yes |
|
Set to true if there is at least one Prospect Plan from dbo.[PROSPECTPLAN] |
| HASOPPORTUNITY |
bit |
yes |
|
Set to true if there is at least one Opportunity from dbo.[OPPORTUNITY] |
| TOTALPROSPECTPLANCOUNT |
int |
yes |
|
Total counts of all prospect plans from dbo.[PROSPECTPLAN] |
| TOTALOPPORTUNITYCOUNT |
int |
yes |
|
Total counts of all Opportunities from dbo.[OPPORTUNITY] |
| LASTOPPORTUNITYASKDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from Fundraiser's last [OPPORTUNITY].[ASKDATE] |
| LASTOPPORTUNITYEXPECTEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from Fundraiser's last [OPPORTUNITY].[EXPECTEDASKDATE] |
| LASTOPPORTUNITYRESPONSEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from Fundraiser's last [OPPORTUNITY].[RESPONSEDATE] |
| TOTALOPPORTUNITYASKAMOUNT |
money |
yes |
|
Total Amount of all Opportunity Ask Amounts from dbo.[OPPORTUNITY].[ASKAMOUNT] |
| TOTALOPPORTUNITYEXPECTEDAMOUNT |
money |
yes |
|
Total Amount of all Opportunity Expected Ask Amounts from dbo.[OPPORTUNITY].[EXPECTEDASKAMOUNT] |
| TOTALOPPORTUNITYAMOUNT |
money |
yes |
|
Total Amount of all Opportunity Amounts from dbo.[OPPORTUNITY].[AMOUNT] |
| HASPROSPECT |
bit |
yes |
|
Set to true if Fundraiser has at least one Prospect from dbo.[PROSPECT] |
| TOTALPROSPECTCOUNT |
int |
yes |
|
Total counts of all Prospects in dbo.[PROSPECT] |
| HASRELATIONSHIP |
bit |
yes |
|
Set to true if Fundraiser has at least one Relationship from dbo.[RELATIONSHIP] |
| TOTALRELATIONSHIPCOUNT |
int |
yes |
|
Total count of all relationships from dbo.[RELATIONSHIP] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |