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