# CaptivateIQ schema ERD

Table and field reference for the Fivetran CaptivateIQ connector.

## Table & Field Reference

### upload

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| date_format | Unknown |  |
| delimiter | Unknown |  |
| details | Json |  |
| encoding | Unknown |  |
| file_name | Unknown |  |
| object_type | Unknown |  |
| params | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |

### period_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook | Unknown | FK |
| created_at | Instant |  |
| is_active | Unknown |  |
| name | Unknown |  |
| plan | Unknown |  |
| updated_at | Instant |  |

### employee_visibility

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| end_date | LocalDate |  |
| source | Json |  |
| start_date | LocalDate |  |
| updated_at | Instant |  |
| visible_employee_id | Unknown |  |

### data_worksheet_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_worksheet_id | Unknown | FK |
| created_at | Instant |  |
| data | Json |  |
| updated_at | Instant |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| linked_user_id | Unknown | FK |
| created_at | Instant |  |
| email | Unknown |  |
| final_process_date | LocalDate |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| last_name | Unknown |  |
| updated_at | Instant |  |

### payout_commission_plan_payout_date

| Column | Type | Keys |
| --- | --- | --- |
| payout_date | Unknown | PK |
| payout_commission_plan_id | Unknown | PK, FK |

### payout_commission_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| confetti_enabled | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| period_group | Json |  |

### report_model_export_worksheet

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_model_export_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |

### report_model_export

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| period_date | LocalDate | FK |
| report_model_id | Unknown | FK |
| is_locked | Unknown |  |

### report_model_period_date

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_model_id | Unknown | PK, FK |
| date | LocalDate | FK |
| id | Unknown |  |

### report_model_worksheet

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_model_id | Unknown | PK, FK |
| id | Unknown |  |
| is_hidden | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### report_model

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### published_dashboard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| display | Unknown |  |
| enable_embedding | Unknown |  |
| favorite | Unknown |  |
| locked_to | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### attribute_worksheet_column_custom_picklist_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_worksheet_id | Unknown | FK |
| attribute_worksheet_column_id | Unknown |  |
| label | Unknown |  |
| sort_order | Unknown |  |

### employee_assumption

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| hierarchy_group_override_id | Unknown | FK |
| period_group_id | Unknown | FK |
| data | Json |  |
| display_value | Unknown |  |
| eid | Unknown |  |
| end_date | LocalDate |  |
| payout_currency | Unknown |  |
| start_date | LocalDate |  |
| statement_template_id | Unknown |  |
| updated_at | Instant |  |

### data_workbook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| is_active | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### data_worksheet_column

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| data_worksheet_id | Unknown | PK, FK |
| created_at | Instant |  |
| data_type | Unknown |  |
| description | Unknown |  |
| format | Unknown |  |
| formula | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| read_only | Unknown |  |
| updated_at | Instant |  |
| variant | Unknown |  |

### data_worksheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook_id | Unknown | FK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| logged_in_user_id | Unknown | FK |
| organization_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| data | Unknown |  |
| event_type | Unknown |  |
| ip_address | Unknown |  |
| object_id | Unknown |  |
| object_name | Unknown |  |
| object_type | Unknown |  |
| parent_object | Json |  |
| version | Unknown |  |

### attribute_worksheet_column

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attribute_worksheet_id | Unknown | PK, FK |
| custom_picklist_options_id | Unknown | FK |
| data_type | Unknown |  |
| description | Unknown |  |
| format | Json |  |
| formula | Unknown |  |
| id | Unknown |  |
| is_primary_key | Unknown |  |
| mapped | Unknown |  |
| name | Unknown |  |
| option_group_id | Unknown |  |
| parent_column | Unknown |  |
| read_only | Unknown |  |
| source_column | Unknown |  |
| source_field_label | Unknown |  |
| source_field_name | Unknown |  |
| sources | Unknown |  |
| user_defined | Unknown |  |
| variant | Unknown |  |

