USP_DATAFORMTEMPLATE_ADD_SETUPNEXTACADEMICYEAR_PRELOAD
The load procedure used by the edit dataform template "Set up next academic year"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @FROM_SCHOOL | nvarchar(200) | INOUT | School |
| @FROM_SCHOOL2 | nvarchar(200) | INOUT | School |
| @FROM_SCHOOLID | uniqueidentifier | INOUT | |
| @ACADEMICYEARID | uniqueidentifier | INOUT | Academic year |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SETUPNEXTACADEMICYEAR_PRELOAD
(
@CONTEXTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier = null,
@FROM_SCHOOL nvarchar(200) = null output,
@FROM_SCHOOL2 nvarchar(200) = null output,
@FROM_SCHOOLID uniqueidentifier = null output,
@ACADEMICYEARID uniqueidentifier = null output
)
as
set nocount on;
if @CONTEXTID <> '00000000-0000-0000-0000-000000000000'
begin
select
@FROM_SCHOOL=CT.KEYNAME,
@FROM_SCHOOL2=CT.KEYNAME,
@FROM_SCHOOLID=CT.ID,
@ACADEMICYEARID = AY.ID
from ACADEMICYEAR AY
inner join CONSTITUENT CT
on AY.SCHOOLID = CT.ID
where AY.ID = @CONTEXTID
end
else
begin
select
@FROM_SCHOOL=CT.KEYNAME,
@FROM_SCHOOL2=CT.KEYNAME,
@FROM_SCHOOLID=CT.ID,
@ACADEMICYEARID = AY.ID
from DBO.APPUSERSESSION S0
inner join SESSION S1 ON S1.ID = S0.SESSIONID
inner join ACADEMICYEAR AY on AY.ID = S1.ACADEMICYEARID
inner join CONSTITUENT CT on AY.SCHOOLID = CT.ID
where S0.ID = @CURRENTAPPUSERID
end
return 0;