USP_DATAFORMTEMPLATE_ADD_APPLICATIONUSERCLAIMSLINK

      CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPLICATIONUSERCLAIMSLINK 
      (
        @ID uniqueidentifier = null output,
        @APPUSERID uniqueidentifier,
        @NAMEIDENTIFIER nvarchar(50),
        @CHANGEAGENTID uniqueidentifier = null
      )
      as
        begin
          set nocount on;

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

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

            set @ID = newid();

          begin try
            insert into dbo.APPUSERCLAIMSLINK (ID,NAMEIDENTIFIER, APPUSERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, ISREGISTERED)
            values (@ID,@NAMEIDENTIFIER, @APPUSERID,@CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, 0);
          end try

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

        return 0;
      end