USP_SIMPLEDATALIST_CONSTITUENTDATAREVIEWROLLBACKREASONS

Returns a list of constituent data review rollback reasons and descriptions.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTDATAREVIEWROLLBACKREASONS
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on

                    select
                        ID as VALUE,
                        CODE + ' - ' + DESCRIPTION  as LABEL
                    from dbo.CONSTITUENTDATAREVIEWROLLBACKREASON
                    where 
                        ACTIVE = 1 or @INCLUDEINACTIVE = 1
                    order by LABEL