USP_DATAFORMTEMPLATE_VIEW_APPUSERSESSION_GETINFO

The load procedure used by the view dataform template "App User Session view"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SCHOOLID	uniqueidentifier	INOUT	SCHOOLID
@ACADEMICYEARID	uniqueidentifier	INOUT	ACADEMICYEARID
@SESSIONID	uniqueidentifier	INOUT	SESSIONID

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPUSERSESSION_GETINFO
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SCHOOLID uniqueidentifier = null output,
                    @ACADEMICYEARID uniqueidentifier = null output,
                    @SESSIONID uniqueidentifier = null output
                )
                as
                    set nocount on

                    select
                        @DATALOADED = 1,
                        @SESSIONID = SESSION.ID,
                        @ACADEMICYEARID = ACADEMICYEAR.ID,
                        @SCHOOLID = ACADEMICYEAR.SCHOOLID
                    from dbo.APPUSERSESSION
                        inner join dbo.SESSION on APPUSERSESSION.SESSIONID = SESSION.ID
                        inner join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
                    where APPUSERSESSION.ID = @CURRENTAPPUSERID

                    return 0