USP_ADD_INDIVIDUAL_ALIAS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@ALIASTYPECODEID	uniqueidentifier	IN
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@TITLECODEID	uniqueidentifier	IN
@TITLE2CODEID	uniqueidentifier	IN
@SUFFIXCODEID	uniqueidentifier	IN
@SUFFIX2CODEID	uniqueidentifier	IN
@IGNOREDUPLICATE	bit	IN

Definition

Copy



        create procedure dbo.USP_ADD_INDIVIDUAL_ALIAS (
            @ID uniqueidentifier = null output,
            @CHANGEAGENTID uniqueidentifier = null,
            @CONSTITUENTID uniqueidentifier,
            @ALIASTYPECODEID uniqueidentifier = null,
            @KEYNAME nvarchar(100) = '',
            @FIRSTNAME nvarchar(50) = '',
            @MIDDLENAME nvarchar(50) = '',
            @TITLECODEID uniqueidentifier = null,
            @TITLE2CODEID uniqueidentifier = null,
            @SUFFIXCODEID uniqueidentifier = null,
            @SUFFIX2CODEID uniqueidentifier = null,
            @IGNOREDUPLICATE bit = 0
            )
        as
        set nocount on;

        declare @CURRENTDATE datetime;

        set @CURRENTDATE = getdate();

        if @ID is null
            set @ID = newid();

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

        begin try
            insert into dbo.[ALIAS] (
                [ID],
                [CONSTITUENTID],
                [ALIASTYPECODEID],
                [KEYNAME],
                [FIRSTNAME],
                [MIDDLENAME],
                [TITLECODEID],
                [TITLE2CODEID],
                [SUFFIXCODEID],
                [SUFFIX2CODEID],
                [ADDEDBYID],
                [CHANGEDBYID],
                [DATEADDED],
                [DATECHANGED]
                )
            values (
                @ID,
                @CONSTITUENTID,
                @ALIASTYPECODEID,
                @KEYNAME,
                @FIRSTNAME,
                @MIDDLENAME,
                @TITLECODEID,
                @TITLE2CODEID,
                @SUFFIXCODEID,
                @SUFFIX2CODEID,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
                );
        end try

        begin catch
            -- If there is already an Alias by this name, don't raise error. 

            if not ((CHARINDEX('UIX_ALIAS_CONSTITUENTID_KEYNAME_FIRSTNAME_MIDDLENAME_TITLECODEID_TITLE2CODEID_SUFFIXCODEID_SUFFIX2CODEID', ERROR_MESSAGE()) > 0) and @IGNOREDUPLICATE = 1)
            begin
                exec dbo.USP_RAISE_ERROR;

                return 1;
            end
        end catch

        return 0;