UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCOURSES

Returns the core curricula courses in an add requests process.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCOURSES( @ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID uniqueidentifier )
returns table
as return(

    select 
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCOURSE.ID,
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCOURSE.CORECURRICULUMCOURSEID,
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCOURSE.TERMNAMECODEID
    from 
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCOURSE

    where 
        ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID = @ADDREQUESTSFORMULTIPLESTUDENTSPROCESSID

    )