# Xactly schema ERD

Table and field reference for the Fivetran Xactly connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | String | PK |
| amount_unit_type_id | String | FK |
| bus_amount_unit_type_id | String | FK |
| bus_group_amount_unit_type_id | String | FK |
| credit_id | String | FK |
| eff_participant_id | String | FK |
| eff_position_id | String | FK |
| item_pay_curr_unit_type_id | String | FK |
| local_currency_unit_type_id | String | FK |
| order_item_id | String | FK |
| participant_id | String | FK |
| payment_curr_unit_type_id | String | FK |
| period_id | String | FK |
| position_id | String | FK |
| amount_display_symbol | Unknown |  |
| conversion_rate | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| earning_group_id | Unknown |  |
| geography_id | Unknown |  |
| is_active | Unknown |  |
| item_code | Unknown |  |
| mgr_eff_part_id | Unknown |  |
| mgr_eff_pos_id | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Instant |  |
| name | Unknown |  |
| order_code | Unknown |  |
| payment_flag | Unknown |  |
| product_id | Unknown |  |
| run_id | Unknown |  |
| trans_id | Unknown |  |

### credit

| Column | Type | Keys |
| --- | --- | --- |
| credit_id | String | PK |
| amount_unit_type_id | String | FK |
| business_group_id | String | FK |
| credit_type_id | String | FK |
| eff_participant_id | String | FK |
| eff_position_id | String | FK |
| order_item_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| plan_id | String | FK |
| position_id | String | FK |
| rule_id | String | FK |
| source_credit_id | String | FK |
| source_position_id | String | FK |
| src_pos_relation_type_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| geography_id | Unknown |  |
| is_active | Unknown |  |
| item_code | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Instant |  |
| name | Unknown |  |
| order_code | Unknown |  |
| product_id | Unknown |  |
| reason_code_id | Unknown |  |
| release_group_id | Unknown |  |
| run_id | Unknown |  |
| trans_id | Unknown |  |

### title_category

| Column | Type | Keys |
| --- | --- | --- |
| category_name | String | PK |
| ui_category_name | Unknown |  |

### login

| Column | Type | Keys |
| --- | --- | --- |
| login_id | String | PK |
| user_id | String | FK |
| akamai_ip | Unknown |  |
| email | Unknown |  |
| login_comment | Unknown |  |
| login_device | Unknown |  |
| login_device_os_version | Unknown |  |
| login_device_version | Unknown |  |
| login_status | Unknown |  |
| login_time | Unknown |  |
| login_type | Unknown |  |
| login_url | Unknown |  |
| logoff_method | Unknown |  |
| logoff_time | Unknown |  |
| module_code | Unknown |  |
| partner_id | Unknown |  |
| partner_session_id | Unknown |  |
| site_pod_name | Unknown |  |
| source_ip | Unknown |  |
| ticket_id | Unknown |  |
| user_agent | Unknown |  |
| user_status | Unknown |  |

### commission_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount_unit_type_id | String | FK |
| as_of_period_id | String | FK |
| business_group_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| earning_group_name | Unknown |  |
| ever_on_hold | Unknown |  |
| held_amount | Unknown |  |
| is_held | Unknown |  |
| name | Unknown |  |
| released_amount | Unknown |  |
| total_amount | Unknown |  |

### approval_doc_instance

| Column | Type | Keys |
| --- | --- | --- |
| approval_doc_inst_id | String | PK |
| doc_owner_user_id | String | FK |
| participant_id | String | FK |
| plan_id | String | FK |
| position_id | String | FK |
| title_id | String | FK |
| approval_doc_def_id | Unknown |  |
| context_param | Unknown |  |
| decline_reason_code_id | Unknown |  |
| default_error_reason | Unknown |  |
| dispute_type | Unknown |  |
| doc_owner_id | Unknown |  |
| doc_owner_name | Unknown |  |
| document_name | Unknown |  |
| effective_date | Unknown |  |
| end_date | Unknown |  |
| error_reason_code | Unknown |  |
| initiator_id | Unknown |  |
| initiator_name | Unknown |  |
| instance_context | Unknown |  |
| instance_status | Unknown |  |
| is_relative_date | Unknown |  |
| participant_hist_id | Unknown |  |
| plan_doc_template_id | Unknown |  |
| position_hist_id | Unknown |  |
| process_name | Unknown |  |
| process_template_name | Unknown |  |
| process_version | Unknown |  |
| reason_code_id | Unknown |  |
| routing_group_inst_id | Unknown |  |
| run_id | Unknown |  |
| signature_type | Unknown |  |
| start_date | Unknown |  |
| subject | Unknown |  |
| workflow_owner_id | Unknown |  |

### commission

