Version 2022.01

These staging tables are added in Infor Expense Management 2022.01

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)
)
CREATE TABLE alex_report_period (
external_key nvarchar(255) NOT NULL
report_period_name nvarchar(255) NOT NULL
report_period_type_ekey nvarchar(255) NOT NULL
start_day smallint
start_time datetime
ref_date datetime
report_period_active_status smallint NOT NULL
submission_cutoff int
payroll_cutoff int
CONSTRAINT PK121_1 PRIMARY KEY CLUSTERED ( external_key )
)
CREATE TABLE alex_weekend_schedule (
external_key nvarchar(255) NOT NULL
weekend_schedule_name nvarchar(255) NOT NULL
sunday smallint NOT NULL
monday smallint NOT NULL
tuesday smallint NOT NULL
wednesday smallint NOT NULL
thursday smallint NOT NULL
friday smallint NOT NULL
saturday smallint NOT NULL
active_status smallint NOT NULL
CONSTRAINT PK556_1 PRIMARY KEY CLUSTERED ( external_key )
)
CREATE TABLE alex_work_schedule (
external_key nvarchar(255) NOT NULL
work_sched_name nvarchar(255) NOT NULL
report_period_ekey nvarchar(255) NOT NULL
hours_day1 numeric(14,4)
hours_day2 numeric(14,4)
hours_day3 numeric(14,4)
hours_day4 numeric(14,4)
hours_day5 numeric(14,4)
hours_day6 numeric(14,4)
hours_day7 numeric(14,4)
hours_day8 numeric(14,4)
hours_day9 numeric(14,4)
hours_day10 numeric(14,4)
hours_day11 numeric(14,4)
hours_day12 numeric(14,4)
hours_day13 numeric(14,4)
hours_day14 numeric(14,4)
min_hours_per_period numeric(7,2)
max_hours_per_period numeric(7,2)
apply_cross_workday_to int
day1_start_time datetime
day1_end_time datetime
day2_start_time datetime
day2_end_time datetime
day3_start_time datetime
day3_end_time datetime
day4_start_time datetime
day4_end_time datetime
day5_start_time datetime
day5_end_time datetime
day6_start_time datetime
day6_end_time datetime
day7_start_time datetime
day7_end_time datetime
day8_start_time datetime
day8_end_time datetime
day9_start_time datetime
day9_end_time datetime
day10_start_time datetime
day10_end_time datetime
day11_start_time datetime
day11_end_time datetime
day12_start_time datetime
day12_end_time datetime
day13_start_time datetime
day13_end_time datetime
day14_start_time datetime
day14_end_time datetime
work_schedule_active_status smallint NOT NULL
CONSTRAINT PK122_1 PRIMARY KEY CLUSTERED ( external_key )
)
CREATE TABLE alex_charge_role (
external_key nvarchar(255) NOT NULL
charge_role_name nvarchar(255)
charge_role_active_status smallint NOT NULL
CONSTRAINT PK111_1 PRIMARY KEY CLUSTERED ( external_key )
)