### attribute_worksheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook_id | Unknown | FK |
| columns_width | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| is_hidden | Unknown |  |
| name | Unknown |  |
| pk_type | Unknown |  |
| records_per_page | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| linked_employee | Unknown | FK |
| created_at | Instant |  |
| eligible_to_receive_inquiries | Unknown |  |
| eligible_to_submit_inquiries | Unknown |  |
| email | Unknown |  |
| enable_audit_log_export_notifications | Unknown |  |
| enable_connector_sync_email_notifications | Unknown |  |
| enable_inquiry_notifications | Unknown |  |
| enable_payout_processing_notifications | Unknown |  |
| enable_scim_email_notifications | Unknown |  |
| enable_statement_notifications | Unknown |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| is_organization_admin | Unknown |  |
| last_activity | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| login_id | Unknown |  |
| role | Unknown |  |
| timezone | Unknown |  |
| updated_at | Instant |  |

### transformation_worksheet_column

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transformation_worksheet_id | Unknown | PK, FK |
| created_at | Instant |  |
| data_type | Unknown |  |
| description | Unknown |  |
| format | Unknown |  |
| formula | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| read_only | Unknown |  |
| updated_at | Instant |  |
| variant | Unknown |  |

### transformation_worksheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbook | Unknown | FK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### hierarchy_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| is_default | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### payout_period_group_payout_date

| Column | Type | Keys |
| --- | --- | --- |
| payout_date | Unknown | PK |
| payout_period_group_id | Unknown | PK, FK |

### payout_period_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| plan | Unknown |  |

### commission_plan_payout_date

| Column | Type | Keys |
| --- | --- | --- |
| payout_date_id | Unknown | PK |
| commission_plan_id | Unknown | PK, FK |

### commission_plan_period_group

| Column | Type | Keys |
| --- | --- | --- |
| commission_plan_id | Unknown | PK, FK |
| period_group_id | Unknown | PK, FK |

### commission_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attainment_display_setting | Unknown |  |
| confetti_enabled | Unknown |  |
| created_at | Instant |  |
| is_active | Unknown |  |
| name | Unknown |  |
| preview_config | Json |  |
| updated_at | Instant |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| name | Unknown |  |
| updated_at | Instant |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| description | Unknown |  |
| detail | Json |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |

## Relationships

- period_group(workbook) → data_workbook(id)
- employee_visibility(user_id) → users(id)
- data_worksheet_record(data_worksheet_id) → data_worksheet(id)
- employee(linked_user_id) → users(id)
- employee(employee_id) → employee(id)
- payout_commission_plan_payout_date(payout_commission_plan_id) → payout_commission_plan(id)
- report_model_export_worksheet(report_model_export_id) → report_model_export(id)
- report_model_export(report_model_id) → report_model(id)
- report_model_export(period_date) → report_model_period_date(date)
- report_model_period_date(date) → report_model_export(period_date)
- report_model_period_date(report_model_id) → report_model(id)
- report_model_worksheet(report_model_id) → report_model(id)
- attribute_worksheet_column_custom_picklist_option(attribute_worksheet_id) → attribute_worksheet_column(attribute_worksheet_id)
- employee_assumption(hierarchy_group_override_id) → hierarchy_group(id)
- employee_assumption(employee_id) → employee(id)
- employee_assumption(period_group_id) → period_group(id)
- data_worksheet_column(data_worksheet_id) → data_worksheet(id)
- data_worksheet(workbook_id) → data_workbook(id)
- audit_log(user_id) → users(id)
- audit_log(organization_id) → organization(id)
- audit_log(logged_in_user_id) → users(id)
- attribute_worksheet_column(custom_picklist_options_id) → attribute_worksheet_column_custom_picklist_option(id)
- attribute_worksheet_column(attribute_worksheet_id) → attribute_worksheet(id)
- attribute_worksheet(workbook_id) → data_workbook(id)
- users(linked_employee) → employee(id)
- transformation_worksheet_column(transformation_worksheet_id) → transformation_worksheet(id)
- transformation_worksheet(workbook) → data_workbook(id)
- payout_period_group_payout_date(payout_period_group_id) → payout_period_group(id)
- commission_plan_payout_date(commission_plan_id) → commission_plan(id)
- commission_plan_period_group(period_group_id) → period_group(id)
- commission_plan_period_group(commission_plan_id) → commission_plan(id)
- job(user_id) → users(id)