USP_DATALIST_CONSTITUENTPROFILEMATCHINGGIFTCONDITION

                CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEMATCHINGGIFTCONDITION
                (
                    @CONSTITUENTID uniqueidentifier,
                    @ISVISIBLE bit = 1,
                    @SELECTEDCURRENCYID uniqueidentifier = null
                )
                as
                    set nocount on;

                    if @ISVISIBLE = 1
                    begin
                    select
                        MATCHINGGIFTCONDITIONTYPECODE.DESCRIPTION as TYPE,
                        [MATCHINGFACTOR],
                        dbo.UFN_MATCHINGGIFTCONDITION_MINPERGIFTINCURRENCY(MATCHINGGIFTCONDITION.ID, @SELECTEDCURRENCYID) as [MINMATCHPERGIFT],
                        dbo.UFN_MATCHINGGIFTCONDITION_MAXPERGIFTINCURRENCY(MATCHINGGIFTCONDITION.ID, @SELECTEDCURRENCYID) as [MAXMATCHPERGIFT],
                        dbo.UFN_MATCHINGGIFTCONDITION_MAXANNUALINCURRENCY(MATCHINGGIFTCONDITION.ID, @SELECTEDCURRENCYID) as [MAXMATCHANNUAL],
                        dbo.UFN_MATCHINGGIFTCONDITION_MAXTOTALINCURRENCY(MATCHINGGIFTCONDITION.ID, @SELECTEDCURRENCYID) as [MAXMATCHTOTAL],
                        [NOTES],
                        (
                            select dbo.uda_buildlist(
                                case when JOBSCHEDULECODE.ID is not null and CAREERLEVELCODE.ID is not null then
                                    RELATIONSHIPTYPECODE.DESCRIPTION + ' / ' + JOBSCHEDULECODE.DESCRIPTION + ' / ' + CAREERLEVELCODE.DESCRIPTION
                                when coalesce(JOBSCHEDULECODE.ID, CAREERLEVELCODEID) is not null then
                                    RELATIONSHIPTYPECODE.DESCRIPTION + ' / ' + coalesce(JOBSCHEDULECODE.DESCRIPTION, CAREERLEVELCODE.DESCRIPTION)
                                else
                                    RELATIONSHIPTYPECODE.DESCRIPTION
                                end)
                            from dbo.MATCHINGGIFTCONDITIONRELATIONSHIP 
                            left join dbo.RELATIONSHIPTYPECODE on RELATIONSHIPTYPECODE.ID = MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID
                            left join dbo.JOBSCHEDULECODE on JOBSCHEDULECODE.ID = MATCHINGGIFTCONDITIONRELATIONSHIP.JOBSCHEDULECODEID
                            left join dbo.CAREERLEVELCODE on CAREERLEVELCODE.ID = MATCHINGGIFTCONDITIONRELATIONSHIP.CAREERLEVELCODEID
                            where MATCHINGGIFTCONDITIONRELATIONSHIP.MATCHINGGIFTCONDITIONID = MATCHINGGIFTCONDITION.ID
                        ) as [RELATIONSHIPS],
                        [MATCHTYPE]
                    from dbo.[MATCHINGGIFTCONDITION]
                    left join dbo.MATCHINGGIFTCONDITIONTYPECODE on MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID = MATCHINGGIFTCONDITIONTYPECODE.ID
                    where
                        MATCHINGGIFTCONDITION.ORGANIZATIONID = @CONSTITUENTID;
                    end