Table Lineage SVG Diagram

Table cms.mbsf_ab_2011 Table cms.mbsf_ab_2011 view medicare.ps view medicare.ps Table cms.mbsf_ab_2011->view medicare.ps union Table cms.mbsf_ab_2012 Table cms.mbsf_ab_2012 Table cms.mbsf_ab_2012->view medicare.ps union Table cms.mbsf_ab_2013 Table cms.mbsf_ab_2013 Table cms.mbsf_abcd_2015 Table cms.mbsf_abcd_2015 Table cms.mbsf_abcd_2016 Table cms.mbsf_abcd_2016 Table cms.mbsf_abcd_2017 Table cms.mbsf_abcd_2017 Table cms.mbsf_abcd_2018 Table cms.mbsf_abcd_2018 Table cms.mbsf_ab_2013->view medicare.ps union Table cms.mbsf_ab_2014 Table cms.mbsf_ab_2014 Table cms.mbsf_ab_2014->view medicare.ps union materialized view medicare.mbsf_d materialized view medicare.mbsf_d Table cms.mbsf_abcd_2015->materialized view medicare.mbsf_d union Table cms.mbsf_abcd_2015->view medicare.ps union Table cms.mbsf_abcd_2016->materialized view medicare.mbsf_d union Table cms.mbsf_abcd_2016->view medicare.ps union Table cms.mbsf_d_2011 Table cms.mbsf_d_2011 Table cms.mbsf_d_2012 Table cms.mbsf_d_2012 Table cms.mbsf_d_2013 Table cms.mbsf_d_2013 Table cms.mbsf_d_2014 Table cms.mbsf_d_2014 Table cms.mbsf_abcd_2017->materialized view medicare.mbsf_d union Table cms.mbsf_abcd_2017->view medicare.ps union Table cms.mbsf_abcd_2018->materialized view medicare.mbsf_d union Table cms.mbsf_abcd_2018->view medicare.ps union Table cms.mbsf_d_2011->materialized view medicare.mbsf_d union Table cms.mbsf_d_2012->materialized view medicare.mbsf_d union Table cms.medpar_2011 Table cms.medpar_2011 Table cms.medpar_2012 Table cms.medpar_2012 Table cms.medpar_2013 Table cms.medpar_2013 Table cms.medpar_2014 Table cms.medpar_2014 Table cms.mbsf_d_2013->materialized view medicare.mbsf_d union Table cms.mbsf_d_2014->materialized view medicare.mbsf_d union view medicare.ip view medicare.ip Table cms.medpar_2011->view medicare.ip union Table cms.medpar_2012->view medicare.ip union Table cms.medpar_2015 Table cms.medpar_2015 Table cms.medpar_2016 Table cms.medpar_2016 Table cms.medpar_2017 Table cms.medpar_2017 Table cms.medpar_2018 Table cms.medpar_2018 Table cms.medpar_2013->view medicare.ip union Table cms.medpar_2014->view medicare.ip union Table cms.medpar_2015->view medicare.ip union Table cms.medpar_2016->view medicare.ip union Table cms.medpar_2017->view medicare.ip union Table cms.medpar_2018->view medicare.ip union view medicare._enrollments view medicare._enrollments materialized view medicare.mbsf_d->view medicare._enrollments custom-select table medicare.enrollments table medicare.enrollments materialized view medicare.mbsf_d->table medicare.enrollments custom-select view medicare.qc_enrl_bene view medicare.qc_enrl_bene materialized view medicare.mbsf_d->view medicare.qc_enrl_bene custom-select materialized view medicare._ps materialized view medicare._ps view medicare.ps->materialized view medicare._ps transformation table medicare.admissions table medicare.admissions view medicare.ip->table medicare.admissions transformation view medicare._beneficiaries view medicare._beneficiaries materialized view medicare._ps->view medicare._beneficiaries aggregation On bene_id materialized view medicare._ps->view medicare._enrollments aggregation On bene_id, year, state materialized view medicare._ps->table medicare.enrollments custom-select materialized view medicare._ps->view medicare.qc_enrl_bene custom-select table medicare.beneficiaries table medicare.beneficiaries view medicare._beneficiaries->table medicare.beneficiaries transformation view medicare._enrollments->table medicare.enrollments transformation table medicare.beneficiaries->table medicare.enrollments parent-child table medicare.beneficiaries->view medicare.qc_enrl_bene join natural table medicare.enrollments->table medicare.admissions parent-child table medicare.enrollments->view medicare.qc_enrl_bene join natural view medicare.qc_adm_union view medicare.qc_adm_union table medicare.admissions->view medicare.qc_adm_union transformation materialized view medicare.qc_enrollments materialized view medicare.qc_enrollments view medicare.qc_enrl_bene->materialized view medicare.qc_enrollments transformation materialized view medicare.qc_admissions materialized view medicare.qc_admissions view medicare.qc_adm_union->materialized view medicare.qc_admissions transformation