USP_DATATUNEUPFOOTNOTEREASONMAP_CREATEORUPDATE

Creates or updates the data tune up footnote reason code map row.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@FOOTNOTECODE1REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE2REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE3REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE4REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE5REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE6REASONCODEID	uniqueidentifier	IN
@FOOTNOTECODE7REASONCODEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_DATATUNEUPFOOTNOTEREASONMAP_CREATEORUPDATE (
                @ID uniqueidentifier,
                @FOOTNOTECODE1REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE2REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE3REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE4REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE5REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE6REASONCODEID uniqueidentifier = null,
                @FOOTNOTECODE7REASONCODEID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null
            ) as begin
                set nocount on;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

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

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

                if exists(select 1 from dbo.DATATUNEUPFOOTNOTEREASONMAP where ID = @ID)
                    update dbo.DATATUNEUPFOOTNOTEREASONMAP
                    set
                        FOOTNOTECODE1REASONCODEID = @FOOTNOTECODE1REASONCODEID,
                        FOOTNOTECODE2REASONCODEID = @FOOTNOTECODE2REASONCODEID,
                        FOOTNOTECODE3REASONCODEID = @FOOTNOTECODE3REASONCODEID,
                        FOOTNOTECODE4REASONCODEID = @FOOTNOTECODE4REASONCODEID,
                        FOOTNOTECODE5REASONCODEID = @FOOTNOTECODE5REASONCODEID,
                        FOOTNOTECODE6REASONCODEID = @FOOTNOTECODE6REASONCODEID,
                        FOOTNOTECODE7REASONCODEID = @FOOTNOTECODE7REASONCODEID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;

                else
                    insert into dbo.DATATUNEUPFOOTNOTEREASONMAP
                    (
                        ID,
                        FOOTNOTECODE1REASONCODEID,
                        FOOTNOTECODE2REASONCODEID,
                        FOOTNOTECODE3REASONCODEID,
                        FOOTNOTECODE4REASONCODEID,
                        FOOTNOTECODE5REASONCODEID,
                        FOOTNOTECODE6REASONCODEID,
                        FOOTNOTECODE7REASONCODEID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values
                    (
                        @ID,
                        @FOOTNOTECODE1REASONCODEID,
                        @FOOTNOTECODE2REASONCODEID,
                        @FOOTNOTECODE3REASONCODEID,
                        @FOOTNOTECODE4REASONCODEID,
                        @FOOTNOTECODE5REASONCODEID,
                        @FOOTNOTECODE6REASONCODEID,
                        @FOOTNOTECODE7REASONCODEID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );

                return 0;
            end