CaptivateIQ

Explore the interactive ERD

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	PKFK

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	PKFK
`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	PKFK
`date`	LocalDate	FK
`id`	Unknown

report_model_worksheet

Column	Type	Keys
`index`	Unknown	PK
`report_model_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK

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	PKFK

commission_plan_period_group

Column	Type	Keys
`commission_plan_id`	Unknown	PKFK
`period_group_id`	Unknown	PKFK

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