USP_DATALIST_CONTACTINFORMATIONADDRESS

CREATE procedure dbo.USP_DATALIST_CONTACTINFORMATIONADDRESS
(
    @CONSTITUENTID uniqueidentifier, 
    @INCLUDEFORMER bit    = 0
)
as
    set nocount on;

    declare @CURRENTDATE datetime = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

    select 
        ADDRESSES.ID,        
        case
            when ADDRESSES.ISCONFIDENTIAL = 0
                then ADDRESSES.DESCRIPTION
            else
                N'(Confidential) ' + ADDRESSES.DESCRIPTION
        end as CONTACTINFO,
        case
            when ((ADDRESSES.HISTORICALENDDATE is null) or (ADDRESSES.HISTORICALENDDATE > @CURRENTDATE))
                then coalesce(ADDRESSES.ADDRESSTYPE, N'') + N' (Current)'
            else
                coalesce(ADDRESSES.ADDRESSTYPE, N'') + N' (Former)'
        end as TYPE,
        case when ADDRESSES.ISPRIMARY = 0 then '' else 'Yes' end as ISPRIMARY,
        case when ADDRESSES.DONOTMAIL = 0 then '' else 'Do not mail' end as DONOTCONTACT,
        ADDRESSES.ISCONFIDENTIAL,
        ADDRESSES.ISFORMER,
        ADDRESSES.HISTORICALSTARTDATE,
        ADDRESSES.HISTORICALENDDATE,
        ADDRESSES.ISGEOCODED,
        ADDRESSES.PENDINGGEOCODE,
        ADDRESSES.INVALIDGEOCODE,
        ADDRESSES.MAPCONTEXTID,        
        ADDRESSES.IMAGEKEY
    from
        dbo.UFN_CONSTITUENT_ADDRESSES(@CONSTITUENTID, @INCLUDEFORMER) ADDRESSES
    order by
        ISPRIMARY desc, ISFORMER asc, ENDDATE_SORT desc, STARTDATE_SORT desc, DATEADDED desc