Version 2022.05

This staging table is added.

CREATE TABLE alex_import_er_per_diem (
external_key	nvarchar(255)	NOT NULL
parent_ekey	nvarchar(255)	NOT NULL
private_nightstay_address	nvarchar(255)
first_day_of_trip	smallint
last_day_of_trip	smallint
time_at_location	smallint
start_time	datetime
end_time	datetime
overnight_stay	smallint
long_term_stay	smallint
breakfast	smallint
lunch	smallint
dinner	smallint
meal_amount	numeric(28,10)
meal_amount_ekey	nvarchar(255)
CONSTRAINT PK_alex_import_er_per_diem PRIMARY KEY CLUSTERED ( external_key )
)
Go