QM and Evaluations Data Model - Table definitions

contact_type_dim table

The contact_type_dim table contains the different categories or types of contacts handled.

Primary key: ct_id

Column name Description Data type Nullable
ct_id

ID for the contact type.

 INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ct_name

The name / description of the contact type.

 STRING TRUE

group_dim table

The group_dim table stores metadata about organizational groups.

Primary key: group_id

Column name Description Data type Nullable
group_id The Calabrio ONE database ID for the group. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
group_name The display name for a collection of teams. STRING TRUE
activated The date and time when the team was activated in Calabrio ONE. TIMESTAMP TRUE
deactivated The date and time when the team was deactivated in Calabrio ONE. TIMESTAMP TRUE
is_active Whether or not a team is active in Calabrio ONE. 1 = yes, 0 = no. BOOLEAN TRUE

is_synchronized

Whether or not a team is synchronized in Calabrio ONE. 1 = yes, 0 = no.

BOOLEAN

 
default_group Whether or not the person is a default user. 1 = yes, 0 = no. BOOLEAN TRUE
productivity_compilation A compilation of productivity metrics for the group or team. BOOLEAN TRUE
group_created_date Date and time when group was created. TIMESTAMP TRUE
group_updated_date Date and time when group was last updated. TIMESTAMP TRUE

person_dim table

The person_dim table contains information about individuals.

Primary key: person_id

Column name Description Data type Nullable
person_id

ID for the person.

 INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
acd_id

The Calabrio ONE database ID of the agent’s ACD system.

 STRING TRUE
first_name

The first name of the person.

 STRING TRUE
last_name

The last name of the person.

 STRING TRUE
full_name

The full name of the person.

 STRING TRUE
email The person's email address. STRING TRUE
activated The date and time when the team was activated in Calabrio ONE. TIMESTAMP TRUE
deactivated The date and time when the team was deactivated in Calabrio ONE. TIMESTAMP TRUE
is_active Whether or not a team is active in Calabrio ONE. 1 = yes, 0 = no. BOOLEAN TRUE
team_id The Calabrio ONE database ID for the team. INTEGER TRUE
is_synchronized Whether or not a team is synchronized in Calabrio ONE. 1 = yes, 0 = no. BOOLEAN TRUE
timezone_name Person timezone. For example, America / Chicago. STRING TRUE
timezone_display The timezone of the person. STRING TRUE
ad_login The agent’s username for logging in to the ACD. STRING TRUE
locale The two-letter code for the language the person is using in Calabrio ONE. For example, EN = English. STRING TRUE
is_hotdesk_default_user Whether or not the person is a hotdesk default user. 1 = yes, 0 = no. BOOLEAN TRUE
enabled_for_scheduling Whether or not a person can be scheduled in WFM. 1 = yes, 0 = no. BOOLEAN TRUE
employee_id The Calabrio ONE database ID of the employee. STRING TRUE
full_time_equivalent_id The Calabrio ONE database ID for the agent's FTE designation. For example, the ID for “.6 FTE.” This field comes from Classic WFM. BIG_INTEGER TRUE
is_tenant_owner Whether or not the user is an administrator for their organization’s Calabrio ONE account. 1 = yes, 0 = no. BOOLEAN TRUE
is_reconcile_only Whether or not a contact has gone through the reconciliation process to match the audio and screen recordings. 1 = yes, 0 = no. BOOLEAN TRUE
agent_rank A number that indicates agent seniority. STRING TRUE
dpt_start_date The hire date of the agent in the department, which indicates seniority. TIMESTAMP TRUE
scheduling_start_date The first day that an agent was scheduled for in Calabrio ONE. TIMESTAMP TRUE
scheduling_end_date The last day that an agent is scheduled for in Calabrio ONE. TIMESTAMP TRUE
wfm_agent_id The agent’s ID from WFM. This field currently comes from Classic WFM only. We recommend using the Person ID or Is Agent fields instead. BIG_INTEGER TRUE
peripheral_id The Calabrio ONE database ID of the person's extension in the ACD. INTEGER TRUE
acd_login_id The Calabrio ONE database ID of the agent’s username for logging in to the ACD system. STRING TRUE
service_queue_id The Calabrio ONE database ID for the system queue. BIG_INTEGER TRUE
staffing_group_id The Calabrio ONE database ID of the staffing group. BIG_INTEGER TRUE
person_created_date Date and time when person was created. TIMESTAMP TRUE
person_updated_date Date and time when person was last updated. TIMESTAMP TRUE

