Call Task Customer Status Fact Table

Call tasks are tasks created at the POS (point of sale machines) for cashiers to process. The tasks could be call customers for birthday wishes that will get populated every day for the cashier to process. These tasks have a specific validity within which these needs to be closed. The call task customer status fact table captures the details of the call task such as call task id, the associated campaign, and date and time of the call task.

Databricks Table Name: call_task_customer_status

Call Task Customer Status Fact - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Call Task Customer Statusauto_update_time_task_status: bigintPKcall_task_id: bigintdim_campaign_id: bigintdim_campaign_message_id: bigintdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_event_zone_till_id: bigintdim_internal_status_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_task_id: bigintdim_updated_by_user_id: bigintdim_updated_date_id: bigintdim_updated_time_id: bigintPKtask_id: bigintyear: intCall Task Customer StatusdateLKdate_id: intday_of_month: intweek_of_year: intmonth: stringyear: intquarter: stringweek_number: intweek_start_date: stringweek_end_date: stringday_of_week: stringmonth_no: intmonth_no_of_year: intmonth_of_year: stringday_of_week_no: intquarter_no: intyearly_quarter_no: intdate: stringDateTimeLKtime_id: biginttime: stringhour_of_day: intminute_of_day: intday_shift: stringday_shift_no: inthour_range: stringTimeusersauto_update_merged_customer: bigintauto_update_loyalty: bigintfraud_status: stringtest_control_bucket: stringis_merged_customer: stringsubscription_status_email_bulk: stringfirst_name: stringslab_name: stringsubscription_status_wechat_bulk: stringemail: stringlast_name: stringmerged_user_id: bigintLKuser_id: bigintsubscription_status_wechat_trans: stringsubscription_status_sms_bulk: stringndnc_status: stringsubscription_status_email_trans: stringtest_control_status: stringauto_update_fraud_user: bigintis_inactive: stringsource: stringslab_number: intauto_update_users: bigintregistered_till_id: bigintauto_update_customer_enrollment: bigintslab_expiry_date: stringcustomer_external_id: stringsubscription_status_sms_trans: stringmobile: stringloyalty_type: stringauto_update_ndnc_status: bigintUsersZone_tillsstore_country: stringexternal_id_1: stringstore: stringauto_update_till_parent: bigintarea: stringstore_name: stringstore_city: stringstore_state: stringtill: stringauto_update_till_store_relation: bigintis_ffc_enabled: stringLKtill_id: biginttype: stringtill_description: stringauto_update_till: bigintstore_channel: stringexternal_id: stringis_billable: stringstore_id: bigintis_active: stringauto_update_store: bigintstore_description: stringlatitude: stringtimezone: stringexternal_id_2: stringtill_name: stringzone_name: stringZone TillsCampaignsis_recurring: stringcampaign_end_date: stringis_migrated: stringauto_update_campaign: bigintLKcampaign_id: bigintcampaign_type: stringroi_type: stringcampaign_start_date: stringname: stringCampaignsInternal Statusexternal_status: stringLKid: bigintinternal_status: stringTasksaction_type: stringstart_date: stringauto_update_task_campaign_map: bigintLKtask_id: bigintdescription: stringcampaign: stringauto_update_campaign_base: bigintcreated_by_type: stringend_date: stringvalid_days_from_create: intauto_update_tasks: bigintCampaign_msgcampaign_end_date: stringcampaign: stringauto_update_campaign: bigintmsg_type: stringauto_update_msg: bigintguid: stringstatus: stringLKid: bigintscheduled_type: stringcampaign_start_date: stringmsg_name: stringis_recurring: stringCampaign MessageInternal StatusTasks

Legend

PK   Primary Key

LK   Linking Key

Fact Table
Dimension Table

Call Task Customer Status Fact Table

Column Name

Data Type

Description

Linked Table

Availability for Export in the

Call Tasks

Template

auto_update_time

  • task_status

bigint

Date and time when the corresponding record in the task status table available at the source was last updated. It is in the Unix timestamp format.

Yes; Measure Name: Auto Update Time Task Status

call_task_id

bigint

Identifier for the call task. It is the primary key for the table.

Yes; Measure Name: Call Task Id

dim_campaign_id

bigint

Identifier of the campaign associated with the call task.

campaign

Yes; Dimension Name: Campaign > Campaign Id

dim_campaign

  • message_id

bigint

Identifier of the campaign message associated with the call task.

campaign_msg

Yes; Dimension Name: Campaign Message > Id

dim_event_date_id

bigint

Date of the call task.

date

Yes; Dimension Name: Date > Date

dim_event_time_id

bigint

Time of the call task.

time

Yes; Dimension Name: Time > Time Id

dim_event_user_id

bigint

Used Id of the customer for which the task is created.

users

Yes; Dimension Name: User > User Id

dim_event_zone_till_id

bigint

Identifier of the store associated with the call task. It is the identifier assigned to the point-of-sale (POS) terminal within a store. It distinguishes one checkout location from another within the same store.

zone_till

Yes; Dimension Name: Store Hierarchy > Till Id

dim_internal_status_id

bigint

Identifier for the internal status of the call task. Possible values are - Open, and complete.

internal_status

Yes; Dimension Name: Internal Status > Id

dim_latest

  • updated_date_id

bigint

Date when the data corresponding to this event/row is changed in the source table.

date

Yes; Dimension Name: Latest Updated Date > Date

dim_latest

  • updated_time_id

bigint

Time when the data corresponding to this event/row is changed in the source table.

time

Yes; Dimension Name: Latest Updated Time > Time Id

dim_task_id

bigint

Identifier that links to the task dimension table, which provides additional details about the task, including the task type, task description, etc.

tasks

Yes; Dimension Name: Task > Task Id

dim_updated_by_user_id

bigint

Identifier of the user who updated the call task status.

users

Yes; Dimension Name: Updated By User > User Id

dim_updated_date_id

bigint

Captures the date when the date has been updated.

date

Yes; Dimension Name: Updated Date

dim_updated_time_id

bigint

Captures the time when the date has been updated.

time

Yes; Dimension Name: Updated Time

task_id

bigint

Unique identifier for the task configured for the campaigns. It is the primary key for the table.

Yes; Measure Name: Task Id

year

integer

Year of the call task creation.

Yes; Dimension Name: Year