UKG Pro Workforce Management
Explore the interactive ERD
Table & Field Reference
device_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
device_id | Unknown | PKFK |
name | Unknown |
balance
| Column | Type | Keys |
|---|---|---|
date_time | Unknown | PK |
id | Unknown | PK |
employee_id | Unknown | FK |
end_balance_amount | Unknown | |
is_changed | Unknown | |
name | Unknown | |
point_balance_type_decimal_place_num | Unknown | |
point_balance_type_id | Unknown | |
point_balance_type_max_balance_amount | Unknown | |
point_balance_type_min_balance_amount | Unknown | |
point_balance_type_qualifier | Unknown | |
point_balance_type_starting_balance_amount | Unknown | |
start_balance_amount | Unknown | |
type_display_name | Unknown | |
type_name | Unknown |
device
| Column | Type | Keys |
|---|---|---|
device_id | Unknown | PK |
access_granted | Unknown | |
adjust_for_dst | Unknown | |
communication_type | Unknown | |
description | Unknown | |
detail | Unknown | |
device_qualifier | Unknown | |
device_type_id | Unknown | |
device_type_qualifier | Unknown | |
enabled | Unknown | |
firmware | Unknown | |
grantor | Unknown | |
id | Unknown | |
ip_address_id | Unknown | |
ip_address_qualifier | Unknown | |
location | Unknown | |
mac_address | Unknown | |
profile_name_id | Unknown | |
profile_name_qualifier | Unknown | |
serial_number | Unknown | |
time_zone_id | Unknown | |
time_zone_qualifier | Unknown |
time_card_as_manager_activity_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
accepted | Unknown | |
approved | Unknown | |
approved_by_employee | Unknown | |
comment_notes | Json | |
concurrent_with_previous | Unknown | |
created_date_time | Unknown | |
data_source_id | Unknown | |
direct | Unknown | |
duration_date | Unknown | |
duration_in_seconds | Unknown | |
duration_order | Unknown | |
edit_by_type_id | Unknown | |
empty_transfer | Unknown | |
end_date_time | Unknown | |
event_type_id | Unknown | |
has_comments | Unknown | |
labor_account_id | Unknown | |
labor_categories | Json | |
mismatched_results | Unknown | |
missing_results | Unknown | |
org_job_id | Unknown | |
reordered | Unknown | |
result_segments | Json | |
start_date_time | Unknown | |
unit_id | Unknown | |
updated_date_time | Unknown | |
weight_value_amount | Unknown | |
wfa_trans_id | Unknown |
time_card_as_manager_punch_comment_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_punch_id | Unknown | PKFK |
categories | Json | |
comment_id | Unknown | |
comment_name | Unknown | |
notes | Json |
time_card_as_manager_punch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
attestation_edit | Unknown | |
cancel_deduct | Unknown | |
datasource_display_name | Unknown | |
datasource_functional_area_name | Unknown | |
datasource_id | Unknown | |
datasource_name | Unknown | |
deduct_rule_id | Unknown | |
deduct_rule_name | Unknown | |
dtm | Unknown | |
edit_by_type_id | Unknown | |
edit_by_type_name | Unknown | |
editable | Unknown | |
entered_on_dtm | Unknown | |
exception_resolved | Unknown | |
exceptions | Json | |
from_phantom_edited | Unknown | |
has_comments | Unknown | |
is_phantom | Unknown | |
is_scheduled | Unknown | |
mark_related_exceptions_as_reviewed | Unknown | |
rounded_dtm | Unknown | |
timezone_id | Unknown | |
timezone_name | Unknown | |
type_override_description | Unknown | |
type_override_id | Unknown | |
type_override_name | Unknown | |
updated_on_dtm | Unknown | |
validate_as_timestamp | Unknown |
time_card_as_manager_worked_shift_worked_span
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
start_date_time | Unknown | PKFK |
time_card_as_manager_worked_shift_id | Unknown | PKFK |
end_punch_id | Unknown | FK |
start_punch_id | Unknown | FK |
approvable_by_manager | Unknown | |
end_date_time | Unknown | |
from_schedule | Unknown | |
id | Unknown | |
item_id | Unknown | |
primary_org_job_id | Unknown | |
primary_org_job_name | Unknown | |
primary_work_rule_id | Unknown | |
primary_work_rule_name | Unknown | |
projected | Unknown | |
rounded_end_date_time | Unknown | |
rounded_start_date_time | Unknown | |
scheduled_org_job | Unknown | |
scheduled_work_rule | Unknown | |
span_id | Unknown | |
transfer_org_job | Unknown | |
transfer_work_rule | Unknown | |
user_entered_org_job | Unknown | |
user_entered_work_rule | Unknown | |
work_rule_id | Unknown | |
work_rule_name | Unknown |
time_card_as_manager_worked_shift
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
start_date_time | Unknown | PK |
employee_id | Unknown | PKFK |
consolidated_schedule_segments | Unknown | |
end_date_time | Unknown | |
end_timezone_id | Unknown | |
end_timezone_name | Unknown | |
from_schedule | Unknown | |
in_progress | Unknown | |
projected | Unknown | |
rounded_end_date_time | Unknown | |
rounded_end_timezone_id | Unknown | |
rounded_start_date_time | Unknown | |
rounded_start_timezone_id | Unknown | |
scheduled_shift_ids | Json | |
shift_total_hours | Unknown | |
start_timezone_id | Unknown | |
start_timezone_name | Unknown | |
transaction_date_time | Unknown |
time_card_as_manager_activity_team_membership
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
created_date_time | Unknown | |
data_source_id | Unknown | |
edit_by_type_id | Unknown | |
end_date_time | Unknown | |
end_timezone_id | Unknown | |
end_timezone_qualifier | Unknown | |
soft_closed | Unknown | |
start_date_time | Unknown | |
start_timezone_id | Unknown | |
start_timezone_qualifier | Unknown | |
system_generated_end | Unknown | |
system_generated_end_timezone_id | Unknown | |
system_generated_end_timezone_qualifier | Unknown | |
team_id | Unknown | |
team_qualifier | Unknown | |
updated_date_time | Unknown |
time_card_as_manager_activity_shift_worked_span
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
work_shift_id | Unknown | PKFK |
activity_processed_segments | Json | |
activity_segment_accepted | Unknown | |
activity_segment_activity | Json | |
activity_segment_approved | Unknown | |
activity_segment_approved_by_employee | Unknown | |
activity_segment_comment_notes | Json | |
activity_segment_concurrent_with_previous | Unknown | |
activity_segment_cost_center | Json | |
activity_segment_created_date_time | Unknown | |
activity_segment_data_source_id | Unknown | |
activity_segment_direct | Unknown | |
activity_segment_duration_date | Unknown | |
activity_segment_duration_in_seconds | Unknown | |
activity_segment_duration_order | Unknown | |
activity_segment_edit_by_type_id | Unknown | |
activity_segment_employee | Json | |
activity_segment_empty_transfer | Unknown | |
activity_segment_end_date_time | Unknown | |
activity_segment_end_timezone | Json | |
activity_segment_event_type_id | Unknown | |
activity_segment_has_comments | Unknown | |
activity_segment_hours_allocated_type | Json | |
activity_segment_id | Unknown | |
activity_segment_labor_account_id | Unknown | |
activity_segment_labor_categories | Json | |
activity_segment_mismatched_results | Unknown | |
activity_segment_missing_results | Unknown | |
activity_segment_org_job | Json | |
activity_segment_org_job_id | Unknown | |
activity_segment_reordered | Unknown | |
activity_segment_result_segments | Json | |
activity_segment_start_date_time | Unknown | |
activity_segment_start_timezone | Json | |
activity_segment_transaction_type | Json | |
activity_segment_unit_id | Unknown | |
activity_segment_updated_date_time | Unknown | |
activity_segment_weight_value_amount | Unknown | |
activity_segment_wfa_trans_id | Unknown | |
activity_segment_work_rule | Json | |
efficiencies_earned_seconds | Unknown | |
efficiencies_efficiency | Unknown | |
efficiencies_efficiency_quantity | Unknown |
time_card_as_manager_activity_shift
| Column | Type | Keys |
|---|---|---|
work_shift_id | Unknown | PK |
employee_id | Unknown | PKFK |
shift_total_actual | Unknown | |
shift_total_allocated | Unknown | |
shift_total_variance | Unknown |
time_card_as_manager_pay_code_edit_entry
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_pay_code_edit_id | Unknown | PKFK |
labor_category_entry_description | Unknown | |
labor_category_entry_id | Unknown | |
labor_category_entry_name | Unknown | |
labor_category_id | Unknown | |
labor_category_name | Unknown | |
labor_category_order_num | Unknown |
time_card_as_manager_pay_code_edit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
approvable_by_manager | Unknown | |
comments_available | Unknown | |
comments_notes | Json | |
duration_in_hours | Unknown | |
edit_by_type_id | Unknown | |
editable | Unknown | |
end_date_time | Unknown | |
item_id | Unknown | |
labor_categories_labor_string | Unknown | |
labor_categories_reference_id | Unknown | |
org_job_id | Unknown | |
org_job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
phantom_spans | Json | |
schedule_amount_type | Unknown | |
scheduled_shift_ids | Json | |
start_date_time | Unknown | |
system_generated | Unknown | |
update_date | Unknown |
time_card_as_manager_exception
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
punch_event_id | Unknown | FK |
worked_shift_id | Unknown | FK |
apply_date | Unknown | |
comment_notes | Json | |
end_date_time | Unknown | |
end_exception | Unknown | |
end_time_zone_id | Unknown | |
event_date | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown | |
is_excused_absence | Unknown | |
is_un_excused_absence | Unknown | |
justifications | Json | |
justified_times | Json | |
missing_time_status_display_name | Unknown | |
missing_time_status_id | Unknown | |
org_job_id | Unknown | |
over_limit_in_hours | Unknown | |
reviewed | Unknown | |
schedule_item_id | Unknown | |
schedule_item_schedule_punch_dtm | Unknown | |
start_date_time | Unknown | |
start_exception | Unknown | |
start_time_zone_id | Unknown | |
transfer | Unknown | |
violation_in_hours | Unknown | |
work_rule_id | Unknown | |
work_rule_name | Unknown |
time_card_as_manager_extended_exception
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
punch_event_id | Unknown | FK |
actual_date_time | Unknown | |
apply_date | Unknown | |
comment_notes | Json | |
comments | Unknown | |
end_date_time | Unknown | |
end_exception | Unknown | |
end_time_zone_id | Unknown | |
event_date | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown | |
is_excused_absence | Unknown | |
is_un_excused_absence | Unknown | |
justifications | Json | |
justified_times | Json | |
missing_time_status_display_name | Unknown | |
missing_time_status_id | Unknown | |
org_job_id | Unknown | |
over_limit_in_hours | Unknown | |
reviewed | Unknown | |
schedule_item_id | Unknown | |
schedule_item_schedule_punch_dtm | Unknown | |
scheduled_date_time | Unknown | |
start_date_time | Unknown | |
start_exception | Unknown | |
start_time_zone_id | Unknown | |
transfer | Unknown | |
violation_in_hours | Unknown | |
work_rule_id | Unknown | |
work_rule_name | Unknown | |
worked_shift_id | Unknown |
time_card_as_manager_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
duration_in_days | Unknown | |
duration_in_hours | Unknown | |
from_shift | Unknown | |
time_item_id | Unknown | |
total_type | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
time_card_as_manager_aggregated_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_total_index | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
approvable_by_manager | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_category_id | Unknown | |
labor_category_name | Unknown | |
labor_category_transfer | Unknown | |
location_id | Unknown | |
location_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
rate | Unknown | |
time_item_type | Json | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
time_card_as_manager_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
employee_context_timezone_id | Unknown | |
employee_context_timezone_name | Unknown | |
total_context_aggregation_type | Unknown | |
total_context_group_by_type | Unknown | |
total_context_type | Unknown |
time_card_as_manager_activity_aggregated_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_activity_total_index | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
approvable_by_manager | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_category_id | Unknown | |
labor_category_name | Unknown | |
labor_category_transfer | Unknown | |
location_id | Unknown | |
location_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
rate | Unknown | |
time_item_type | Json | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
time_card_as_manager_activity_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
employee_context_timezone_id | Unknown | |
employee_context_timezone_name | Unknown | |
time_item_type | Json | |
total_context_aggregation_type | Unknown | |
total_context_group_by_type | Unknown | |
total_context_type | Unknown |
time_card_as_manager_last_update
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
is_edited_in_signed_off | Unknown | |
update_by_person_full_name | Unknown | |
update_date_time | Unknown |
time_card_as_manager_ota_segment
| Column | Type | Keys |
|---|---|---|
effective_date | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_ota_index | Unknown | PKFK |
approved_amount | Unknown | |
comment_count | Unknown | |
denied_amount | Unknown | |
ot_state_indicator | Unknown | |
overtime_detail_segments | Json | |
pending_amount | Unknown |
time_card_as_manager_ota
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
overtime_summary_approvals_count | Unknown | |
overtime_summary_denials_count | Unknown | |
overtime_summary_has_comments | Unknown | |
overtime_summary_has_pending | Unknown | |
overtime_summary_pending_count | Unknown |
time_card_as_manager_daily_total_hours_cost_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
apply_date | Unknown | PKFK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
duration_in_days | Unknown | |
duration_in_hours | Unknown | |
from_shift | Unknown | |
time_item_id | Unknown | |
total_type | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
time_card_as_manager_daily_total_summary
| Column | Type | Keys |
|---|---|---|
apply_date | Unknown | PK |
employee_id | Unknown | PKFK |
cumulative_total | Unknown | |
daily_total_amount_hour | Unknown |
time_card_as_manager_item_total_summary
| Column | Type | Keys |
|---|---|---|
end_apply_date | Unknown | PK |
start_apply_date | Unknown | PK |
employee_id | Unknown | PKFK |
item_hours | Unknown | |
item_id | Unknown |
time_card_as_manager_schedule_shift_segment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
start_date_time | Unknown | PKFK |
time_card_as_manager_schedule_shift_id | Unknown | PKFK |
end_date_time | Unknown | |
id | Unknown | |
labor_categories_labor_entry | Json | |
labor_categories_labor_string | Unknown | |
labor_categories_reference_id | Unknown | |
org_job_ref_id | Unknown | |
org_job_ref_qualifier | Unknown | |
primary_labor_categories_labor_entry | Json | |
primary_labor_categories_labor_string | Unknown | |
primary_labor_categories_reference_id | Unknown | |
primary_org_job_ref_id | Unknown | |
primary_org_job_ref_qualifier | Unknown | |
primary_work_rule_qualifier | Unknown | |
primary_work_rule_ref_id | Unknown | |
segment_type_ref_id | Unknown | |
segment_type_ref_qualifier | Unknown | |
skill_cert_profile_refs | Json | |
transfer_cost_center | Unknown | |
transfer_labor_categories | Unknown | |
transfer_org_job | Unknown | |
transfer_work_rule | Unknown | |
type | Unknown | |
user_entered_cost_center | Unknown | |
user_entered_org_job | Unknown | |
user_entered_work_rule | Unknown | |
work_rule_ref_id | Unknown | |
work_rule_ref_qualifier | Unknown |
time_card_as_manager_schedule_shift
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
start_date_time | Unknown | PK |
employee_id | Unknown | PKFK |
allow_inactive_position | Unknown | |
by_pass_position_selection | Unknown | |
comment_notes | Json | |
deleted | Unknown | |
element_type | Unknown | |
end_date_time | Unknown | |
event_date | Unknown | |
generated | Unknown | |
locked | Unknown | |
modified_date_time | Unknown | |
on_call_shift | Unknown | |
opens | Unknown | |
posted | Unknown | |
posted_notification_pending | Unknown | |
relations | Json | |
self_serviced | Unknown | |
version | Unknown |
time_card_as_manager_processed_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
apply_date | Unknown | |
duration_in_days | Unknown | |
duration_in_seconds | Unknown | |
end_date_time | Unknown | |
in_progress | Unknown | |
item_id | Unknown | |
labor_account_id | Unknown | |
labor_categories_labor_entry | Json | |
labor_categories_labor_string | Unknown | |
labor_categories_reference_id | Unknown | |
money_amount | Unknown | |
order_number | Unknown | |
org_job_apply_date | Unknown | |
org_job_id | Unknown | |
org_job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
projected | Unknown | |
rounded_end_date_time | Unknown | |
rounded_start_date_time | Unknown | |
segment_type_id | Unknown | |
start_date_time | Unknown | |
work_rule_id | Unknown | |
work_rule_name | Unknown |
time_card_as_manager_scheduled_aggregated_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
time_card_as_manager_scheduled_total_index | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
approvable_by_manager | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_category_id | Unknown | |
labor_category_name | Unknown | |
labor_category_transfer | Unknown | |
location_id | Unknown | |
location_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
rate | Unknown | |
time_item_type | Json | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
time_card_as_manager_scheduled_total
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
employee_context_timezone_id | Unknown | |
employee_context_timezone_name | Unknown | |
total_context_total_aggregation_type | Unknown | |
total_context_total_group_by_type | Unknown | |
total_context_total_type | Unknown |
time_card_as_manager_work_holiday_credit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
duration_in_hours | Unknown | |
editable | Unknown | |
end_date_time | Unknown | |
holiday_display_name | Unknown | |
schedule_amount_type | Unknown | |
start_date_time | Unknown | |
system_generated | Unknown |
time_card_as_manager_over_time_info_segment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
effective_date | Unknown | PKFK |
employee_id | Unknown | PKFK |
time_card_as_manager_over_time_info_index | Unknown | PKFK |
amount | Unknown | |
apply_date | Unknown | |
end_date_time | Unknown | |
overtime_detail_segments | Json | |
start_date_time | Unknown | |
work_item_id | Unknown |
time_card_as_manager_over_time_info
| Column | Type | Keys |
|---|---|---|
effective_date | Unknown | PK |
index | Unknown | PK |
employee_id | Unknown | PKFK |
approval_segments | Json | |
approved_amount | Unknown | |
comment_count | Unknown | |
denied_amount | Unknown | |
ot_state_indicator | Unknown | |
pending_amount | Unknown |
time_card_as_manager
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
employee_name | Unknown | |
has_move_amounts | Unknown | |
has_pending_changes | Unknown | |
historical_corrections | Json | |
hours_worked | Json | |
missing_time_groups | Json | |
move_amounts | Json | |
start_date | Instant | |
totalization_status | Unknown |
manager
| Column | Type | Keys |
|---|---|---|
person_number | Unknown | PK |
aoid | Unknown | |
badge_number | Unknown | |
coid | Unknown | |
effective_date | Unknown | |
effective_time | Unknown | |
employee_key | Unknown | |
global_id | Unknown | |
person_key | Unknown | |
request_item_id | Unknown | |
supervisor_number | Unknown | |
supervisor_person_number | Unknown | |
user_key | Unknown | |
username | Unknown |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employment_status | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
number | Unknown | |
user_account_status | Unknown |
schedule_pattern_item_shift_template_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
comment_active | Unknown | |
comment_id | Unknown | |
comment_name | Unknown | |
comment_scheduling_comment_id | Unknown | |
id | Unknown | |
notes | Json | |
scheduling_comment_note_id | Unknown |
schedule_pattern_item_shift_template_segment_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
schedule_pattern_item_shift_template_segment_id | Unknown | PKFK |
color | Unknown | |
id | Unknown | |
tag_definition_ref_id | Unknown | |
tag_definition_ref_localized_qualifier | Unknown | |
tag_definition_ref_qualifier | Unknown |
schedule_pattern_item_shift_template_segment_labor_category_entry
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
schedule_pattern_item_shift_template_segment_id | Unknown | PKFK |
entry_id | Unknown | |
entry_localized_qualifier | Unknown | |
entry_qualifier | Unknown | |
labor_category_id | Unknown | |
labor_category_localized_qualifier | Unknown | |
labor_category_qualifier | Unknown | |
scheduling_labor_category_entry_id | Unknown |
schedule_pattern_item_shift_template_segment_profile
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
schedule_pattern_item_shift_template_segment_id | Unknown | PKFK |
id | Unknown | |
localized_qualifier | Unknown | |
qualifier | Unknown |
schedule_pattern_item_shift_template_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
cost_center_id | Unknown | |
cost_center_localized_qualifier | Unknown | |
cost_center_qualifier | Unknown | |
cost_center_reference_id | Unknown | |
cost_center_scheduling_cost_center_reference_id | Unknown | |
end_date_time | Unknown | |
labor_categories_labor_string | Unknown | |
labor_categories_reference_id | Unknown | |
labor_categories_scheduling_labor_categories_id | Unknown | |
order_number | Unknown | |
org_node_id | Unknown | |
org_node_localized_qualifier | Unknown | |
org_node_qualifier | Unknown | |
segment_type_id | Unknown | |
segment_type_localized_qualifier | Unknown | |
segment_type_qualifier | Unknown | |
start_date_time | Unknown | |
transfer_string | Unknown | |
work_rule_id | Unknown | |
work_rule_localized_qualifier | Unknown | |
work_rule_qualifier | Unknown |
schedule_pattern_item_availability_template_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
availability_type_id | Unknown | |
availability_type_localized_qualifier | Unknown | |
availability_type_qualifier | Unknown | |
end_time | Unknown | |
from_pcet_template | Unknown | |
start_time | Unknown |
schedule_pattern_item_schedule_tag_template_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
comment_active | Unknown | |
comment_id | Unknown | |
comment_name | Unknown | |
comment_scheduling_comment_id | Unknown | |
id | Unknown | |
notes | Json | |
scheduling_comment_note_id | Unknown |
schedule_pattern_item_schedule_tag_template_segment_labor_category_entry
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
schedule_pattern_item_schedule_tag_template_segment_id | Unknown | PKFK |
entry_id | Unknown | |
entry_localized_qualifier | Unknown | |
entry_qualifier | Unknown | |
labor_category_id | Unknown | |
labor_category_localized_qualifier | Unknown | |
labor_category_qualifier | Unknown | |
scheduling_labor_category_entry_id | Unknown |
schedule_pattern_item_schedule_tag_template_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
cost_center_id | Unknown | |
cost_center_localized_qualifier | Unknown | |
cost_center_qualifier | Unknown | |
cost_center_reference_id | Unknown | |
cost_center_scheduling_cost_center_reference_id | Unknown | |
labor_categories_labor_string | Unknown | |
labor_categories_reference_id | Unknown | |
labor_categories_scheduling_labor_categories_id | Unknown | |
org_job_id | Unknown | |
org_job_localized_qualifier | Unknown | |
org_job_qualifier | Unknown | |
schedule_tag_color | Unknown | |
segment_type_id | Unknown | |
segment_type_localized_qualifier | Unknown | |
segment_type_qualifier | Unknown | |
tag_definition_id | Unknown | |
tag_definition_localized_qualifier | Unknown | |
tag_definition_qualifier | Unknown | |
work_rule_id | Unknown | |
work_rule_localized_qualifier | Unknown | |
work_rule_qualifier | Unknown |
schedule_pattern_item_pay_code_edit_template_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
comment_active | Unknown | |
comment_id | Unknown | |
comment_name | Unknown | |
comment_scheduling_comment_id | Unknown | |
id | Unknown | |
notes | Json | |
scheduling_comment_note_id | Unknown |
schedule_pattern_item_pay_code_edit_template_labor_category_entry
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
schedule_pattern_item_id | Unknown | PKFK |
entry_id | Unknown | |
entry_localized_qualifier | Unknown | |
entry_qualifier | Unknown | |
labor_category_id | Unknown | |
labor_category_localized_qualifier | Unknown | |
labor_category_qualifier | Unknown | |
scheduling_labor_category_entry_id | Unknown |
schedule_pattern_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_pattern_id | Unknown | PKFK |
availability_template_deleted | Unknown | |
availability_template_id | Unknown | |
availability_template_system_generated | Unknown | |
availability_template_version | Unknown | |
day | Unknown | |
pay_code_edit_template_code_id | Unknown | |
pay_code_edit_template_code_localized_qualifier | Unknown | |
pay_code_edit_template_code_qualifier | Unknown | |
pay_code_edit_template_cost_center_id | Unknown | |
pay_code_edit_template_cost_center_localized_qualifier | Unknown | |
pay_code_edit_template_cost_center_qualifier | Unknown | |
pay_code_edit_template_cost_center_reference_id | Unknown | |
pay_code_edit_template_cost_center_scheduling_cost_center_reference_id | Unknown | |
pay_code_edit_template_deleted | Unknown | |
pay_code_edit_template_duration_in_days | Unknown | |
pay_code_edit_template_duration_in_time | Unknown | |
pay_code_edit_template_end_date_time | Unknown | |
pay_code_edit_template_id | Unknown | |
pay_code_edit_template_labor_categories_labor_string | Unknown | |
pay_code_edit_template_labor_categories_reference_id | Unknown | |
pay_code_edit_template_labor_categories_scheduling_labor_categories_id | Unknown | |
pay_code_edit_template_locked | Unknown | |
pay_code_edit_template_money_amount | Unknown | |
pay_code_edit_template_name | Unknown | |
pay_code_edit_template_org_job_id | Unknown | |
pay_code_edit_template_org_job_localized_qualifier | Unknown | |
pay_code_edit_template_org_job_qualifier | Unknown | |
pay_code_edit_template_override_accrual_amount | Unknown | |
pay_code_edit_template_start_date_time | Unknown | |
pay_code_edit_template_system_generated | Unknown | |
pay_code_edit_template_transfer_string | Unknown | |
pay_code_edit_template_version | Unknown | |
schedule_tag_template_deleted | Unknown | |
schedule_tag_template_end_date_time | Unknown | |
schedule_tag_template_id | Unknown | |
schedule_tag_template_start_date_time | Unknown | |
schedule_tag_template_system_generated | Unknown | |
schedule_tag_template_version | Unknown | |
shift_template_deleted | Unknown | |
shift_template_description | Unknown | |
shift_template_end_date_time | Unknown | |
shift_template_id | Unknown | |
shift_template_label | Unknown | |
shift_template_locked | Unknown | |
shift_template_name | Unknown | |
shift_template_start_date_time | Unknown | |
shift_template_system_generated | Unknown | |
shift_template_version | Unknown |
schedule_pattern
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
anchor_start_day | Unknown | |
day_count | Unknown | |
deleted | Unknown | |
description | Unknown | |
modified_date_time | Unknown | |
name | Unknown | |
start_date | Unknown | |
system_generated | Unknown | |
time_period_type_id | Unknown | |
time_period_type_name | Unknown |
employee_time_off_request_approval_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
pay_code_id | Unknown | FK |
duration | Unknown | |
end_date | Unknown | |
id | Unknown | |
overridden_shift_id | Unknown | |
start_date | Unknown | |
start_time | Unknown | |
symbolic_amount_id | Unknown | |
symbolic_amount_localized_qualifier | Unknown | |
symbolic_amount_qualifier | Unknown |
employee_time_off_request_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_comment_index | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
data_source_display_name | Unknown | |
id | Unknown | |
text | Unknown | |
timestamps | Unknown |
employee_time_off_request_comment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
comment_active | Unknown | |
comment_id | Unknown | |
comment_name | Unknown | |
id | Unknown |
employee_time_off_request_next_valid_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
id | Unknown | |
name | Unknown | |
symbolic_id | Unknown |
employee_time_off_request_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
pay_code_id | Unknown | FK |
duration | Unknown | |
end_date | Unknown | |
overridden_shift_id | Unknown | |
start_date | Unknown | |
start_time | Unknown | |
symbolic_amount_id | Unknown | |
symbolic_amount_localized_qualifier | Unknown | |
symbolic_amount_qualifier | Unknown |
employee_time_off_request_position_detail_primary_job
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
employee_time_off_request_position_detail_index | Unknown | PKFK |
effective_date | Unknown | |
expiration_date | Unknown | |
labor_account_id | Unknown | |
primary_job | Unknown | |
primary_job_color | Unknown | |
primary_labour_account | Unknown | |
primary_labour_category | Unknown | |
primary_organization_id | Unknown |
employee_time_off_request_position_detail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
accessible | Unknown | |
id | Unknown | |
name | Unknown | |
order_entry_order_number | Unknown | |
order_entry_primary | Unknown |
employee_time_off_request_request_status_change
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
change_date_time | Unknown | |
from_status_id | Unknown | |
from_status_name | Unknown | |
from_status_symbolic_id | Unknown | |
manager_comment_notes | Json | |
person_name | Unknown | |
to_status_id | Unknown | |
to_status_name | Unknown | |
to_status_symbolic_id | Unknown |
employee_time_off_request_approval_history_reviewer
| Column | Type | Keys |
|---|---|---|
create_date_time | Unknown | PK |
employee_time_off_request_id | Unknown | PK |
index | Unknown | PK |
employee_id | Unknown | FK |
approval_step | Unknown | |
approver | Unknown | |
full_name | Unknown |
employee_time_off_request_approval_info_current_reviewer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
create_date_time | Unknown | PKFK |
employee_time_off_request_id | Unknown | PKFK |
employee_id | Unknown | FK |
approver | Unknown | |
full_name | Unknown |
employee_time_off_request
| Column | Type | Keys |
|---|---|---|
create_date_time | Unknown | PK |
id | Unknown | PK |
employee_id | Unknown | FK |
approval_info_current_reviewers_approval_step | Unknown | |
approval_info_pending_steps | Unknown | |
approval_info_request_id | Unknown | |
create_open_shifts_excluded_on | Json | |
creator_id | Unknown | |
creator_localized_qualifier | Unknown | |
creator_qualifier | Unknown | |
current_status_id | Unknown | |
current_status_name | Unknown | |
current_status_symbolic_id | Unknown | |
employee_localized_qualifier | Unknown | |
historical | Unknown | |
overridden_shifts | Json | |
position_id | Unknown | |
position_localized_qualifier | Unknown | |
position_qualifier | Unknown | |
recipient_id | Unknown | |
recipient_position_id | Unknown | |
request_description | Unknown | |
request_id | Unknown | |
request_localized_description | Unknown | |
request_localized_name | Unknown | |
request_name | Unknown | |
request_symbol | Unknown |
device_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
device_id | Unknown | FK |
access_granted | Unknown | |
action_metrics_error_count | Unknown | |
action_metrics_pending_count | Unknown | |
action_metrics_success_count | Unknown | |
adjust_for_dst | Unknown | |
communication_type | Unknown | |
description | Unknown | |
device_metrics_punch_count | Unknown | |
device_metrics_punches_processed | Unknown | |
device_metrics_uncollected_biometric_templates | Unknown | |
device_metrics_uncollected_transactions | Unknown | |
enabled | Unknown | |
firmware | Unknown | |
grantor | Unknown | |
last_action_created_date_time | Unknown | |
last_action_error_message | Unknown | |
last_action_name | Unknown | |
last_action_status | Unknown | |
last_action_updated_date_time | Unknown | |
location | Unknown | |
serial_number | Unknown | |
status_details_firmware_status | Unknown | |
status_details_last_communication_time | Unknown | |
status_details_state | Unknown | |
status_details_status | Unknown |
time_off_request_manager_approval_info_reviewer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
approver | Unknown | |
employee_id | Unknown | |
full_name | Unknown | |
person_number | Unknown |
time_off_request_manager_comment_note_detail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_comment_note_index | Unknown | PKFK |
time_off_request_manager_id | Unknown | PKFK |
comment_note_id | Unknown | |
data_source_display_name | Unknown | |
id | Unknown | |
scheduling_note_id | Unknown | |
text | Unknown | |
time_stamp | Unknown |
time_off_request_manager_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
comment_active | Unknown | |
comment_id | Unknown | |
id | Unknown | |
scheduling_comment_id | Unknown | |
scheduling_comment_note_id | Unknown |
time_off_request_manager_position_detail_primary_job
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
time_off_request_manager_position_detail_index | Unknown | PKFK |
effective_date | Unknown | |
expiration_date | Unknown | |
labor_account_id | Unknown | |
primary_job | Unknown | |
primary_job_color | Unknown | |
primary_labour_account | Unknown | |
primary_labour_category | Unknown | |
primary_organization_id | Unknown |
time_off_request_manager_position_detail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
id | Unknown | |
name | Unknown | |
order_entry_number | Unknown | |
order_entry_primary | Unknown |
time_off_request_manager_valid_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
id | Unknown | |
name | Unknown | |
symbolic_id | Unknown |
time_off_request_manager_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
duration | Unknown | |
end_date | Unknown | |
overridden_shifts | Json | |
pay_code_id | Unknown | |
pay_code_localized_qualifier | Unknown | |
pay_code_qualifier | Unknown | |
start_date | Unknown | |
start_time | Unknown | |
symbolic_amount_id | Unknown | |
symbolic_amount_localized_qualifier | Unknown | |
symbolic_amount_qualifier | Unknown |
time_off_request_manager_approval_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
duration | Unknown | |
end_date | Unknown | |
overridden_shifts | Json | |
pay_code_id | Unknown | |
pay_code_localized_qualifier | Unknown | |
pay_code_qualifier | Unknown | |
start_date | Unknown | |
start_time | Unknown | |
symbolic_amount_id | Unknown | |
symbolic_amount_localized_qualifier | Unknown | |
symbolic_amount_qualifier | Unknown |
time_off_request_manager_request_change_comment_note
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
time_off_request_manager_request_change_index | Unknown | PKFK |
comment_active | Unknown | |
comment_categories | Json | |
comment_id | Unknown | |
comment_name | Unknown | |
id | Unknown | |
notes | Json |
time_off_request_manager_request_change
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
time_off_request_manager_id | Unknown | PKFK |
change_date_time | Unknown | |
from_status_id | Unknown | |
from_status_name | Unknown | |
from_status_symbolic_id | Unknown | |
person_name | Unknown | |
to_status_id | Unknown | |
to_status_name | Unknown | |
to_status_symbolic_id | Unknown |
time_off_request_manager
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
approval_info_current_reviewers_approval_step | Unknown | |
approval_info_history | Json | |
approval_info_modified_date_time | Unknown | |
approval_info_pending_steps | Unknown | |
approval_info_request_id | Unknown | |
create_date_time | Unknown | |
create_open_shifts_excluded_on | Json | |
current_status_id | Unknown | |
current_status_name | Unknown | |
current_status_symbolic_id | Unknown | |
employee_localized_qualifier | Unknown | |
historical | Unknown | |
on_behalf_of_mgr_id | Unknown | |
overridden_shifts | Json | |
position_id | Unknown | |
position_localized_qualifier | Unknown | |
position_qualifier | Unknown | |
recipient_position_id | Unknown | |
request_sub_type_description | Unknown | |
request_sub_type_id | Unknown | |
request_sub_type_localized_description | Unknown | |
request_sub_type_localized_name | Unknown | |
request_sub_type_name | Unknown | |
request_sub_type_symbol | Unknown | |
request_type_description | Unknown | |
request_type_id | Unknown | |
request_type_name | Unknown |
employee_accrual_remaining_day_balance
| Column | Type | Keys |
|---|---|---|
balance_date | Unknown | PK |
index | Unknown | PK |
date | Unknown | PKFK |
employee_accrual_remaining_balance_index | Unknown | PKFK |
pay_code_id | Unknown | PKFK |
available_balance_in_days | Unknown | |
available_balance_in_money | Unknown | |
available_balance_in_seconds | Unknown | |
probationary_balance_in_days | Unknown | |
probationary_balance_in_money | Unknown | |
probationary_balance_in_seconds | Unknown | |
vested_balance_in_days | Unknown | |
vested_balance_in_money | Unknown | |
vested_balance_in_seconds | Unknown |
employee_accrual_remaining_balance
| Column | Type | Keys |
|---|---|---|
date | Unknown | PK |
index | Unknown | PK |
pay_code_id | Unknown | PK |
accrual_code_id | Unknown | |
accrual_code_qualifier | Unknown |
employee_time_card_muster_report_daily_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
date | Unknown | |
error | Unknown | |
status | Unknown |
employee_time_card_absence_exception
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
is_excused_absence | Unknown | |
is_unexcused_absence | Unknown | |
position_id | Unknown |
employee_time_card_contact_total
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
actual_total_approval_status | Unknown | |
actual_total_approved_managers | Unknown | |
amount_type | Unknown | |
apply_date | Unknown | |
apply_work_week | Unknown | |
approving_manager_ids | Unknown | |
approving_manager_names | Unknown | |
approving_managers | Json | |
combined | Unknown | |
contributing_days_of_week | Json | |
cost_center_id | Unknown | |
cost_center_reference_id | Unknown | |
days_amount | Unknown | |
days_amount_1 | Unknown | |
end_date | Unknown | |
hours_amount | Unknown | |
hours_amount_1 | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_transfer | Unknown | |
labor_categories | Json | |
labor_transfer | Unknown | |
manager_approval_needed | Unknown | |
pay_code_id | Unknown | |
pay_period_number | Unknown | |
pay_period_week | Unknown | |
position_id | Unknown | |
signed_off | Unknown | |
start_date | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_1 | Unknown | |
wages_1_amount | Unknown | |
wages_1_currency_code | Unknown | |
wages_amount | Unknown | |
wages_currency_code | Unknown | |
work_week_apply_date_time | Unknown | |
work_week_apply_short_date | Unknown |
employee_time_card_averaging
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
actual_amount | Unknown | |
actual_through_selected_day_hours | Unknown | |
actual_through_selected_day_hours_minus_averaging_target_hours | Unknown | |
amount | Unknown | |
amount_from | Unknown | |
averaging_target_hours_minus_actual_through_selected_day_hours | Unknown | |
avg_reporting_period | Unknown | |
date_pattern_type | Unknown | |
end_date | Unknown | |
include_in_averaging_dataview | Unknown | |
position_id | Unknown | |
projected_hours | Unknown | |
start_date | Unknown | |
target_amount | Unknown | |
target_through_selected_day_hours | Unknown | |
variance | Unknown | |
variance_actual_hours_minus_target_through_selected_day_hours | Unknown | |
variance_projected_hours_minus_target_hours | Unknown | |
variance_target_hours_minus_actual_through_selected_day_hours | Unknown |
employee_time_card_exception_count
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown |
employee_time_card_exception_count_auto_resolved
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown |
employee_time_card_exception_count_manager_justified
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown |
employee_time_card_exception_count_employee_justified
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown |
employee_time_card_exception_count_unreviewed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
exception_type_category | Unknown | |
exception_type_description | Unknown | |
exception_type_display_name | Unknown | |
exception_type_id | Unknown | |
exception_type_name | Unknown |
employee_time_card_actual_total_correction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
actual_total_approval_status | Unknown | |
actual_total_approved_managers | Unknown | |
amount_type | Unknown | |
apply_date | Unknown | |
apply_work_week | Unknown | |
approving_manager_ids | Unknown | |
approving_manager_names | Unknown | |
approving_managers | Json | |
combined | Unknown | |
contributing_days_of_week | Json | |
cost_center_id | Unknown | |
cost_center_reference_id | Unknown | |
days_amount | Unknown | |
days_amount_1 | Unknown | |
end_date | Unknown | |
hours_amount | Unknown | |
hours_amount_1 | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_transfer | Unknown | |
labor_categories | Json | |
labor_transfer | Unknown | |
manager_approval_needed | Unknown | |
pay_code_id | Unknown | |
pay_period_number | Unknown | |
pay_period_week | Unknown | |
position_id | Unknown | |
signed_off | Unknown | |
start_date | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_1 | Unknown | |
wages_1_amount | Unknown | |
wages_1_currency_code | Unknown | |
wages_amount | Unknown | |
wages_currency_code | Unknown | |
work_week_apply_date_time | Unknown | |
work_week_apply_short_date | Unknown |
employee_time_card_muster_report_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
count | Unknown | |
description | Unknown | |
status | Unknown |
employee_time_card_ftpt_all_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
average_all_weekly_hours | Unknown | |
hours_worked | Unknown | |
number_of_all_weeks | Unknown | |
pay_code_id | Unknown |
employee_time_card_ftpt_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
average_all_weekly_hours | Unknown | |
average_worked_weekly_hours | Unknown | |
hours_worked | Unknown | |
number_of_all_weeks | Unknown | |
number_of_worked_weeks | Unknown | |
pay_code_id | Unknown |
employee_time_card_scheduled_total
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_projected_total
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_exclude_correction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_project_total_correction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_shift_contract_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_grouped_hours_total
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
actual_total_approval_status | Unknown | |
actual_total_approved_managers | Unknown | |
amount_type | Unknown | |
apply_date | Unknown | |
apply_work_week | Unknown | |
approving_manager_ids | Unknown | |
approving_manager_names | Unknown | |
approving_managers | Json | |
combined | Unknown | |
contributing_days_of_week | Json | |
cost_center_id | Unknown | |
cost_center_reference_id | Unknown | |
days_amount | Unknown | |
days_amount_1 | Unknown | |
end_date | Unknown | |
hours_amount | Unknown | |
hours_amount_1 | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_transfer | Unknown | |
labor_categories | Json | |
labor_transfer | Unknown | |
manager_approval_needed | Unknown | |
pay_code_id | Unknown | |
pay_period_number | Unknown | |
pay_period_week | Unknown | |
position_id | Unknown | |
signed_off | Unknown | |
start_date | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_1 | Unknown | |
wages_1_amount | Unknown | |
wages_1_currency_code | Unknown | |
wages_amount | Unknown | |
wages_currency_code | Unknown | |
work_week_apply_date_time | Unknown | |
work_week_apply_short_date | Unknown |
employee_time_card_actual_total
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
employee_id | Unknown | FK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
id | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_actual_total_exclude_correction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
hours_amount | Unknown | |
is_from_correction | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
job_transfer | Unknown | |
labor_categories_entry | Json | |
labor_categories_reference_id | Unknown | |
labor_categories_string | Unknown | |
labor_transfer | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
pay_period_number | Unknown | |
signed_off | Unknown | |
wage_addition | Unknown | |
wage_multiplier | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_shift_scheduled_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_shift_projected_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_shift_actual_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_daily_scheduled_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_daily_projected_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_daily_actual_total_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount_type | Unknown | |
apply_date | Unknown | |
combined | Unknown | |
days_amount | Unknown | |
duration_in_hours | Unknown | |
job_id | Unknown | |
job_name | Unknown | |
pay_code_id | Unknown | |
pay_code_name | Unknown | |
wages | Unknown | |
wages_currency_amount | Unknown | |
wages_currency_code | Unknown |
employee_time_card_accrual_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
accrual_code_allow_edit | Unknown | |
accrual_code_amount_type | Unknown | |
accrual_code_hours_per_day_in_seconds | Unknown | |
accrual_code_id | Unknown | |
accrual_code_name | Unknown | |
accrual_code_shortname | Unknown | |
accrual_code_type_id | Unknown | |
accrual_code_type_name | Unknown | |
carry_forward_hours_amount | Unknown | |
disqualified | Unknown | |
effective_date | Unknown | |
excluded | Unknown | |
from_transition | Unknown | |
grant_hours_amount | Unknown | |
hours_amount | Unknown | |
limit_hours_amount | Unknown | |
original_hours_amount | Unknown | |
probation_hours_amount | Unknown | |
probation_seconds_amount | Unknown | |
seconds_amount | Unknown | |
spceded_by_reset | Unknown | |
suspended | Unknown | |
system_generated_num | Unknown | |
to_person_name | Unknown | |
to_person_qualifier | Unknown | |
type | Unknown | |
type_str | Unknown | |
update_datetm | Unknown |
employee_time_card_accrual_daily_summary
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
employee_time_card_accrual_summary_id | Unknown | PKFK |
available_balance_hours | Unknown | |
available_balance_in_seconds | Unknown | |
balance_date | Unknown | |
current_balance_date | Unknown | |
current_balance_probation_duration_in_seconds | Unknown | |
current_balance_probation_hours_amount | Unknown | |
current_balance_vested_duration_in_seconds | Unknown | |
current_balance_vested_hours_amount | Unknown | |
earned_to_date_hours | Unknown | |
pending_grant_hours | Unknown | |
planned_taking_hours | Unknown | |
reporting_period | Unknown | |
taking_to_date_hours | Unknown | |
taking_to_date_in_seconds | Unknown |
employee_time_card_accrual_reporting_period_summary
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
employee_time_card_accrual_summary_id | Unknown | PKFK |
ending_balance_date | Unknown | |
ending_balance_probation_duration_in_seconds | Unknown | |
ending_balance_probation_hours_amount | Unknown | |
ending_balance_vested_duration_in_seconds | Unknown | |
ending_balance_vested_hours_amount | Unknown | |
opening_balance_date | Unknown | |
opening_balance_probation_duration_in_seconds | Unknown | |
opening_balance_probation_hours_amount | Unknown | |
opening_balance_vested_duration_in_seconds | Unknown | |
opening_balance_vested_hours_amount | Unknown | |
prior_ending_balance_date | Unknown | |
prior_ending_balance_probation_duration_in_seconds | Unknown | |
prior_ending_balance_probation_hours_amount | Unknown | |
prior_ending_balance_vested_duration_in_seconds | Unknown | |
prior_ending_balance_vested_hours_amount | Unknown | |
reporting_period_span | Unknown |
employee_time_card_accrual_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
accrual_code_allow_edit | Unknown | |
accrual_code_hours_per_day | Unknown | |
accrual_code_hours_per_day_in_seconds | Unknown | |
accrual_code_id | Unknown | |
accrual_code_name | Unknown | |
accrual_code_shortname | Unknown | |
accrual_code_typeid | Unknown | |
accrual_code_typename | Unknown | |
effective_date_range | Json | |
end_date_time | Unknown | |
start_date_time | Unknown | |
starting_balance_for_period_balance_date | Unknown | |
starting_balance_for_period_probation_days_amount | Unknown | |
starting_balance_for_period_probation_duration_in_seconds | Unknown | |
starting_balance_for_period_probation_hours_amount | Unknown | |
starting_balance_for_period_vested_days_amount | Unknown | |
starting_balance_for_period_vested_duration_in_seconds | Unknown | |
starting_balance_for_period_vested_hours_amount | Unknown |
employee_time_card
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
absence_exception_employee_id | Unknown | FK |
employee_name | Unknown | |
is_excused_absence | Unknown | |
is_unexcused_absence | Unknown |
perfect_attendance_transaction
| Column | Type | Keys |
|---|---|---|
apply_date_time | Unknown | PK |
id | Unknown | PK |
employee_id | Unknown | FK |
point_transaction_employee_id | Unknown | FK |
name | Unknown | |
perfect_attendance_definition_id | Unknown | |
perfect_attendance_definition_qualifier | Unknown | |
point_transaction_apply_date_time | Unknown | |
point_transaction_balance_change | Unknown | |
point_transaction_decimal_place_num | Unknown | |
point_transaction_id | Unknown | |
point_transaction_name | Unknown | |
policy_definition_detail_label | Unknown | |
policy_definition_id | Unknown | |
policy_definition_qualifier | Unknown | |
type_display_name | Unknown | |
type_name | Unknown |