UFN_STUDENTPROGRESSION_CURRENTINFORMATION

Returns a table of all current student progression information for a given student

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_STUDENTPROGRESSION_CURRENTINFORMATION(
            @STUDENTID uniqueidentifier
        )
        returns @STUDENTPROGRESSION_CURRENTINFORMATION TABLE
       (
        ENROLLMENTID uniqueidentifier,
        STUDENTPROGRESSIONID    uniqueidentifier,
        SCHOOLID   uniqueidentifier,
        GRADELEVELID uniqueidentifier,
        HOMEROOMTEACHERID uniqueidentifier
       )

        with execute as caller
        as begin

            INSERT INTO @STUDENTPROGRESSION_CURRENTINFORMATION (ENROLLMENTID, STUDENTPROGRESSIONID,SCHOOLID,GRADELEVELID,HOMEROOMTEACHERID)
                SELECT dbo.STUDENTPROGRESSION.[ENROLLMENTID], dbo.STUDENTPROGRESSION.[ID], dbo.SCHOOLGRADELEVEL.[SCHOOLID], dbo.SCHOOLGRADELEVEL.[GRADELEVELID], dbo.STUDENTPROGRESSION.[HOMEROOMTEACHERID]
                FROM dbo.UFN_STUDENTENROLLMENT_CURRENTINFORMATION(@STUDENTID) as CURR_ENROLL
                INNER JOIN dbo.STUDENTPROGRESSION on dbo.STUDENTPROGRESSION.[ENROLLMENTID] = CURR_ENROLL.[ENROLLMENTID]
                INNER JOIN dbo.SCHOOLGRADELEVEL on dbo.STUDENTPROGRESSION.[SCHOOLGRADELEVELID] = dbo.SCHOOLGRADELEVEL.[ID]
                WHERE GETDATE() BETWEEN dbo.STUDENTPROGRESSION.[STARTDATE] AND dbo.STUDENTPROGRESSION.[ENDDATE]
                ORDER BY dbo.STUDENTPROGRESSION.[STARTDATE];

            return
        end