Qmatic Data Connect
Explore the interactive ERD
Table & Field Reference
visit_customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
visit_key | Unknown | FK |
customer_id | Unknown |
feedback_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
answer_key | Unknown | FK |
branch_key | Unknown | FK |
question_key | Unknown | FK |
question_type_key | Unknown | FK |
visit_key | Unknown | FK |
date_key | Unknown | |
event_timestamp | Unknown | |
text_answer | Unknown | |
time_key | Unknown | |
time_seconds | Unknown |
visit_call_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
device_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
date_key | Unknown | FK |
device_key | Unknown | FK |
unit_key | Unknown | FK |
asf_device_status_key | Unknown | |
device_connect_duration | Unknown | |
device_disconnect_duration | Unknown | |
device_num_disconnects | Unknown | |
no_data | Unknown |
mark_transaction_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
appointment_start_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
feedback_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
call_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
entry_point
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
origin_id | Unknown |
end_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_status_key | Unknown | FK |
arrival_status_key | Unknown | FK |
branch_key | Unknown | FK |
origin_id | Unknown | FK |
resource_key | Unknown | FK |
service_key | Unknown | FK |
cancelled_date_key | Unknown | |
client_key | Unknown | |
count_service | Unknown | |
created_date_key | Unknown | |
created_time_key | Unknown | |
date_key | Unknown | |
days_cancelled_before | Unknown | |
days_to_appointment | Unknown | |
duration | Unknown | |
end_time_key | Unknown | |
lateness | Unknown | |
start_time_key | Unknown | |
tardiness | Unknown | |
transaction_time | Unknown | |
updated_count | Unknown | |
waiting_time | Unknown | |
walking_time | Unknown | |
wrapup_time | Unknown |
agent_device_controller_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
device_controller_key | Unknown | FK |
device_controller_status_key | Unknown | FK |
last_device_controller_event_type_key | Unknown | FK |
last_event_time | Unknown | |
last_status_time | Unknown | |
origin_id | Unknown |
service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
origin_id | Unknown |
visit_transaction_outcome
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
device_controller_event_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
daemon_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown |
staff_session_end_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
device_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown |
feedback_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
numeric_answer | Unknown | |
text_answer | Unknown |
delivered_service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | FK |
outcome_key | Unknown | FK |
queue_key | Unknown | FK |
queue_type_key | Unknown | FK |
service_key | Unknown | FK |
service_point_key | Unknown | FK |
staff_key | Unknown | FK |
visit_key | Unknown | FK |
date_key | Unknown | |
delivered_service_key | Unknown | |
time_key | Unknown | |
time_seconds | Unknown | |
transaction_time | Unknown | |
waiting_time | Unknown |
service_delivereds
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
origin_id | Unknown | |
service_delivered | Unknown |
device_event_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
mark_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | FK |
mark_key | Unknown | FK |
mark_type_key | Unknown | FK |
queue_key | Unknown | FK |
queue_type_key | Unknown | FK |
service_key | Unknown | FK |
service_point_key | Unknown | FK |
staff_key | Unknown | FK |
visit_key | Unknown | FK |
date_key | Unknown | |
time_key | Unknown | |
time_seconds | Unknown | |
transaction_time | Unknown | |
waiting_time | Unknown |
jiql_event_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
appointment_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown |
mark_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
origin_id | Unknown |
daemon_event_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
fact_agent_jiql_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
date_key | Unknown | FK |
jiql_event_type_key | Unknown | FK |
time_key | Unknown | FK |
asf_agent_status_key | Unknown | |
event_timestamp | Unknown | |
time_seconds | Unknown |
service_point
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
origin_id | Unknown |
staff_session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | FK |
session_outcome_key | Unknown | FK |
staff_key | Unknown | FK |
date_key | Unknown | |
end_time_key | Unknown | |
end_timestamp | Unknown | |
idle_time | Unknown | |
served_count | Unknown | |
serving_time | Unknown | |
start_timestamp | Unknown | |
store_next_time | Unknown | |
time_key | Unknown | |
time_seconds | Unknown | |
total_time | Unknown | |
visits_served | Unknown | |
wrapup_time | Unknown |
agent_device_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
device_key | Unknown | FK |
device_status_key | Unknown | FK |
last_device_event_type_key | Unknown | FK |
unit_key | Unknown | FK |
device_event_time | Unknown | |
device_status_time | Unknown | |
origin_id | Unknown |
dim_unit_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
appointment_service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | FK |
service_key | Unknown | FK |
served | Unknown |
daemon_version
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
version | Unknown |
staff_session_start_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
dim_device_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
appointment_customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | FK |
customer_id | Unknown | FK |
booked | Unknown | |
served | Unknown |
appointment_end_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
delivered_service_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
resource
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_origin_id | Unknown | |
name | Unknown | |
origin_id | Unknown |
branch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
city | Unknown | |
country | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
name | Unknown | |
origin_id | Unknown | |
time_zone | Unknown |
question_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
appointment_created_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
staff_session_outcome
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
jiql_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown |
time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
queue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
origin_id | Unknown |
mark
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
mark_type_key | Unknown | FK |
name | Unknown | |
origin_id | Unknown |
queue_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
device_controller_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
date_key | Unknown | FK |
device_controller_key | Unknown | FK |
asf_dc_status_key | Unknown | |
connect_duration | Unknown | |
disconnect_duration | Unknown | |
no_data | Unknown | |
num_disconnects | Unknown |
entered_queue_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
am_pm | Unknown | |
hour | Unknown | |
hour_24 | Unknown | |
interval_10_min | Unknown | |
interval_10_min_24 | Unknown | |
interval_15_min | Unknown | |
interval_15_min_24 | Unknown | |
interval_30_min | Unknown | |
interval_30_min_24 | Unknown | |
interval_5_min | Unknown | |
interval_5_min_24 | Unknown | |
minute | Unknown | |
time | Unknown |
staff
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
first_name | Unknown | |
full_name | Unknown | |
last_name | Unknown | |
origin_id | Unknown | |
user_name | Unknown |
appointment_arrival_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
arrival_status | Unknown |
device_controller_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown |
jiql_version
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
version | Unknown |
feedback_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question | Unknown | |
start_date | Unknown |
appointment_cancelled_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
day_of_month | Unknown | |
day_of_week | Unknown | |
day_of_week_name | Unknown | |
day_of_week_name_en | Unknown | |
full_date | Unknown | |
month | Unknown | |
month_name | Unknown | |
month_name_en | Unknown | |
quarter | Unknown | |
week_number | Unknown | |
week_number_iso | Unknown | |
year | Unknown |
agent_daemon_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
daemon_event_type_key | Unknown | FK |
date_key | Unknown | FK |
time_key | Unknown | FK |
asf_agent_status_key | Unknown | |
event_timestamp | Unknown | |
time_seconds | Unknown |
mark_transaction_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
day_of_month | Unknown | |
day_of_week | Unknown | |
day_of_week_name | Unknown | |
day_of_week_name_en | Unknown | |
full_date | Unknown | |
month | Unknown | |
month_name | Unknown | |
month_name_en | Unknown | |
quarter | Unknown | |
week_number_iso | Unknown | |
year | Unknown |
device_controller_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
date_key | Unknown | FK |
dc_event_type_key | Unknown | FK |
device_controller_key | Unknown | FK |
time_key | Unknown | FK |
asf_dc_status_key | Unknown | |
event_timestamp | Unknown | |
time_seconds | Unknown |
unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | |
device_controller_key | Unknown | |
end_date | Unknown | |
logic_id | Unknown | |
name | Unknown | |
origin_id | Unknown | |
start_date | Unknown | |
unit_id | Unknown | |
unit_template | Unknown | |
unit_type_key | Unknown |
device
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
unit_key | Unknown | FK |
device_type_key | Unknown | |
end_date | Unknown | |
firmware_version | Unknown | |
ip | Unknown | |
logic_id | Unknown | |
name | Unknown | |
origin_id | Unknown | |
start_date | Unknown |
date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
day_of_month | Unknown | |
day_of_week | Unknown | |
day_of_week_name | Unknown | |
day_of_week_name_en | Unknown | |
full_date | Unknown | |
month | Unknown | |
month_name | Unknown | |
month_name_en | Unknown | |
quarter | Unknown | |
week_number_iso | Unknown | |
year | Unknown |
work_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_origin_id | Unknown | |
client_key | Unknown | |
end_date | Unknown | |
name | Unknown | |
origin_id | Unknown | |
start_date | Unknown |
appointment_created_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
day_of_month | Unknown | |
day_of_week | Unknown | |
day_of_week_name | Unknown | |
day_of_week_name_en | Unknown | |
full_date | Unknown | |
month | Unknown | |
month_name | Unknown | |
month_name_en | Unknown | |
quarter | Unknown | |
week_number | Unknown | |
week_number_iso | Unknown | |
year | Unknown |
device_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_key | Unknown | FK |
branch_key | Unknown | FK |
date_key | Unknown | FK |
device_event_type_key | Unknown | FK |
device_key | Unknown | FK |
time_key | Unknown | FK |
unit_key | Unknown | FK |
asf_device_status_key | Unknown | |
event_timestamp | Unknown | |
time_seconds | Unknown |
visit_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | FK |
entry_point_key | Unknown | FK |
outcome_key | Unknown | FK |
queue_key | Unknown | FK |
queue_type_key | Unknown | FK |
service_key | Unknown | FK |
service_point_key | Unknown | FK |
staff_key | Unknown | FK |
visit_call_type_key | Unknown | FK |
visit_key | Unknown | FK |
visit_outcome_key | Unknown | FK |
work_profile_key | Unknown | FK |
call_time_key | Unknown | |
call_time_of_day | Unknown | |
call_timestamp | Unknown | |
date_key | Unknown | |
end_time_key | Unknown | |
end_time_of_day | Unknown | |
enter_queue_time_of_day | Unknown | |
entered_queue_time_key | Unknown | |
entered_queue_timestamp | Unknown | |
is_appointment | Unknown | |
recycle_count | Unknown | |
service_transaction_time_level | Unknown | |
staff_transaction_time | Unknown | |
time_seconds | Unknown | |
transaction_time | Unknown | |
transaction_time_vs_service_level | Unknown | |
vertical_message_key | Unknown | |
waiting_time | Unknown | |
waiting_time_service_level | Unknown | |
waiting_time_vs_service_level | Unknown | |
walking_time | Unknown | |
wrapup_time | Unknown |
agent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
daemon_version_key | Unknown | FK |
jiql_version_key | Unknown | FK |
end_date | Unknown | |
host | Unknown | |
name | Unknown | |
original_id | Unknown | |
start_date | Unknown |
outcome
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_origin_id | Unknown | |
client_key | Unknown | |
end_date | Unknown | |
name | Unknown | |
origin_id | Unknown | |
start_date | Unknown |
feedback_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
day_of_month | Unknown | |
day_of_week | Unknown | |
day_of_week_name | Unknown | |
day_of_week_name_en | Unknown | |
full_date | Unknown | |
month | Unknown | |
month_name | Unknown | |
month_name_en | Unknown | |
quarter | Unknown | |
week_number_iso | Unknown | |
year | Unknown |
device_controller
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branch_key | Unknown | FK |
end_date | Unknown | |
name | Unknown | |
origin_id | Unknown | |
start_date | Unknown | |
unit_id | Unknown | |
unit_template | Unknown |
visit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | FK |
created_timestamp | Unknown | |
custom_1 | Unknown | |
custom_2 | Unknown | |
custom_3 | Unknown | |
custom_4 | Unknown | |
custom_5 | Unknown | |
ticket_id | Unknown | |
vip_level | Unknown | |
visit_type | Unknown |