UFN_STUDENTENROLLMENT_GETPROGRESSIONS

        CREATE function dbo.UFN_STUDENTENROLLMENT_GETPROGRESSIONS
        (
            @ENROLLMENTID uniqueidentifier
        )
        returns table
        as
        return
        (
            select
                STUDENTPROGRESSION.[ID],
                SCHOOLGRADELEVEL.[SCHOOLID],
                CONSTIT_SCHOOL.[KEYNAME] 'SCHOOLNAME',
                dbo.ACADEMICYEARNAMECODE.[DESCRIPTION] 'ACADEMICYEARNAME',
                dbo.STUDENTPROGRESSION.[STARTDATE],
                dbo.STUDENTPROGRESSION.[ENDDATE],
                GRADELEVEL.[DESCRIPTION] 'GRADELEVELNAME',
                CONSTIT_HOMEROOMTEACHER.[NAME] 'HOMEROOMTEACHERNAME',
                dbo.UFN_STUDENTPROGRESSION_GETADVISORNAMES(STUDENTPROGRESSION.[ID]) 'STUDENTADVISORS'
            from
                dbo.STUDENTPROGRESSION
                join dbo.SCHOOLGRADELEVEL on dbo.STUDENTPROGRESSION.[SCHOOLGRADELEVELID] = dbo.SCHOOLGRADELEVEL.[ID]
                join dbo.CONSTITUENT as CONSTIT_SCHOOL on dbo.SCHOOLGRADELEVEL.[SCHOOLID] = CONSTIT_SCHOOL.[ID]
                join dbo.GRADELEVEL on dbo.SCHOOLGRADELEVEL.[GRADELEVELID] = dbo.GRADELEVEL.[ID]
                join dbo.ACADEMICYEAR on dbo.UFN_ACADEMICYEAR_GET_FORSCHOOL_BYDATE(dbo.SCHOOLGRADELEVEL.[SCHOOLID], STUDENTPROGRESSION.[STARTDATE], STUDENTPROGRESSION.[ENDDATE]) = ACADEMICYEAR.ID
                join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
                left outer join dbo.CONSTITUENT as CONSTIT_HOMEROOMTEACHER on dbo.STUDENTPROGRESSION.[HOMEROOMTEACHERID] = CONSTIT_HOMEROOMTEACHER.[ID]
            where
                ENROLLMENTID = @ENROLLMENTID
        )