team_dim table

The team_dim table defines teams based on functional or managerial structures.

Primary key: team_id

Column name Description Data type Nullable
team_id The Calabrio ONE database ID for the team. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
team_name The display name for the collection of agents. STRING TRUE
activated The date and time when the team was activated in Calabrio ONE. TIMESTAMP TRUE
deactivated The date and time when the team was deactivated in Calabrio ONE. TIMESTAMP TRUE
is_active Whether or not a team is active in Calabrio ONE. 1 = yes, 0 = no. BOOLEAN TRUE

group_id

 The Calabrio ONE database ID for the group. BIG_INTEGER

TRUE
is_synchronized Whether or not a team is synchronized in Calabrio ONE. 1 = yes, 0 = no. BOOLEAN TRUE

default_team

Whether or not the person is a default user. 1 = yes, 0 = no. BOOLEAN TRUE

productivity_compilation

A compilation of productivity metrics for the group or team. BOOLEAN TRUE

team_created_date

Date and time when team was created. TIMESTAMP TRUE

team_updated_date

 Date and time when team was last updated. TIMESTAMP TRUE

recording_event_type_dim table

The recording_event_type_dim table lists the different types of events captured in recordings.

Primary key: ret_id

Column name Description Data type Nullable
ret_id The Calabrio ONE database ID for the instance of a single recording event. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ret_name The name for recording event type. such as pause or hold. STRING TRUE
ret_display_name The display name for this recording event type. It is used to display in the Calabrio ONE application. STRING TRUE
retc_id The Calabrio ONE database ID for the recording event type, such as pause or hold. INTEGER TRUE
retc_name The display name for recording events such as pause or hold. STRING TRUE

ret_created_date

 Date and time when recording event was created. TIMESTAMP

TRUE
ret_updated_date Date and time when recording event was last updated. TIMESTAMP TRUE

meta_data_field_dim table

The meta_data_field_dim table describes metadata fields associated with contacts or evaluations.

Primary key: mdf_id

Column name Description Data type Nullable
mdf_id The Calabrio ONE database ID for the metadata field. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
mdf_display_name The name for the metadata field that appears to users in Calabrio ONE. This comes from the Metadata Label field on the Metadata Manager page. STRING TRUE
mdf_key_name The automatically generated key for the metadata field. This comes from the Metadata Key field on the Metadata Manager page. STRING TRUE
dx_key The number 1—20 for the item. STRING TRUE
mdt_id The Calabrio ONE database ID for the metadata. INTEGER TRUE

mdt_name

 What kind of metadata it is: number, text, or hyperlink. This comes from the Metadata Manager page. STRING

TRUE
is_encrypted Whether or not a meta data field is marked encrypted. 1 = yes, 0 = no. BOOLEAN TRUE

is_exportable

 Whether or not a meta data field is marked exportable. 1 = yes, 0 = no. BOOLEAN TRUE

is_readonly

 Whether or not a meta data field is marked readonly. 1 = yes, 0 = no. BOOLEAN TRUE

mdf_created_date

When the metadata was created on Metadata Manager page.

 TIMESTAMP TRUE

mdf_updated_date

The date when the metadata was last updated on the Metadata Manager page.

 TIMESTAMP TRUE

contact_fact table

The contact_fact table records detailed information about individual interactions and performance metrics.

Primary key: contact_id

