UFN_CHARITYCLAIMREFERENCENUMBER_GETBYSITE

Returns the charity claim reference number that a site belongs to.
Return

Return Type
uniqueidentifier
Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	uniqueidentifier	IN
Definition

Copy


            -- Note: Changes made here may need to be made to UFN_REVENUESPLITGIFTAID_GETTRANSITIONALRELIEFNOTEXPIRED

            CREATE function dbo.UFN_CHARITYCLAIMREFERENCENUMBER_GETBYSITE
            (
                @SITEID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier

                if @SITEID is not null
                begin
                    select top 1
                        @CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBERID
                    from dbo.CHARITYCLAIMREFERENCENUMBERSITE
                    where
                        SITEID = @SITEID
                end

                -- If @CHARITYCLAIMREFERENCENUMBERID is still null, see if there's a default CCRN

                if @CHARITYCLAIMREFERENCENUMBERID is null
                begin
                    select top 1
                        @CHARITYCLAIMREFERENCENUMBERID = ID
                    from dbo.CHARITYCLAIMREFERENCENUMBER
                    where
                        not exists (    select 1
                                        from dbo.CHARITYCLAIMREFERENCENUMBERSITE
                                        where
                                            CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID
                                        )
                end

                return @CHARITYCLAIMREFERENCENUMBERID
            end