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 ) |
|
|
) |
|
|