| Column | Type | Keys |
| --- | --- | --- |
| commission_id | String | PK |
| amount_unit_type_id | String | FK |
| attainment_value_unit_type_id | String | FK |
| business_group_id | String | FK |
| credit_id | String | FK |
| credit_type_id | String | FK |
| credit_unit_type_id | String | FK |
| eff_participant_id | String | FK |
| eff_position_id | String | FK |
| measure_value_unit_type_id | String | FK |
| order_item_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| plan_id | String | FK |
| position_id | String | FK |
| quota_id | String | FK |
| quota_period_type_id | String | FK |
| rate_amount_unit_type_id | String | FK |
| rule_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| earning_group_id | Unknown |  |
| geography_id | Unknown |  |
| is_active | Unknown |  |
| item_code | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Instant |  |
| name | Unknown |  |
| order_code | Unknown |  |
| product_id | Unknown |  |
| rate_table_id | Unknown |  |
| reason_code_id | Unknown |  |
| run_id | Unknown |  |
| source | Unknown |  |
| trans_id | Unknown |  |

### credit_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount_unit_type_id | String | FK |
| as_of_period_id | String | FK |
| business_group_id | String | FK |
| eff_position_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| position_id | String | FK |
| credit_type_name | Unknown |  |
| ever_on_hold | Unknown |  |
| is_held | Unknown |  |
| name | Unknown |  |
| total_amount | Unknown |  |

### quota_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount_unit_type_id | String | FK |
| as_of_period_id | String | FK |
| business_group_id | String | FK |
| eff_position_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| position_id | String | FK |
| quota_id | String | FK |
| name | Unknown |  |
| total_amount | Unknown |  |

### rate_tier_value

| Column | Type | Keys |
| --- | --- | --- |
| rate_tier_values_id | String | PK |
| effective_end_period_id | String | FK |
| effective_start_period_id | String | FK |
| rate_table_tier_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| element_id | Unknown |  |
| element_name | Unknown |  |
| element_type | Unknown |  |
| formula_expression | Unknown |  |
| formula_id | Unknown |  |
| formula_name | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| rate_type | Unknown |  |
| tier_rate | Unknown |  |
| version | Unknown |  |

### plan_rule

| Column | Type | Keys |
| --- | --- | --- |
| planrules_id | String | PK |
| plan_id | String | FK |
| rule_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### rate_table

| Column | Type | Keys |
| --- | --- | --- |
| rate_table_id | String | PK |
| attainment_ut_disp_sym | Unknown |  |
| attainment_ut_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| source_id | Unknown |  |
| version | Unknown |  |

### bonus

| Column | Type | Keys |
| --- | --- | --- |
| bonus_id | String | PK |
| amount_unit_type_id | String | FK |
| business_group_id | String | FK |
| credit_id | String | FK |
| eff_participant_id | String | FK |
| eff_position_id | String | FK |
| order_item_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| plan_id | String | FK |
| position_id | String | FK |
| rule_id | String | FK |
| amount | Unknown |  |
| amount_display_symbol | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| earning_group_id | Unknown |  |
| earning_group_name | Unknown |  |
| estimated_rel_date | Unknown |  |
| ever_on_hold | Unknown |  |
| geography_id | Unknown |  |
| geography_name | Unknown |  |
| incentive_date | Unknown |  |
| input_type | Unknown |  |
| is_active | Unknown |  |
| is_held | Unknown |  |
| is_processed | Unknown |  |
| item_code | Unknown |  |
| mgr_eff_part_id | Unknown |  |
| mgr_eff_pos_id | Unknown |  |
| mgr_master_pos_id | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| order_code | Unknown |  |
| participant_name | Unknown |  |
| plan_name | Unknown |  |
| position_name | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| reason_code_id | Unknown |  |
| reason_code_name | Unknown |  |
| release_date | Unknown |  |
| release_group_id | Unknown |  |
| rule_name | Unknown |  |
| run_id | Unknown |  |
| trans_id | Unknown |  |
| version | Unknown |  |

### pos_part_assignment

| Column | Type | Keys |
| --- | --- | --- |
| pos_part_assignment_id | String | PK |
| participant_id | String | FK |
| position_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### pos_relation_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| from_pos_id | String | FK |
| pos_rel_type_id | String | FK |
| to_pos_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

### participant

| Column | Type | Keys |
| --- | --- | --- |
| participant_id | String | PK |
| business_group_id | String | FK |
| native_cur_unit_type_id | String | FK |
| obj_bonus_target_unittype_id | String | FK |
| payment_cur_unit_type_id | String | FK |
| pr_target_unit_type_id | String | FK |
| salary_unit_type_id | String | FK |
| user_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| department | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| emp_status_id | Unknown |  |
| employee_id | Unknown |  |
| is_active | Unknown |  |
| manager_emp_id | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| participant_type | Unknown |  |
| payroll_id | Unknown |  |
| source_id | Unknown |  |
| version_reason_id | Unknown |  |
| version_sub_reason_id | Unknown |  |

### approval_document

| Column | Type | Keys |
| --- | --- | --- |
| document_id | String | PK |
| configurable_columns | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| doc_format | Unknown |  |
| document_name | Unknown |  |
| document_status | Unknown |  |
| document_type | Unknown |  |
| is_active | Unknown |  |
| is_relative_date | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| modified_date | Unknown |  |
| process_template_id | String |  |
| process_template_name | Unknown |  |
| routing_group_inst_id | Unknown |  |

