USP_DATALIST_ADDRESSES

This datalist returns all addresses 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_ADDRESSES (@CONSTITUENTID uniqueidentifier)
            as
                set nocount on;

                select
                    ADDRESS.ID,
                    ADDRESSTYPECODE.DESCRIPTION,
                    case when ADDRESSCOORDINATES.ID is null or ADDRESSCOORDINATES.PENDINGGEOCODE = 1 or ADDRESSCOORDINATES.INVALIDGEOCODE = 1 then 0 else 1 end ISGEOCODED,
                    case when ADDRESSCOORDINATES.ID is null then 0 else ADDRESSCOORDINATES.PENDINGGEOCODE end PENDINGGEOCODE,
                    case when ADDRESSCOORDINATES.ID is null then 0 else ADDRESSCOORDINATES.INVALIDGEOCODE end INVALIDGEOCODE,
                    dbo.UFN_MAPPING_BUILDCONTEXTRECORDID(cast('645E6BE7-459C-402b-A03C-67587CA72B94' as uniqueidentifier),@CONSTITUENTID,ADDRESS.ID)
                from
                    dbo.ADDRESS
                left join
                    dbo.ADDRESSTYPECODE
                on
                    ADDRESS.ADDRESSTYPECODEID = ADDRESSTYPECODE.ID
                left join
                    dbo.ADDRESSCOORDINATES
                on
                    ADDRESSCOORDINATES.ADDRESSID = ADDRESS.ID
                where
                    ADDRESS.CONSTITUENTID = @CONSTITUENTID
                order by
                    ADDRESS.ISPRIMARY desc, ADDRESS.SEQUENCE;