UFN_BBNC_CONSTITPRIMARYALUMNIATTRIBUTEDATA

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

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	int	IN
@ATTRIBUTETYPEID	int	IN
Definition

Copy


            CREATE function dbo.UFN_BBNC_CONSTITPRIMARYALUMNIATTRIBUTEDATA
            (
                @CONSTITUENTID int,
                @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_CONSTITPRIMARYALUMNIATTRIBUTEDATABUILTIN');
                        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_CONSTITPRIMARYALUMNIATTRIBUTEDATABUILTIN(@CONSTITUENTID, @ATTRIBUTETYPEID);
                    end;
                return;
            end;