USP_DATALIST_RECOGNITIONPROGRAMDESIGNATION

Returns the designations to filter revenue by for a recognition program.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONPROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_RECOGNITIONPROGRAMDESIGNATION(@RECOGNITIONPROGRAMID uniqueidentifier)
            as
                set nocount on;

                select RPD.ID,
                       D.NAME as DESIGNATION,
                       RPD.SEQUENCE
                from dbo.RECOGNITIONPROGRAMDESIGNATION RPD
                inner join dbo.DESIGNATION D on RPD.DESIGNATIONID = D.ID
                where RPD.RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
                order by RPD.SEQUENCE asc