2022-02-27T23:15:01.216+0100 [INFO]: Data distribution worker started
2022-02-27T23:15:01.216+0100 [INFO]: Request id: "disc_Ej1DIfUby5:m0ScAT0meKlkV6mu:9gyT1WU6oxMYeiTy"
2022-02-27T23:15:01.216+0100 [INFO]: Data source: "621bf3e8b2cdbe0001772b1b"
2022-02-27T23:15:01.216+0100 [INFO]: Additional parameters: {GDC_DATALOAD_DATASETS=[{"dataset":"dataset.gd_ccg_schedule","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_schedule_objective","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_patient","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_clinic","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_schedule_track","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_prebooking","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_operator","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_prebooking_objective","uploadMode":"DEFAULT"},{"dataset":"dataset.data_gd_charge_line_item","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_team","uploadMode":"DEFAULT"},{"dataset":"dataset.data_gd_charge_objective","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_department","uploadMode":"DEFAULT"},{"dataset":"dataset.gd_ccg_procedure","uploadMode":"DEFAULT"}], GDC_DATALOAD_SINGLE_RUN_LOAD_MODE=DEFAULT, PROCESS_ID=5c1336cf-877f-4a57-a5d6-1d78097195d5}
2022-02-27T23:15:01.216+0100 [INFO]: Synchronization mode: selected datasets (default)
2022-02-27T23:15:01.987+0100 [INFO]: Synchronized datasets: [dataset.gd_ccg_schedule, dataset.gd_ccg_schedule_objective, dataset.gd_ccg_patient, dataset.gd_ccg_clinic, dataset.gd_ccg_schedule_track, dataset.gd_ccg_prebooking, dataset.gd_ccg_operator, dataset.gd_ccg_prebooking_objective, dataset.data_gd_charge_line_item, dataset.gd_ccg_team, dataset.data_gd_charge_objective, dataset.gd_ccg_department, dataset.gd_ccg_procedure]
2022-02-27T23:15:05.849+0100 [INFO]: 

====================== Mapping Validation ======================

Mapping Validation is OK

====================== End of Mapping Validation ======================


2022-02-27T23:15:05.858+0100 [INFO]: 

====================== Output Stage -> LDM mapping ======================


Output Stage table/view: data_gd__charge_line_item (full, private) -> Dataset: dataset.data_gd_charge_line_item
r__team[STRING] -> dataset.gd_ccg_team{REFERENCE}[VARCHAR(128)]
a__currency[STRING] -> label.data_gd_charge_line_item.currency{LABEL}[VARCHAR(128)]
a__responsible[STRING] -> label.data_gd_charge_line_item.responsible{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
f__unit_amount[FLOAT64] -> fact.data_gd_charge_line_item.unit_amount{FACT}[DECIMAL(12,2)]
f__unit_count[INT64] -> fact.data_gd_charge_line_item.unit_count{FACT}[BIGINT]
f__laboratory_amount[FLOAT64] -> fact.data_gd_charge_line_item.laboratory_amount{FACT}[DECIMAL(12,2)]
cp__charge_line_item[STRING] -> label.data_gd_charge_line_item.charge_line_item{LABEL}[VARCHAR(128)]
r__patient[STRING] -> dataset.gd_ccg_patient{REFERENCE}[VARCHAR(128)]
f__tax_amount[FLOAT64] -> fact.data_gd_charge_line_item.tax_amount{FACT}[DECIMAL(12,2)]
r__operator[STRING] -> dataset.gd_ccg_operator{REFERENCE}[VARCHAR(128)]
r__ccg[STRING] -> label.data_gd_charge_line_item.r__ccg{LABEL}[VARCHAR(128)]
a__payer_category[STRING] -> label.data_gd_charge_line_item.payer_category{LABEL}[VARCHAR(128)]
a__metadata_is_orthodontics[BOOL] -> label.data_gd_charge_line_item.metadata_is_orthodontics{LABEL}[VARCHAR(128)]
a__metadata_realm[STRING] -> label.data_gd_charge_line_item.metadata_realm{LABEL}[VARCHAR(128)]
d__date[DATE] -> date{DATE}[DATE]
f__gross_amount[FLOAT64] -> fact.data_gd_charge_line_item.gross_amount{FACT}[DECIMAL(12,2)]
a__charge_invoice[STRING] -> label.data_gd_charge_line_item.charge_invoice{LABEL}[VARCHAR(128)]
a__metadata_calculation[STRING] -> label.data_gd_charge_line_item.metadata_calculation{LABEL}[VARCHAR(128)]
r__procedure[STRING] -> dataset.gd_ccg_procedure{REFERENCE}[VARCHAR(128)]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]

