V_QUERY_REGISTRANTREGISTRATIONINFORMATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REGISTRANTID | uniqueidentifier | ||
| REGISTRATIONINFORMATIONID | uniqueidentifier | ||
| QUESTION | nvarchar(111) | yes | |
| RESPONSE | nvarchar(max) | yes | |
| 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:04 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REGISTRANTREGISTRATIONINFORMATION AS
select
REGISTRANTREGISTRATIONINFORMATION.ID,
REGISTRANTREGISTRATIONINFORMATION.REGISTRANTID,
REGISTRANTREGISTRATIONINFORMATION.REGISTRATIONINFORMATIONID,
REGISTRATIONINFORMATION.NAME
+
case REGISTRANTREGISTRATIONINFORMATION.PERSONDETAILTYPECODE
when 1 then
' First Name'
when 2 then
' Last Name'
when 3 then
' Phone'
when 4 then
' Phone 2'
when 5 then
' Email'
else
''
end as QUESTION,
case REGISTRATIONINFORMATION.RESPONSETYPECODE
when 2 then -- Dropdown list
REGISTRATIONINFORMATIONOPTION.NAME
when 3 then -- Checkbox (Yes/No)
case when REGISTRANTREGISTRATIONINFORMATION.BOOLEANVALUE = 1 then N'Yes' else N'No' end
else
REGISTRANTREGISTRATIONINFORMATION.TEXTVALUE
end as RESPONSE,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
REGISTRANTREGISTRATIONINFORMATION.DATEADDED,
REGISTRANTREGISTRATIONINFORMATION.DATECHANGED,
REGISTRANTREGISTRATIONINFORMATION.TSLONG
/*#EXTENSION*/
from
dbo.REGISTRANTREGISTRATIONINFORMATION
left outer join
dbo.REGISTRATIONINFORMATION on REGISTRATIONINFORMATION.ID = REGISTRANTREGISTRATIONINFORMATION.REGISTRATIONINFORMATIONID
left outer join
dbo.REGISTRATIONINFORMATIONOPTION on REGISTRATIONINFORMATIONOPTION.ID = REGISTRANTREGISTRATIONINFORMATION.REGISTRATIONINFORMATIONOPTIONID
left outer join
dbo.CHANGEAGENT as ADDEDBY on REGISTRANTREGISTRATIONINFORMATION.ADDEDBYID = ADDEDBY.ID
left outer join
dbo.CHANGEAGENT as CHANGEDBY on REGISTRANTREGISTRATIONINFORMATION.CHANGEDBYID = CHANGEDBY.ID