Column name Description Data type Nullable
contact_id The unique identifier for every interaction. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
contact_uuid A globally unique identifier for each contact event, used for ensuring consistency across systems. STRING TRUE
associated_call_id The ID of other contacts associated with the contact in question. This is used to display associated calls on the Interactions page so that various legs of the same customer contact can be viewed together. STRING TRUE
icm_call_id The Calabrio ONE database ID of an ICM call. STRING TRUE
contact_start_time The date and time this contact began, in GMT (UTC). TIMESTAMP TRUE
contact_start_tz The timezone that the contact occurred in, as determined by the ACD. STRING TRUE
has_screen Whether or not the contact has a screen recording. 1= yes, 0 = no. BOOLEAN TRUE
has_voice Whether or not the contact has an audio recording. 1 = yes, 0 = no. BOOLEAN TRUE
is_calibration Whether or not the contact had a calibration performed on it. 1 = yes, 0 = no. BOOLEAN TRUE
is_pip Whether or not the contact is marked for HR. 1 = yes, 0 = no. BOOLEAN TRUE
is_reconciled Whether or not a contact has gone through the reconciliation process to match the audio and screen recordings. 1 = yes, 0 = no. BOOLEAN TRUE
is_training Whether or not a contact is marked for training. 1 = yes, 0 = no. BOOLEAN TRUE
is_inbound Whether or not a call was inbound to the contact center. 1 = yes, 0 = no. BOOLEAN TRUE
was_answered Whether or not the call was answered. 1 = yes, 0 = no. BOOLEAN TRUE
calling_number The automatic number identification (ANI) for a call. In other words, ANI identifies the number of the calling party. STRING TRUE
number_called The dialed number identification server (DNIS) for the call. In other words, the called number. STRING TRUE
line The extension where the call took place. STRING TRUE
time_to_answer Milliseconds from the startTime until the agent answered the incoming call. FLOAT TRUE
duration The duration of the call from time answered to time dropped, in seconds. FLOAT TRUE
group_id The Calabrio ONE database ID for the group. This ID can be helpful if your organization has multiple groups with the same name. INTEGER TRUE
team_id The Calabrio ONE database ID for the team. INTEGER TRUE
person_id The Calabrio ONE database ID for the person. This field can be helpful if your organization has multiple people with the same name. INTEGER TRUE
eval_state_id The Calabrio ONE database ID for the evaluation state. INTEGER TRUE
contact_type_id The unique reference ID for the type of contact. INTEGER TRUE
recording_type_id The Calabrio ONE database ID for the recording type. INTEGER TRUE
calibration_form_id The unique identifier for the calibration form associated with the contact. INTEGER TRUE
audio_upload_state The status of the audio file upload related to the contact. INTEGER TRUE
screen_upload_state The status of the screen recording upload related to the contact. INTEGER TRUE
survey_send_status The status of the survey sent to the user after the contact. INTEGER TRUE
contact_created_date The date and time when the contact was initially created or logged into the system. TIMESTAMP TRUE
contact_updated_date The date and time when the contact was last updated. TIMESTAMP TRUE
cu_date The date when the contact occurred or was completed. TIMESTAMP TRUE

is_deleted

If true, this row has been removed. If false, this row is new or updated.

BOOLEAN

TRUE

contact_upload_state_fact table

The contact_upload_state_fact table tracks the upload status and processing state of contact records.

Primary key: contact_id

Column name Description Data type Nullable
contact_id The unique identifier for every interaction. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
audio_display_state The display status of the audio file associated with the contact. INTEGER TRUE
screen_display_state The display status of the screen recording associated with the contact. INTEGER TRUE
last_update_time The date and time of the last update made to the contact upload state. TIMESTAMP TRUE

recording_event_fact table

The recording_event_fact table captures detailed event data from contact recordings.

Primary key: event_id

Column name Description Data type Nullable
event_id A unique identifier for each event related to the recording. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
contact_id The unique identifier for every interaction. BIG_INTEGER TRUE
event_type_id The identifier for the type of recording event (e.g., "audio edit," "screen recording error"). INTEGER TRUE
contact_offset The time offset from the start of the contact when the recording event occurred. INTEGER TRUE
duration The length of time the recording event lasted. INTEGER TRUE

text

The text or description associated with the recording event. STRING

