RPT_RECOGNITIONGIVINGLISTDETAIL
The RPT_RECOGNITIONGIVINGLISTDETAIL table contains information for the recognition list builder in the GivingList.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REVENUERECOGNITIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_REVENUERECOGNITION].[REVENUERECOGNITIONSYSTEMID] | |
| FINANCIALTRANSACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONSYSTEMID] | |
| CONSTITUENTLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTLOOKUPID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTSYSTEMID] | |
| NAME | nvarchar(300) | yes | Derived from BBDW.[DIM_CONSTITUENT].[FIRSTNAME], BBDW.[DIM_CONSTITUENT].[LASTNAME], BBDW.[DIM_CONSTITUENT].[MIDDLENAME], BBDW.[DIM_CONSTITUENT].[KEYNAME], BBDW.[DIM_CONSTITUENT].[FULLNAME] | |
| PRIMARYEMAILADDRESS | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENT].[PRIMARYEMAILADDRESS] | |
| PRIMARYPHONE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENT].[PRIMARYPHONE] | |
| DONOTEMAIL | bit | yes | BBDW.[DIM_CONSTITUENT].[DONOTEMAIL] | |
| DONOTCALL | bit | yes | [BBDW].[DIM_CONSTITUENT].[DONOTCALL] | |
| PRIMARYADDRESS | nvarchar(150) | yes | [BBDW].[DIM_CONSTITUENT].[PRIMARYADDRESS] | |
| CITYSTATEZIP | nvarchar(114) | yes | [BBDW].[DIM_CONSTITUENT].[CITYSTATEZIP] | |
| PRIMARYADDRESSCITY | nvarchar(50) | yes | [BBDW].[DIM_CONSTITUENT].[PRIMARYADDRESSCITY] | |
| PRIMARYADDRESSSTATEABBREVIATION | nvarchar(50) | yes | [BBDW].[DIM_CONSTITUENT].[PRIMARYADDRESSSTATEABBREVIATION] | |
| PRIMARYADDRESSPOSTCODE | nvarchar(12) | yes | [BBDW].[DIM_CONSTITUENT].[PRIMARYADDRESSPOSTCODE] | |
| GIVENANONYMOUSLY | int | [BBDW].[DIM_REVENUEFLAG].[GIVENANONYMOUSLY] | ||
| ISORGANIZATION | bit | yes | [BBDW].[DIM_CONSTITUENT].[ISORGANIZATION] | |
| ISCONSTITUENT | bit | yes | [BBDW].[DIM_CONSTITUENT].[ISCONSTITUENT] | |
| ISGROUP | bit | yes | [BBDW].[DIM_CONSTITUENT].[ISGROUP] | |
| ISACTIVE | bit | yes | BBDW.[DIM_CONSTITUENT].[ISACTIVE] | |
| ISDECEASED | bit | yes | [BBDW].[DIM_CONSTITUENT].[ISDECEASED] | |
| FINANCIALTRANSACTIONDATE | date | yes | [BBDW].[FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONDATE] | |
| REVENUERECOGNITIONDATE | date | yes | [BBDW].[FACT_REVENUERECOGNITION].[EFFECTIVEDATE] | |
| TRANAPPLICATION | nvarchar(104) | yes | Derived from BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATION] and BBDW.[DIM_REVENUECODE].[REVENUETRANSACTIONTYPE] | |
| CAMPAIGNS | nvarchar(4000) | yes | Derived from BBDW.[DIM_CAMPAIGN].[CAMPAIGNNAME] using [BBDW].[FACT_REVENUECAMPAIGN] | |
| APPEALNAME | nvarchar(100) | yes | [BBDW].[DIM_APPEAL].[APPEALNAME] | |
| DESIGNATIONLOOKUPID | nvarchar(512) | yes | [BBDW].[DIM_DESIGNATION].[DESIGNATIONLOOKUPID] | |
| DESIGNATIONNAME | nvarchar(512) | yes | [BBDW].[DIM_DESIGNATION].[DESIGNATIONNAME] | |
| DESIGNATIONREPORT1CODE | nvarchar(100) | yes | BBDW.[DIM_DESIGNATION].[DESIGNATIONREPORT1CODE] | |
| DESIGNATIONREPORT2CODE | nvarchar(100) | yes | BBDW.[DIM_DESIGNATION].[DESIGNATIONREPORTCODE] | |
| ISO4217 | nvarchar(3) | yes | [BBDW].[DIM_CURRENCY].[ISO4217] | |
| FINANCIALTRANSACTIONLINEITEMBASEAMOUNT | money | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMBASEAMOUNT] | |
| REVENUERECOGNITIONBASEAMOUNT | money | yes | [BBDW].[FACT_REVENUERECOGNITION].[BASEREVENUERECOGNITIONAMOUNT] | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_CURRENCY].[CURRENCYSYSTEMID] | |
| PROSPECTMANAGERFULLNAME | nvarchar(300) | yes | Derived from [BBDW].[DIM_CONSTITUENT].[FULLNAME] and [BBDW].[DIM_FUNDRAISER].[ID] | |
| CONSTITUENCY | nvarchar(4000) | yes | [BBDW].[DIM_CONSTITUENT].[CONSTITUENCY] | |
| SOLICITORS | nvarchar(4000) | yes | Derived from BBDW.[DIM_CONSTITUENT].[FULLNAME] using [BBDW].[FACT_REVENUEFUNDRAISER] | |
| SITES | nvarchar(4000) | yes | Derived from BBDW.[DIM_SITE].[SITENAME] using [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEMSITE] | |
| REVENUECHANNELDESCRIPTION | nvarchar(100) | yes | [BBDW].[DIM_REVENUECHANNEL].[REVENUECHANNELDESCRIPTION] | |
| REVENUEPAYMENTMETHOD | nvarchar(50) | yes | [BBDW].[DIM_REVENUECODE].[REVENUEPAYMENTMETHOD] | |
| REVENUEAPPLICATIONCODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATIONCODE] | |
| REVENUEAPPLICATION | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATION] | |
| GLREVENUECATEGORYNAME | nvarchar(100) | yes | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYNAME] | |
| RECOGNITIONTYPE | nvarchar(100) | yes | BBDW.[DIM_REVENUERECOGNITIONTYPE].[REVENUERECOGNITIONTYPE] | |
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMSYSTEMID] |