# UKG Pro Workforce Management schema ERD

Table and field reference for the Fivetran UKG Pro Workforce Management connector.

## Table & Field Reference

### device_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_punch_id | Unknown | PK, FK |
| categories | Json |  |
| comment_id | Unknown |  |
| comment_name | Unknown |  |
| notes | Json |  |

### time_card_as_manager_punch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| start_date_time | Unknown | PK, FK |
| time_card_as_manager_worked_shift_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| work_shift_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_pay_code_edit_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_total_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_activity_total_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_ota_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| item_hours | Unknown |  |
| item_id | Unknown |  |

### time_card_as_manager_schedule_shift_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| start_date_time | Unknown | PK, FK |
| time_card_as_manager_schedule_shift_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_card_as_manager_scheduled_total_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_id | Unknown | PK, FK |
| time_card_as_manager_over_time_info_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| schedule_pattern_item_shift_template_segment_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| schedule_pattern_item_shift_template_segment_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| schedule_pattern_item_shift_template_segment_id | Unknown | PK, FK |
| id | Unknown |  |
| localized_qualifier | Unknown |  |
| qualifier | Unknown |  |

### schedule_pattern_item_shift_template_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_pattern_id | Unknown | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| schedule_pattern_item_schedule_tag_template_segment_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_pattern_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_comment_index | Unknown | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| symbolic_id | Unknown |  |

### employee_time_off_request_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| create_date_time | Unknown | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| employee_time_off_request_position_detail_index | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_off_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_off_request_manager_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_off_request_manager_position_detail_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| symbolic_id | Unknown |  |

### time_off_request_manager_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| time_off_request_manager_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_off_request_manager_request_change_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_accrual_remaining_balance_index | Unknown | PK, FK |
| pay_code_id | Unknown | PK, FK |
| 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 | PK, FK |
| date | Unknown |  |
| error | Unknown |  |
| status | Unknown |  |

### employee_time_card_absence_exception

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| count | Unknown |  |
| description | Unknown |  |
| status | Unknown |  |

