UFN_CONSTITUENT_ISGRANTOR

This functions returns whether a constituent is a grantor as of the given date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_CONSTITUENT_ISGRANTOR(@CONSTITUENTID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
            /*
            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            declare @UPPERBOUND datetime;
            set @UPPERBOUND = dbo.UFN_DATE_GETLATESTTIME(@CURRENTDATE);

            declare @LOWERBOUND datetime;
            set @LOWERBOUND = dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE);
            */

            if exists(
                select
                    ID
                from
                    dbo.GRANTOR
                where
                    GRANTOR.ID = @CONSTITUENTID
                    /* and (GRANTORDATERANGE.DATEFROM <= @UPPERBOUND or GRANTORDATERANGE.DATEFROM is null) and (GRANTORDATERANGE.DATETO >= @LOWERBOUND or GRANTORDATERANGE.DATETO is null)*/                    
            ) return 1;

            return 0;
        end