### draw_assignment

| Column | Type | Keys |
| --- | --- | --- |
| draw_assignment_id | String | PK |
| business_group_id | String | FK |
| draw_id | String | FK |
| eff_participant_id | String | FK |
| eff_position_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| assignment_id | Unknown |  |
| assignment_name | Unknown |  |
| assignment_type | Unknown |  |
| balance | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| finalized_by | Unknown |  |
| finalized_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| pay_amount | Unknown |  |
| person_name | Unknown |  |
| position_name | Unknown |  |
| preview_balance | Unknown |  |
| projected_amount | Unknown |  |
| recovery_percent | Unknown |  |
| version | Unknown |  |

### rate_table_tier

| Column | Type | Keys |
| --- | --- | --- |
| rate_table_tier_id | String | PK |
| rate_table_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| default_rate | Unknown |  |
| formula_expression | Unknown |  |
| formula_name | Unknown |  |
| high_value | Unknown |  |
| is_active | Unknown |  |
| low_value | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| rate_type | Unknown |  |
| tier_name | Unknown |  |
| tier_number | Unknown |  |
| version | Unknown |  |

### quota

| Column | Type | Keys |
| --- | --- | --- |
| quota_id | String | PK |
| quota_period_id | String | FK |
| quota_value_unit_type_id | String | FK |
| classification_name | Unknown |  |
| classification_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| quota_interval_id | Unknown |  |
| quota_value | Unknown |  |
| source_id | Unknown |  |
| version | Unknown |  |

### quota_total

| Column | Type | Keys |
| --- | --- | --- |
| quota_totals_id | String | PK |
| participant_id | String | FK |
| period_id | String | FK |
| position_id | String | FK |
| unittype_id | String | FK |
| amount | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### batch_type

| Column | Type | Keys |
| --- | --- | --- |
| batch_type_id | String | PK |
| batch_type_sub_category_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### plan_approval

| Column | Type | Keys |
| --- | --- | --- |
| plan_approval_id | String | PK |
| business_group_id | String | FK |
| plan_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| doc_template_id | Unknown |  |
| document | Unknown |  |
| is_active | Unknown |  |
| manager_id | Unknown |  |
| mgr_acpt_date | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| per_acpt_date | Unknown |  |
| person_id | Unknown |  |
| route_date | Unknown |  |
| route_id | Unknown |  |
| status | Unknown |  |
| version | Unknown |  |

### user_batch

| Column | Type | Keys |
| --- | --- | --- |
| batch_id | String | PK |
| batch_type_id | String | FK |
| period_id | String | FK |
| batch_name | Unknown |  |
| batch_status | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| is_aggregation_enabled | Unknown |  |
| item_count | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### order_type

| Column | Type | Keys |
| --- | --- | --- |
| order_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| is_active | Unknown |  |
| is_ordertype_shown | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### plan

| Column | Type | Keys |
| --- | --- | --- |
| plan_id | String | PK |
| period_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### quota_relationship

| Column | Type | Keys |
| --- | --- | --- |
| quota_relationship_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| label | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### pos_title_assignment

| Column | Type | Keys |
| --- | --- | --- |
| pos_title_assignment_id | String | PK |
| position_id | String | FK |
| title_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### period

| Column | Type | Keys |
| --- | --- | --- |
| period_id | String | PK |
| parent_period_id | String | FK |
| period_type_id_fk | String | FK |
| calendar_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| end_date | Unknown |  |
| is_active | Unknown |  |
| is_calc_period | Unknown |  |
| is_etl_excluded | Unknown |  |
| is_hidden | Unknown |  |
| is_open | Unknown |  |
| is_published | Unknown |  |
| is_visible | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| order_number | Unknown |  |
| start_date | Unknown |  |
| version | Unknown |  |

### attainment_measure

| Column | Type | Keys |
| --- | --- | --- |
| attainment_measure_id | String | PK |
| effective_end_period_id | String | FK |
| effective_start_period_id | String | FK |
| master_attainment_measure_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| history_uuid | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| period_type | Unknown |  |
| version | Unknown |  |

### co_item_assignment

| Column | Type | Keys |
| --- | --- | --- |
| comp_order_assignment_id | String | PK |
| comp_order_item_id | String | FK |
| order_type_id | String | FK |
| participant_id | String | FK |
| period_id | String | FK |
| split_amount_unit_type_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| split_amount | Unknown |  |
| split_amount_pct | Unknown |  |
| upload_id | Unknown |  |
| version | Unknown |  |

### credit_type

| Column | Type | Keys |
| --- | --- | --- |
| credit_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK |
| business_group_id | String | FK |
| accepted_contract | Unknown |  |
| activated_date | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| email | Unknown |  |
| enabled | Unknown |  |
| eu_migration_status | Unknown |  |
| ip_addresses | Unknown |  |
| is_active | Unknown |  |
| is_internal_user | Unknown |  |
| is_passwd_reset | Unknown |  |
| locale | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| passwd_chg_dt | Unknown |  |
| passwd_exp_dt | Unknown |  |
| primary_role_type | Unknown |  |
| source_id | Unknown |  |
| user_uuid | Unknown |  |
| version | Unknown |  |

