UFN_CONSTITUENT_GETCONSTITUENCIES_USERDEFINED

Returns a table of user defined constituents for a given constituent.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@CURRENTDATE	date	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENT_GETCONSTITUENCIES_USERDEFINED
(
    @ID uniqueidentifier,
    @CURRENTDATE date
)
returns table
as return (
    select
        CONSTITUENCYCODE.DESCRIPTION,
        CONSTITUENCYCODE.SEQUENCE
    from
        dbo.CONSTITUENCY
        inner join dbo.CONSTITUENCYCODE
            on CONSTITUENCYCODE.ID = CONSTITUENCY.CONSTITUENCYCODEID
        inner join dbo.CONSTITUENCYDEFINITION
            on CONSTITUENCYDEFINITION.ID = CONSTITUENCYCODE.ID
    where
        (CONSTITUENCY.CONSTITUENTID = @ID)
        and (CONSTITUENCY.DATEFROM is null or convert(date, CONSTITUENCY.DATEFROM) <= @CURRENTDATE)
        and (CONSTITUENCY.DATETO is null or convert(date, CONSTITUENCY.DATETO) >= @CURRENTDATE)
        and CONSTITUENCYDEFINITION.ISACTIVE = 1
)