DIM_TRIBUTE_STAGE
Contains information about tributes associated with revenues.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| TRIBUTESYSTEMID | uniqueidentifier | yes | [dbo].[TRIBUTE].[ID] | |
| TRIBUTEECONSTITUENTSYSTEMID | uniqueidentifier | yes | [dbo].[TRIBUTE].[TRIBUTEEID] | |
| TRIBUTETEXT | nvarchar(520) | yes | [dbo].[TRIBUTE].[TRIBUTETEXT] | |
| TRIBUTETYPE | nvarchar(200) | yes | [dbo].[TRIBUTETYPECODE].[DESCRIPTION] | |
| DESIGNATIONDIMID | int | yes | Reference key to the designation dimension, derived from dbo.[TRIBUTE].[DESIGNATIONID] | |
| 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. |