V_QUERY_CONSTITUENCY_LATENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | ||
| CONSTITUENCY | nvarchar(100) | ||
| DATEFROM | date | yes | |
| DATETO | date | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | ||
| ADDEDBY_USERNAME | nvarchar(128) | ||
| CHANGEDBY_APPLICATION | nvarchar(200) | ||
| CHANGEDBY_USERNAME | nvarchar(128) | ||
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes | |
| TSLONG | varbinary | yes | |
| CONSTITUENCYDEFINITIONID | uniqueidentifier | ||
| REFRESHDATE | datetime | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/21/2016 5:06:52 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENCY_LATENT AS
select
CONSTITUENCYDATERANGE.ID as [ID],
CONSTITUENCYDATERANGE.CONSTITUENTID as [CONSTITUENTID],
CONSTITUENCYDEFINITION.DESCRIPTION as [CONSTITUENCY],
CONSTITUENCYDATERANGE.DATEFROM as [DATEFROM],
CONSTITUENCYDATERANGE.DATETO as [DATETO],
coalesce(CONSTITUENCYDATERANGE.ADDEDBYAPPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
coalesce(CONSTITUENCYDATERANGE.ADDEDBYUSERNAME, '') as [ADDEDBY_USERNAME],
coalesce(CONSTITUENCYDATERANGE.CHANGEDBYAPPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
coalesce(CONSTITUENCYDATERANGE.CHANGEDBYUSERNAME, '') as [CHANGEDBY_USERNAME],
CONSTITUENCYDATERANGE.DATEADDED as [DATEADDED],
CONSTITUENCYDATERANGE.DATECHANGED as [DATECHANGED],
CONSTITUENCYDATERANGE.CONSTITUENCYTS as [TSLONG],
CONSTITUENCYDATERANGE.CONSTITUENCYDEFINITIONID as [CONSTITUENCYDEFINITIONID],
CONSTITUENCYDATERANGE.REFRESHDATE as [REFRESHDATE]
/*#EXTENSION*/
from
dbo.CONSTITUENCYDATERANGE
inner join dbo.CONSTITUENCYDEFINITION
on CONSTITUENCYDEFINITION.ID = CONSTITUENCYDATERANGE.CONSTITUENCYDEFINITIONID