TRUE
audio_edit_required A flag indicating whether an audio edit is required for the recording. BOOLEAN TRUE

screen_edit_required

A flag indicating whether a screen recording edit is required.

 BOOLEAN TRUE

is_edit_processed

A flag indicating whether the requested edit (audio or screen) has been processed.

 BOOLEAN TRUE

attempts_to_edit

The number of attempts made to edit the recording.

INTEGER

 TRUE

re_created_date

The date and time when the recording event record was created.

STRING

 TRUE

re_updated_date

The date and time when the recording event record was last updated.

 TIMESTAMP TRUE

common_contact_meta_data table

The common_contact_meta_data table stores standardized metadata fields associated with contacts, enabling consistent analysis across different contact types and sources.

Primary key: contact_id

Column name Description Data type Nullable
contact_id The unique identifier for every interaction. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
nps_response A response score from 0–10 used in calculating the Net Promoter Score. INTEGER TRUE
custom_data_01 to custom_data_20

Custom Data fields are unique to your organization. These fields allow reporting on metadata defined in Calabrio ONE. Up to 20 Custom Data fields can be identified by assigning a key to the metadata field on the Metadata Manager page. See Manage custom metadata fields.

Custom Data Fields are stored as text data, regardless of whether they contain a number, a date, time, or text. To use these in a formula, you may need to convert their field data type.

 STRING TRUE

predictive_metadata_fact table

The predictive_metadata_fact table contains data generated by predictive models applied to contacts.

Primary key: pmd_id

Column name Description Data type Nullable
pmd_id A unique identifier for each predictive metadata record. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
contact_id The unique identifier for every interaction. BIG_INTEGER TRUE
predictive_nps Computed predictive NPS scores - range from -100 to 100. FLOAT TRUE

predictive_sentiment_chan_a

In a call with two audio streams, the predicted sentiment for the person in channel A.

 FLOAT TRUE

predictive_sentiment_chan_b

In a call with two audio streams, the predicted sentiment for the person in channel B.

 FLOAT TRUE

pmd_created_date

Date and time at which a predictive metadata was created.

 TIMESTAMP TRUE

pmd_updated_date

Date and time at which a predictive metadata was updated.

 TIMESTAMP TRUE

recording_event_summary_fact table

The recording_event_summary_fact table aggregates recording event data at a higher level, summarizing key metrics and event counts per contact or session.

Primary key: contact_id

Column name Description Data type Nullable
contact_id The unique identifier for every interaction. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
num_talkovers The number of instances where multiple people talked over each other during the recording. BIG_INTEGER TRUE
talkover_time_s The total duration (in seconds) of talkover time during the recording. FLOAT TRUE
num_silences The number of instances of silence detected during the recording. BIG_INTEGER TRUE

silence_time_s

The total duration (in seconds) of silence during the recording.

 FLOAT TRUE

num_holds

The number of times the contact was put on hold during the recording.

 BIG_INTEGER TRUE

hold_time_s

The total duration (in seconds) of time the contact was on hold.

 FLOAT TRUE

num_pauses

The number of times there was a pause in the conversation during the recording.

 BIG_INTEGER TRUE

pause_time_s

The total duration (in seconds) of pauses during the recording.

FLOAT

TRUE

eval_form_dim table

The eval_form_dim table holds metadata about evaluation forms used in the quality management process.

Primary key: ef_id

Column name Description Data type Nullable
ef_id The Calabrio ONE database ID for an evaluation form. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ef_name The name of the form. This comes from the Form Name field on the Evaluation Form Manager page. STRING TRUE
ef_desc The description for the form. This comes from the Form Description field on the Evaluation Form Manager page. STRING TRUE
is_default_form Whether or not the form is used for predictive analytics. 1 = yes, 0 = no. BOOLEAN TRUE

form_total_points

The total number of points assigned in the evaluation form. INTEGER TRUE

form_applicable_points

The maximum score that can be awarded for the evaluation form.

 INTEGER TRUE

band_max_1

The maximum score that falls within the Needs Improvement scoring band.

 INTEGER TRUE