### plan_assignment

| Column | Type | Keys |
| --- | --- | --- |
| plan_assignment_id | String | PK |
| plan_id | String | FK |
| active_end_date | Unknown |  |
| active_start_date | Unknown |  |
| assignment_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### payment_balance_trace

| Column | Type | Keys |
| --- | --- | --- |
| payment_balance_trace_id | String | PK |
| period_id | String | FK |
| created_by_id | Unknown |  |
| created_by_name | String |  |
| created_date | Unknown |  |
| is_active | String |  |
| modified_by_id | Unknown |  |
| modified_by_name | String |  |
| modified_date | Unknown |  |
| run_id | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| target_id | Unknown |  |
| trans_id | Unknown |  |
| version | Unknown |  |

### pos_rel_type

| Column | Type | Keys |
| --- | --- | --- |
| pos_rel_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### emp_status_code

| Column | Type | Keys |
| --- | --- | --- |
| emp_status_code_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| emp_status_code | Unknown |  |
| emp_status_color | Unknown |  |
| is_active | Unknown |  |
| is_included_in_ranking | Unknown |  |
| is_sort_by | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### position

| Column | Type | Keys |
| --- | --- | --- |
| position_id | String | PK |
| business_group_id | String | FK |
| master_position_id | String | FK |
| parent_position_id | String | FK |
| participant_id | String | FK |
| title_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| incent_end_date | Unknown |  |
| incent_st_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| parent_record_id | Unknown |  |
| pos_group_id | Unknown |  |
| version | Unknown |  |

### pos_title_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| pos_title_assignment_id | String | PK |
| id | Unknown | FK |
| position_id | String | FK |
| title_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

### period_type

| Column | Type | Keys |
| --- | --- | --- |
| period_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### pos_relation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| from_pos_id | String | FK |
| pos_rel_type_id | String | FK |
| to_pos_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### credit_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| credit_adjustment_id | String | PK |
| amount_unit_type_id | String | FK |
| credit_id | String | FK |
| period_id | String | FK |
| amount | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| reason_id | Unknown |  |

### pos_hierarchy_history

| Column | Type | Keys |
| --- | --- | --- |
| pos_hierarchy_id | String | PK |
| from_pos_id | String | FK |
| id | Unknown | FK |
| pos_hierarchy_type_id | String | FK |
| to_pos_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| role_type | Unknown |  |
| version | Unknown |  |

### business_group

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | String | PK |
| finalize_start_period_id | String | FK |
| group_unit_type_id | String | FK |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| is_active | Unknown |  |
| locale | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### pos_hierarchy_type

| Column | Type | Keys |
| --- | --- | --- |
| pos_hierarchy_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| pos_hierarchy_type_disp_name | Unknown |  |
| pos_hierarchy_type_name | Unknown |  |
| version | Unknown |  |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| rule_id | String | PK |
| attainment_measure_id | String | FK |
| pos_relation_id | String | FK |
| primary_rule_id | String | FK |
| active_end_date | Unknown |  |
| active_start_date | Unknown |  |
| bonus_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| multiplier | Unknown |  |
| name | Unknown |  |
| parse_tree | Unknown |  |
| rule_content | Unknown |  |
| rule_type | Unknown |  |
| version | Unknown |  |

### unit_type

| Column | Type | Keys |
| --- | --- | --- |
| unit_type_id | String | PK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| display_symbol | Unknown |  |
| group_name | Unknown |  |
| group_type | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### title

| Column | Type | Keys |
| --- | --- | --- |
| title_id | String | PK |
| category_name | String | FK |
| category_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| function_name | Unknown |  |
| function_type | Unknown |  |
| is_active | Unknown |  |
| market | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| pay_period_type | Unknown |  |
| title_level | Unknown |  |
| version | Unknown |  |

### order_stage

| Column | Type | Keys |
| --- | --- | --- |
| order_stage_id | String | PK |
| amount_unit_type_id | String | FK |
| order_type_id | String | FK |
| period_id | String | FK |
| related_item_id | String | FK |
| amount | Unknown |  |
| batch_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| discount | Unknown |  |
| geography_id | Unknown |  |
| incentive_date | Unknown |  |
| is_active | Unknown |  |
| is_promoted | Unknown |  |
| is_validated | Unknown |  |
| item_code | Unknown |  |
| item_status | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| order_code | Unknown |  |
| order_date | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| source_id | Unknown |  |
| upload_id | Unknown |  |
| version | Unknown |  |

### position_history

| Column | Type | Keys |
| --- | --- | --- |
| position_id | String | PK |
| business_group_id | String | FK |
| master_position_id | String | FK |
| parent_position_id | String | FK |
| participant_id | String | FK |
| title_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| incent_end_date | Unknown |  |
| incent_st_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| parent_record_id | Unknown |  |
| pos_group_id | Unknown |  |
| version | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| role_id | String | FK |
| user_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### currency_rate

