V_QUERY_REGISTRATIONINFORMATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| TYPE | nvarchar(17) | yes | |
| DISPLAYONLINE | bit | ||
| ONLINEHTML | nvarchar(max) | ||
| RESPONSETYPE | nvarchar(17) | yes | |
| INACTIVE | bit | ||
| ALLPRICETYPES | bit | ||
| ASKPERSONPHONE2 | bit | ||
| ASKPERSONEMAIL | bit | ||
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:19:03 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REGISTRATIONINFORMATION AS
select
REGISTRATIONINFORMATION.ID,
REGISTRATIONINFORMATION.NAME,
REGISTRATIONINFORMATION.TYPE,
REGISTRATIONINFORMATION.DISPLAYONLINE,
REGISTRATIONINFORMATION.ONLINEHTML,
REGISTRATIONINFORMATION.RESPONSETYPE,
REGISTRATIONINFORMATION.INACTIVE,
REGISTRATIONINFORMATION.ALLPRICETYPES,
REGISTRATIONINFORMATION.ASKPERSONPHONE2,
REGISTRATIONINFORMATION.ASKPERSONEMAIL,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
REGISTRATIONINFORMATION.DATEADDED,
REGISTRATIONINFORMATION.DATECHANGED,
REGISTRATIONINFORMATION.TSLONG
from
dbo.REGISTRATIONINFORMATION
left outer join
dbo.CHANGEAGENT as ADDEDBY on REGISTRATIONINFORMATION.ADDEDBYID = ADDEDBY.ID
left outer join
dbo.CHANGEAGENT as CHANGEDBY on REGISTRATIONINFORMATION.CHANGEDBYID = CHANGEDBY.ID