USP_DATALIST_EVENTREGISTRATIONBALANCEBYREGISTRANT

Gets the outstanding balance of an event registration.

Parameters

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

Definition

Copy



          create procedure dbo.USP_DATALIST_EVENTREGISTRATIONBALANCEBYREGISTRANT(@HOSTREGISTRANTID uniqueidentifier)
          as
              set nocount on;


          with [EVENTFEEINFO] as 
                          (
                              select
                                  coalesce((select sum(REGISTRANTREGISTRATION.AMOUNT) from dbo.REGISTRANTREGISTRATION where REGISTRANTREGISTRATION.REGISTRANTID = @HOSTREGISTRANTID),0) as [TOTALFEES],
                                  coalesce((select sum(EVENTREGISTRANTPAYMENT.AMOUNT) from dbo.EVENTREGISTRANTPAYMENT where EVENTREGISTRANTPAYMENT.REGISTRANTID = @HOSTREGISTRANTID), 0) as [TOTALPAID],
                                  coalesce((select sum(CREDITITEMS.TOTAL) from dbo.[UFN_REGISTRANT_GETCREDITITEMS](@HOSTREGISTRANTID) CREDITITEMS),0) as [TOTALREFUNDED]
                          )
                          select
                              [TOTALFEES] = [EVENTFEEINFO].TOTALFEES,
                              [TOTALPAID] = [EVENTFEEINFO].TOTALPAID - [EVENTFEEINFO].TOTALREFUNDED,
                              [FEEBALANCE] = [EVENTFEEINFO].TOTALFEES - [EVENTFEEINFO].TOTALPAID + [EVENTFEEINFO].[TOTALREFUNDED]
                          from [EVENTFEEINFO]