USP_DATALIST_RECOGNITIONRELATIONSHIPDEFAULT

Provides the list of relationship recognitions.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTTYPECODE	tinyint	IN	Constituent type
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_RECOGNITIONRELATIONSHIPDEFAULT
      (
        @CONSTITUENTTYPECODE tinyint = null,
        @RELATIONSHIPTYPECODEID uniqueidentifier = null
      )
      as
        set nocount on;

        select RRD.ID,
            RRD.CONSTITUENTTYPE [CONSTITUENTTYPENAME],
            RELATIONSHIPTYPECODE.DESCRIPTION [RELATIONSHIPTYPENAME],
            REVENUERECOGNITIONTYPECODE.DESCRIPTION [REVENUERECOGNITIONTYPENAME],
            MATCHFACTOR,
            REVENUERECOGNITIONTYPECODE.ID [REVENUERECOGNITIONTYPECODEID]
        from dbo.RECOGNITIONRELATIONSHIPDEFAULT as RRD
            inner join dbo.RELATIONSHIPTYPECODE on RRD.RELATIONSHIPTYPECODEID = RELATIONSHIPTYPECODE.ID
            left join dbo.REVENUERECOGNITIONTYPECODE on RRD.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
        where
            (@CONSTITUENTTYPECODE is null or RRD.CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE) and
            (@RELATIONSHIPTYPECODEID is null or RRD.RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPECODEID)