FACT_PROSPECTPLANATTRIBUTE_STAGE
Contains information from prospect plan attributes.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PROSPECTPLANATTRIBUTESYSTEMID | 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. | |
| PROSPECTPLANSYSTEMID | uniqueidentifier | yes | The attribute's [PROSPECTPLANID] 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 | |
| VALUEDATE | date | yes | The attribute's value column for date attributes | |
| VALUEDATEDIMID | int | yes | Reference key to the date dimension, derived from the attribute's value column for date attributes | |
| VALUEYESNO | bit | yes | The attribute's value column for yes/no attributes | |
| VALUECURRENCY | money | yes | The attribute's value column for currency attributes | |
| VALUECONSTITUENTSYSTEMID | uniqueidentifier | yes | The attribute's value column for constituent record attributes | |
| VALUEHOURMINUTE | UDT_HOURMINUTE | yes | The attribute's value column for time attributes | |
| VALUEFUZZYDATE | UDT_FUZZYDATE | yes | The attribute's value column for fuzzy date attributes | |
| VALUENUMBER | int | yes | The attribute's value column for number attributes |