V_QUERY_CONSTITUENTRESTRICTIONOPTION

Constituent Restriction Option Query

Fields

Field Field Type Null Description
ID uniqueidentifier System record ID
TYPE nvarchar(100) Type
DESCRIPTION nvarchar(255) Description
CONSTITUENTID uniqueidentifier Constituent ID
EVENTRESTRICTIONOPTIONID uniqueidentifier Event Restriction Option ID

Definition

Copy 
/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:43:39 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTRESTRICTIONOPTION AS



                select distinct
                    EVENTRESTRICTIONTYPE.ID,
                    EVENTRESTRICTIONTYPE.NAME as TYPE,
                    EVENTRESTRICTIONTYPE.DESCRIPTION,
                    CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID,
                    CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
                    /*#EXTENSION*/ 
                from dbo.CONSTITUENTRESTRICTIONOPTION
                inner join dbo.EVENTRESTRICTIONOPTION
                    on EVENTRESTRICTIONOPTION.ID = CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
                inner join dbo.EVENTRESTRICTIONTYPE
                    on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID