v_DIM_CONSTITUENTADDRESS
The constituent address dimension contains information about addresses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTADDRESSDIMID | int | BBDW.[DIM_CONSTITUENTADDRESS].[CONSTITUENTADDRESSDIMID] | |
| CITY | nvarchar(50) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[CITY] |
| STATE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[STATE] |
| STATEABBREVIATION | nvarchar(50) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[STATEABBREVIATION] |
| COUNTRY | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[COUNTRY] |
| COUNTRYABBREVIATION | nvarchar(5) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[COUNTRYABBREVIATION] |
| POSTCODE | nvarchar(12) | yes | BBDW.[DIM_CONSTITUENTADDRESS].[POSTCODE] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTADDRESS] as
select
[CONSTITUENTADDRESSDIMID],
[CITY],
[STATE],
[STATEABBREVIATION],
[COUNTRY],
[COUNTRYABBREVIATION],
[POSTCODE]
from BBDW.[DIM_CONSTITUENTADDRESS]