/****** Object: Table [dbo].[pp] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[pp](

[e_id] [bigint] NULL,

[p_id] [bigint] NULL,

[pr_id] [int] NULL,

[s_name] [varchar](256) NULL,

[pro_id] [varchar](512) NULL,

[timestamp] [varchar](30) NULL,

[extra] [varchar](max) NULL,

[checked] [bit] NULL,

[timestamp_ts] [datetime] NULL,

[arrival_timestamp] [datetimeoffset](7) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[pp_staging](

[e_id] [bigint] NULL,

[p_id] [bigint] NULL,

[pr_id] [int] NULL,

[s_name] [varchar](256) NULL,

[pro_id] [varchar](512) NULL,

[timestamp] [varchar](30) NULL,

[extra] [varchar](max) NULL,

[checked] [bit] NULL,

[timestamp_ts] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[patient_property_arrival] ON [dbo].[patient_property]

AFTER INSERT, UPDATE

AS

UPDATE dbo.pp

SET arrival_timestamp = SYSDATETIMEOFFSET()

FROM inserted i

WHERE dbo.pp.p_id = i.p_id

AND dbo.pp.s_name = i.s_name

AND dbo.pp.pro_id = i.pro_id

AND dbo.pp.timestamp_ts = i.timestamp_ts

AND dbo.pp.checked = i.checked

let me know if you need any additinal info. thanks.