UFN_COURSERESTRICTIONSTARTTERM_TERMDATES_VALID
Verifies that the dates are for a valid term for the course restriction's school and session.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSERESTRICTIONID | uniqueidentifier | IN | |
| @STARTDATE | date | IN | |
| @ENDDATE | date | IN |
Definition
Copy
create function dbo.UFN_COURSERESTRICTIONSTARTTERM_TERMDATES_VALID(
@COURSERESTRICTIONID uniqueidentifier,
@STARTDATE date,
@ENDDATE date )
returns bit
with execute as caller
as begin
declare @retval bit = 0
if exists(
select TERM.ID
from
dbo.COURSERESTRICTION
join dbo.COURSE on COURSE.ID = COURSERESTRICTION.COURSEID
join dbo.SESSION on SESSION.ID = dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSERESTRICTION.STARTDATE, COURSERESTRICTION.ENDDATE)
join dbo.TERM on TERM.ID = dbo.UFN_TERM_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, @STARTDATE, @ENDDATE)
and TERM.SESSIONID = SESSION.ID
where
COURSERESTRICTION.ID = @COURSERESTRICTIONID)
set @retval = 1
return @retval
end