USP_DATALIST_DESIGNATIONLEVELDECAPITALIZATION

A datalist of fundraising purpose decapitalizations.

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_DESIGNATIONLEVELDECAPITALIZATION
                (
                    @DESIGNATIONLEVELID uniqueidentifier = null
                )
                as

                select    
                    DESIGNATIONLEVELDECAPITALIZATION.ID, 
                    DESIGNATIONLEVELDECAPITALIZATION.DESIGNATIONLEVELID, 
                    DESIGNATIONLEVELDECAPITALIZATION.APPROVALDATE,
                    DESIGNATIONLEVELDECAPITALIZATION.APPROVEDBYID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(DESIGNATIONLEVELDECAPITALIZATION.APPROVEDBYID) as APPROVEDBYNAME,
                    DESIGNATIONLEVELDECAPITALIZATION.AMOUNT, 
                    DESIGNATIONLEVELDECAPITALIZATION.ACCOUNTID, 
                    DESIGNATION.NAME as ACCOUNTNAME,
                    DESIGNATIONLEVELDECAPITALIZATION.RATIONALE,
                    DESIGNATIONLEVELDECAPITALIZATION.BASECURRENCYID
                from dbo.DESIGNATIONLEVELDECAPITALIZATION
                left outer join CONSTITUENT on CONSTITUENT.ID = DESIGNATIONLEVELDECAPITALIZATION.APPROVEDBYID
                left outer join DESIGNATION on DESIGNATION.ID = DESIGNATIONLEVELDECAPITALIZATION.ACCOUNTID
                where 
                    DESIGNATIONLEVELDECAPITALIZATION.DESIGNATIONLEVELID = @DESIGNATIONLEVELID 
                order by DESIGNATIONLEVELDECAPITALIZATION.APPROVALDATE