| Column | Type | Keys |
| --- | --- | --- |
| currency_rate_id | String | PK |
| base_currency_unit_type_id | String | FK |
| target_currency_unit_type_id | String | FK |
| active_end_date | Unknown |  |
| active_start_date | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| exchange_rate | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| source_id | Unknown |  |
| version | Unknown |  |

### part_user_assignment

| Column | Type | Keys |
| --- | --- | --- |
| part_user_assignment_id | String | PK |
| participant_id | String | FK |
| user_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| employee_id | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### participant_history

| Column | Type | Keys |
| --- | --- | --- |
| version | Unknown | PK |
| participant_id | String | PK, FK |
| business_group_id | Unknown | FK |
| native_cur_unit_type_id | Unknown | FK |
| obj_bonus_target_unittype_id | Unknown | FK |
| payment_cur_unit_type_id | Unknown | FK |
| pr_target_unit_type_id | Unknown | FK |
| salary_unit_type_id | Unknown | FK |
| user_id | Unknown | FK |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| emp_status_id | Unknown |  |
| employee_id | Unknown |  |
| first_name | Unknown |  |
| hire_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| is_obj_active | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| obj_bonus_target | Unknown |  |
| obj_payment_cap_percent | Unknown |  |
| object_id | Unknown |  |
| participant_type | Unknown |  |
| personal_target | Unknown |  |
| prefix | Unknown |  |
| prorated_personal_target | Unknown |  |
| prorated_salary | Unknown |  |
| region | Unknown |  |
| salary | Unknown |  |
| source_id | Unknown |  |
| termination_date | Unknown |  |
| version_reason_id | Unknown |  |
| version_sub_reason_id | Unknown |  |

### comp_order_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| comp_order_item_detail_id | String | PK |
| amount_unit_type_id | String | FK |
| comp_order_item_id | String | FK |
| order_type_id | String | FK |
| period_id | String | FK |
| related_item_id | String | FK |
| batch_id | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| customer_id | Unknown |  |
| discount | Unknown |  |
| geography_id | Unknown |  |
| incentive_date | Unknown |  |
| is_active | Unknown |  |
| item_code | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| order_code | Unknown |  |
| order_date | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| source_id | Unknown |  |
| upload_id | Unknown |  |

### credit_held

| Column | Type | Keys |
| --- | --- | --- |
| credit_held_id | String | PK |
| credit_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| held_date | Unknown |  |
| is_active | Unknown |  |
| is_held | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| release_group_id | Unknown |  |
| run_id | Unknown |  |
| trans_id | Unknown |  |
| version | Unknown |  |

### quota_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| quota_assignment_id | String | PK |
| amount_unit_type_id | String | FK |
| effective_end_period_id | String | FK |
| effective_start_period_id | String | FK |
| id | Unknown | FK |
| period_id | String | FK |
| quota_id | String | FK |
| amount | Unknown |  |
| assignment_id | Unknown |  |
| assignment_name | Unknown |  |
| assignment_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

### credit_total

| Column | Type | Keys |
| --- | --- | --- |
| credit_totals_id | String | PK |
| participant_id | String | FK |
| period_id | String | FK |
| position_id | String | FK |
| unittype_id | String | FK |
| amount | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### comp_order_item

| Column | Type | Keys |
| --- | --- | --- |
| comp_order_item_id | String | PK |
| amount_unit_type_id | String | FK |
| order_type_id | String | FK |
| period_id | String | FK |
| related_item_id | String | FK |
| batch_id | Unknown |  |
| customer_id | Unknown |  |
| geography_id | Unknown |  |
| is_active | Unknown |  |
| item_code | Unknown |  |
| line_number | Unknown |  |
| modified_date | Unknown |  |
| order_code | Unknown |  |
| order_date | Unknown |  |
| product_id | Unknown |  |
| source_id | Unknown |  |
| upload_id | Unknown |  |

### pos_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| pos_hierarchy_id | String | PK |
| from_pos_id | String | FK |
| pos_hierarchy_type_id | String | FK |
| to_pos_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### attainment_measure_criteria

| Column | Type | Keys |
| --- | --- | --- |
| attainment_measure_criteria_id | String | PK |
| attainment_measure_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| criteria_id | Unknown |  |
| history_uuid | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### pos_part_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| pos_part_assignment_id | String | PK |
| id | Unknown | FK |
| participant_id | String | FK |
| position_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

### draw

| Column | Type | Keys |
| --- | --- | --- |
| draw_id | String | PK |
| period_id | String | FK |
| unit_type_id | String | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| draw_type | Unknown |  |
| earning_group_id | Unknown |  |
| earning_group_name | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| recovery_percent | Unknown |  |
| version | Unknown |  |

### pos_hierarchy_type_history

