USP_DATALIST_ALTERNATELOOKUPIDS

This datalist returns all alternate lookup IDs 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_ALTERNATELOOKUPIDS
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        ALTERNATELOOKUPID.ID,
                        ALTERNATELOOKUPIDTYPECODE.DESCRIPTION as TYPE,
                        ALTERNATELOOKUPID.ALTERNATELOOKUPID
                    from
                        dbo.ALTERNATELOOKUPID
                        left join dbo.ALTERNATELOOKUPIDTYPECODE on ALTERNATELOOKUPIDTYPECODE.ID = ALTERNATELOOKUPID.ALTERNATELOOKUPIDTYPECODEID
                    where
                        ALTERNATELOOKUPID.CONSTITUENTID = @CONSTITUENTID
                    order by
                        ALTERNATELOOKUPIDTYPECODE.DESCRIPTION;