V_QUERY_PROGRAMGROUPPROGRAM

Provides the ability to query programs of the program groups of the combinations.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes	System record ID
PROGRAMGROUPID	uniqueidentifier		Program group system ID
PROGRAMID	uniqueidentifier	yes	Program system ID
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:58 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PROGRAMGROUPPROGRAM AS



                select
                    PROGRAMGROUPPROGRAM.ID,
                    PROGRAMGROUPPROGRAM.PROGRAMGROUPID,
                    PROGRAMGROUPPROGRAM.PROGRAMID,
                    [ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
                    [ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
                    [CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
                    [PROGRAMGROUPPROGRAM].[DATEADDED],
                    [PROGRAMGROUPPROGRAM].[DATECHANGED],
                    [PROGRAMGROUPPROGRAM].[TSLONG] 
                /*EXTENSION*/
                from dbo.[PROGRAMGROUPPROGRAM]
                left join dbo.[CHANGEAGENT] as [ADDEDBY] 
                        on [PROGRAMGROUPPROGRAM].[ADDEDBYID] = [ADDEDBY].ID
                left join dbo.[CHANGEAGENT] as [CHANGEDBY] 
                    on [PROGRAMGROUPPROGRAM].[CHANGEDBYID] = [CHANGEDBY].ID

                union all

                select
                    newid() as ID,
                    PROGRAMGROUP.ID,
                    SELECTION.ID,
                    [ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
                    [ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
                    [CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
                    [PROGRAMGROUP].[DATEADDED],
                    [PROGRAMGROUP].[DATECHANGED],
                    [PROGRAMGROUP].[TSLONG] 
                /*EXTENSION*/
                from dbo.[PROGRAMGROUP]
                cross apply dbo.UFN_IDSETREADER_GETRESULTS_GUID(PROGRAMGROUP.IDSETREGISTERID) AS SELECTION
                left join dbo.[CHANGEAGENT] as [ADDEDBY] 
                        on [PROGRAMGROUP].[ADDEDBYID] = [ADDEDBY].ID
                left join dbo.[CHANGEAGENT] as [CHANGEDBY] 
                    on [PROGRAMGROUP].[CHANGEDBYID] = [CHANGEDBY].ID