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