UFN_CONSTITUENT_GETSPOUSEALTERNATELOOKUPIDS_FORUPDATEBATCH

This function returns a spouses alternate lookup IDs for the update batch given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_GETSPOUSEALTERNATELOOKUPIDS_FORUPDATEBATCH(@CONSTITUENTID uniqueidentifier)
            returns table
            as return
                select
                    A.[ALTERNATELOOKUPIDTYPECODEID],
                    A.[ALTERNATELOOKUPID],
                    A.[ID],
                    A.[ID] as ORIGINALALTERNATELOOKUPID
                from
                    dbo.[ALTERNATELOOKUPID] A
                where
                    A.[CONSTITUENTID] = @CONSTITUENTID;