CONSTITUENTSUMMARYSELECTEDTILE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| APPUSERID | uniqueidentifier | ||
| CONSTITUENTSUMMARYAVAILABLETILEID | uniqueidentifier | ||
| SEQUENCE | int | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.CONSTITUENTSUMMARYSELECTEDTILE
with schemabinding
as
select
SELECTEDSUMMARYTILE.ID,
APPUSERSUMMARYTILECONTEXT.APPUSERID,
SELECTEDSUMMARYTILE.AVAILABLESUMMARYTILEID as CONSTITUENTSUMMARYAVAILABLETILEID,
SELECTEDSUMMARYTILE.SEQUENCE,
SELECTEDSUMMARYTILE.ADDEDBYID,
SELECTEDSUMMARYTILE.CHANGEDBYID,
SELECTEDSUMMARYTILE.DATEADDED,
SELECTEDSUMMARYTILE.DATECHANGED,
SELECTEDSUMMARYTILE.TS,
SELECTEDSUMMARYTILE.TSLONG
from
dbo.SELECTEDSUMMARYTILE
inner join dbo.APPUSERSUMMARYTILECONTEXT
on SELECTEDSUMMARYTILE.APPUSERSUMMARYTILECONTEXTID = APPUSERSUMMARYTILECONTEXT.ID
where
APPUSERSUMMARYTILECONTEXT.SUMMARYTILECONTEXTID in (
'3B16827B-54B1-4826-92DC-FDDA859D7C80', -- Individual
'942E27F1-3191-49B9-AA0C-1F43E183E103', -- Organization
'2C4191B4-A446-4974-B37D-19AF30F93D50', -- Household
'7D38A703-41AE-4328-8A67-6F6441ADC392' -- Group
)