UFN_CONSTITUENT_GETPHONESWITHTIME

This function returns a constituent's phone numbers given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENT_GETPHONESWITHTIME(@CONSTITUENTID uniqueidentifier)
        returns table
        as return
            select
                ID,
                PHONETYPECODEID,
                NUMBER,
                ISPRIMARY, 
                SEQUENCE,
                STARTTIME,
                ENDTIME,
                STARTDATE,
                COUNTRYID
            from
                dbo.PHONE
            where
                CONSTITUENTID=@CONSTITUENTID;