USP_DATALIST_CONSTITUENTDATAREVIEWROLLBACKREASONS

Returns a list of reason codes.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTDATAREVIEWROLLBACKREASONS
                    (
                        @INCLUDEINACTIVE bit = 0
                    )
                    as
                        set nocount on

                        select
                            ID,
                            CODE,
                            DESCRIPTION,
                            ACTIVE
                        from dbo.CONSTITUENTDATAREVIEWROLLBACKREASON
                        where
                            (ACTIVE = 1 or @INCLUDEINACTIVE = 1)
            order by CODE asc