CONSTITUENTSUMMARYAVAILABLETILE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTTYPECODE | tinyint | yes | |
| DATAFORMINSTANCECATALOGID | uniqueidentifier | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| ISDEFAULT | bit | ||
| SEQUENCE | int | ||
| CONSTITUENTTYPE | nvarchar(12) | ||
| TILENAME | nvarchar(100) |
Definition
Copy
CREATE view dbo.CONSTITUENTSUMMARYAVAILABLETILE
with schemabinding
as
select
AVAILABLESUMMARYTILE.ID,
cast(case AVAILABLESUMMARYTILE.SUMMARYTILECONTEXTID
when '3B16827B-54B1-4826-92DC-FDDA859D7C80' then 0 -- Individual
when '942E27F1-3191-49B9-AA0C-1F43E183E103' then 1 -- Organization
when '2C4191B4-A446-4974-B37D-19AF30F93D50' then 2 -- Household
when '7D38A703-41AE-4328-8A67-6F6441ADC392' then 3 -- Group
else 0 -- Default to individual
end as tinyint) as CONSTITUENTTYPECODE,
AVAILABLESUMMARYTILE.DATAFORMINSTANCECATALOGID,
AVAILABLESUMMARYTILE.ADDEDBYID,
AVAILABLESUMMARYTILE.CHANGEDBYID,
AVAILABLESUMMARYTILE.DATEADDED,
AVAILABLESUMMARYTILE.DATECHANGED,
AVAILABLESUMMARYTILE.TS,
AVAILABLESUMMARYTILE.TSLONG,
AVAILABLESUMMARYTILE.ISVISIBLEBYDEFAULT as ISDEFAULT,
AVAILABLESUMMARYTILE.SEQUENCE,
case AVAILABLESUMMARYTILE.SUMMARYTILECONTEXTID
when '3B16827B-54B1-4826-92DC-FDDA859D7C80' then N'Individual'
when '942E27F1-3191-49B9-AA0C-1F43E183E103' then N'Organization'
when '2C4191B4-A446-4974-B37D-19AF30F93D50' then N'Household'
when '7D38A703-41AE-4328-8A67-6F6441ADC392' then N'Group'
else N'Individual' -- Default to individual
end as CONSTITUENTTYPE,
AVAILABLESUMMARYTILE.TILENAME
from
dbo.AVAILABLESUMMARYTILE
where
AVAILABLESUMMARYTILE.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
)