DIM_RECURRINGGIFTFLAG
Contains boolean flags for recurring gift installments.
Primary Key
| Primary Key | Field Type |
|---|---|
| RECURRINGGIFTFLAGDIMID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ISFIRSTINSTALLMENT | bit | yes | Is the first installment ever for the recurring gift | |
| ISLASTINSTALLMENT | bit | yes | Is the last installment ever for the recurring gift | |
| ISMISSEDINSTALLMENT | bit | yes | Is a missed installment for the recurring gift | |
| ISFUTUREINSTALLMENT | bit | yes | Is a future installment for the recurring gift | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| SOURCEDIMID | int | yes | Source system used. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_DIM_RECURRINGGIFTFLAG | RECURRINGGIFTFLAGDIMID | yes | yes | yes |