Output Stage table/view: data_gd__charge_objective (full, private) -> Dataset: dataset.data_gd_charge_objective
f__gross_amount_objective[FLOAT64] -> fact.data_gd_charge_objective.gross_amount_objective{FACT}[DECIMAL(12,2)]
d__date[DATE] -> date{DATE}[DATE]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
r__ccg[STRING] -> label.data_gd_charge_objective.r__ccg{LABEL}[VARCHAR(128)]
a__currency[STRING] -> label.data_gd_charge_objective.currency{LABEL}[VARCHAR(128)]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]
f__gross_amount_hourly_rate_objective[FLOAT64] -> fact.data_gd_charge_objective.gross_amount_hourly_rate_objective{FACT}[DECIMAL(12,2)]
cp__charge_objective[STRING] -> label.data_gd_charge_objective.charge_objective{LABEL}[VARCHAR(128)]
f__open_time_slot_hours[FLOAT64] -> fact.data_gd_charge_objective.open_time_slot_hours{FACT}[DECIMAL(12,2)]

Output Stage table/view: gd_ccg__clinic (full, shared) -> Dataset: dataset.gd_ccg_clinic
cp__clinic[STRING] -> label.gd_ccg_clinic.clinic{LABEL}[VARCHAR(128)]
d__onboarding_date[DATE] -> onboardingdate{DATE}[DATE]
a__name[STRING] -> label.gd_ccg_clinic.name{LABEL}[VARCHAR(128)]
a__slug[STRING] -> label.gd_ccg_clinic.slug{LABEL}[VARCHAR(128)]
a__fy_start_month[INT64] -> label.gd_ccg_clinic.fy_start_month{LABEL}[BIGINT]
r__ccg[STRING] -> label.gd_ccg_clinic.r__ccg{LABEL}[VARCHAR(128)]
a__fy_start_day[INT64] -> label.gd_ccg_clinic.fy_start_day{LABEL}[BIGINT]
a__acronym[STRING] -> label.gd_ccg_clinic.acronym{LABEL}[VARCHAR(128)]

Output Stage table/view: gd_ccg__department (full, shared) -> Dataset: dataset.gd_ccg_department
cp__department[STRING] -> label.gd_ccg_department.department{LABEL}[VARCHAR(128)]
a__color[STRING] -> label.gd_ccg_department.color{LABEL}[VARCHAR(128)]
a__label[STRING] -> label.gd_ccg_department.label{LABEL}[VARCHAR(128)]

