USP_BBNC_GETORCREATEEDUCATIONALINSTITUTION

Gets or create an educational institution for use in committing profile update transactions from Blackbaud Internet Solutions.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@ISAFFILIATED	bit	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_BBNC_GETORCREATEEDUCATIONALINSTITUTION
            (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,    
                @NAME nvarchar(100),
                @ISAFFILIATED bit = 0,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

                begin try
                    set @ID = null;

                    select top 1
                        @ID = [EDUCATIONALINSTITUTION].[ID]
                    from
                        dbo.EDUCATIONALINSTITUTION
                    where
                        [EDUCATIONALINSTITUTION].[NAME] = @NAME;

                    if @ID is null
                    begin                        
                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @COUNTRYID uniqueidentifier;
                        set @COUNTRYID=dbo.UFN_COUNTRY_GETDEFAULT();

                        exec dbo.USP_DATAFORMTEMPLATE_ADD_EDUCATIONALINSTITUTION_2 @ID output, 
                                                                                   @CHANGEAGENTID, 
                                                                                   '', 
                                                                                   @NAME, 
                                                                                   @ISAFFILIATED, 
                                                                                   @COUNTRYID, 
                                                                                   '', 
                                                                                   null;


                    end

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;