USP_DATALIST_DESIGNATIONLEVELFINANCIALINFORMATION

Returns a list of all financial information for a fundraising purpose.

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELFINANCIALINFORMATION 
                (
                    @DESIGNATIONLEVELID uniqueidentifier                                                                          
                )
                as

                select    
                    DESIGNATIONLEVELFINANCIALINFO.ID, 
                    DESIGNATIONLEVELFINANCIALINFO.STARTDATE, 
                    DESIGNATIONLEVELFINANCIALINFO.ENDDATE,                                    
                    DESIGNATIONLEVELFINANCIALINFO.BOOKVALUESTART,
                    DESIGNATIONLEVELFINANCIALINFO.BOOKVALUEEND,
                    DESIGNATIONLEVELFINANCIALINFO.MARKETVALUESTART,
                    DESIGNATIONLEVELFINANCIALINFO.MARKETVALUEEND,
                    DESIGNATIONLEVELFINANCIALINFO.TOTALGIFTREVENUE, 
                    DESIGNATIONLEVELFINANCIALINFO.TOTALDISBURSEMENTS,
                    DESIGNATIONLEVELFINANCIALINFO.PLEDGEBALANCE,
                    DESIGNATIONLEVELFINANCIALINFO.BASECURRENCYID

                from dbo.DESIGNATIONLEVELFINANCIALINFO
                where 
                    DESIGNATIONLEVELFINANCIALINFO.DESIGNATIONLEVELID = @DESIGNATIONLEVELID                     
                order by DESIGNATIONLEVELFINANCIALINFO.DATEADDED