USP_DATALIST_PHONES

This datalist returns all phone numbers for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PHONES (@CONSTITUENTID uniqueidentifier)
            as
                set nocount on;

                select
                    PHONE.ID,
                    PHONE.NUMBER,
                    TYPE = (SELECT DESCRIPTION from dbo.PHONETYPECODE WHERE ID=PHONE.PHONETYPECODEID),
                    PHONE.ISPRIMARY,
                    case when PHONE.DONOTCALL=0 then '' else 'Do not call' end,
                    PHONE.STARTTIME,
                    PHONE.ENDTIME,
                    dbo.UFN_INFOSOURCECODE_GETDESCRIPTION(PHONE.INFOSOURCECODEID) as INFOSOURCE,
                    PHONE.INFOSOURCECOMMENTS,
                    dbo.UFN_COUNTRY_GETDESCRIPTION(PHONE.COUNTRYID) as COUNTRY,
                    PHONE.PHONETYPECODEID,
                    PHONE.DONOTCALL,
                    PHONE.STARTDATE,
                    PHONE.ENDDATE
                from
                    dbo.PHONE
                where
                    PHONE.CONSTITUENTID = @CONSTITUENTID
                order by
                    PHONE.ISPRIMARY desc, TYPE;