band_max_2

 The maximum score that falls within the Meets Expectations scoring band. INTEGER TRUE

status

The current status of the form or evaluation, indicating whether it is active, completed, pending, or in another state.

 INTEGER

TRUE

status_desc

 The publication status of the evaluation form.

STRING

 TRUE

efst_id

The unique identifier for the evaluation form section type.

INTEGER

 TRUE

efst_name

The name of the evaluation form section type.

STRING

 TRUE

manual_weighting

The manually assigned weight for the form or section in the evaluation process.

BOOLEAN

 TRUE

ert_id

The unique identifier for the evaluation response type associated with the form.

INTEGER

 TRUE

ert_name

The name of the evaluation response type.

STRING

 TRUE

ef_created_date

The date and time an evaluation form was created.

 TIMESTAMP TRUE

ef_updated_date

The date and time an evaluation form was updated.

 TIMESTAMP TRUE

eval_form_question_dim table

The eval_form_question_dim table contains the questions that appear on evaluation forms.

Primary key: efq_id

Column name Description Data type Nullable
efq_id A unique identifier for each evaluation form question. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ef_id The Calabrio ONE database ID for an evaluation form. INTEGER TRUE
efs_id A unique identifier for each section in the evaluation form. INTEGER TRUE
efq_ordinal The ordinal number of the question within the evaluation form. INTEGER TRUE

efq_text

The text or description of the evaluation question.

 STRING TRUE

efq_weight

The weight assigned to the evaluation question, indicating its relative importance in the overall score.

 FLOAT TRUE

possible_score

The maximum score that can be awarded for the evaluation question.

 INTEGER TRUE

efq_desc

A description of the evaluation question.

 STRING TRUE

efq_created_date

The date and time when the evaluation form question was created.

 TIMESTAMP

TRUE

efq_updated_date

The date and time when the evaluation question was last updated.

 TIMESTAMP

TRUE

eval_form_question_opt_dim table

The eval_form_question_opt_dim table stores the possible answer options for evaluation form questions, supporting structured response analysis.

Primary key: efqo_id

Column name Description Data type Nullable
efqo_id A unique identifier for each evaluation form question option. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
efs_id A unique identifier for each section in the evaluation form. INTEGER TRUE
efq_id The identifier for the evaluation form question associated with this option. INTEGER TRUE
efqo_label The label or text of the question option. STRING TRUE

efqo_ordinal

The order or sequence of the question option within the set of options for a specific question.

 INTEGER TRUE

efqo_default

A flag indicating whether this option is the default choice for the question.

 BOOLEAN TRUE

efqo_kpi_priority

The priority level of the question option in relation to Key Performance Indicators (KPIs).

 INTEGER TRUE

efqo_points

The points assigned to the question option.

 INTEGER TRUE

efqot_id

The identifier for the type of evaluation form question option.

 INTEGER

TRUE

efqot_name

The name of the evaluation form question option type.

STRING

TRUE

efqo_created_date

The date and time when the evaluation form question option was created.

 TIMESTAMP

TRUE

efqo_updated_date

The date and time when the evaluation form question option was last updated.

 TIMESTAMP

TRUE

eval_form_section_dim table

The eval_form_section_dim table describes the sections of evaluation forms.

Primary key: efs_id

Column name Description Data type Nullable
efs_id A unique identifier for each section in the evaluation form. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ef_id The Calabrio ONE database ID for an evaluation form. STRING TRUE
efs_name The name of the evaluation form section. INTEGER TRUE

efs_ordinal

The order or sequence of the section within the evaluation form.

 FLOAT TRUE

efs_weight

The weight or importance assigned to the section within the overall evaluation.

 TIMESTAMP TRUE

efs_created_date

The date and time when the evaluation form section was created.

 TIMESTAMP TRUE

efs_updated_date

The date and time when the evaluation form section was last updated.

 INTEGER TRUE

eval_response_state_dim table

The eval_response_state_dim table defines the possible states of an evaluation response.

Primary key: ers_id

Column name Description Data type Nullable