### employee_time_card_ftpt_all_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| employee_time_card_accrual_summary_id | Unknown | PK, FK |
| 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 | PK, FK |
| employee_time_card_accrual_summary_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- device_group(device_id) → device(device_id)
- balance(employee_id) → employee(id)
- time_card_as_manager_activity_segment(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_punch_comment_note(employee_id) → time_card_as_manager_punch(employee_id)
- time_card_as_manager_punch_comment_note(time_card_as_manager_punch_id) → time_card_as_manager_punch(id)
- time_card_as_manager_punch(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_worked_shift_worked_span(end_punch_id) → time_card_as_manager_punch(id)
- time_card_as_manager_worked_shift_worked_span(start_punch_id) → time_card_as_manager_punch(id)
- time_card_as_manager_worked_shift_worked_span(employee_id) → time_card_as_manager_worked_shift(employee_id)
- time_card_as_manager_worked_shift_worked_span(start_date_time) → time_card_as_manager_worked_shift(start_date_time)
- time_card_as_manager_worked_shift_worked_span(time_card_as_manager_worked_shift_id) → time_card_as_manager_worked_shift(id)
- time_card_as_manager_worked_shift(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_activity_team_membership(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_activity_shift_worked_span(employee_id) → time_card_as_manager_activity_shift(employee_id)
- time_card_as_manager_activity_shift_worked_span(work_shift_id) → time_card_as_manager_activity_shift(work_shift_id)
- time_card_as_manager_activity_shift(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_pay_code_edit_entry(employee_id) → time_card_as_manager_pay_code_edit(employee_id)
- time_card_as_manager_pay_code_edit_entry(time_card_as_manager_pay_code_edit_id) → time_card_as_manager_pay_code_edit(id)
- time_card_as_manager_pay_code_edit(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_exception(worked_shift_id) → time_card_as_manager_worked_shift(id)
- time_card_as_manager_exception(punch_event_id) → time_card_as_manager_punch(id)
- time_card_as_manager_exception(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_extended_exception(punch_event_id) → time_card_as_manager_punch(id)
- time_card_as_manager_extended_exception(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_total_summary(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_aggregated_total(employee_id) → time_card_as_manager_total(employee_id)
- time_card_as_manager_aggregated_total(time_card_as_manager_total_index) → time_card_as_manager_total(index)
- time_card_as_manager_total(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_activity_aggregated_total(employee_id) → time_card_as_manager_activity_total(employee_id)
- time_card_as_manager_activity_aggregated_total(time_card_as_manager_activity_total_index) → time_card_as_manager_activity_total(index)
- time_card_as_manager_activity_total(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_last_update(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_ota_segment(employee_id) → time_card_as_manager_ota(employee_id)
- time_card_as_manager_ota_segment(time_card_as_manager_ota_index) → time_card_as_manager_ota(index)
- time_card_as_manager_ota(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_daily_total_hours_cost_summary(employee_id) → time_card_as_manager_daily_total_summary(employee_id)
- time_card_as_manager_daily_total_hours_cost_summary(apply_date) → time_card_as_manager_daily_total_summary(apply_date)
- time_card_as_manager_daily_total_summary(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_item_total_summary(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_schedule_shift_segment(employee_id) → time_card_as_manager_schedule_shift(employee_id)
- time_card_as_manager_schedule_shift_segment(start_date_time) → time_card_as_manager_schedule_shift(start_date_time)
- time_card_as_manager_schedule_shift_segment(time_card_as_manager_schedule_shift_id) → time_card_as_manager_schedule_shift(id)
- time_card_as_manager_schedule_shift(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_processed_segment(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_scheduled_aggregated_total(employee_id) → time_card_as_manager_scheduled_total(employee_id)
- time_card_as_manager_scheduled_aggregated_total(time_card_as_manager_scheduled_total_index) → time_card_as_manager_scheduled_total(index)
- time_card_as_manager_scheduled_total(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_work_holiday_credit(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager_over_time_info_segment(employee_id) → time_card_as_manager_over_time_info(employee_id)
- time_card_as_manager_over_time_info_segment(effective_date) → time_card_as_manager_over_time_info(effective_date)
- time_card_as_manager_over_time_info_segment(time_card_as_manager_over_time_info_index) → time_card_as_manager_over_time_info(index)
- time_card_as_manager_over_time_info(employee_id) → time_card_as_manager(employee_id)
- time_card_as_manager(employee_id) → employee(id)
- schedule_pattern_item_shift_template_comment_note(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_shift_template_comment_note(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_shift_template_segment_tag(schedule_pattern_item_shift_template_segment_id) → schedule_pattern_item_shift_template_segment(id)
- schedule_pattern_item_shift_template_segment_tag(schedule_pattern_item_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_item_id)
- schedule_pattern_item_shift_template_segment_tag(schedule_pattern_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_id)
- schedule_pattern_item_shift_template_segment_labor_category_entry(schedule_pattern_item_shift_template_segment_id) → schedule_pattern_item_shift_template_segment(id)
- schedule_pattern_item_shift_template_segment_labor_category_entry(schedule_pattern_item_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_item_id)
- schedule_pattern_item_shift_template_segment_labor_category_entry(schedule_pattern_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_id)
- schedule_pattern_item_shift_template_segment_profile(schedule_pattern_item_shift_template_segment_id) → schedule_pattern_item_shift_template_segment(id)
- schedule_pattern_item_shift_template_segment_profile(schedule_pattern_item_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_item_id)
- schedule_pattern_item_shift_template_segment_profile(schedule_pattern_id) → schedule_pattern_item_shift_template_segment(schedule_pattern_id)
- schedule_pattern_item_shift_template_segment(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_shift_template_segment(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_availability_template_segment(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_availability_template_segment(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_schedule_tag_template_comment_note(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_schedule_tag_template_comment_note(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_schedule_tag_template_segment_labor_category_entry(schedule_pattern_item_schedule_tag_template_segment_id) → schedule_pattern_item_schedule_tag_template_segment(id)
- schedule_pattern_item_schedule_tag_template_segment_labor_category_entry(schedule_pattern_item_id) → schedule_pattern_item_schedule_tag_template_segment(schedule_pattern_item_id)
- schedule_pattern_item_schedule_tag_template_segment_labor_category_entry(schedule_pattern_id) → schedule_pattern_item_schedule_tag_template_segment(schedule_pattern_id)
- schedule_pattern_item_schedule_tag_template_segment(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_schedule_tag_template_segment(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_pay_code_edit_template_comment_note(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_pay_code_edit_template_comment_note(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item_pay_code_edit_template_labor_category_entry(schedule_pattern_item_id) → schedule_pattern_item(id)
- schedule_pattern_item_pay_code_edit_template_labor_category_entry(schedule_pattern_id) → schedule_pattern_item(schedule_pattern_id)
- schedule_pattern_item(schedule_pattern_id) → schedule_pattern(id)
- employee_time_off_request_approval_period(pay_code_id) → employee_accrual_remaining_balance(pay_code_id)
- employee_time_off_request_approval_period(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_approval_period(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_comment_note(create_date_time) → employee_time_off_request_comment(create_date_time)
- employee_time_off_request_comment_note(employee_time_off_request_id) → employee_time_off_request_comment(employee_time_off_request_id)
- employee_time_off_request_comment_note(employee_time_off_request_comment_index) → employee_time_off_request_comment(index)
- employee_time_off_request_comment(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_comment(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_next_valid_status(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_next_valid_status(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_period(pay_code_id) → employee_accrual_remaining_balance(pay_code_id)
- employee_time_off_request_period(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_period(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_position_detail_primary_job(create_date_time) → employee_time_off_request_position_detail(create_date_time)
- employee_time_off_request_position_detail_primary_job(employee_time_off_request_id) → employee_time_off_request_position_detail(employee_time_off_request_id)
- employee_time_off_request_position_detail_primary_job(employee_time_off_request_position_detail_index) → employee_time_off_request_position_detail(index)
- employee_time_off_request_position_detail(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_position_detail(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_request_status_change(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_request_status_change(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request_approval_history_reviewer(employee_id) → employee(id)
- employee_time_off_request_approval_info_current_reviewer(employee_id) → employee(id)
- employee_time_off_request_approval_info_current_reviewer(create_date_time) → employee_time_off_request(create_date_time)
- employee_time_off_request_approval_info_current_reviewer(employee_time_off_request_id) → employee_time_off_request(id)
- employee_time_off_request(employee_id) → employee(id)
- device_status(device_id) → device(device_id)
- time_off_request_manager_approval_info_reviewer(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_comment_note_detail(time_off_request_manager_comment_note_index) → time_off_request_manager_comment_note(index)
- time_off_request_manager_comment_note_detail(time_off_request_manager_id) → time_off_request_manager_comment_note(time_off_request_manager_id)
- time_off_request_manager_comment_note(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_position_detail_primary_job(time_off_request_manager_position_detail_index) → time_off_request_manager_position_detail(index)
- time_off_request_manager_position_detail_primary_job(time_off_request_manager_id) → time_off_request_manager_position_detail(time_off_request_manager_id)
- time_off_request_manager_position_detail(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_valid_status(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_period(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_approval_period(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager_request_change_comment_note(time_off_request_manager_request_change_index) → time_off_request_manager_request_change(index)
- time_off_request_manager_request_change_comment_note(time_off_request_manager_id) → time_off_request_manager_request_change(time_off_request_manager_id)
- time_off_request_manager_request_change(time_off_request_manager_id) → time_off_request_manager(id)
- time_off_request_manager(employee_id) → employee(id)
- employee_accrual_remaining_day_balance(pay_code_id) → employee_accrual_remaining_balance(pay_code_id)
- employee_accrual_remaining_day_balance(date) → employee_accrual_remaining_balance(date)
- employee_accrual_remaining_day_balance(employee_accrual_remaining_balance_index) → employee_accrual_remaining_balance(index)
- employee_time_card_muster_report_daily_data(employee_id) → employee_time_card(employee_id)
- employee_time_card_absence_exception(employee_id) → employee_time_card(employee_id)
- employee_time_card_contact_total(employee_id) → employee_time_card(employee_id)
- employee_time_card_averaging(employee_id) → employee_time_card(employee_id)
- employee_time_card_exception_count(employee_id) → employee_time_card(employee_id)
- employee_time_card_exception_count_auto_resolved(employee_id) → employee_time_card(employee_id)
- employee_time_card_exception_count_manager_justified(employee_id) → employee_time_card(employee_id)
- employee_time_card_exception_count_employee_justified(employee_id) → employee_time_card(employee_id)
- employee_time_card_exception_count_unreviewed(employee_id) → employee_time_card(employee_id)
- employee_time_card_actual_total_correction(employee_id) → employee_time_card(employee_id)
- employee_time_card_muster_report_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_ftpt_all_data(employee_id) → employee_time_card(employee_id)
- employee_time_card_ftpt_data(employee_id) → employee_time_card(employee_id)
- employee_time_card_scheduled_total(employee_id) → employee_time_card(employee_id)
- employee_time_card_projected_total(employee_id) → employee_time_card(employee_id)
- employee_time_card_exclude_correction(employee_id) → employee_time_card(employee_id)
- employee_time_card_project_total_correction(employee_id) → employee_time_card(employee_id)
- employee_time_card_shift_contract_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_grouped_hours_total(employee_id) → employee_time_card(employee_id)
- employee_time_card_actual_total(employee_id) → employee_time_card(employee_id)
- employee_time_card_actual_total_exclude_correction(employee_id) → employee_time_card(employee_id)
- employee_time_card_shift_scheduled_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_shift_projected_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_shift_actual_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_daily_scheduled_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_daily_projected_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_daily_actual_total_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card_accrual_transaction(employee_id) → employee_time_card(employee_id)
- employee_time_card_accrual_daily_summary(employee_id) → employee_time_card_accrual_summary(employee_id)
- employee_time_card_accrual_daily_summary(employee_time_card_accrual_summary_id) → employee_time_card_accrual_summary(id)
- employee_time_card_accrual_reporting_period_summary(employee_id) → employee_time_card_accrual_summary(employee_id)
- employee_time_card_accrual_reporting_period_summary(employee_time_card_accrual_summary_id) → employee_time_card_accrual_summary(id)
- employee_time_card_accrual_summary(employee_id) → employee_time_card(employee_id)
- employee_time_card(employee_id) → employee(id)
- employee_time_card(absence_exception_employee_id) → employee(id)
- perfect_attendance_transaction(employee_id) → employee(id)
- perfect_attendance_transaction(point_transaction_employee_id) → employee(id)