USP_DATAFORMTEMPLATE_EDITLOAD_WITHDRAWSTUDENT

The load procedure used by the edit dataform template "Withdraw Student Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(73)	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@STUDENTCOURSEID	uniqueidentifier	INOUT
@NAME	nvarchar(200)	INOUT	Student
@GRADELEVEL	nvarchar(100)	INOUT	Grade level
@COURSE	nvarchar(300)	INOUT	Course
@ACADEMICYEAR	nvarchar(100)	INOUT	Academic year
@WITHDRAWNDATE	date	INOUT	Withdrawn date
@WITHDRAWNTERMNAME	nvarchar(100)	INOUT
@WITHDRAWNTERMID	uniqueidentifier	INOUT	Withdraw starting in
@WITHDRAWNSTATUS	bit	INOUT
@MARKINGCOLUMNGRADES	xml	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WITHDRAWSTUDENT(
    @ID nvarchar(73),
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @STUDENTCOURSEID uniqueidentifier = null output,
    @NAME nvarchar(200) = null output,
    @GRADELEVEL nvarchar(100) = null output,
    @COURSE nvarchar(300) = null output,
    @ACADEMICYEAR nvarchar(100) = null output,
    @WITHDRAWNDATE date = null output,
    @WITHDRAWNTERMNAME nvarchar(100) = null output,
    @WITHDRAWNTERMID uniqueidentifier = null output,
    @WITHDRAWNSTATUS bit = null output,
    @MARKINGCOLUMNGRADES xml = null output
)
as

    set nocount on;

    declare @CLASSID uniqueidentifier
    declare @STUDENTID uniqueidentifier

    select
        @CLASSID = cast(substring(@ID,1,36) as uniqueidentifier),
        @STUDENTID = cast(substring(@ID,38,36) as uniqueidentifier)


    select        
        @WITHDRAWNTERMID = WITHDRAWN_TERMID,
        @WITHDRAWNTERMNAME = WITHDRAWN_TERMNAME,
        @WITHDRAWNDATE = WITHDRAWN_DATE,
        @WITHDRAWNSTATUS = WITHDRAWN_STATUS
    from dbo.UFN_GETWITHDRAWNDETAILS(@CLASSID,@STUDENTID)


    select
        @DATALOADED = 1,
        @STUDENTCOURSEID = STUDENTCOURSE.ID,
        @NAME = CONSTITUENT.NAME,
        @GRADELEVEL = dbo.UFN_CLASS_GETSTUDENTGRADELEVELSTRING(@CLASSID, STUDENTCOURSE.ID),
        @COURSE = COURSE.COURSEID + ', ' + COURSE.NAME,
        @ACADEMICYEAR = ACADEMICYEARNAMECODE.DESCRIPTION,
        @MARKINGCOLUMNGRADES = dbo.UFN_STUDENTMARKINGCOLUMN_GETCLASSGRADES_TOITEMLISTXML(STUDENTCOURSE.ID, 0),
        @WITHDRAWNDATE = COALESCE(@WITHDRAWNDATE, getdate())
    from dbo.CLASS
        inner join dbo.COURSE on CLASS.COURSEID = COURSE.ID
        inner join dbo.ACADEMICYEAR on COURSE.SCHOOLID = ACADEMICYEAR.SCHOOLID
            and ACADEMICYEAR.STARTDATE <= CLASS.STARTDATE
            and ACADEMICYEAR.ENDDATE >= CLASS.ENDDATE
        inner join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
        inner join dbo.CLASSMEETINGGROUP on CLASS.ID = CLASSMEETINGGROUP.CLASSID
        inner join dbo.STUDENTCLASSMEETINGGROUP on CLASSMEETINGGROUP.ID = STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID
        inner join dbo.STUDENTCOURSE on STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = STUDENTCOURSE.ID
        inner join dbo.CONSTITUENT on STUDENTCOURSE.STUDENTID = CONSTITUENT.ID

    where CLASS.ID = @CLASSID
        and STUDENTCOURSE.STUDENTID = @STUDENTID

    return 0;