| Column | Type | Keys |
| --- | --- | --- |
| pos_hierarchy_type_id | String | PK |
| id | Unknown | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| object_id | Unknown |  |
| pos_hierarchy_type_disp_name | Unknown |  |
| pos_hierarchy_type_name | Unknown |  |
| version | Unknown |  |

### quota_assignment

| Column | Type | Keys |
| --- | --- | --- |
| quota_assignment_id | String | PK |
| amount_unit_type_id | String | FK |
| effective_end_period_id | String | FK |
| effective_start_period_id | String | FK |
| period_id | String | FK |
| quota_id | String | FK |
| amount | Unknown |  |
| assignment_id | Unknown |  |
| assignment_name | Unknown |  |
| assignment_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| version | Unknown |  |

### quota_history

| Column | Type | Keys |
| --- | --- | --- |
| quota_id | String | PK |
| id | Unknown | FK |
| quota_period_id | String | FK |
| quota_value_unit_type_id | String | FK |
| classification_name | Unknown |  |
| classification_type | Unknown |  |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| is_active | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| quota_interval_id | Unknown |  |
| quota_value | Unknown |  |
| source_id | Unknown |  |
| version | Unknown |  |

### pos_rel_type_history

| Column | Type | Keys |
| --- | --- | --- |
| pos_rel_type_id | String | PK |
| id | Unknown | FK |
| created_by_id | Unknown |  |
| created_date | Unknown |  |
| descr | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| is_active | Unknown |  |
| is_master | Unknown |  |
| modified_by_id | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| version | Unknown |  |

## Relationships

