FACT_PLANNEDGIFTDESIGNATION_STAGE
Contains information about planned gift designation.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PLANNEDGIFTDESIGNATIONSYSTEMID | uniqueidentifier | yes | dbo.[PLANNEDGIFTDESIGNATION].[ID] | |
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | dbo.[PLANNEDGIFTDESIGNATION].[PLANNEDGIFTID] | |
| PLANNEDGIFTDIMID | int | yes | Surrogate key for the planned gift dim table. | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SOURCEDIMID | int | yes | Source system used. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. |