V_QUERY_REGISTRANTRESTRICTIONOPTION
Registrant Restriction Option Query
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| TYPE | nvarchar(100) | Type | |
| DESCRIPTION | nvarchar(255) | Description | |
| REGISTRANTID | uniqueidentifier | Registrant ID | |
| EVENTRESTRICTIONOPTIONID | uniqueidentifier | Event Restriction Option ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:33 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REGISTRANTRESTRICTIONOPTION AS
select distinct
EVENTRESTRICTIONTYPE.ID,
EVENTRESTRICTIONTYPE.NAME as TYPE,
EVENTRESTRICTIONTYPE.DESCRIPTION,
REGISTRANTRESTRICTIONOPTION.REGISTRANTID,
REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
/*#EXTENSION*/
from dbo.REGISTRANTRESTRICTIONOPTION
inner join dbo.EVENTRESTRICTIONOPTION
on EVENTRESTRICTIONOPTION.ID = REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
inner join dbo.EVENTRESTRICTIONTYPE
on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID