USP_DATALIST_PLANNEDGIFT_DESIGNATION

                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_DESIGNATION(@PLANNEDGIFTID uniqueidentifier)
                as
                    select 
                        PLANNEDGIFTDESIGNATION.ID,
                        DESIGNATION.ID,
                        case when len(DESIGNATION.VANITYNAME) > 0 then
                            DESIGNATION.VANITYNAME
                        else
                            dbo.UFN_DESIGNATION_BUILDNAME(PLANNEDGIFTDESIGNATION.DESIGNATIONID)
                        end, --JamesWill 2009-01-06 Design wants to use the public name for view-only designations in planned gifts.

                        PLANNEDGIFTDESIGNATION.TRANSACTIONAMOUNT,
                        PLANNEDGIFTDESCATEGORYCODE.DESCRIPTION as CATEGORY,
                        DESIGNATIONUSECODE.DESCRIPTION as USECODE,
                        PLANNEDGIFTDESIGNATION.DATE,
                        PLANNEDGIFTDESIGNATION.TRANSACTIONCURRENCYID,
                        PLANNEDGIFTDESIGNATION.AMOUNT as BASEAMOUNT,
                        PLANNEDGIFTDESIGNATION.BASECURRENCYID,
                        OPPORTUNITYDESIGNATIONTYPECODE.DESCRIPTION AS TYPE
                    from
                        dbo.PLANNEDGIFTDESIGNATION
                        left join dbo.DESIGNATION on DESIGNATION.ID = PLANNEDGIFTDESIGNATION.DESIGNATIONID --GPB 2011-11-19 Designation no longer required.

                        left join dbo.PLANNEDGIFTDESCATEGORYCODE on PLANNEDGIFTDESCATEGORYCODE.ID = PLANNEDGIFTDESIGNATION.CATEGORYCODEID 
                        left join dbo.DESIGNATIONUSECODE on DESIGNATIONUSECODE.ID = PLANNEDGIFTDESIGNATION.USECODEID
                        left join dbo.OPPORTUNITYDESIGNATIONTYPECODE on OPPORTUNITYDESIGNATIONTYPECODE.ID = PLANNEDGIFTDESIGNATION.TYPECODEID
                    where
                        PLANNEDGIFTDESIGNATION.PLANNEDGIFTID=@PLANNEDGIFTID
                    order by
                        PLANNEDGIFTDESIGNATION.SEQUENCE;