V_QUERY_RE7_ADDRESS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| STATE | nvarchar(100) | yes | |
| STATEABBREVIATION | nvarchar(6) | yes | |
| CONSTITUENT_LOCALID | int | ||
| ISPRIMARY | bit | ||
| SENDMAIL | bit | yes | |
| ADDRESSBLOCK | nvarchar(150) | ||
| CITY | nvarchar(50) | ||
| POSTCODE | nvarchar(12) | ||
| CART | nvarchar(20) | ||
| DPC | nvarchar(8) | ||
| LOT | nvarchar(5) | ||
| ADDRESSLINE1 | nvarchar(150) | yes | |
| ADDRESSLINE2 | nvarchar(150) | yes | |
| ADDRESSLINE3 | nvarchar(150) | yes | |
| ADDRESSLINE4 | nvarchar(150) | yes | |
| ADDRESSLINE5 | nvarchar(150) | yes | |
| COUNTY | nvarchar(100) | yes | |
| REGION | nvarchar(100) | yes | |
| COUNTRY | nvarchar(100) | yes | |
| INDICATOR | int | yes | |
| DATECHANGED | datetime | ||
| DATEADDED | datetime | ||
| ADDEDBYUSER_LOCALID | int | ||
| CHANGEDBYUSER_LOCALID | int | ||
| IMPORTID | nvarchar(20) | yes | |
| CHANGEDBY | nvarchar(50) | yes | |
| ADDEDBY | nvarchar(50) | yes | |
| TYPE | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_ADDRESS AS
select
[A].[LOCALID],
[S].[DESCRIPTION] as [STATE],
[S].[ABBREVIATION] as [STATEABBREVIATION],
[A].[CONSTITUENT_LOCALID],
[ISPRIMARY],
cast((case [A].[DONOTMAIL] when 1 then 0 else 1 end) as bit) [SENDMAIL],
[ADDRESSBLOCK],
[CITY],
[POSTCODE],
[CART],
[DPC],
[LOT],
[ADDRESSLINE1],
[ADDRESSLINE2],
[ADDRESSLINE3],
[ADDRESSLINE4],
[ADDRESSLINE5],
[C].[DESCRIPTION] [COUNTY],
[R].[DESCRIPTION] [REGION],
[CO].[DESCRIPTION] as [COUNTRY],
[A].[INDICATOR],
[A].[DATECHANGED],
[A].[DATEADDED],
[A].[ADDEDBYUSER_LOCALID],
[A].[CHANGEDBYUSER_LOCALID],
[A].[IMPORTID],
[UC].[NAME] [CHANGEDBY],
[UA].[NAME] [ADDEDBY],
[AT].[DESCRIPTION] [TYPE]
from dbo.[RE7_ADDRESS] [A]
left outer join dbo.[RE7_ADDRESSTYPE] [AT] on [A].[ADDRESSTYPE_LOCALID] = [AT].[LOCALID]
left outer join dbo.[RE7_STATE] [S] on [A].[STATE_LOCALID] = [S].[LOCALID]
left outer join dbo.[RE7_COUNTYCODE] [C] on [A].[COUNTY_LOCALID] = [C].[LOCALID]
left outer join dbo.[RE7_REGIONCODE] [R] on [A].[REGION_LOCALID] = [R].[LOCALID]
left outer join dbo.[RE7_COUNTRY] [CO] on [A].[COUNTRY_LOCALID] = [CO].[LOCALID]
left outer join dbo.[RE7_USER] [UC] on [A].[CHANGEDBYUSER_LOCALID] = [UC].[LOCALID]
left outer join dbo.[RE7_USER] [UA] on [A].[ADDEDBYUSER_LOCALID] = [UA].[LOCALID]
where [A].[INDICATOR] in (0,2,3);