V_QUERY_PROGRAMREGISTRATIONINFORMATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PROGRAMID | uniqueidentifier | yes | |
| REGISTRATIONSECTIONCODEID | uniqueidentifier | ||
| REGISTRATIONSECTION | nvarchar(100) | yes | |
| SECTIONSEQUENCE | int | ||
| REGISTRATIONINFORMATIONID | uniqueidentifier | ||
| REGISTRATIONINFORMATIONSEQUENCE | int | ||
| REQUIRED | 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:04 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PROGRAMREGISTRATIONINFORMATION AS
select
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.ID,
PROGRAMEVENTREGISTRATIONSECTION.PROGRAMID,
PROGRAMEVENTREGISTRATIONSECTION.REGISTRATIONSECTIONCODEID,
REGISTRATIONSECTIONCODE.DESCRIPTION as REGISTRATIONSECTION,
PROGRAMEVENTREGISTRATIONSECTION.SEQUENCE as SECTIONSEQUENCE,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.REGISTRATIONINFORMATIONID,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.SEQUENCE as REGISTRATIONINFORMATIONSEQUENCE,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.REQUIRED,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.DATEADDED,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.DATECHANGED,
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.TSLONG
/*#EXTENSION*/
from
dbo.PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION
inner join
dbo.PROGRAMEVENTREGISTRATIONSECTION on PROGRAMEVENTREGISTRATIONSECTION.ID = PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.PROGRAMEVENTREGISTRATIONSECTIONID
left outer join
dbo.REGISTRATIONSECTIONCODE on REGISTRATIONSECTIONCODE.ID = PROGRAMEVENTREGISTRATIONSECTION.REGISTRATIONSECTIONCODEID
left outer join
dbo.CHANGEAGENT as ADDEDBY on PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.ADDEDBYID = ADDEDBY.ID
left outer join
dbo.CHANGEAGENT as CHANGEDBY on PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION.CHANGEDBYID = CHANGEDBY.ID