UFN_BBNC_CONSTITALUMNIATTRIBUTEDATA

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN
@ATTRIBUTETYPEID	int	IN

Definition

Copy



CREATE function dbo.UFN_BBNC_CONSTITALUMNIATTRIBUTEDATA
(
    @EDUCATIONALHISTORYID 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_CONSTITALUMNIATTRIBUTEDATABUILTIN');
            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_CONSTITALUMNIATTRIBUTEDATABUILTIN(@EDUCATIONALHISTORYID, @ATTRIBUTETYPEID);
        end;
    return;
end;