UFN_BBNC_GETRULESFORTRANSACTIONPROCESSOR

Retrieves the rules for a Blackbaud Internet Solutions transaction processor from the database.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETRULESFORTRANSACTIONPROCESSOR
            (
                @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier
            )
            returns table
            as return 
            (
                select
                    ID,
                    MAPPINGTYPECODE,
                    SELECTIONID,
                    cast(dbo.UFN_BBNC_GETPAGEIDSFORMAPPINGRULE_TOITEMLISTXML(ID) as xml) as PAGEIDS,
                    cast(dbo.UFN_BBNC_GETOWNERIDSFORMAPPINGRULE_TOITEMLISTXML(ID) as xml) as OWNERIDS,
                    CONSTIT_SECURITY_ATTRIBUTEID,
                    SITEID,
                    DEFAULTTRIBUTEID,
                    SEQUENCE,
                    DEFAULTPDACCOUNTSYSTEMID,
                    ATTRIBUTECURRENCYID,
          cast(dbo.UFN_BBNC_GETBBISSITESFORMAPPINGRULE_TOITEMLISTXML(ID) as xml) as BBISSITES,
          NAME,
          BATCHTEMPLATEID
                from dbo.NETCOMMUNITYMAPPINGRULE
                where NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID
            )