USP_DATAFORMTEMPLATE_ADD_ASSIGNHOMEROOMS_PRELOAD

The load procedure used by the edit dataform template "Assign Homeroom Teachers Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ISSINGLESCHOOL	bit	INOUT
@SCHOOLID	uniqueidentifier	INOUT	School
@SCHOOLNAME	nvarchar(200)	INOUT	School
@APPUSERSESSIONACADEMICYEARID	uniqueidentifier	INOUT
@APPUSERSESSIONACADEMICYEARNAME	nvarchar(100)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ASSIGNHOMEROOMS_PRELOAD
(
    @CURRENTAPPUSERID uniqueidentifier,
    @ISSINGLESCHOOL bit = null output,
    @SCHOOLID uniqueidentifier = null output,
    @SCHOOLNAME nvarchar(200) = null output,
    @APPUSERSESSIONACADEMICYEARID uniqueidentifier = null output,
    @APPUSERSESSIONACADEMICYEARNAME nvarchar(100) = null output
)
 as
    set nocount on;

    set @ISSINGLESCHOOL = dbo.UFN_SCHOOL_ISSINGLESCHOOL()

    select 
        @SCHOOLID = CONSTITUENT.ID,
        @SCHOOLNAME = NAME,
        @APPUSERSESSIONACADEMICYEARID = ACADEMICYEAR.ID,
        @APPUSERSESSIONACADEMICYEARNAME = DESCRIPTION
    from dbo.APPUSERSESSION
        inner join dbo.SESSION on APPUSERSESSION.SESSIONID = SESSION.ID
        inner join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
        inner join dbo.CONSTITUENT on ACADEMICYEAR.SCHOOLID = CONSTITUENT.ID
        inner join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
    where APPUSERSESSION.ID = @CURRENTAPPUSERID

    return 0;