UFN_CONSTITUENT_ISFACULTY

Validates whether the constituent record is a faculty member.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@FACULTYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_ISFACULTY(@FACULTYID uniqueidentifier)
      returns bit
            with execute as caller
            as begin

            if exists(
                select
                    ID
                from
                    dbo.FACULTY
                where
                    FACULTY.ID = @FACULTYID
            ) return 1;

            return 0;
        end