ers_id

 The Calabrio ONE database ID for the evaluation response state. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
ers_name The state of the agent’s response to the evaluation. STRING TRUE
ers_created_date The date when the agent responded to an evaluation response state of a contact they handled. TIMESTAMP TRUE
ers_updated_date The date when the agent updated an evaluation response state of a contact they handled. TIMESTAMP TRUE

eval_state_dim table

The eval_state_dim table categorizes the overall state of an evaluation.

Primary key: es_id

Column name Description Data type Nullable

es_id

 The Calabrio ONE database ID for the evaluation state. INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
es_name The current evaluation state of a customer contact record. STRING TRUE
es_created_date The date an evaluation was created, in UTC format. TIMESTAMP TRUE
es_updated_date The date an evaluation was last updated, in UTC format. TIMESTAMP TRUE

eval_fact table

The eval_fact table records individual evaluation instances, capturing the application of evaluation forms to specific contacts or interactions.

Primary key: evaluation_id

Column name Description Data type Nullable
evaluation_id The Calabrio ONE database ID for a completed evaluation. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
contact_id The unique identifier for every interaction. BIG_INTEGER TRUE
evaluation_form_id A unique identifier for the evaluation form used to assess a contact or interaction. INTEGER TRUE
eval_state_id The Calabrio ONE database ID for the evaluation state. INTEGER TRUE

eval_response_state_id

The identifier for the state or status of the evaluation response (e.g., pending, approved, rejected).

 INTEGER TRUE

evaluator_id

The unique identifier for the evaluator who conducted the evaluation.

 INTEGER TRUE

approver_id

The unique identifier for the approver who validated or reviewed the evaluation.

 INTEGER TRUE

evaluated_date

The date when the evaluation was completed.

 TIMESTAMP TRUE

evaluated_tz

The timezone in which the evaluation was completed.

 TIMESTAMP

TRUE

total_score

The total score awarded in the evaluation, usually based on multiple criteria or sections.

FLOAT

 TRUE

is_counted_score

A flag indicating whether the score is included in the final evaluation.

BOOLEAN

 TRUE

additive_score

The additional score added to the total score, often from extra sections or criteria that contribute incrementally to the final evaluation result.

INTEGER

 TRUE

last_state_change_score

The score assigned during the last change in the evaluation state.

FLOAT

 TRUE

eval_created_date

The date when the evaluation record was created.

TIMESTAMP

TRUE

eval_updated_date

The date when the evaluation record was last updated.

TIMESTAMP

TRUE

eval_response_date

The date when the evaluator's response was submitted.

 TIMESTAMP TRUE

eval_comment_fact table

The eval_comment_fact table stores comments and notes added during evaluations, providing qualitative insights and feedback.

Primary key: eval_comment_id

Column name Description Data type Nullable
eval_comment_id A unique identifier for each comment within the evaluation. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
evaluation_id The Calabrio ONE database ID for a completed evaluation. BIG_INTEGER TRUE
eval_form_id The Calabrio ONE database ID for an evaluation form. INTEGER TRUE
eval_section_id The Calabrio ONE database ID for the section within an evaluation form. This ID can be helpful if your organization has multiple sections with the same name. INTEGER TRUE

eval_question_id

The Calabrio ONE database ID for a question on an evaluation form. This ID can be helpful if your organization has multiple questions with the same wording.

 INTEGER TRUE

person_id

ID for the person.

 INTEGER TRUE

comment_text

The content of the comment made during the evaluation.

 STRING TRUE

parent_comment_id

The identifier of the parent comment if the current comment is a response or reply.

 INTEGER TRUE

comment_group_id

The identifier for the group of related comments.

 INTEGER

TRUE

contact_offset

The time offset from the start of the contact when the comment was created.

INTEGER

 TRUE

comment_created_date

The date and time when the comment was initially created.

TIMESTAMP

 TRUE

comment_created_tz

The timezone in which the comment was created.

STRING

 TRUE

comment_updated_date

The date and time when the comment was last updated.

TIMESTAMP

 TRUE

