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