- payment(position_id) → position(position_id)
- payment(credit_id) → credit(credit_id)
- payment(eff_participant_id) → participant(participant_id)
- payment(participant_id) → participant(participant_id)
- payment(bus_group_amount_unit_type_id) → unit_type(unit_type_id)
- payment(amount_unit_type_id) → unit_type(unit_type_id)
- payment(item_pay_curr_unit_type_id) → unit_type(unit_type_id)
- payment(eff_position_id) → position(position_id)
- payment(local_currency_unit_type_id) → unit_type(unit_type_id)
- payment(bus_amount_unit_type_id) → unit_type(unit_type_id)
- payment(order_item_id) → comp_order_item(comp_order_item_id)
- payment(period_id) → period(period_id)
- payment(payment_curr_unit_type_id) → unit_type(unit_type_id)
- credit(position_id) → position(position_id)
- credit(credit_type_id) → credit_type(credit_type_id)
- credit(src_pos_relation_type_id) → pos_relation(id)
- credit(plan_id) → plan(plan_id)
- credit(source_position_id) → position(position_id)
- credit(eff_participant_id) → participant(participant_id)
- credit(participant_id) → participant(participant_id)
- credit(amount_unit_type_id) → unit_type(unit_type_id)
- credit(eff_position_id) → position(position_id)
- credit(business_group_id) → business_group(business_group_id)
- credit(source_credit_id) → credit(credit_id)
- credit(order_item_id) → comp_order_item(comp_order_item_id)
- credit(period_id) → period(period_id)
- credit(rule_id) → rule(rule_id)
- login(user_id) → users(user_id)
- commission_summary(as_of_period_id) → period(period_id)
- commission_summary(participant_id) → participant(participant_id)
- commission_summary(amount_unit_type_id) → unit_type(unit_type_id)
- commission_summary(business_group_id) → business_group(business_group_id)
- commission_summary(period_id) → period(period_id)
- approval_doc_instance(position_id) → position(position_id)
- approval_doc_instance(plan_id) → plan(plan_id)
- approval_doc_instance(participant_id) → participant(participant_id)
- approval_doc_instance(doc_owner_user_id) → users(user_id)
- approval_doc_instance(title_id) → title(title_id)
- commission(position_id) → position(position_id)
- commission(attainment_value_unit_type_id) → unit_type(unit_type_id)
- commission(quota_id) → quota(quota_id)
- commission(credit_type_id) → credit_type(credit_type_id)
- commission(quota_period_type_id) → period_type(period_type_id)
- commission(credit_id) → credit(credit_id)
- commission(measure_value_unit_type_id) → unit_type(unit_type_id)
- commission(plan_id) → plan(plan_id)
- commission(credit_unit_type_id) → unit_type(unit_type_id)
- commission(eff_participant_id) → participant(participant_id)
- commission(participant_id) → participant(participant_id)
- commission(amount_unit_type_id) → unit_type(unit_type_id)
- commission(eff_position_id) → position(position_id)
- commission(rate_amount_unit_type_id) → unit_type(unit_type_id)
- commission(business_group_id) → business_group(business_group_id)
- commission(order_item_id) → comp_order_item(comp_order_item_id)
- commission(period_id) → period(period_id)
- commission(rule_id) → rule(rule_id)
- credit_summary(position_id) → position(position_id)
- credit_summary(as_of_period_id) → period(period_id)
- credit_summary(participant_id) → participant(participant_id)
- credit_summary(amount_unit_type_id) → unit_type(unit_type_id)
- credit_summary(eff_position_id) → position(position_id)
- credit_summary(business_group_id) → business_group(business_group_id)
- credit_summary(period_id) → period(period_id)
- quota_summary(position_id) → position(position_id)
- quota_summary(quota_id) → quota(quota_id)
- quota_summary(as_of_period_id) → period(period_id)
- quota_summary(participant_id) → participant(participant_id)
- quota_summary(amount_unit_type_id) → unit_type(unit_type_id)
- quota_summary(eff_position_id) → position(position_id)
- quota_summary(business_group_id) → business_group(business_group_id)
- quota_summary(period_id) → period(period_id)
- rate_tier_value(effective_start_period_id) → period(period_id)
- rate_tier_value(rate_table_tier_id) → rate_table_tier(rate_table_tier_id)
- rate_tier_value(effective_end_period_id) → period(period_id)
- plan_rule(plan_id) → plan(plan_id)
- plan_rule(rule_id) → rule(rule_id)
- bonus(position_id) → position(position_id)
- bonus(credit_id) → credit(credit_id)
- bonus(plan_id) → plan(plan_id)
- bonus(eff_participant_id) → participant(participant_id)
- bonus(participant_id) → participant(participant_id)
- bonus(amount_unit_type_id) → unit_type(unit_type_id)
- bonus(eff_position_id) → position(position_id)
- bonus(business_group_id) → business_group(business_group_id)
- bonus(order_item_id) → comp_order_item(comp_order_item_id)
- bonus(period_id) → period(period_id)
- bonus(rule_id) → rule(rule_id)
- pos_part_assignment(position_id) → position(position_id)
- pos_part_assignment(participant_id) → participant(participant_id)
- pos_relation_history(from_pos_id) → position(position_id)
- pos_relation_history(id) → pos_relation(id)
- pos_relation_history(pos_rel_type_id) → pos_rel_type(pos_rel_type_id)
- pos_relation_history(to_pos_id) → position(position_id)
- participant(user_id) → users(user_id)
- participant(payment_cur_unit_type_id) → unit_type(unit_type_id)
- participant(native_cur_unit_type_id) → unit_type(unit_type_id)
- participant(pr_target_unit_type_id) → unit_type(unit_type_id)
- participant(business_group_id) → business_group(business_group_id)
- participant(salary_unit_type_id) → unit_type(unit_type_id)
- participant(obj_bonus_target_unittype_id) → unit_type(unit_type_id)
- draw_assignment(draw_id) → draw(draw_id)
- draw_assignment(eff_participant_id) → participant(participant_id)
- draw_assignment(participant_id) → participant(participant_id)
- draw_assignment(eff_position_id) → position(position_id)
- draw_assignment(business_group_id) → business_group(business_group_id)
- draw_assignment(period_id) → period(period_id)
- rate_table_tier(rate_table_id) → rate_table(rate_table_id)
- quota(quota_period_id) → period(period_id)
- quota(quota_value_unit_type_id) → unit_type(unit_type_id)
- quota_total(position_id) → position(position_id)
- quota_total(unittype_id) → unit_type(unit_type_id)
- quota_total(participant_id) → participant(participant_id)
- quota_total(period_id) → period(period_id)
- plan_approval(plan_id) → plan(plan_id)
- plan_approval(business_group_id) → business_group(business_group_id)
- user_batch(batch_type_id) → batch_type(batch_type_id)
- user_batch(period_id) → period(period_id)
- plan(period_id) → period(period_id)
- pos_title_assignment(position_id) → position(position_id)
- pos_title_assignment(title_id) → title(title_id)
- period(parent_period_id) → period(period_id)
- period(period_type_id_fk) → period_type(period_type_id)
- attainment_measure(master_attainment_measure_id) → attainment_measure(attainment_measure_id)
- attainment_measure(effective_start_period_id) → period(period_id)
- attainment_measure(effective_end_period_id) → period(period_id)
- co_item_assignment(order_type_id) → order_type(order_type_id)
- co_item_assignment(participant_id) → participant(participant_id)
- co_item_assignment(split_amount_unit_type_id) → unit_type(unit_type_id)
- co_item_assignment(comp_order_item_id) → comp_order_item(comp_order_item_id)
- co_item_assignment(period_id) → period(period_id)
- users(business_group_id) → business_group(business_group_id)
- plan_assignment(plan_id) → plan(plan_id)
- payment_balance_trace(period_id) → period(period_id)
- position(parent_position_id) → position(position_id)
- position(master_position_id) → position(position_id)
- position(participant_id) → participant(participant_id)
- position(business_group_id) → business_group(business_group_id)
- position(title_id) → title(title_id)
- pos_title_assignment_history(position_id) → position(position_id)
- pos_title_assignment_history(title_id) → title(title_id)
- pos_title_assignment_history(id) → pos_title_assignment(pos_title_assignment_id)
- pos_relation(from_pos_id) → position(position_id)
- pos_relation(pos_rel_type_id) → pos_rel_type(pos_rel_type_id)
- pos_relation(to_pos_id) → position(position_id)
- credit_adjustment(credit_id) → credit(credit_id)
- credit_adjustment(amount_unit_type_id) → unit_type(unit_type_id)
- credit_adjustment(period_id) → period(period_id)
- pos_hierarchy_history(from_pos_id) → position(position_id)
- pos_hierarchy_history(pos_hierarchy_type_id) → pos_hierarchy_type(pos_hierarchy_type_id)
- pos_hierarchy_history(to_pos_id) → position(position_id)
- pos_hierarchy_history(id) → pos_hierarchy(pos_hierarchy_id)
- business_group(finalize_start_period_id) → period(period_id)
- business_group(group_unit_type_id) → unit_type(unit_type_id)
- rule(primary_rule_id) → rule(rule_id)
- rule(attainment_measure_id) → attainment_measure(attainment_measure_id)
- rule(pos_relation_id) → pos_relation(id)
- title(category_name) → title_category(category_name)
- order_stage(related_item_id) → comp_order_item(comp_order_item_id)
- order_stage(order_type_id) → order_type(order_type_id)
- order_stage(amount_unit_type_id) → unit_type(unit_type_id)
- order_stage(period_id) → period(period_id)
- position_history(parent_position_id) → position(position_id)
- position_history(master_position_id) → position(position_id)
- position_history(participant_id) → participant(participant_id)
- position_history(business_group_id) → business_group(business_group_id)
- position_history(title_id) → title(title_id)
- user_role(user_id) → users(user_id)
- user_role(role_id) → role(role_id)
- currency_rate(base_currency_unit_type_id) → unit_type(unit_type_id)
- currency_rate(target_currency_unit_type_id) → unit_type(unit_type_id)
- part_user_assignment(user_id) → users(user_id)
- part_user_assignment(participant_id) → participant(participant_id)
- participant_history(user_id) → users(user_id)
- participant_history(payment_cur_unit_type_id) → unit_type(unit_type_id)
- participant_history(participant_id) → participant(participant_id)
- participant_history(native_cur_unit_type_id) → unit_type(unit_type_id)
- participant_history(pr_target_unit_type_id) → unit_type(unit_type_id)
- participant_history(business_group_id) → business_group(business_group_id)
- participant_history(salary_unit_type_id) → unit_type(unit_type_id)
- participant_history(obj_bonus_target_unittype_id) → unit_type(unit_type_id)
- comp_order_item_detail(related_item_id) → comp_order_item(comp_order_item_id)
- comp_order_item_detail(order_type_id) → order_type(order_type_id)
- comp_order_item_detail(amount_unit_type_id) → unit_type(unit_type_id)
- comp_order_item_detail(comp_order_item_id) → comp_order_item(comp_order_item_id)
- comp_order_item_detail(period_id) → period(period_id)
- credit_held(credit_id) → credit(credit_id)
- quota_assignment_history(quota_id) → quota(quota_id)
- quota_assignment_history(effective_start_period_id) → period(period_id)
- quota_assignment_history(effective_end_period_id) → period(period_id)
- quota_assignment_history(amount_unit_type_id) → unit_type(unit_type_id)
- quota_assignment_history(period_id) → period(period_id)
- quota_assignment_history(id) → quota_assignment(quota_assignment_id)
- credit_total(position_id) → position(position_id)
- credit_total(unittype_id) → unit_type(unit_type_id)
- credit_total(participant_id) → participant(participant_id)
- credit_total(period_id) → period(period_id)
- comp_order_item(related_item_id) → comp_order_item(comp_order_item_id)
- comp_order_item(order_type_id) → order_type(order_type_id)
- comp_order_item(amount_unit_type_id) → unit_type(unit_type_id)
- comp_order_item(period_id) → period(period_id)
- pos_hierarchy(from_pos_id) → position(position_id)
- pos_hierarchy(pos_hierarchy_type_id) → pos_hierarchy_type(pos_hierarchy_type_id)
- pos_hierarchy(to_pos_id) → position(position_id)
- attainment_measure_criteria(attainment_measure_id) → attainment_measure(attainment_measure_id)
- pos_part_assignment_history(position_id) → position(position_id)
- pos_part_assignment_history(participant_id) → participant(participant_id)
- pos_part_assignment_history(id) → pos_part_assignment(pos_part_assignment_id)
- draw(unit_type_id) → unit_type(unit_type_id)
- draw(period_id) → period(period_id)
- pos_hierarchy_type_history(id) → pos_hierarchy_type(pos_hierarchy_type_id)
- quota_assignment(quota_id) → quota(quota_id)
- quota_assignment(effective_start_period_id) → period(period_id)
- quota_assignment(effective_end_period_id) → period(period_id)
- quota_assignment(amount_unit_type_id) → unit_type(unit_type_id)
- quota_assignment(period_id) → period(period_id)
- quota_history(quota_period_id) → period(period_id)
- quota_history(quota_value_unit_type_id) → unit_type(unit_type_id)
- quota_history(id) → quota(quota_id)
- pos_rel_type_history(id) → pos_rel_type(pos_rel_type_id)