USP_DATAFORMTEMPLATE_ADD_PERSONALACCESSTOKEN

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PERSONALACCESSTOKEN
            (
                @ID uniqueidentifier = null output,
                @APPUSERID uniqueidentifier,
                @PROXYOWNERID uniqueidentifier = null,
                @NAME nvarchar(50) = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @PERSONALACCESSTOKEN nvarchar(500) = null
            )
            as

            set nocount on;

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

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

            declare @CURRENTDATE datetime;
            declare @EXPIRATIONDATE datetime;

            set @CURRENTDATE = getdate();
            set @EXPIRATIONDATE = DATEADD(year, 1, @CURRENTDATE);

             if((select count(1) 
                from dbo.PERSONALACCESSTOKEN
                where PROXYUSERID = @APPUSERID and ENABLED = 1 and EXPIRATIONDATE >= @CURRENTDATE)<2 )
                    begin
                        if((select 1 from dbo.APPUSER where ISACTIVE = 1 and ID = @APPUSERID) = 1)
                            begin
                                begin try
                                    -- handle inserting the data
                                    insert into dbo.PERSONALACCESSTOKEN
                                        (ID, NAME, TOKEN, PROXYUSERID, EXPIRATIONDATE, ENABLED, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                                    values
                                        (@ID, @NAME, @PERSONALACCESSTOKEN , @APPUSERID, @EXPIRATIONDATE ,1, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
                                end try

                                begin catch
                                    exec dbo.USP_RAISE_ERROR;
                                    return 1;
                                end catch
                            end
                        else
                            begin
                                raiserror('ERR_APPUSER_ADDPAT_ACTIVEUSER', 13, 1);
                            end
                    end
            else
                  raiserror('ERR_APPUSER_ADDPAT', 13, 1);
            return 0