UFN_CONSTITUENT_ISFORMERSTUDENT

CREATE function dbo.UFN_CONSTITUENT_ISFORMERSTUDENT(@CONSTITUENTID uniqueidentifier) 
            returns bit
            with execute as caller
            as begin
                if exists(                    

                    select EDUCATIONALHISTORY.CONSTITUENTID

                    from dbo.EDUCATIONALHISTORY 
                    inner join dbo.EDUCATIONALINSTITUTION on EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTION.ID and EDUCATIONALINSTITUTION.ISAFFILIATED = 1
                    where
                        EDUCATIONALHISTORY.CONSTITUENTID = @CONSTITUENTID and
                        EDUCATIONALHISTORY.ISPRIMARYRECORD = 1 and
                        EDUCATIONALHISTORY.CONSTITUENCYSTATUSCODE = 2 /*Incomplete -- from EducationalHistory table*/

                ) return 1;

                return 0;
            end