FACT_REVENUEATTRIBUTE_STAGE
DEPRECATED as of 4.0. Please use the newer FACT_FINANCIALTRANSACTIONATTRIBUTE table. Contains information from revenue attributes.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REVENUEATTRIBUTESYSTEMID | uniqueidentifier | yes | The attribute's [ID] column | |
| ATTRIBUTEDIMID | int | yes | Reference key to the attribute dimension, derived from dbo.[ATTRIBUTE].[ID] and the attribute's code table ID column | |
| ATTRIBUTESYSTEMID | uniqueidentifier | yes | dbo.[ATTRIBUTECATEGORY].[ID] | |
| ATTRIBUTEVALUESYSTEMID | uniqueidentifier | yes | The [ID] from the appropriate code table for this attribute. | |
| REVENUESYSTEMID | uniqueidentifier | yes | The attribute's [REVENUEID] column | |
| ATTRIBUTESTARTDATEDIMID | int | yes | Reference key to the date dimension, derived from the attribute's [STARTDATE] column | |
| ATTRIBUTESTARTDATE | datetime | yes | The attribute's [STARTDATE] column | |
| ATTRIBUTEENDDATEDIMID | int | yes | Reference key to the date dimension, derived from the attribute's [ENDDATE] column | |
| ATTRIBUTEENDDATE | datetime | yes | The attribute's [ENDDATE] column | |
| ATTRIBUTEVALUE | nvarchar(255) | yes | The attribute's value column | |
| ATTRIBUTEISCURRENT | bit | yes | Flag indicating if the attribute is currently active. | |
| 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. | |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | The attribute's comment column |