UFN_STUDENTCHARGE_VALIDENROLLMENT

        CREATE function dbo.UFN_STUDENTCHARGE_VALIDENROLLMENT
        (
            @CHARGEID uniqueidentifier,
            @EDUCATIONALHISTORYID uniqueidentifier
        )
        returns bit
        with execute as caller
        as begin
            declare @ISVALID bit
            set @ISVALID = 0

            if (exists (select * 
                        from 
                            dbo.EDUCATIONALHISTORY as EH
                        inner join dbo.FINANCIALTRANSACTION as FT on EH.CONSTITUENTID = FT.CONSTITUENTID
                        inner join dbo.ACADEMICYEAR as AY on EH.EDUCATIONALINSTITUTIONID = AY.SCHOOLID
                        where 
                            (EH.ID = @EDUCATIONALHISTORYID and FT.ID = @CHARGEID) and
                            (dbo.UFN_DATE_FROMFUZZYDATE(EH.STARTDATE) <= FT.[DATE]) and
                            ((dbo.UFN_DATE_FROMFUZZYDATE(EH.DATELEFT) >= FT.[DATE]) or (EH.DATELEFT = '00000000')) and
                            (AY.BILLINGSTARTDATE <= FT.[DATE]) and
                            (AY.BILLINGENDDATE >= FT.[DATE])
                            ))
                set @ISVALID = 1

            return @ISVALID
        end