UFN_CONSTITUENT_GETCLASSYEAR

Find the Class Year for a given constituent

Return

Return Type
nvarchar(4)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_GETCLASSYEAR(@CONSTITUENTID uniqueidentifier)
            returns nvarchar(4)
            as 
            begin
                declare @CLASSYEAR nvarchar(4);

                select 
                    @CLASSYEAR = cast(CLASSOF as nvarchar(4))
                from dbo.EDUCATIONALHISTORY
                where CONSTITUENTID = @CONSTITUENTID 
                        and ISPRIMARYRECORD = 1
                        and CLASSOF > 0;

                return @CLASSYEAR;
            end