DIM_RECURRINGGIFTSTATUSREASON_STAGE
Staging table for the recurring gift status reason dimension.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RECURRINGGIFTSTATUSREASONSYSTEMID | uniqueidentifier | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[ID] | |
| REASONTYPECODE | smallint | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[REASONTYPECODE] | |
| REASONTYPE | nvarchar(25) | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[REASONTYPE] | |
| RECURRINGGIFTSTATUSREASONCODE | nvarchar(10) | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[CODE] | |
| RECURRINGGIFTSTATUSREASONDESCRIPTION | nvarchar(50) | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[DESCRIPTION] | |
| RECURRINGGIFTSTATUSREASONISACTIVE | bit | yes | dbo.[RECURRINGGIFTSTATUSREASONCODE].[ACTIVE] | |
| 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. |