Output Stage table/view: gd_ccg__operator (full, shared) -> Dataset: dataset.gd_ccg_operator
a__occupation[STRING] -> label.gd_ccg_operator.occupation{LABEL}[VARCHAR(128)]
r__ccg[STRING] -> label.gd_ccg_operator.r__ccg{LABEL}[VARCHAR(128)]
a__title[STRING] -> label.gd_ccg_operator.title{LABEL}[VARCHAR(128)]
a__occupation_label[STRING] -> label.gd_ccg_operator.occupation_label{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> label.gd_ccg_operator.r__clinic{LABEL}[VARCHAR(128)]
a__given_name[STRING] -> label.gd_ccg_operator.given_name{LABEL}[VARCHAR(128)]
a__label[STRING] -> label.gd_ccg_operator.label{LABEL}[VARCHAR(128)]
a__family_name[STRING] -> label.gd_ccg_operator.family_name{LABEL}[VARCHAR(128)]
a__occupation_department[STRING] -> label.gd_ccg_operator.occupation_department{LABEL}[VARCHAR(128)]
cp__operator[STRING] -> label.gd_ccg_operator.operator{LABEL}[VARCHAR(128)]

Output Stage table/view: gd_ccg__patient (full, shared) -> Dataset: dataset.gd_ccg_patient
cp__patient[STRING] -> label.gd_ccg_patient.patient{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> label.gd_ccg_patient.r__clinic{LABEL}[VARCHAR(128)]
a__admission_category[STRING] -> label.gd_ccg_patient.admission_category{LABEL}[VARCHAR(128)]
d__birth_date[DATE] -> birthdate{DATE}[DATE]
r__ccg[STRING] -> label.gd_ccg_patient.r__ccg{LABEL}[VARCHAR(128)]
a__file_id[STRING] -> label.gd_ccg_patient.file_id{LABEL}[VARCHAR(128)]
a__home_address_district[STRING] -> label.gd_ccg_patient.home_address_district{LABEL}[VARCHAR(128)]
a__language_1[STRING] -> label.gd_ccg_patient.language_1{LABEL}[VARCHAR(128)]
a__home_address_postal_code[STRING] -> label.gd_ccg_patient.home_address_postal_code{LABEL}[VARCHAR(128)]
d__file_inactivated_date[DATE] -> fileinactivateddate{DATE}[DATE]
d__file_opened_date[DATE] -> fileopeneddate{DATE}[DATE]
a__home_address_city[STRING] -> label.gd_ccg_patient.home_address_city{LABEL}[VARCHAR(128)]
d__file_closed_date[DATE] -> filecloseddate{DATE}[DATE]
a__home_address_country[STRING] -> label.gd_ccg_patient.home_address_country{LABEL}[VARCHAR(128)]
a__sex[STRING] -> label.gd_ccg_patient.sex{LABEL}[VARCHAR(128)]
d__admission_date[DATE] -> admissiondate{DATE}[DATE]
d__file_created_date[DATE] -> filecreateddate{DATE}[DATE]

Output Stage table/view: gd_ccg__prebooking (full, shared) -> Dataset: dataset.gd_ccg_prebooking
r__department[STRING] -> dataset.gd_ccg_department{REFERENCE}[VARCHAR(128)]
d__date[DATE] -> date{DATE}[DATE]
cp__prebooking[STRING] -> label.gd_ccg_prebooking.prebooking{LABEL}[VARCHAR(128)]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]
f__has_future_denturology_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_denturology_appointment{FACT}[BIGINT]
r__ccg[STRING] -> label.gd_ccg_prebooking.r__ccg{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
f__has_future_orthodontics_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_orthodontics_appointment{FACT}[BIGINT]
f__has_future_restorative_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_restorative_appointment{FACT}[BIGINT]
r__patient[STRING] -> dataset.gd_ccg_patient{REFERENCE}[VARCHAR(128)]
f__has_future_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_appointment{FACT}[BIGINT]
f__has_future_consultation_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_consultation_appointment{FACT}[BIGINT]
f__has_future_hygiene_appointment[INT64] -> fact.gd_ccg_prebooking.has_future_hygiene_appointment{FACT}[BIGINT]

Output Stage table/view: gd_ccg__prebooking_objective (full, shared) -> Dataset: dataset.gd_ccg_prebooking_objective
f__hygiene_prebooking_rate_objective[FLOAT64] -> fact.gd_ccg_prebooking_objective.hygiene_prebooking_rate_objective{FACT}[DECIMAL(12,2)]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
f__hygiene_prebooking_patient_objective[FLOAT64] -> fact.gd_ccg_prebooking_objective.hygiene_prebooking_patient_objective{FACT}[DECIMAL(12,2)]
d__date[DATE] -> date{DATE}[DATE]
cp__prebooking_objective[STRING] -> label.gd_ccg_prebooking_objective.prebooking_objective{LABEL}[VARCHAR(128)]
r__ccg[STRING] -> label.gd_ccg_prebooking_objective.r__ccg{LABEL}[VARCHAR(128)]

Output Stage table/view: gd_ccg__procedure (full, shared) -> Dataset: dataset.gd_ccg_procedure
f__recommended_price[FLOAT64] -> fact.gd_ccg_procedure.recommended_price{FACT}[DECIMAL(12,2)]
a__label[STRING] -> label.gd_ccg_procedure.label{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> label.gd_ccg_procedure.r__clinic{LABEL}[VARCHAR(128)]
a__description[STRING] -> label.gd_ccg_procedure.description{LABEL}[VARCHAR(128)]
f__recommended_price_ramq[FLOAT64] -> fact.gd_ccg_procedure.recommended_price_ramq{FACT}[DECIMAL(12,2)]
f__recommended_price_patient[FLOAT64] -> fact.gd_ccg_procedure.recommended_price_patient{FACT}[DECIMAL(12,2)]
r__ccg[STRING] -> label.gd_ccg_procedure.r__ccg{LABEL}[VARCHAR(128)]
cp__procedure[STRING] -> label.gd_ccg_procedure.procedure{LABEL}[VARCHAR(128)]
a__procedure_category[STRING] -> label.gd_ccg_procedure.procedure_category{LABEL}[VARCHAR(128)]

Output Stage table/view: gd_ccg__schedule (full, shared) -> Dataset: dataset.gd_ccg_schedule
d__date[DATE] -> date{DATE}[DATE]
a__status[STRING] -> label.gd_ccg_schedule.status{LABEL}[VARCHAR(128)]
f__has_charges[INT64] -> fact.gd_ccg_schedule.has_charges{FACT}[BIGINT]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]
r__team[STRING] -> dataset.gd_ccg_team{REFERENCE}[VARCHAR(128)]
f__booked_hours[FLOAT64] -> fact.gd_ccg_schedule.booked_hours{FACT}[DECIMAL(12,2)]
f__open_hours[FLOAT64] -> fact.gd_ccg_schedule.open_hours{FACT}[DECIMAL(12,2)]
f__unused_hours[FLOAT64] -> fact.gd_ccg_schedule.unused_hours{FACT}[DECIMAL(12,2)]
f__charge_cad_amount[FLOAT64] -> fact.gd_ccg_schedule.charge_cad_amount{FACT}[DECIMAL(12,2)]
f__is_active_or_inactive_with_nonzero_charges[INT64] -> fact.gd_ccg_schedule.is_active_or_inactive_with_nonzero_charges{FACT}[BIGINT]
r__ccg[STRING] -> label.gd_ccg_schedule.r__ccg{LABEL}[VARCHAR(128)]
f__has_nonzero_charges[INT64] -> fact.gd_ccg_schedule.has_nonzero_charges{FACT}[BIGINT]
cp__schedule[STRING] -> label.gd_ccg_schedule.schedule{LABEL}[VARCHAR(128)]
f__is_open[INT64] -> fact.gd_ccg_schedule.is_open{FACT}[BIGINT]
f__charge_cad_laboratory_amount[FLOAT64] -> fact.gd_ccg_schedule.charge_cad_laboratory_amount{FACT}[DECIMAL(12,2)]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
f__accessible_hours[FLOAT64] -> fact.gd_ccg_schedule.accessible_hours{FACT}[DECIMAL(12,2)]

Output Stage table/view: gd_ccg__schedule_objective (full, shared) -> Dataset: dataset.gd_ccg_schedule_objective
d__date[DATE] -> date{DATE}[DATE]
f__occupation_rate_objective[FLOAT64] -> fact.gd_ccg_schedule_objective.occupation_rate_objective{FACT}[DECIMAL(12,2)]
f__booked_hours_objective[FLOAT64] -> fact.gd_ccg_schedule_objective.booked_hours_objective{FACT}[DECIMAL(12,2)]
cp__schedule_objective[STRING] -> label.gd_ccg_schedule_objective.schedule_objective{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> dataset.gd_ccg_clinic{REFERENCE}[VARCHAR(128)]
r__ccg[STRING] -> label.gd_ccg_schedule_objective.r__ccg{LABEL}[VARCHAR(128)]
r__schedule_track[STRING] -> dataset.gd_ccg_schedule_track{REFERENCE}[VARCHAR(128)]

Output Stage table/view: gd_ccg__schedule_track (full, shared) -> Dataset: dataset.gd_ccg_schedule_track
r__clinic[STRING] -> label.gd_ccg_schedule_track.r__clinic{LABEL}[VARCHAR(128)]
r__ccg[STRING] -> label.gd_ccg_schedule_track.r__ccg{LABEL}[VARCHAR(128)]
a__department[STRING] -> label.gd_ccg_schedule_track.department{LABEL}[VARCHAR(128)]
cp__schedule_track[STRING] -> label.gd_ccg_schedule_track.schedule_track{LABEL}[VARCHAR(128)]
a__mode[STRING] -> label.gd_ccg_schedule_track.mode{LABEL}[VARCHAR(128)]
a__label[STRING] -> label.gd_ccg_schedule_track.label{LABEL}[VARCHAR(128)]
d__activity_start_date[DATE] -> activitystartdate{DATE}[DATE]
d__activity_end_date[DATE] -> activityenddate{DATE}[DATE]

Output Stage table/view: gd_ccg__team (full, shared) -> Dataset: dataset.gd_ccg_team
a__color[STRING] -> label.gd_ccg_team.color{LABEL}[VARCHAR(128)]
r__clinic[STRING] -> label.gd_ccg_team.r__clinic{LABEL}[VARCHAR(128)]
r__ccg[STRING] -> label.gd_ccg_team.r__ccg{LABEL}[VARCHAR(128)]
cp__team[STRING] -> label.gd_ccg_team.team{LABEL}[VARCHAR(128)]
a__label[STRING] -> label.gd_ccg_team.label{LABEL}[VARCHAR(128)]

====================== End of Output Stage -> LDM mapping ======================


2022-02-27T23:15:05.865+0100 [ERROR]: Data distribution worker failed. Reason: The Output Stage has the x__client_id column, but no Client Identifier was provided for the current workspace.