USP_REJECTIONCODE_GETORCREATEID

Returns the ID for a rejection code given a description. The ID is created if necessary.

Parameters

Parameter	Parameter Type	Mode	Description
@DESCRIPTION	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_REJECTIONCODE_GETORCREATEID
            (
                @DESCRIPTION nvarchar(100),
                @CHANGEAGENTID uniqueidentifier
            )
            as            
            set nocount on;

            declare @ID uniqueidentifier;

            select 
                @ID = ID
            from dbo.REJECTIONCODE
            where DESCRIPTION = @DESCRIPTION;

            if @ID is null
            begin
                set @ID = newid();
                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                insert into dbo.REJECTIONCODE(ID, DESCRIPTION, ACTIVE, SEQUENCE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                select
                    @ID, @DESCRIPTION, 1, (select coalesce(max(SEQUENCE) + 1,0) from dbo.REJECTIONCODE), @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE;    
            end

            select @ID as [ID];