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 Communications auto_update_time: bigint client_id: bigint dim_event_date_id: bigint dim_latest_updated_date_id: bigint dim_latest_updated_time_id: bigint dim_milestone_id: bigint dim_user_target_id: bigint PK id: bigint year: int date LK date_id: int day_of_month: int week_of_year: int month: string year: int quarter: string week_number: int week_start_date: string week_end_date: string day_of_week: string month_no: int month_no_of_year: int month_of_year: string day_of_week_no: int quarter_no: int yearly_quarter_no: int date: string Date Time LK time_id: bigint time: string hour_of_day: int minute_of_day: int day_shift: string day_shift_no: int hour_range: string Time Milestones milestone_id: int org_config_id: int auto_update_milestone: bigint LK id: bigint name: string User Target recurring_cycles: bigint frequency: bigint target_entity: string enrollment_type: string targetRuleIsActive: bigint end_date: string target_type: string target_cycle_start_date: bigint targetGroupCreatedOn: bigint evaluation_type: string targetGroupIsActive: bigint target_rule_name: string target_group_name: string target_rule_id: bigint user_id: bigint target_value: bigint period_name: string entityType: string target_group_id: bigint start_date: string LK user_target_id: bigint preferred_till_id: bigint period_id: bigint entityIds: string targetRuleCreatedOn: bigint frequency_type: string Milestone User Target Target Milestone Trigger Communications Legend
PK Primary Key
LK Linking Key
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.
_