| CONSTITUENTADDRESSATTRIBUTESYSTEMID |
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. |
| CONSTITUENTADDRESSFACTID |
int |
yes |
|
Reference key to the CONSTITUENTADDRESS fact, derived from the attribute's [CONSTITUENTADDRESSID] 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. |
| CONSTITUENTADDRESSSYSTEMID |
uniqueidentifier |
yes |
|
The attribute table's [ADDRESSID] column |
| 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 |
| VALUECONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from 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 |