UFN_STUDENTCHARGE_VALIDSTUDENTPROGRESSION

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

            if (exists (select * 
                        from 
                            DBO.STUDENTPROGRESSION as SP
                        inner join dbo.SCHOOLGRADELEVEL as SGL on SP.SCHOOLGRADELEVELID = SGL.ID 
                        inner join dbo.ACADEMICYEAR as AY on (SP.STARTDATE = AY.STARTDATE) and (SP.ENDDATE = AY.ENDDATE) and (SGL.SCHOOLID = AY.SCHOOLID)
                        inner join dbo.EDUCATIONALHISTORY as EH on SP.ENROLLMENTID = EH.ID
                        inner join dbo.FINANCIALTRANSACTION as FT on EH.CONSTITUENTID = FT.CONSTITUENTID
                        where 
                            (SP.ID = @STUDENTPROGRESSIONID and FT.ID = @CHARGEID) and
                            (AY.[BILLINGSTARTDATE] <= FT.[DATE]) and
                            (AY.[BILLINGENDDATE] >= FT.[DATE]) 
                            ))
                set @ISVALID = 1

            return @ISVALID
        end