eval_comment_latest_fact table

The eval_comment_latest_fact table contains the most recent comments for each evaluation, enabling quick access to current feedback.

Primary key: comment_group_id

Column name Description Data type Nullable
comment_group_id The Calabrio ONE database ID of the comment on an evalaution form. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
evaluation_id The Calabrio ONE database ID for a completed evaluation. BIG_INTEGER TRUE
eval_form_id The Calabrio ONE database ID for an evaluation form. INTEGER TRUE
eval_section_id The Calabrio ONE database ID for the section within an evaluation form. This ID can be helpful if your organization has multiple sections with the same name. INTEGER TRUE

eval_question_id

The Calabrio ONE database ID for a question on an evaluation form. This ID can be helpful if your organization has multiple questions with the same wording.

 INTEGER TRUE

person_id

The Calabrio ONE database ID for the person. This field can be helpful if your organization has multiple people with the same name.

 INTEGER TRUE

comment_text

The content of the comment added during the evaluation. This field stores the feedback or notes provided by the evaluator.

 STRING TRUE

parent_comment_id

The identifier for the parent comment, if the current comment is a reply to an earlier comment.

INTEGER TRUE

comment_group_id

The identifier for the group of comments.

 INTEGER

TRUE

contact_offset

The time offset, from the start of the contact when the comment was made.

INTEGER

 TRUE

comment_created_date

The date and time when the comment was initially created.

TIMESTAMP

 TRUE

comment_created_tz

The timezone in which the comment was created.

STRING

 TRUE

comment_updated_date

The date and time when the comment was last updated.

TIMESTAMP

 TRUE

comment_modified_date

The date and time when the comment was last modified.

TIMESTAMP

TRUE

eval_answers_fact table

The eval_answers_fact table captures answers submitted for evaluation questions.

Primary key: answer_id

Column name Description Data type Nullable
answer_id A unique identifier for the answer provided during the evaluation. BIG_INTEGER FALSE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
evaluation_id The Calabrio ONE database ID for a completed evaluation. BIG_INTEGER TRUE
section_id The Calabrio ONE database ID for the section within an evaluation form. This ID can be helpful if your organization has multiple sections with the same name. INTEGER TRUE
eval_question_id

The Calabrio ONE database ID for a question on an evaluation form. This ID can be helpful if your organization has multiple questions with the same wording.

 INTEGER TRUE

selected_option_id

The identifier for the option selected by the evaluator for a specific question.

 INTEGER TRUE

points

The points awarded for the selected answer. This field reflects the score assigned to the answer, contributing to the overall evaluation score.

 INTEGER TRUE

answer_created_date

The date when an evaluation question was answered.

TIMESTAMP

 TRUE

answer_updated_date

 The date when an evaluation question was last updated.

TIMESTAMP

 TRUE

eval_section_scores_fact table

The eval_section_scores_fact table contains calculated scores for each section of evaluation forms.

Primary key: evaluation_id, section_id

Column name Description Data type Nullable
evaluation_id The Calabrio ONE database ID for a completed evaluation. BIG_INTEGER FALSE
section_id The Calabrio ONE database ID for the section within an evaluation form. This ID can be helpful if your organization has multiple sections with the same name. INTEGER TRUE

bi_id

A unique identifier for each row. It can also serve as the primary key when no explicit primary key is defined.

STRING

FALSE

bi_ingest_timestamp

The date and time when the data was ingested or last updated.

TIMESTAMP

FALSE
contact_id The unique identifier for the contact event (e.g., call or chat) being evaluated. BIG_INTEGER TRUE
evaluation_form_id The unique identifier for the evaluation form used to assess the interaction. INTEGER TRUE

evaluation_state_id

The identifier for the state or status of the evaluation.

 INTEGER TRUE

section_score

The score assigned to a specific section of the evaluation form.

 FLOAT TRUE

is_score_counted

A flag indicating whether the section score is included in the final evaluation score.

 BOOLEAN TRUE

is_deleted

A flag indicating whether the record has been marked as deleted.

 BOOLEAN TRUE