RPT_GIVINGLISTDETAIL
The RPT_GIVINGLISTDETAIL table contains information from the list builder in the GivingList Summary Section.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| 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] | |
| FINANCIALTRANSACTIONLINEITEMPOSTDATE | date | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMPOSTDATE] | |
| TRANAPPLICATION | nvarchar(104) | yes | Derived from BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATION] and BBDW.[DIM_REVENUECODE].[REVENUETRANSACTIONTYPE] | |
| CAMPAIGNS | nvarchar(4000) | yes | [BBDW].[DIM_CAMPAIGN].[CAMPAIGNNAME] | |
| APPEALNAME | nvarchar(100) | yes | [BBDW].[DIM_APPEAL].[APPEALNAME] | |
| DESIGNATIONLOOKUPID | nvarchar(512) | yes | [BBDW].[DIM_DESIGNATION].[DESIGNATIONLOOKUPID] | |
| DESIGNATIONNAME | nvarchar(512) | yes | [BBDW].[DIM_DESIGNATION].[DESIGNATIONNAME] | |
| ISO4217 | nvarchar(3) | yes | [BBDW].[DIM_CURRENCY].[ISO4217] | |
| FINANCIALTRANSACTIONLINEITEMAMOUNT | money | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMAMOUNT] | |
| ORGANIZATIONCURRENCYSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_CURRENCY].[CURRENCYSYSTEMID] | |
| FINANCIALTRANSACTIONLINEITEMBASEAMOUNT | money | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMBASEAMOUNT] | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_CURRENCY].[CURRENCYSYSTEMID] | |
| FINANCIALTRANSACTIONLINEITEMTRANSACTIONAMOUNT | money | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMTRANSACTIONAMOUNT] | |
| TRANSACTIONCURRENCYSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_CURRENCY].[CURRENCYSYSTEMID] | |
| ISSPLIT | int | Derived from BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMAMOUNT] and BBDW.[FACT_FINANCIALTRANSACTION].[AMOUNT] | ||
| FIRSTTIMEDONATION | int | yes | Derived from [BBDW].[FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONSEQUENCEID] | |
| FINANCIALTRANSACTIONAMOUNT | money | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONAMOUNT] | |
| FINANCIALTRANSACTIONLOOKUPID | nvarchar(100) | yes | [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLOOKUPID] | |
| PROSPECTMANAGERFULLNAME | nvarchar(300) | yes | Derived from [BBDW].[DIM_CONSTITUENT].[FULLNAME] and [BBDW].[DIM_FUNDRAISER].[ID] | |
| CONSTITUENCY | nvarchar(4000) | yes | [BBDW].[DIM_CONSTITUENT].[CONSTITUENCY] | |
| RECOGNITION | nvarchar(4000) | yes | Derived from [BBDW].[DIM_CONSTITUENT].[FULLNAME] and BBDW.[REVENUERECOGNITION].[AMOUNT] | |
| SOLICITORS | nvarchar(4000) | yes | BBDW.[DIM_FUNDRAISER].[FULLNAME] | |
| SITES | nvarchar(4000) | yes | [BBDW].[DIM_SITE].[SITENAME] | |
| REVENUECHANNELDESCRIPTION | nvarchar(100) | yes | [BBDW].[DIM_REVENUECHANNEL].[REVENUECHANNELDESCRIPTION] | |
| REVENUEPAYMENTMETHOD | nvarchar(50) | yes | [BBDW].[DIM_REVENUECODE].[REVENUEPAYMENTMETHOD] | |
| DESIGNATIONREPORT1CODE | nvarchar(100) | yes | BBDW.[DIM_DESIGNATION].[DESIGNATIONREPORT1CODE] | |
| DESIGNATIONREPORT2CODE | nvarchar(100) | yes | BBDW.[DIM_DESIGNATION].[DESIGNATIONREPORTCODE] | |
| ISACTIVE | bit | yes | BBDW.[DIM_CONSTITUENT].[ISACTIVE] | |
| ISDECEASED | bit | yes | [BBDW].[DIM_CONSTITUENT].[ISDECEASED] | |
| REVENUEAPPLICATIONCODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATIONCODE] | |
| REVENUEAPPLICATION | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATION] | |
| FINANCIALTRANSACTIONDATE | date | yes | [BBDW].[FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONDATE] | |
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | uniqueidentifier | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMSYSTEMID] | ||
| GLREVENUECATEGORYNAME | nvarchar(100) | yes | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYNAME] |