USP_DATAFORMTEMPLATE_ADD_PROMOTESTUDENTS_PRELOAD

The load procedure used by the edit dataform template "Promote Students Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ISSINGLESCHOOL	bit	INOUT
@APPUSERSESSIONSCHOOLID	uniqueidentifier	INOUT
@APPUSERSESSIONSCHOOLNAME	nvarchar(200)	INOUT
@APPUSERSESSIONACADEMICYEARID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROMOTESTUDENTS_PRELOAD
(
    @CURRENTAPPUSERID uniqueidentifier,
    @ISSINGLESCHOOL bit = null output,
    @APPUSERSESSIONSCHOOLID uniqueidentifier = null output,
    @APPUSERSESSIONSCHOOLNAME nvarchar(200) = null output,
    @APPUSERSESSIONACADEMICYEARID uniqueidentifier = null output
)
as
    set nocount on;

    set @ISSINGLESCHOOL = dbo.UFN_SCHOOL_ISSINGLESCHOOL()

    select 
        @APPUSERSESSIONSCHOOLID = SCHOOLID,
        @APPUSERSESSIONSCHOOLNAME = NAME,
        @APPUSERSESSIONACADEMICYEARID = ACADEMICYEARID
    from dbo.UFN_APPUSERSESSION_GETHEADERTEXT(@CURRENTAPPUSERID) AUS
        inner join dbo.SCHOOL on AUS.SCHOOLID = SCHOOL.ID
        inner join dbo.CONSTITUENT on SCHOOL.ID = CONSTITUENT.ID

    return 0;