UFN_STUDENTCONSTITUENCYCRITERIA_GETISCONSTITUENTWHEN

Returns the current setting for the student constituency criteria determining when a student is marked as a constituent.

Return

Return Type
tinyint

Definition

Copy



            create function dbo.UFN_STUDENTCONSTITUENCYCRITERIA_GETISCONSTITUENTWHEN()
            returns tinyint
            as begin
                declare @ISCONSTITUENTWHEN tinyint = 0;

                if (not exists (select ID from dbo.STUDENTCONSTITUENCYSETTINGS))
                begin
                    set @ISCONSTITUENTWHEN = 0;
                end
                else
                begin
                    select @ISCONSTITUENTWHEN = ISCONSTITUENTWHENCODE
                    from dbo.STUDENTCONSTITUENCYSETTINGS;
                end

                return @ISCONSTITUENTWHEN;
            end