WFM Data Model - Table definitions
absence_dim table
The absence_dim table contains all attributes of absences used in the system.
Primary key: absence_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| absence_id |
ID for the absence. |
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 |
| absence_code |
The unique identifier representing the ID in Calabrio WFM application. |
STRING | TRUE |
| absence_name |
The name or description of the absence. |
STRING | TRUE |
| absence_shortname |
The short name of the absence. |
STRING | TRUE |
| display_color |
The display color of the absence in Calabrio WFM application. |
BIG_INTEGER | TRUE |
| in_contract_time |
A bit value set to True if the absence is to be counted as contract time. |
BOOLEAN | TRUE |
| in_contract_time_name |
A description set to "In Contract Time" if bit value in_contract_time is set to True. |
STRING | TRUE |
| in_paid_time |
A bit value set to True if the absence is to be counted as paid time. |
BOOLEAN | TRUE |
| in_paid_time_name |
A description set to "In Paid Time" if bit value in_paid_time is set to True. |
STRING | TRUE |
| in_work_time |
A bit value set to True if the absence is to be counted as work time. |
BOOLEAN | TRUE |
| in_work_time_name |
A description set to "In Work Time" if bit value in_work_time is set to True. |
STRING | TRUE |
| display_color_html |
An HTML representation of the absence color. |
INTEGER | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
| is_deleted |
Marks that this absence type is deleted in the system but still available for reporting. |
BOOLEAN | TRUE |
| absence_id |
ID for the absence. |
INTEGER | FALSE |
| absence_code |
The unique identifier representing the ID in Calabrio WFM application. |
STRING | TRUE |
| absence_name |
The name or description of the absence. |
STRING | TRUE |
| absence_shortname |
The short name of the absence. |
STRING | TRUE |
| display_color |
The display color of the absence in Calabrio WFM application. |
BIG_INTEGER | TRUE |
| in_contract_time |
A bit value set to True if the absence is to be counted as contract time. |
BOOLEAN | TRUE |
| in_contract_time_name |
A description set to "In Contract Time" if bit value in_contract_time is set to True. |
STRING | TRUE |
| in_paid_time |
A bit value set to True if the absence is to be counted as paid time. |
BOOLEAN | TRUE |
| in_paid_time_name |
A description set to "In Paid Time" if bit value in_paid_time is set to True. |
STRING | TRUE |
| in_work_time |
A bit value set to True if the absence is to be counted as work time. |
BOOLEAN | TRUE |
| in_work_time_name |
A description set to "In Work Time" if bit value in_work_time is set to True. |
STRING | TRUE |
| display_color_html |
An HTML representation of the absence color. |
INTEGER | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
| is_deleted |
Marks that this absence type is deleted in the system but still available for reporting. |
BOOLEAN | TRUE |
| absence_id |
ID for the absence. |
INTEGER | FALSE |
| absence_code |
The unique identifier representing the ID in Calabrio WFM application. |
STRING | TRUE |
| absence_name |
The name or description of the absence. |
STRING | TRUE |
| absence_shortname |
The short name of the absence. |
STRING | TRUE |
| display_color |
The display color of the absence in Calabrio WFM application. |
BIG_INTEGER | TRUE |
| in_contract_time |
A bit value set to True if the absence is to be counted as contract time. |
BOOLEAN | TRUE |
activity_dim table
The activity_dim table contains all attributes of activities used in the system.
Primary key: activity_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| activity_id |
ID for the activity. |
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 |
|
activity_code |
The unique identifier representing the activity id in Calabrio WFM application. |
STRING |
TRUE |
|
activity_name |
The name or description of the activity. |
STRING |
TRUE |
| display_color |
Color code that represents actvity in the schedule in Calabrio WFM application. |
BIG_INTEGER | TRUE |
| in_ready_time |
A bit value set to True if the activity is to be counted as ready time. |
BOOLEAN | TRUE |
| in_ready_time_name |
A description set to "In Ready Time" if bit value in_ready_time is set to True. |
STRING | TRUE |
| in_contract_time |
A bit value set to True if the activity is to be counted as contract time. |
BOOLEAN | TRUE |
| in_contract_time_name |
A description set to "In Contract Time" if bit value in_contract_time is set to True. |
STRING | TRUE |
| in_paid_time |
A bit value set to True if the activity is to be counted as paid time. |
BOOLEAN | TRUE |
| in_paid_time_name |
A description set to "In Paid Time" if bit value in_paid_time is set to True. |
STRING | TRUE |
| in_work_time |
A bit value set to True if the activity is to be counted as work time. |
BOOLEAN | TRUE |
| in_work_time_name |
A description set to "In Work Time" if bit value in_work_time is set to True. |
STRING | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| display_color_html |
An HTML representation of the activity color. |
STRING | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
| is_deleted |
Marks that this activity is deleted in the system but still available for reporting. |
BOOLEAN | TRUE |
business_unit_dim table
The business_unit_dim table contains all attributes of the business units in the system.
Primary key: business_unit_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| business_unit_id |
ID for the business unit. |
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 |
| business_unit_code |
The unique identifier representing the ID in Calabrio WFM application. |
STRING | TRUE |
| business_unit_name |
The name of the business unit. |
STRING | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
day_off_dim table
The day_off_dim table contains all types of days off used in the system.
Primary key: day_off_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| day_off_id |
ID for the day off. |
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 |
| day_off_code | Day off id from Calabrio WFM application, not defined yet. | STRING | TRUE |
| day_off_name |
The name/description of the day off type. |
STRING | TRUE |
| display_color |
The display color in Calabrio WFM application for the day off. |
BIG_INTEGER | TRUE |
| business_unit_id |
ID representing the business unit. |
BIG_INTEGER | TRUE |
| display_color_html |
An HTML representation of the day off color. |
STRING | TRUE |
|
day_off_shortname |
The short name of the day off. |
STRING |
TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
external_logon_dim
The external_logon_dim table contains all attributes of the agent logins used in the platform.
Primary key: acd_login_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| acd_login_id | ID representing the agent's ACD/CTI platform login ID. | 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_login_agg_id | Agent_id in table agent_info in database. | INTEGER | TRUE |
| acd_login_original_id | ID of the ACD login in the CTI platform. | STRING | TRUE |
| acd_login_name | Agent_name in table agent_info in database. | STRING | TRUE |
| log_object_name | Name of the log object where the ACD login originates from. | STRING | TRUE |
| is_active | Is_active in table agent_info in database. | BOOLEAN | TRUE |
| time_zone | ID representing the log_objects time zone. | STRING | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
| update_date | Date and time when post was last updated in the table. | TIMESTAMP | TRUE |
group_page_dim table
The group_page_dim table contains all group pages (default or user defined) and their corresponding groups (default or user defined).
Primary key: group_page_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| group_page_id | ID of group page. | 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_page_code | Group page ID for custom group pages in the Calabrio WFM application. For fixed groups, the ID is related to the fixed group ID. | STRING | TRUE |
| group_page_name | Group page name or description. | STRING | TRUE |
| group_code | Person group base ID from Calabrio WFM application. | STRING | TRUE |
| group_name | Name of group page. | STRING | TRUE |
| group_is_custom | Bit value. 1 if this is a custom group. | BOOLEAN | TRUE |
| business_unit_id | ID representing the business unit. | BIG_INTEGER | TRUE |
| business_unit_code | The unique identifier representing business unit ID in Calabrio WFM application. | STRING | TRUE |
| business_unit_name | The name of the business of this group page. | STRING | TRUE |
| group_id | ID of group page. | BIG_INTEGER | TRUE |
| insert_date | Date and time when record was inserted in the table. | TIMESTAMP | TRUE |
| update_date | UTC date and time when post was last updated in the table. | TIMESTAMP | TRUE |
| is_deleted | If true, this row has been removed. If false, this row is new or updated. | BOOLEAN | TRUE |
location_dim table
The location_dim table contains available agent locations to consider when scheduling. The available locations are Home or Office.
Primary key: location_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| location_id |
ID for the business unit. |
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 |
| location_name |
The unique identifier representing the ID in Calabrio WFM application. |
STRING | TRUE |
| resource_key |
The name of the business unit. |
STRING | TRUE |
| location_code |
Date and time when post was inserted in the table. |
STRING | TRUE |
| insert_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
overtime_dim table
The overtime_dim table contains all attributes of the overtime types in the system.
Primary key: overtime_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| overtime_id |
ID for the overtime. |
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 |
| overtime_code |
Unique identifier representing the overtime in Calabrio WFM. |
STRING | TRUE |
| overtime_name |
The overtime name. |
STRING | TRUE |
| business_unit_id | ID representing the business unit. | BIG_INTEGER | TRUE |
| insert_date |
Date and time when record was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
|
is_deleted |
Marks that this overtime type is deleted in the system but still available for reporting. |
BOOLEAN |
TRUE |
person_dim table
The person_dim table contains all persons/agents in the Calabrio WFM application.
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 |
| person_code |
Unique identifier representing the person id in Calabrio WFM application. |
STRING | TRUE |
| valid_from_date |
Date from when the person period is valid in UTC. |
TIMESTAMP | TRUE |
| valid_to_date |
Date from when the person period is valid in UTC.2059-12- 31 00:00:00 if period is still valid. |
TIMESTAMP | TRUE |
| person_period_code |
Unique identifier representing the person period ID in Calabrio WFM application. |
STRING | TRUE |
| person_name |
Person full name. |
STRING | TRUE |
| first_name |
First name. |
STRING | TRUE |
| last_name |
Last or Surname. |
STRING | TRUE |
| employment_number |
Employment number. |
STRING | TRUE |
| employment_type_code |
A bit value set to True if the absence is to be counted as work time. |
INTEGER | TRUE |
| contract_code |
Unique identifier representing the person contract ID in Calabrio WFM application. |
STRING | TRUE |
| contract_name |
The person contract name/description. |
STRING | TRUE |
| parttime_code |
Unique identifier representing the person part-time ID in Calabrio WFM application. |
STRING | TRUE |
| parttime_percentage |
Part-time percentage. |
STRING | TRUE |
| team_id |
The ID for the team that the person belongs to. |
INTEGER | TRUE |
| team_code |
Unique identifier representing the person’s team ID in Calabrio WFM application. |
STRING | TRUE |
| team_name |
The name for the team that the person belongs to. |
STRING | TRUE |
| site_id |
The ID for the site that the person belongs to. |
INTEGER | TRUE |
| site_code |
Unique identifier representing the person’s site ID in Calabrio application. |
STRING | TRUE |
| site_name |
The name for the site that the person belongs to. |
STRING | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| business_unit_code |
Unique identifier representing the person’s business unit ID in Calabrio WFM application. |
STRING | TRUE |
| business_unit_name |
The name for the business unit that the person belongs to. |
STRING | TRUE |
| skillset_id |
The skillset_id representing the combination of skills that the person has. |
INTEGER | TRUE |
|
Email address. |
STRING | TRUE | |
| note |
Notes field. |
STRING | TRUE |
| employment_start_date |
The start date of the employment. |
TIMESTAMP | TRUE |
| employment_end_date |
The end date of the employment. 2059-12-31 00:00:00 if emplyment is still valid. |
TIMESTAMP | TRUE |
| time_zone |
The time zone that the person is working in. |
STRING | TRUE |
| is_agent |
A bit value set to True if the person is also an agent. |
BOOLEAN | TRUE |
| is_user |
A bit value set to True if the person is also a user. |
BOOLEAN | TRUE |
| to_be_deleted | Marks that this person period is no longer valid. It will be deleted by the ETL cleanup job. | BOOLEAN | TRUE |
| windows_domain |
The name of the Windows domain that the user is logged in to. |
STRING | TRUE |
| windows_username |
The username of the Windows domain. |
TIMESTAMP |
TRUE |
| valid_from_date_local |
A date representing the person period end date based on agent local date. |
TIMESTAMP |
TRUE |
| period_note |
Text field that stores notes or comments related to a specific time period for the person. |
STRING | TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
preference_type_dim table
The preference_type_dim table contains all schedule preference types used in the system like a day off or shift category preference.
Primary key: preference_type_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| preference_type_id |
ID for the preference 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 |
| preference_type_name |
Name/description for the preference type. |
STRING | TRUE |
| resource_key |
The preference type resource key |
STRING | TRUE |
queue_dim table
The queue_dim table contains all queues in the CTI platform.
Primary key: queue_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| queue_id |
ID for the queue. |
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 |
| queue_agg_id |
ID for queue, created in table queues. |
INTEGER | TRUE |
| queue_original_id |
The queue's ID in the ACD/CTI. |
STRING | TRUE |
| queue_name | Name of the queue. | STRING | TRUE |
| queue_description |
The queue's description. |
STRING | TRUE |
| log_object_name |
The name of the log object. |
STRING | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
request_status_dim table
A static dimension table holding request statuses.
Primary key: request_status_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| request_status_id |
ID of request status. |
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 |
| request_status_name |
Name for the request status. |
STRING | TRUE |
| resource_key |
Resource key for each request status. |
STRING | TRUE |
request_type_dim table
A static dimension table holding request types.
Primary key: request_type_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| request_type_id |
ID of request 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 |
| request_type_name |
Name for the request type. |
STRING | TRUE |
| resource_key |
Resource key for each request type. |
STRING | TRUE |
scenario_dim table
The scenario_dim table contains the scenarios that are in the system that is to be used for reporting, currently the scenario marked as the default scenario.
Primary key: scenario_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| scenario_id |
ID for the scenario. |
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 |
| scenario_code |
Unique identifier representing the scenario ID in Calabrio WFM application. |
STRING | TRUE |
| scenario_name |
The name of the scenario. |
STRING | TRUE |
| default_scenario | A bit value set to True if the scenario is the default scenario. | BOOLEAN | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| business_unit_code |
Unique identifier representing the person business unit ID in Calabrio WFM application. |
STRING | TRUE |
| business_unit_name |
The name for the business unit that the person belongs to. |
STRING |
TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
| is_deleted |
Deleted flag. |
BOOLEAN |
TRUE |
shift_category_dim table
The shift_category_dim table contains all shift categories in the system.
Primary key: shift_category_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| shift_category_id |
ID for the scenario. |
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 |
| shift_category_code |
Unique identifier representing the scenario ID in Calabrio WFM application. |
STRING | TRUE |
| shift_category_name |
The name of the scenario. |
STRING | TRUE |
| shift_category_shortname |
ID representing the business. |
STRING | TRUE |
| display_color |
Unique identifier representing the person business unit ID in Calabrio WFM application. |
BIG_INTEGER | TRUE |
| business_unit_id |
The name for the business unit that the person belongs to. |
INTEGER |
TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
| is_deleted |
Deleted flag. |
BOOLEAN |
TRUE |
shift_length_dim table
The shift_length_dim table contains a surrogate key defining the length in time for a shift.
Primary key: shift_length_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| shift_length_id |
ID for the shift length. |
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 |
| shift_length_m |
Shift length in minutes. |
INTEGER | TRUE |
| shift_length_h |
Shift length in hours. |
FLOAT | TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP | TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP | TRUE |
site_dim table
site_dim table contains all sites in the system.
Primary key: site_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| site_id |
ID for the site. |
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 |
| site_code |
Unique identifier representing the person site ID in Calabrio WFM application. |
STRING | TRUE |
| site_name |
The name for the site that the person belongs to. |
STRING | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
skill_dim table
The skill_dim table contains information about all agent skills used in the Calabrio WFM application. Each agent can have a set of skills.
Primary key: skill_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| skill_id |
ID for the skill. |
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 |
| skill_code |
Unique identifier representing the skill ID in Calabrio WFM application. |
STRING | TRUE |
| skill_name |
Name of the skill. |
STRING | TRUE |
| time_zone |
Time zone that the skill is scheduled in. |
STRING | TRUE |
| forecast_method_code |
Unique identifier representing the forecast method ID in Calabrio WFM application. |
STRING | TRUE |
| forecast_method_name |
The name of the forecast method. |
STRING | TRUE |
| business_unit_id |
ID representing the business unit in business_unit_dim table. |
INTEGER |
TRUE |
| insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
| update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
| is_deleted |
Deleted flag. |
BOOLEAN |
TRUE |
skillset_dim table
The skillset_dim table contains a unique sets of skills used in the system.
Primary key: skillset_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| skillset_id |
ID of the skillset. |
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 |
| skillset_code |
The unique combination of the IDs of the skills in the skillset separated by a comma. |
STRING | TRUE |
| skillset_name |
The name of the skills in the skillset in a comma-separated string. |
STRING | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
team_dim table
The team_dim table contains all teams in the Calabrio WFM application.
Primary key: team_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| team_id |
ID of 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_code | Unique identifier representing the team ID in Calabrio WFM application. | STRING | TRUE |
| team_name |
The name of the team. |
STRING | TRUE |
|
scorecard_id |
ID representing the score card assigned to the team. |
INTEGER |
TRUE |
|
site_id |
The ID for the site that the team belongs to. |
INTEGER |
TRUE |
| business_unit_id |
ID representing the business unit that the team belongs to. |
INTEGER | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
workload_dim table
The workload_dim table contains all available workloads in the Calabrio WFM application. The workload can contain a set of queues. The relationship between the workloads and queues can be found in the queue_workload_bridge table.
Primary key: workload_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| workload_id |
ID of the workload. |
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 |
| workload_code |
Unique identifier representing the workload ID in Calabrio WFM application. |
STRING | TRUE |
| workload_name |
The workload name. |
STRING | TRUE |
| skill_id |
The skill ID that the workload belongs to. -1 if no skill. |
INTEGER | TRUE |
| skill_code |
Unique identifier representing the skill ID in Calabrio WFM application. |
STRING | TRUE |
| skill_name |
The name of the skill that the workload belongs to. |
STRING | TRUE |
| time_zone |
The time zone that the workload is in. |
STRING | TRUE |
| forecast_method_code |
Unique identifier representing the forecast method id in Calabrio WFM application. |
STRING | TRUE |
| forecast_method_name |
The name of the forecast method. |
STRING | TRUE |
| percentage_offered |
Quota of the offered calls to include. |
FLOAT | TRUE |
| percentage_overflow_in |
Quota of the incoming overflowed calls to include. |
FLOAT | TRUE |
| percentage_overflow_out |
Quota of the outgoing overflowed calls to include (-1 to exclude all). |
FLOAT | TRUE |
| percentage_abandoned |
Quota of the abandoned calls to include (-1 to exclude all). |
FLOAT | TRUE |
| percentage_abandoned_short |
Quota of the short abandoned calls to include. |
FLOAT | TRUE |
| percentage_abandoned_within_service_level |
Quota of the calls abandoned within service level target to include. |
FLOAT | TRUE |
| percentage_abandoned_after_service_level |
Quota of the calls abandoned after service level target to include. |
FLOAT | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
Deleted flag. |
BOOLEAN |
TRUE |
acd_login_person_bridge table
The acd_login_person_bridge table shows the relationship between persons in the Calabrio WFM application and the acd_logins in the CTI platform.
Primary key: acd_login_id, person_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| acd_login_id |
ID representing the agent's acd_login. |
INTEGER | TRUE |
| person_id |
ID representing the agent/person in Calabrio WFM. |
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 |
| team_id |
ID representing the team that the person belongs to. |
INTEGER | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
group_page_person_bridge table
The group_page_person_bridge table shows the relationship between group pages and included people in the Calabrio WFM application.
Primary key: person_id, group_page_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| group_page_id | ID for the group page. | INTEGER | TRUE |
| person_id |
ID for the person included in this group page. |
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 |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
queue_workload_bridge table
The queue_workload_bridge table shows the relationship between the queues in the CTI platform and the workloads in the Calabrio WFM application.
Primary key: queue_id, workload_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| queue_id |
ID representing the CTI platform queue. |
INTEGER | TRUE |
| workload_id |
ID representing the workload for which the forecast is valid. |
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 |
| skill_id |
ID representing the skill for which the forecast is valid. |
INTEGER | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| insert_date | Date and time when post was inserted in the table. | TIMESTAMP | TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
agent_adherence_day_fact table
The agent_adherence_day_fact table holds the adherence numbers for calculating historical adherence based on an RTA feed. The numbers are updated at the end of the shift.
Primary key: shift_startdate_local, person_code
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| shift_startdate_local |
The date when shift starts in agent’s local date (not UTC). |
TIMESTAMP | TRUE |
| person_code |
ID representing a person in WFM application. |
STRING | 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 |
| person_id |
ID representing the agent/person. |
INTEGER | TRUE |
| seconds_in_adherence |
The number of seconds marked as in adherence. |
FLOAT | TRUE |
|
seconds_out_of_adherence |
The number of seconds marked as out of adherence. |
FLOAT |
TRUE |
| seconds_in_neutral_adherence |
The number of seconds marked as neutral (for example because of technical issues). Neutral time is not considered when calculating the adherence percentage. |
FLOAT | TRUE |
| seconds_in_shift |
The total number of seconds in the shift. |
FLOAT | TRUE |
| seconds_late_for_work |
The number of seconds marked as late for work (logged in to the CTI platform after the shift started). Late for work calculation is done from the start of the first activity for which tracking of late for work is turned on until the moment the agent enters a logged-in state. Threshold is 1 minute. |
FLOAT | TRUE |
|
insert_date |
UTC date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
UTC date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
agent_queue_fact table
The agent_queue_fact table holds aggregated numbers of the agent’s activities in the CTI platform on specific Queues, Number of calls, and Talk time.
Primary key: date_interval, queue_id, acd_login_id, person_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| date_interval |
The date range or period for which the schedule preference is defined. |
TIMESTAMP | TRUE |
| queue_id |
ID representing the CTI platform queue. |
INTEGER | TRUE |
| acd_login_id |
ID representing the agent’s acd_login. |
INTEGER | TRUE |
| person_id |
ID representing the agent/person. |
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 |
|
person_code |
ID representing a person in WFM application. |
STRING |
TRUE |
|
team_id |
ID representing the team that the person belongs to. |
INTEGER | TRUE |
| team_code | Unique identifier representing the team ID in Calabrio WFM application. | STRING | TRUE |
| team_name |
The name of the team. |
STRING | TRUE |
|
talk_time_s |
Time in seconds that the agent spent in a call. Corresponds to field talking_call_dur in agent_logg table. |
FLOAT |
TRUE |
|
after_call_work_time_s |
The time the agent spends on a call, after they have finished talking to a customer. Corresponds to field wrap_up_dur in agent_logg. |
FLOAT |
TRUE |
|
answered_calls |
Number of calls to a queue that have been answered by an agent. Corresponds to field answ_call_cnt in agent_logg. |
BIG_INTEGER | TRUE |
|
transferred_calls |
Total number of calls that an agent transfers to another agent. Corresponds to the field transfer_out_call_cnt in agent_logg table. |
BIG_INTEGER |
|
|
hold_time_s |
Total hold time in seconds for an agent, queue, and interval. Hold_time_s is included in talk_time_s. Hold time may not be available for all platforms. |
FLOAT |
|
|
completed_calls |
Column added for upcoming release of completed calls. NULL value returned. |
FLOAT |
|
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
UTC date and time when post was last updated in the table |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
agent_skill_fact table
The agent_skill_fact table holds all the skills for each person on a given date from the Calabrio WFM application.
Primary key: person_id, skill_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| person_id |
ID representing the agent/person in Calabrio WFM. |
INTEGER | TRUE |
| skill_id |
ID representing the skill. |
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 |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| has_skill |
Bit flag, but implemented as Int for aggregation reasons, representing if the agent has this skill or not. |
BOOLEAN | TRUE |
| active | Bit flag representing if the agent has this skill as an active skill or not. | BOOLEAN | TRUE |
|
update_date |
UTC date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
forecast_workload_fact table
The forecast_workload_fact table holds the aggregated numbers of the workloads created in the Calabrio WFM application.
Primary key: date_interval, start_time, workload_id, scenario_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| date_interval |
|
TIMESTAMP | TRUE |
| start_time |
The start time from when forecast is valid. |
TIMESTAMP | TRUE |
| workload_id |
ID representing the workload for which the forecast is valid. |
INTEGER | TRUE |
| scenario_id |
ID representing the scenario for which the forecast is valid. |
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 |
| end_time |
The end time for the period which the forecast is valid. |
TIMESTAMP | TRUE |
| skill_id |
ID representing the skill for which the forecast is valid. |
INTEGER | TRUE |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| forecasted_calls |
Total number of forecasted calls, including campaign calls. |
FLOAT | TRUE |
| forecasted_emails |
Total number of forecasted emails. |
FLOAT | TRUE |
| forecasted_backoffice_tasks |
Total number of forecasted back office tasks. |
FLOAT | TRUE |
| forecasted_campaign_calls |
Total number of forecasted campaign calls. |
FLOAT | TRUE |
| forecasted_calls_excl_campaign |
Total number of forecasted calls, excluding campaign calls. |
FLOAT | TRUE |
| forecasted_talk_time_s |
The forecast of how long the agents will spend talking to customers in seconds. The forecast is based on how long each call is, i.e., average talk time. |
FLOAT | TRUE |
| forecasted_campaign_talk_time_s |
The forecast of how long the agents will spend talking to customers in campaign calls. The forecast is based on how long each call is. |
FLOAT | TRUE |
| forecasted_talk_time_excl_campaign_s |
The forecast of how long the agents will spend talking to customers (excluding campaign calls) in seconds. The forecast is based on how long each call is, i.e., average talk time. |
FLOAT | TRUE |
| forecasted_after_call_work_s |
Forecasted After Call Work (ACW) is the forecast for how much time the agents will spend working on calls after they have ended the conversation with the customer. |
FLOAT | TRUE |
| forecasted_campaign_after_call_work_s |
Forecasted After Call Work (ACW) is the forecast for how much time the agents will spend working on campaign calls after they have ended the conversation with the customer. |
FLOAT | TRUE |
|
forecasted_after_call_work_excl_campaign_s |
Forecasted After Call Work (ACW) is the forecast for how much time the agents will spend working on calls (excluding campaign calls) after they have ended the conversation with the customer. |
FLOAT | TRUE |
|
forecasted_handling_time_s |
Date and time when post was last updated in the table. | FLOAT | TRUE |
|
forecasted_campaign_handling_time_s |
A sum of the forecasted time that an agent will spend talking to customers (Forecasted Talk Time) and the forecasted after call work (Forecasted ACW) for campaign calls. |
FLOAT | TRUE |
|
forecasted_handling_time_excl_campaign_s |
A sum of the forecasted time that an agent will spend talking to customers (Forecasted Talk Time) and the forecasted after call work (Forecasted ACW) excluding campaign calls. |
FLOAT | TRUE |
|
period_length_min |
Length in minutes for a forecasted period. |
FLOAT |
TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
hourly_availability_fact table
The hourly_availability_fact table holds the numbers for hourly availability. For example, the available time and days and scheduled time and days.
Primary key: date, person_id, scenario_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| date |
ID representing the agent/person in Calabrio WFM. |
TIMESTAMP | TRUE |
| person_id |
ID representing the agent/person. |
INTEGER | TRUE |
| scenario_id |
ID for the scenario. |
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 |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| available_time_m | Time in minutes set as available by an agent in MyTime in function Availability. | BIG_INTEGER | TRUE |
|
available_days |
The number of available days where available time is set by an agent in MyTime in function Availability. |
BIG_INTEGER |
TRUE |
|
scheduled_time_m |
The number of scheduled work time in minutes for a day set as available. |
BIG_INTEGER |
TRUE |
|
scheduled_days |
The number of days scheduled of the available days. |
BIG_INTEGER | TRUE |
|
update_date |
UTC date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
requests_fact table
The requests_fact table holds the number of requests and days requested from the Calabrio WFM application.
Primary key: request_code
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| request_code |
Unique identifier representing the request ID in Calabrio WFM application. |
STRING | 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 |
| person_id |
The request is valid for this person_id |
INTEGER | TRUE |
| application_datetime |
Timestamp when the request was made in the application. |
TIMESTAMP | TRUE |
| request_starttime |
The first date requested in the agent’s time zone (not UTC). |
TIMESTAMP | TRUE |
| request_endtime | The last date requested in the agent’s time zone (not UTC) | TIMESTAMP | TRUE |
| request_type_id |
Type of the request. |
INTEGER |
TRUE |
|
request_status_id |
Status of the request. |
INTEGER |
TRUE |
|
business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
|
absence_id |
ID representing which absence that was requested. -1 if no absence. |
INTEGER | TRUE |
|
request_day_count |
Marks that this day is included in a request. |
BIG_INTEGER |
TRUE |
|
request_start_date_count |
Marks that this is a starting point of a request. |
BIG_INTEGER |
TRUE |
|
requested_time_m |
Total number of minutes requested. Valid for absence or text requests. |
BIG_INTEGER |
TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
schedule_deviation_fact table
The schedule_deviation_fact table holds the deviation for each interval. This information can be used to calculate the Ready Time Adherence percentage.
Primary key: date_interval, shift_startdate_interval, person_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| date_interval |
The date range or period for which the schedule preference is defined |
TIMESTAMP | TRUE |
| shift_startdate_interval |
The date range representing the start date of the shift in the schedule deviation data. |
TIMESTAMP | TRUE |
| person_id |
ID representing the agent/person in Calabrio WFM. |
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 |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| is_logged_in | Logged in flag. | BOOLEAN | TRUE |
| scheduled_ready_time_s |
All scheduled ready time expressed in seconds. Based on setting “InReadyTime”. |
BIG_INTEGER |
TRUE |
|
ready_time_s |
Time in seconds that the agent is available for calls. Corresponds to field avail_dur in agent_logg. |
BIG_INTEGER |
TRUE |
|
contract_time_s |
The contract time according to the schedule. |
BIG_INTEGER |
|
|
deviation_schedule_s |
The absolute time in seconds for schedule ready time - ready time, also intervals where schedule ready time is 0 are included. |
FLOAT | TRUE |
|
deviation_schedule_ready_s |
The absolute time in seconds for schedule ready time - ready time, only intervals where schedule ready time is greater than 0 are included. |
FLOAT | TRUE |
|
deviation_contract_s |
The deviation between schedule and actual ready time in seconds. |
FLOAT |
TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
schedule_forecast_skill_fact
The schedule_forecast_skill_fact table holds aggregated numbers of schedule time and forecasted workload per skill from the Calabrio WFM application.
Primary key: scenario_id, date_interval, skill_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| scenario_id |
ID representing the scenario for which the forecast is valid. |
INTEGER | TRUE |
| date_interval |
The date range or period for which the schedule preference is defined. |
TIMESTAMP | TRUE |
| skill_id |
ID representing the skill for which the forecast is valid for. |
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 |
| business_unit_id |
ID representing the business unit. |
INTEGER | TRUE |
| forecasted_resources_m | The number of forecasted resources expressed in minutes. For example, 15 minute interval length and 1 forecasted person/resource = 15 minutes, 2 persons = 30 minutes. | FLOAT | TRUE |
| forecasted_resources |
The number of forecasted resources according to calculated traffic intensity. |
FLOAT |
TRUE |
|
forecasted_resources_incl_shrinkage_m |
The number of forecasted resources expressed in minutes including shrinkage compensation. For example, 15 minute interval length and 1 forecasted person/resource and a planned shrinkage at 1.2 = |
FLOAT |
TRUE |
|
forecasted_resources_incl_shrinkage |
The number of forecasted resources including shrinkage compensation. For example, 1 forecasted person/resource and a planned shrinkage at 1.2 = 1.2, 2 persons, shrinkage 1.2 = 2.4 resources. |
FLOAT |
TRUE |
|
scheduled_resources_m |
The number of scheduled resources expressed in minutes for selected skill and scenario. |
FLOAT | TRUE |
|
scheduled_resources |
The number of scheduled resources according to calculated traffic intensity for selected skill and scenario. |
FLOAT | TRUE |
|
scheduled_resources_incl_shrinkage_m |
Scheduled resources including shrinkage in minutes. | FLOAT | TRUE |
|
scheduled_resources_incl_shrinkage |
The number of scheduled resources. |
FLOAT | TRUE |
|
intraday_deviation_m |
Absolute value of scheduled_resources_m - forecasted_resources_m. |
FLOAT | TRUE |
|
relative_difference |
(Scheduled Time - Forecasted Time) / Forecasted Time. |
FLOAT | TRUE |
|
forecasted_tasks |
Total number of forecasted calls, including campaign calls. |
FLOAT | TRUE |
|
estimated_tasks_answered_within_sl |
Total number of forecasted calls, including campaign calls. |
FLOAT | TRUE |
|
forecasted_tasks_incl_shrinkage |
Total number of forecasted calls, including campaign calls shrinkage. |
FLOAT | TRUE |
|
estimated_tasks_answered_within_sl_incl_shrinkage |
Estimated numbers of calls answered within service level including shrinkage. |
FLOAT | TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |
schedule_preference_fact table
The schedule_preference_fact table holds the numbers of preferences created and handled in the Calabrio WFM application. For example, the Shift Category, Day Off, Extended with count of Requested, Accepted, and Denied.
Primary key: date_interval, person_id, scenario_id, preference_type_id, shift_category_id, day_off_id, absence_id
| Column name | Description | Data type | Nullable |
|---|---|---|---|
| date_interval |
The date range or period for which the schedule preference is defined. |
TIMESTAMP | TRUE |
| person_id |
ID representing the agent/person in Calabrio WFM. |
INTEGER | TRUE |
| scenario_id |
ID representing the scenario in scenario_dim for which the forecast is valid for. |
INTEGER | TRUE |
| preference_type_id |
ID representing the type of preference in preference_type_dim that is made. If an extended preference is made, both shift category and day off are set to - 1. |
INTEGER | TRUE |
| shift_category_id | ID representing the preferred shift category. -1 if no shift category. | INTEGER | TRUE |
| day_off_id |
ID representing the preferred day off. -1 if no day off. |
INTEGER |
TRUE |
|
absence_id |
The absence requested for in preference. -1 if no absence. |
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 |
|
business_unit_id |
ID representing the business unit in business_unit_dim table. |
INTEGER |
TRUE |
|
preferences_requested |
Number of preferences made in this preferred type and shift category ID/day off/extended. |
BIG_INTEGER | TRUE |
|
preferences_fulfilled |
No of preferences accepted in this preference type and shift category ID/day off id or extended. |
BIG_INTEGER | TRUE |
|
preferences_unfulfilled |
Number of preferences declined in this preference type and shift category ID/day off ID or extended. | BIG_INTEGER | TRUE |
|
must_haves |
The number of preferences marked as a must have by the agent. |
BIG_INTEGER | TRUE |
|
insert_date |
Date and time when post was inserted in the table. |
TIMESTAMP |
TRUE |
|
update_date |
Date and time when post was last updated in the table. |
TIMESTAMP |
TRUE |
|
is_deleted |
If true, this row has been removed. If false, this row is new or updated. |
BOOLEAN |
TRUE |