RPT_GIVINGLISTDETAIL_CAMPAIGNS
Intermediate storage table for RPT_GIVINGLISTDETAIL
Primary Key
| Primary Key | Field Type |
|---|---|
| FINANCIALTRANSACTIONLINEITEMFACTID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CAMPAIGNS | nvarchar(4000) | yes | Derived from BBDW.[DIM_CAMPAIGN].[CAMPAIGNNAME] using [BBDW].[FACT_REVENUECAMPAIGN] | |
| ISDELETED | bit | yes | Denotes that the row has a deleted value. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_RPT_GIVINGLISTDETAIL_CAMPAIGNSS | FINANCIALTRANSACTIONLINEITEMFACTID | yes | yes | yes |