USP_DATALIST_CONSTITUENTRECOGNITIONDEFAULTSBYSOURCE

Display a list of recognition defaults where the constituent is the source.

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_CONSTITUENTRECOGNITIONDEFAULTSBYSOURCE
                    (
                        @CONSTITUENTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select
                            RM.ID,
                            NF.NAME,
                            RM.MATCHFACTOR,
                            RT.DESCRIPTION as RECOGNITIONTYPE,
                            RM.HOUSEHOLDSETTINGSGENERATED,
                            RM.STARTDATE,
                            RM.ENDDATE,
                            C.ID,
                            RT.ID RECOGNITIONCREDITTYPECODEID
                        from dbo.UFN_CONSTITUENT_GETRECOGNITIONDEFAULTSBYSOURCE(@CONSTITUENTID, 0, 1) as RM
                        cross apply dbo.CONSTITUENT C
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(C.ID) NF
                        left join dbo.REVENUERECOGNITIONTYPECODE RT on RM.REVENUERECOGNITIONTYPECODEID = RT.ID
                        where C.ID = RM.RECIPIENTCONSTITUENTID
                        order by C.KEYNAME, C.FIRSTNAME