new_weekly_calendar

= all the weeks for which we have submissions with the first day of the week

Backtrack time = first_day_week

ID= Year + Month + Week

new_weekly_calendar_outlets

= a table with all the places ID for each week

Backtrack time = first_day_week

ID = customer code + Year + Month + Week

Dependent on : new_weekly_calendar

new_weekly_outlets_details

new_weekly_calculation_bso

new_weekly_dms

=all the informations related to the teams, users and places

= all the calculations with the values from the workflow : BSO, new products, nbr submissions

=all the calculations from DMS aggregated per week

Backtrack time = first_day_week

Backtrack time = backtrack_week

Backtrack time = first_day_week

ID= Year + Month + Week + Place id

ID= Year + Month + Week + place id + user id

ID=Customer ID + Year + Week

Dependent on : new_weekly_calendar_outlets

Dependent on : new_weekly_calendar_outlets

new_weekly_analysis

= a table with all the details and calculations from Fieldpro and from DMS aggregated per week

Backtrack time = first_day_week

ID= Year + Month + Week, place id + user id

Dependent on : new_weekly_outlets_details

Index: _user_id, place_id, team_id

new_weekly_ranking

=a table with the ranking of the calls based on the bso status grade to keep only the 2 best calls for the monthly aggregation

Backtrack time : first_day_month

ID=new_weekly_analysis.id

Dependant on: new_weekly_analysis

new_monthly_outlets_details

new_monthly_outlets_bso

=a table with the outlets details for the month

=a table with the ranking of the calls based on the bso status grade to keep only the 2 best calls for the monthly aggregation

Backtrack time : first_day_month

Backtrack time : first_day_month

ID=new_weekly_analysis.id

ID=new_weekly_analysis.id

Dependant on: new_weekly_analysis

Dependant on: new_weekly_analysis

new_monthly_analysis

= a table with all the details from Fieldpro and from DMS aggregated per month and BSO calculations based on the 2 best calls

Backtrack time = first_day_month

ID= Year + Month + place id + user id

Dependent on : new_weekly_calculation_bso

Index: _user_id, place_id, team_id

Partition : branch