Milestones Fact Table

This table captures the milestone event of customers, such as the start date of the milestone target, client/ org to which the milestone belongs, and identifier of the milestone.

Databricks Table Name: target_milestone_trigger_communications

Milestones Entity Relationship Diagram

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

Target Milestone Trigger Communicationsauto_update_time: bigintclient_id: bigintdim_event_date_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_milestone_id: bigintdim_user_target_id: bigintPKid: bigintyear: intdateLKdate_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: stringTimeMilestonesmilestone_id: intorg_config_id: intauto_update_milestone: bigintLKid: bigintname: stringUser Targetrecurring_cycles: bigintfrequency: biginttarget_entity: stringenrollment_type: stringtargetRuleIsActive: bigintend_date: stringtarget_type: stringtarget_cycle_start_date: biginttargetGroupCreatedOn: bigintevaluation_type: stringtargetGroupIsActive: biginttarget_rule_name: stringtarget_group_name: stringtarget_rule_id: bigintuser_id: biginttarget_value: bigintperiod_name: stringentityType: stringtarget_group_id: bigintstart_date: stringLKuser_target_id: bigintpreferred_till_id: bigintperiod_id: bigintentityIds: stringtargetRuleCreatedOn: bigintfrequency_type: stringMilestoneUser TargetTarget Milestone Trigger Communications

Legend

PK   Primary Key

LK   Linking Key

Fact Table
Dimension Table

Milestones Fact Table

Column Name

Data Type

Description

Linked Table

auto_update_time

bigint

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

_

client_id

bigint

Unique identifier for the client or organization.

_

dim_event_date_id

bigint

Start date of the milestone.

date

dim_latest_updated_date_id

bigint

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

date

dim_latest_updated_time_id

bigint

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

time

dim_milestone_id

bigint

Identifier for the milestone.

milestone

dim_user_target_id

bigint

Identifier for the user target.

user_target

id

bigint

Unique identifier and primary key for the table.

_

year

integer

Year of the milestone.

_