UFN_BBNC_REGISTRANTATTRIBUTEDATA

Returns a list of attributes for the specified registrant for Blackbaud Internet Solutions. The list may be filtered by attribute type.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN
@ATTRIBUTETYPEID	int	IN
Definition

Copy


            CREATE function dbo.UFN_BBNC_REGISTRANTATTRIBUTEDATA
            (
                @REGISTRANTID uniqueidentifier,
                @ATTRIBUTETYPEID int = null
            )
            returns @TABLE table
            (
                ID int,
                ATTRIBUTETYPEID int,
                ATTRIBUTEDATATYPE tinyint,
                COMMENTS nvarchar(max),
                SEQUENCE int,
                DESCRIPTION nvarchar(max),
                TABLEENTRYID int,
                CURRENCYISO4217 nvarchar(3)
            )
            as
            begin
                declare @BUILTINATTRIBID int;

                set @ATTRIBUTETYPEID = coalesce(@ATTRIBUTETYPEID, 0);

                -- Add any built-in attributes (DO NOT REMOVE OR MODIFY THIS SECTION!!)            

                if @ATTRIBUTETYPEID = 0 or @ATTRIBUTETYPEID > 499
                    begin
                        select @BUILTINATTRIBID = object_id('dbo.UFN_BBNC_REGISTRANTATTRIBUTEDATABUILTIN');
                        if @BUILTINATTRIBID > 0
                            insert into @TABLE 
                            (
                                ID, 
                                ATTRIBUTETYPEID,
                                ATTRIBUTEDATATYPE,
                                COMMENTS,
                                SEQUENCE,
                                DESCRIPTION,
                                TABLEENTRYID,
                                CURRENCYISO4217
                            )
                            select 
                                ID, 
                                ATTRIBUTETYPEID,
                                ATTRIBUTEDATATYPE,
                                COMMENTS,
                                SEQUENCE,
                                DESCRIPTION,
                                TABLEENTRYID,
                                CURRENCYISO4217
                            from 
                                dbo.UFN_BBNC_REGISTRANTATTRIBUTEDATABUILTIN(@REGISTRANTID, @ATTRIBUTETYPEID);
                    end;
                return;
            end;