USP_WEALTHPOINT_DATAREFRESHNOTIFICATION_ADD

Adds WealthPoint Data Refresh notification information to the database.

Parameters

Parameter	Parameter Type	Mode
@NOTIFICATIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	IN
@DBOBJECTNAME	nvarchar(150)	IN

Definition

Copy



            create procedure dbo.USP_WEALTHPOINT_DATAREFRESHNOTIFICATION_ADD(
                @NOTIFICATIONID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @IDSETREGISTERID uniqueidentifier,
                @DBOBJECTNAME nvarchar(150)
            ) as begin
                set nocount on;

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

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

                insert into 
                    dbo.WEALTHPOINTDATAREFRESHNOTIFICATION(
                        NOTIFICATIONID,
                        IDSETREGISTERID,
                        DBOBJECTNAME,
                        DATEADDED, 
                        DATECHANGED, 
                        ADDEDBYID, 
                        CHANGEDBYID
                    )values(
                        @NOTIFICATIONID,
                        @IDSETREGISTERID,
                        @DBOBJECTNAME,
                        @CURRENTDATE, 
                        @CURRENTDATE, 
                        @CHANGEAGENTID, 
                        @CHANGEAGENTID
                    )        
            end