Version 2025.04

These staging tables are modified

CREATE TABLE aler_export_external_data (
export_er_hdr_id	int	NOT NULL
er_paid_on	datetime
er_amt_paid	numeric(28,10)
er_payment_number	nvarchar(255)
corp_charge_date	datetime
corp_charge_amt_paid	numeric(28,10)
update_status	int
aler_export_external_data_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__aler_export_external_data PRIMARY KEY CLUSTERED (aler_export_external_data_id)
)

CREATE TABLE alex_cumulative_miles (
user_ekey	nvarchar(255)	NOT NULL
mileage_period_ekey	nvarchar(255)	NOT NULL
initial_cumulative_miles	numeric(28	10)
expense_type_ekey	nvarchar(255)
alex_cumulative_miles_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_cumulative_miles PRIMARY KEY CLUSTERED (alex_cumulative_miles_id)
)

CREATE TABLE alex_document_export_status (
export_doc_hdr_id	int	NOT NULL
export_document_type	nchar(3)	NOT NULL
export_document_id	nvarchar(255)
export_line_id	int
export_status	int	NOT NULL
status_timestamp	datetime
external_error_code	nvarchar(255)
external_error_message	nvarchar(255)
alex_document_export_status_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_document_export_status PRIMARY KEY CLUSTERED (alex_document_export_status_id )
)

CREATE TABLE alex_external_key (
bus_obj_type_id	int	NOT NULL
bob_id	int
old_external_key	nvarchar(255)
new_external_key	nvarchar(255)
alex_external_key_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_external_key PRIMARY KEY CLUSTERED (alex_external_key_id)

CREATE TABLE alex_fx_rate (
currency_ekey	nvarchar(255)	NOT NULL
valid_date	datetime	NOT NULL
fx_rate	numeric(28,10)	NOT NULL
fx_source_ekey	nvarchar(255)
alex_fx_rate_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_fx_rate PRIMARY KEY CLUSTERED (alex_fx_rate_id)
)

CREATE TABLE alex_invoice_payment (
export_invoice_hdr_id	int	NOT NULL
paid_amount	numeric(28	10)
paid_date	datetime
payment_number	nvarchar(255)
voucher_number	nvarchar(255)
update_status	int
alex_invoice_payment_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_invoice_payment PRIMARY KEY CLUSTERED (alex_invoice_payment_id)
)

CREATE TABLE alex_pd_eur_rate (
perdiem_definition_ekey	nvarchar(255)	NOT NULL
location_ekey	nvarchar(255)
min_time_at_location	smallint
perdiem_per_hour	smallint
overnight_stay	smallint	NOT NULL
first_day_of_trip	smallint	NOT NULL
last_day_of_trip	smallint	NOT NULL
effective_date	datetime
rate_value	numeric(28,10)	NOT NULL
rate_currency_ekey	nvarchar(255)	NOT NULL
active_status	smallint	NOT NULL
until_date	datetime
alex_pd_eur_rate_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_pd_eur_rate PRIMARY KEY CLUSTERED (alex_pd_eur_rate_id)
)

CREATE TABLE alex_project_assignments (
employee_number	nvarchar(255)	NOT NULL
project_charge_code	nvarchar(255)	NOT NULL
start_date	datetime	NOT NULL
end_date	datetime	NOT NULL
hourly_charge_type_name	nvarchar(255)
charge_type_name	nvarchar(255)
start_time	datetime
end_time	datetime
location_name	nvarchar(255)
role_name	nvarchar(255)
alex_project_assignments_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_project_assignments PRIMARY KEY CLUSTERED (alex_project_assignments_id)
)

CREATE TABLE alex_proxy (
user_ekey	nvarchar(255)
proxy_user_ekey	nvarchar(255)	NOT NULL
proxy_role	smallint	NOT NULL
business_process_id	int	NOT NULL
only_out_of_office	smallint	NOT NULL
active_status	smallint	NOT NULL
user_group_ekey	nvarchar(255)
alex_proxy_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_proxy PRIMARY KEY CLUSTERED (alex_proxy_id)
)

CREATE TABLE alex_reviewer_permission (
reviewer_user_ekey	nvarchar(255)
reviewer_group_ekey	nvarchar(50)
activity_internal_name	nvarchar(50)	NOT NULL
user_group_ekey	nvarchar(50)	NOT NULL
active_status	smallint	DEFAULT 1 NOT NULL
alex_reviewer_permission_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_reviewer_permission PRIMARY KEY CLUSTERED (alex_reviewer_permission_id)
)

CREATE TABLE alex_ts_user_billable_rates (
user_ekey	nvarchar(255)
project_ekey	nvarchar(255)
charge_role_ekey	nvarchar(40)
effective_date	datetime
billable_rate	numeric(20,2)	NOT NULL
billable_rate_currency_ekey	nvarchar(255)	NOT NULL
expiration_date	datetime
alex_ts_user_billable_rates_id	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__alex_ts_user_billable_rates PRIMARY KEY CLUSTERED (alex_ts_user_billable_rates_id )
)