Issue Tracker Fact Table

This fact table captures details of all customer complaints that have been converted into "issues" and are managed by the Customer Care Management System.

Databricks Table Name: issue_tracker_fact

Issue Tracker Fact - Entity Relationship Diagram (ERD)

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

Issue Trackerdim_active_status_id: bigintdim_assigned_by_id: bigintdim_assigned_to_id: bigintdim_created_by_id: bigintdim_due_date_id: bigintdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_issue_type_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_reported_by_id: bigintissue_code: stringissue_depearment: stringissue_name: stringissue_priority: stringissue_status: stringPKissue_tracker_id: bigintticket_code: stringyear: intActive StatusLKid: bigintvalue: stringIssue TypeLKid: biginttype: stringReported ByLKid: bigintvalue: string

Legend

PK   Primary Key

LK   Linking Key

Fact Table
Dimension Table
Issue Tracker FactActive StatusIssue TypeReported BydateLKdate_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: stringzone_name: stringZone Tills

Issue Tracker Fact Table

Column Name

Data Type

Description

Linked Table

Availability for Export in theIssue Trackers Template

dim_active_status_id

bigint

Identifier indicating whether the issue is still active or not. Possible values are 0 and 1.

active_status

Yes; Dimension Name: Active Status > Id

dim_assigned_by_id

bigint

Identifier for the person or entity who assigned the issue.

zone_till

Yes; Dimension Name: Assigned By > Till Id

dim_assigned_to_id

bigint

Identifier for the person or department to whom the issue is assigned.

zone_till

Yes; Dimension Name: Assigned To > Id

dim_created_by_id

bigint

Identifier for the person who created the issue record.

zone_till

Yes; Dimension Name: Created By > Till Id

dim_due_date_id

bigint

Identifier for the due date of the issue resolution.

date

Yes; Dimension Name: Due Date > Date

dim_event_date_id

bigint

Date when the issue event occurred.

date

Yes; Dimension Name: Date

dim_event_time_id

bigint

Time when the issue event occurred.

time

Yes; Dimension Name: Time > Time Id

dim_event_user_id

bigint

Identifier for the user involved in the issue event.

users

Yes; Dimension Name: User > User Id

dim_issue_type_id

bigint

Identifier for the type or category of the issue. Possible values are - Store, and Customer.

issue_type

Yes; Dimension Name: Issue Type > 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_reported_by_id

bigint

Identifier indicating how the issue was reported. Possible values are - email, intouch, call center, client and microsite.

reported_by

Yes; Dimension Name: Reported By > Id

issue_code

string

Identifier of the issue.

_

Yes; Measure Name: Issue Code

issue_depearment

string

Department to which the issue belongs.

_

Yes; Measure Name: Issue Department

issue_name

string

Gives the actual issue description.

_

Yes; Measure Name: Issue Name

issue_priority

string

Priority of the complaint as per the escalation metrics. Possible values are - high, medium, and low.

_

Yes; Measure Name: Issue Priority

issue_status

string

Current status of the issue. Possible values are - open, and closed.

_

Yes; Measure Name: Issue Status

issue_tracker_id

bigint

Unique identifier generated for the issue or complaint. It is the primary key for the table.

_

Yes; Measure Name: Issue Tracker Id

ticket_code

string

Unique identifier of the issue for internal reference.

_

Yes; Measure Name: Ticket Code

year

int

Year of the issue.

_

Yes; Dimension Name: Year