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
)