USP_MAPENTITY_SELECTION_TO_CONSTTIUENT

                    CREATE procedure dbo.USP_MAPENTITY_SELECTION_TO_CONSTTIUENT(
                        @RECORDID uniqueidentifier
                    ) as
                        set nocount on;

                        select 
                            CONSTITUENT.ID MAPPEDRECORDID,
                            CONSTITUENT.NAME DESCRIPTION,
                            ADDRESS.ID ADDRESSID,
                            ADDRESS.ADDRESSBLOCK,
                            ADDRESS.CITY,
                            STATE.ABBREVIATION [STATE],
                            ADDRESS.POSTCODE,
                            COUNTRY.ABBREVIATION [COUNTRY],
                            case when ADDRESSCOORDINATES.LATITUDE is null then POSTCODECOORDINATES.LATITUDE else ADDRESSCOORDINATES.LATITUDE end LATITUDE,
                            case when ADDRESSCOORDINATES.LONGITUDE is null then POSTCODECOORDINATES.LONGITUDE else ADDRESSCOORDINATES.LONGITUDE end LONGITUDE,
                            @RECORDID GROUPID,
                            (select NAME from dbo.IDSETREGISTER where ID = @RECORDID) GROUPNAME
                        from dbo.CONSTITUENT
                        inner join dbo.UFN_IDSETREADER_GETRESULTS_GUID (@RECORDID)  as [IDSET_506b995d_4ada_4d76_b0a4_a07fd943fa0c] on [CONSTITUENT].[ID] = [IDSET_506b995d_4ada_4d76_b0a4_a07fd943fa0c].[ID] 
                        inner join dbo.ADDRESS on CONSTITUENT.ID = [ADDRESS].CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                        left join dbo.POSTCODECOORDINATES on ADDRESS.POSTCODE = POSTCODECOORDINATES.POSTCODE
                        left join dbo.ADDRESSCOORDINATES on ADDRESS.ID = ADDRESSCOORDINATES.ADDRESSID
                        left join dbo.STATE on [STATE].ID = ADDRESS.STATEID
                        left join dbo.COUNTRY on COUNTRY.ID = ADDRESS.COUNTRYID
                        left join dbo.ORGANIZATIONDATA on CONSTITUENT.ID = ORGANIZATIONDATA.ID
                        order by CONSTITUENT.KEYNAME;