UFN_REPORT_VSESECONDARY

Returns the table of data for the VSE college report.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@INCLUDEINACTIVE	smallint	IN
@INCLUDEDECEASED	smallint	IN
@USEGIFTDATE	smallint	IN
Definition

Copy


            CREATE function dbo.UFN_REPORT_VSESECONDARY
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @INCLUDEINACTIVE smallint = 0,
                @INCLUDEDECEASED smallint = 0,
                @USEGIFTDATE smallint = 0
            )
            returns table
            as
            return(
                select distinct 
                    REPORT_VSECATEGORY.DATE,
                    REPORT_VSECATEGORY.POSTDATE,
                    REPORT_VSECATEGORY.REVENUESPLITAMOUNT,
                    REPORT_VSECATEGORY.VSECATEGORYCODE,
                    REPORT_VSECATEGORY.VSECATEGORY,
                    REPORT_VSECATEGORY.VSECATEGORYPURPOSETYPECODE,
                    VSECONSTITUENT.VSECONSTITUENCYCODE,
                    VSECONSTITUENT.VSECONSTITUENCY,
                    VSECONSTITUENT.TYPECODE as VSECONSTITUENTTYPECODE,
                    VSECONSTITUENT.[TYPE] as VSECONSTITUENCYTYPE,
                    REPORT_VSECATEGORY.CONSTITUENTID as CONSTITUENTID,
                    REPORT_VSECATEGORY.TRANSACTIONTYPECODE as REVENUETYPE,
                    REPORT_VSECATEGORY.REVENUEID,
                    REPORT_VSECATEGORY.REVENUESPLITID,
                    --REPORT_VSECATEGORY.PAYMENTMETHODCODE,

                    DECEASED.ID as DECEASEDCONSTITUENTID,
                    REPORT_VSECATEGORY.APPLICATIONCODE,
                    REPORT_VSECATEGORY.VEHICLECODE
                from 
                    dbo.UFN_REPORT_VSECATEGORY_PAYMENT(@STARTDATE, @ENDDATE, @USEGIFTDATE, 0) as REPORT_VSECATEGORY
                    inner join dbo.CONSTITUENT with (nolock) on CONSTITUENT.ID = REPORT_VSECATEGORY.CONSTITUENTID
                    inner join dbo.UFN_CONSTITUENT_GETVSECONSTITUENTS(@STARTDATE, @ENDDATE, 0) as VSECONSTITUENT on VSECONSTITUENT.CONSTITUENTID = REPORT_VSECATEGORY.CONSTITUENTID 
                    left outer join dbo.DECEASEDCONSTITUENT as DECEASED on DECEASED.ID = CONSTITUENT.ID
                where
                    (@INCLUDEINACTIVE <> 0 or CONSTITUENT.ISINACTIVE = 0)
                    and (@INCLUDEDECEASED <> 0 or DECEASED.ID is null)
            )