USP_DATALIST_RECURRINGGIFTSTATUSUPDATEPROCESS

            CREATE procedure dbo.USP_DATALIST_RECURRINGGIFTSTATUSUPDATEPROCESS
            (
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            as
                set nocount on;

                with BASICFIELDS as (
                    select
                        RECURRINGGIFTSTATUSUPDATEPROCESS.ID,
                        RECURRINGGIFTSTATUSUPDATEPROCESS.NAME,
                        RECURRINGGIFTSTATUSUPDATEPROCESS.DESCRIPTION,
                        BPI.OWNERID as OWNERID
                    from
                        dbo.RECURRINGGIFTSTATUSUPDATEPROCESS
                        left join dbo.BUSINESSPROCESSINSTANCE BPI on RECURRINGGIFTSTATUSUPDATEPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, RECURRINGGIFTSTATUSUPDATEPROCESS.ID) = 1

                )

                select 
                    BASICFIELDS.ID,
                    BASICFIELDS.NAME,
                    BASICFIELDS.DESCRIPTION,
                    BASICFIELDS.OWNERID,
                    S.STARTEDON,
                    S.DURATION,
                    S.NUMBEROFRECORDSPROCESSED RECORDSPROCESSED, 
                    (R.ACTIVECOUNT + R.HELDCOUNT + R.LAPSEDCOUNT + R.TERMINATEDCOUNT + R.CANCELEDCOUNT) as RECORDSUPDATED
                from BASICFIELDS
                outer apply dbo.UFN_BUSINESSPROCESSSTATUS_STANDARDDATALISTVALUES_ROWSTORETURNSTARTEDDATE('2a13ea65-e2a3-4edc-8407-ab09ac62d7bb',BASICFIELDS.ID,null,1,null, null) S
                left join dbo.RECURRINGGIFTSTATUSUPDATEPROCESSOUTCOME R on S.ID = R.ID
                order by BASICFIELDS.NAME