First, if any UPR10500 tables have data in them, you'll want to make a backup such as using this script:
Select * into UPR10500BAK from UPR10500
The script for the UPR10500 table with the Workflow_Action_Date column you can then use is here:
/*Begin_UPR10500*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR10500]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPR10500]
GO
CREATE TABLE [dbo].[UPR10500] (
[EMPLOYID] [char] (15) NOT NULL ,
[Pay_Schedule] [char] (15) NOT NULL ,
[YEAR1] [smallint] NOT NULL ,
[PERIODID] [smallint] NOT NULL ,
[Workflow_Status] [smallint] NOT NULL ,
[SupervisorADLogin] [char](85) NOT NULL,
[Workflow_Action_Date] [datetime] NOT NULL,
[DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PKUPR10500] PRIMARY KEY NONCLUSTERED
(
[EMPLOYID],
[Pay_Schedule],
[YEAR1],
[PERIODID]
) ON [PRIMARY],
CHECK (datepart(hour,[Workflow_Action_Date])=(0) AND datepart(minute,[Workflow_Action_Date])=(0) AND datepart(second,[Workflow_Action_Date])=(0) AND datepart(millisecond,[Workflow_Action_Date])=(0))
) ON [PRIMARY]
GO
setuser
GO
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[EMPLOYID]'
GO
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[PERIODID]'
GO
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[Pay_Schedule]'
GO
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[Workflow_Status]'
GO
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[YEAR1]'
GO
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[SupervisorADLogin]'
GO
EXEC sp_bindefault N'[dbo].[GPS_DATE]', N'[UPR10500].[Workflow_Action_Date]'
GO
setuser
GO
GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[UPR10500] TO [DYNGRP]
GO
/*End_UPR10500*/
After that, you'll need to move any data from the UPR10500BAK table to the UPR10500 table again, then continue with the upgrade.
If you need further assistance with the upgrade, we'd need to open a support case so an engineer can work with you.
Thanks,
