RPT_GIVINGLISTDETAIL_SITES
Intermediate storage table for RPT_GIVINGLISTDETAIL
Primary Key
| Primary Key | Field Type |
|---|---|
| FINANCIALTRANSACTIONLINEITEMFACTID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | uniqueidentifier | yes | Derived from [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEMSITE].[FINANCIALTRANSACTIONLINEITEMSYSTEMID] | |
| SITES | nvarchar(4000) | yes | Derived from BBDW.[DIM_SITE].[SITENAME] using [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEMSITE] | |
| 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 |
|---|---|---|---|---|
| IX_RPT_GIVINGLISTDETAIL_SITES_FINANCIALTRANSACTIONLINEITEMSYSTEMID | FINANCIALTRANSACTIONLINEITEMSYSTEMID | |||
| PK_RPT_GIVINGLISTDETAIL_SITESS | FINANCIALTRANSACTIONLINEITEMFACTID | yes | yes | yes |