RPT_GIVINGLISTDETAIL_SOLICITORS
Intermediate storage table for RPT_GIVINGLISTDETAIL
Primary Key
| Primary Key | Field Type |
|---|---|
| FINANCIALTRANSACTIONLINEITEMFACTID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SOLICITORS | nvarchar(4000) | yes | Derived from BBDW.[DIM_CONSTITUENT].[FULLNAME] using [BBDW].[FACT_REVENUEFUNDRAISER] | |
| 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_SOLICITORSS | FINANCIALTRANSACTIONLINEITEMFACTID | yes | yes | yes |