DIM_SPONSORSHIPREASON_STAGE
Intermediate storage for sponsorship reason records
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SPONSORSHIPREASONSYSTEMID | uniqueidentifier | yes | dbo.[SPONSORSHIPREASON].[ID] | |
| SPONSORSHIPREASON | nvarchar(100) | yes | dbo.[SPONSORSHIPREASON].[REASON] | |
| SPONSORSHIPREASONTYPECODE | int | yes | dbo.[SPONSORSHIPREASON].[REASONTYPECODE] | |
| SPONSORSHIPREASONTYPE | nvarchar(100) | yes | dbo.[SPONSORSHIPREASON].[REASONTYPE] | |
| 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. |