UFN_REVENUESPLITGIFTAID_GETCHARITYCLASSIFICATION

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

            CREATE function dbo.UFN_REVENUESPLITGIFTAID_GETCHARITYCLASSIFICATION
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns tinyint
            begin
                declare @SITEID uniqueidentifier
                select
                    @SITEID = dbo.UFN_SITEID_MAPFROM_DESIGNATIONID(DESIGNATIONID)
                from dbo.FINANCIALTRANSACTIONLINEITEM
                inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1

                declare @CLASSIFICATIONCODE tinyint
                select
                    @CLASSIFICATIONCODE = CLASSIFICATIONCODE
                from dbo.CHARITYCLAIMREFERENCENUMBER
                where ID = dbo.UFN_CHARITYCLAIMREFERENCENUMBER_GETBYSITE(@SITEID)

                return @CLASSIFICATIONCODE
            end