UFN_STUDENT_CURRENTEDUCATIONALHISTORYSTATUS

            create function dbo.UFN_STUDENT_CURRENTEDUCATIONALHISTORYSTATUS
            (
                @STUDENTID uniqueidentifier
            )
            returns uniqueidentifier
            with execute as caller
            as begin
                declare @RETVAL uniqueidentifier;

                select top 1 @RETVAL = CURRENTINFO.EDUCATIONALHISTORYSTATUSID
                from dbo.UFN_STUDENTENROLLMENT_CURRENTINFORMATION(@STUDENTID) as CURRENTINFO;

                return @RETVAL;
            end